Advertisement
Guest User

Untitled

a guest
May 17th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.82 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10.  
  11. namespace testProjectBCA
  12. {
  13. public partial class StokPosisiForm : Form
  14. {
  15. Database1Entities en = new Database1Entities();
  16.  
  17. public StokPosisiForm()
  18. {
  19. InitializeComponent();
  20. }
  21.  
  22. private void buttonSelectFiles_Click(object sender, EventArgs e)
  23. {
  24. OpenFileDialog of = new OpenFileDialog();
  25. //of.Multiselect = true;
  26. of.Filter = "Microsoft Excel | *.xls; *xlsx; *xlsm";
  27. of.Multiselect = true;
  28. if (of.ShowDialog() == DialogResult.OK)
  29. {
  30. loadForm.ShowSplashScreen();
  31. String[] filenames = of.FileNames;
  32. foreach (var filename in filenames)
  33. {
  34. DataSet ds = Util.openExcel(filename);
  35. //dataGridView1.DataSource = ds.Tables[0];
  36. for (int i = 0; i < ds.Tables.Count - 1; i++)
  37. {
  38. Console.WriteLine(i);
  39. DataTable dt = ds.Tables[i];
  40. String sheetname = dt.TableName;
  41.  
  42.  
  43. var query3 = (from x in en.StokPosisis.AsEnumerable()
  44. where x.namaPkt == ds.Tables[0].Rows[5][11].ToString() && ((DateTime)x.tanggal).ToShortDateString() == Convert.ToDateTime(dt.Rows[8][1].ToString()).ToShortDateString()
  45. select x).ToList();
  46. if (query3.Count() != 0)
  47. {
  48. //start of penimpaan
  49. //Console.WriteLine(query);
  50. //continue
  51. for (int j = 0; j < 8; j++)
  52. {
  53. Int64 unprocessed = 0;
  54. Int64 newBaru = 0;
  55. Int64 newLama = 0;
  56. Int64 fitBaru = 0;
  57. Int64 fitNKRI = 0;
  58. Int64 fitLama = 0;
  59. Int64 passThrough = 0;
  60. Int64 unfitBaru = 0;
  61. Int64 unfitNKRI = 0;
  62. Int64 unfitLama = 0;
  63. Int64 RRMBaru = 0;
  64. Int64 RRMLama = 0;
  65. Int64 RRMNKRI = 0;
  66. Int64 RupiahRusakMayor = 0;
  67. Int64 cekLaporan = 0;
  68. Int64 inCabang = 0;
  69. Int64 inRetail = 0;
  70. DateTime tanggal;
  71.  
  72.  
  73. if (!String.IsNullOrEmpty(dt.Rows[12 + j][27].ToString()))
  74. unprocessed = Int64.Parse(dt.Rows[12 + j][27].ToString());
  75.  
  76. if (!String.IsNullOrEmpty(dt.Rows[12 + j][28].ToString()))
  77. newBaru = Int64.Parse(dt.Rows[12 + j][28].ToString());
  78.  
  79. if (!String.IsNullOrEmpty(dt.Rows[12 + j][29].ToString()))
  80. newLama = Int64.Parse(dt.Rows[12 + j][29].ToString());
  81.  
  82. if (!String.IsNullOrEmpty(dt.Rows[12 + j][30].ToString()))
  83. fitBaru = Int64.Parse(dt.Rows[12 + j][30].ToString());
  84.  
  85. if (!String.IsNullOrEmpty(dt.Rows[12 + j][31].ToString()))
  86. fitNKRI = Int64.Parse(dt.Rows[12 + j][31].ToString());
  87.  
  88. if (!String.IsNullOrEmpty(dt.Rows[12 + j][32].ToString()))
  89. fitLama = Int64.Parse(dt.Rows[12 + j][32].ToString());
  90.  
  91. if (!String.IsNullOrEmpty(dt.Rows[12 + j][33].ToString()))
  92. passThrough = Int64.Parse(dt.Rows[12 + j][33].ToString());
  93.  
  94. if (!String.IsNullOrEmpty(dt.Rows[12 + j][34].ToString()))
  95. unfitBaru = Int64.Parse(dt.Rows[12 + j][34].ToString());
  96.  
  97. if (!String.IsNullOrEmpty(dt.Rows[12 + j][35].ToString()))
  98. unfitNKRI = Int64.Parse(dt.Rows[12 + j][35].ToString());
  99.  
  100. if (!String.IsNullOrEmpty(dt.Rows[12 + j][36].ToString()))
  101. unfitLama = Int64.Parse(dt.Rows[12 + j][36].ToString());
  102.  
  103. if (!String.IsNullOrEmpty(dt.Rows[12 + j][37].ToString()))
  104. RRMBaru = Int64.Parse(dt.Rows[12 + j][37].ToString());
  105.  
  106. if (!String.IsNullOrEmpty(dt.Rows[12 + j][38].ToString()))
  107. RRMNKRI = Int64.Parse(dt.Rows[12 + j][38].ToString());
  108.  
  109. if (!String.IsNullOrEmpty(dt.Rows[12 + j][39].ToString()))
  110. RRMLama = Int64.Parse(dt.Rows[12 + j][39].ToString());
  111.  
  112. if (!String.IsNullOrEmpty(dt.Rows[12 + j][40].ToString()))
  113. RupiahRusakMayor = Int64.Parse(dt.Rows[12 + j][40].ToString());
  114.  
  115. if (!String.IsNullOrEmpty(dt.Rows[12 + j][41].ToString()))
  116. cekLaporan = Int64.Parse(dt.Rows[12 + j][41].ToString());
  117.  
  118. if (!String.IsNullOrEmpty(dt.Rows[12 + j][2].ToString()))
  119. inCabang = Int64.Parse(dt.Rows[12 + j][2].ToString());
  120.  
  121. if (!String.IsNullOrEmpty(dt.Rows[12 + j][3].ToString()))
  122. inRetail = Int64.Parse(dt.Rows[12 + j][3].ToString());
  123.  
  124.  
  125.  
  126.  
  127. //
  128. tanggal = Convert.ToDateTime(dt.Rows[8][1].ToString());
  129.  
  130. //
  131.  
  132. //en.StokPosisis.Add(new StokPosisi()
  133. //{
  134.  
  135. query3[j].unprocessed = unprocessed;
  136. query3[j].newBaru = newBaru;
  137. query3[j].newLama = newLama;
  138. query3[j].fitBaru = fitBaru;
  139. query3[j].fitNKRI = fitNKRI;
  140. query3[j].fitLama = fitLama;
  141. query3[j].passThrough = passThrough;
  142. query3[j].unfitBaru = unfitBaru;
  143. query3[j].unfitNKRI = unfitNKRI;
  144. query3[j].unfitLama = unfitLama;
  145. query3[j].RRMBaru = RRMBaru;
  146. query3[j].RRMNKRI = RRMNKRI;
  147. query3[j].RRMLama = RRMLama;
  148. query3[j].RupiahRusakMayor = RupiahRusakMayor;
  149. query3[j].cekLaporan = cekLaporan;
  150. query3[j].denom = dt.Rows[12 + j][0].ToString();
  151. query3[j].jenis = "Kertas";
  152. query3[j].tanggal = tanggal;
  153. query3[j].namaPkt = dt.Rows[5][11].ToString();
  154. query3[j].inCabang = inCabang;
  155. query3[j].inRetail = inRetail;
  156.  
  157. //});
  158. en.SaveChanges();
  159.  
  160. }
  161. //koin
  162.  
  163. for (int j = 0; j < 6; j++)
  164. {
  165. Int64 unprocessed = 0;
  166. Int64 newBaru = 0;
  167. Int64 newLama = 0;
  168. Int64 fitBaru = 0;
  169. Int64 fitNKRI = 0;
  170. Int64 fitLama = 0;
  171. Int64 passThrough = 0;
  172. Int64 unfitBaru = 0;
  173. Int64 unfitNKRI = 0;
  174. Int64 unfitLama = 0;
  175. Int64 RRMBaru = 0;
  176. Int64 RRMLama = 0;
  177. Int64 RRMNKRI = 0;
  178. Int64 RupiahRusakMayor = 0;
  179. Int64 cekLaporan = 0;
  180. Int64 inCabang = 0;
  181. Int64 inRetail = 0;
  182. DateTime tanggal;
  183.  
  184. if (!String.IsNullOrEmpty(dt.Rows[23 + j][27].ToString()))
  185. unprocessed = Int64.Parse(dt.Rows[23 + j][27].ToString());
  186.  
  187.  
  188.  
  189. if (!String.IsNullOrEmpty(dt.Rows[23 + j][28].ToString()))
  190. newBaru = Int64.Parse(dt.Rows[23 + j][28].ToString());
  191.  
  192. if (!String.IsNullOrEmpty(dt.Rows[23 + j][29].ToString()))
  193. newLama = Int64.Parse(dt.Rows[23 + j][29].ToString());
  194.  
  195. if (!String.IsNullOrEmpty(dt.Rows[23 + j][30].ToString()))
  196. fitBaru = Int64.Parse(dt.Rows[23 + j][30].ToString());
  197.  
  198. if (!String.IsNullOrEmpty(dt.Rows[23 + j][31].ToString()))
  199. fitNKRI = Int64.Parse(dt.Rows[23 + j][31].ToString());
  200.  
  201. if (!String.IsNullOrEmpty(dt.Rows[23 + j][32].ToString()))
  202. fitLama = Int64.Parse(dt.Rows[23 + j][32].ToString());
  203.  
  204. if (!String.IsNullOrEmpty(dt.Rows[23 + j][33].ToString()))
  205. passThrough = Int64.Parse(dt.Rows[23 + j][33].ToString());
  206.  
  207. if (!String.IsNullOrEmpty(dt.Rows[23 + j][34].ToString()))
  208. unfitBaru = Int64.Parse(dt.Rows[23 + j][34].ToString());
  209.  
  210. if (!String.IsNullOrEmpty(dt.Rows[23 + j][35].ToString()))
  211. unfitNKRI = Int64.Parse(dt.Rows[23 + j][35].ToString());
  212.  
  213. if (!String.IsNullOrEmpty(dt.Rows[23 + j][36].ToString()))
  214. unfitLama = Int64.Parse(dt.Rows[23 + j][36].ToString());
  215.  
  216. if (!String.IsNullOrEmpty(dt.Rows[23 + j][37].ToString()))
  217. RRMBaru = Int64.Parse(dt.Rows[23 + j][37].ToString());
  218.  
  219. if (!String.IsNullOrEmpty(dt.Rows[23 + j][38].ToString()))
  220. RRMNKRI = Int64.Parse(dt.Rows[23 + j][38].ToString());
  221.  
  222. if (!String.IsNullOrEmpty(dt.Rows[23 + j][39].ToString()))
  223. RRMLama = Int64.Parse(dt.Rows[23 + j][39].ToString());
  224.  
  225. if (!String.IsNullOrEmpty(dt.Rows[23 + j][40].ToString()))
  226. RupiahRusakMayor = Int64.Parse(dt.Rows[23 + j][40].ToString());
  227.  
  228. if (!String.IsNullOrEmpty(dt.Rows[23 + j][41].ToString()))
  229. cekLaporan = Int64.Parse(dt.Rows[23 + j][41].ToString());
  230.  
  231. if (!String.IsNullOrEmpty(dt.Rows[23 + j][2].ToString()))
  232. inCabang = Int64.Parse(dt.Rows[23 + j][2].ToString());
  233.  
  234. if (!String.IsNullOrEmpty(dt.Rows[23 + j][3].ToString()))
  235. inRetail = Int64.Parse(dt.Rows[23 + j][3].ToString());
  236.  
  237. tanggal = Convert.ToDateTime(dt.Rows[8][1].ToString());
  238.  
  239. //en.StokPosisis.Add(new StokPosisi()
  240. //{
  241. query3[j + 8].unprocessed = unprocessed;
  242. query3[j + 8].newBaru = newBaru;
  243. query3[j + 8].newLama = newLama;
  244. query3[j + 8].fitBaru = fitBaru;
  245. query3[j + 8].fitNKRI = fitNKRI;
  246. query3[j + 8].fitLama = fitLama;
  247. query3[j + 8].passThrough = passThrough;
  248. query3[j + 8].unfitBaru = unfitBaru;
  249. query3[j + 8].unfitNKRI = unfitNKRI;
  250. query3[j + 8].unfitLama = unfitLama;
  251. query3[j + 8].RRMBaru = RRMBaru;
  252. query3[j + 8].RRMNKRI = RRMNKRI;
  253. query3[j + 8].RRMLama = RRMLama;
  254. query3[j + 8].RupiahRusakMayor = RupiahRusakMayor;
  255. query3[j + 8].cekLaporan = cekLaporan;
  256. query3[j + 8].denom = dt.Rows[23 + j][0].ToString();
  257. query3[j + 8].jenis = "Koin";
  258. query3[j + 8].tanggal = tanggal;
  259. query3[j + 8].namaPkt = dt.Rows[5][11].ToString();
  260. query3[j + 8].inCabang = inCabang;
  261. query3[j + 8].inRetail = inRetail;
  262. //});
  263. en.SaveChanges();
  264. }
  265. //continue;
  266. //end of penimpaan
  267. //continue;
  268. }
  269.  
  270. //kertas
  271. else
  272. {
  273. for (int j = 0; j < 8; j++)
  274. {
  275.  
  276. Int64 unprocessed = 0;
  277. Int64 newBaru = 0;
  278. Int64 newLama = 0;
  279. Int64 fitBaru = 0;
  280. Int64 fitNKRI = 0;
  281. Int64 fitLama = 0;
  282. Int64 passThrough = 0;
  283. Int64 unfitBaru = 0;
  284. Int64 unfitNKRI = 0;
  285. Int64 unfitLama = 0;
  286. Int64 RRMBaru = 0;
  287. Int64 RRMLama = 0;
  288. Int64 RRMNKRI = 0;
  289. Int64 RupiahRusakMayor = 0;
  290. Int64 cekLaporan = 0;
  291. Int64 inCabang = 0;
  292. Int64 inRetail = 0;
  293. //
  294. DateTime tanggal;
  295.  
  296. if (!String.IsNullOrEmpty(dt.Rows[12 + j][27].ToString()))
  297. unprocessed = Int64.Parse(dt.Rows[12 + j][27].ToString());
  298.  
  299.  
  300. if (!String.IsNullOrEmpty(dt.Rows[12 + j][28].ToString()))
  301. newBaru = Int64.Parse(dt.Rows[12 + j][28].ToString());
  302.  
  303. if (!String.IsNullOrEmpty(dt.Rows[12 + j][29].ToString()))
  304. newLama = Int64.Parse(dt.Rows[12 + j][29].ToString());
  305.  
  306. if (!String.IsNullOrEmpty(dt.Rows[12 + j][30].ToString()))
  307. fitBaru = Int64.Parse(dt.Rows[12 + j][30].ToString());
  308.  
  309. if (!String.IsNullOrEmpty(dt.Rows[12 + j][31].ToString()))
  310. fitNKRI = Int64.Parse(dt.Rows[12 + j][31].ToString());
  311.  
  312. if (!String.IsNullOrEmpty(dt.Rows[12 + j][32].ToString()))
  313. fitLama = Int64.Parse(dt.Rows[12 + j][32].ToString());
  314.  
  315. if (!String.IsNullOrEmpty(dt.Rows[12 + j][33].ToString()))
  316. passThrough = Int64.Parse(dt.Rows[12 + j][33].ToString());
  317.  
  318. if (!String.IsNullOrEmpty(dt.Rows[12 + j][34].ToString()))
  319. unfitBaru = Int64.Parse(dt.Rows[12 + j][34].ToString());
  320.  
  321. if (!String.IsNullOrEmpty(dt.Rows[12 + j][35].ToString()))
  322. unfitNKRI = Int64.Parse(dt.Rows[12 + j][35].ToString());
  323.  
  324. if (!String.IsNullOrEmpty(dt.Rows[12 + j][36].ToString()))
  325. unfitLama = Int64.Parse(dt.Rows[12 + j][36].ToString());
  326.  
  327. if (!String.IsNullOrEmpty(dt.Rows[12 + j][37].ToString()))
  328. RRMBaru = Int64.Parse(dt.Rows[12 + j][37].ToString());
  329.  
  330. if (!String.IsNullOrEmpty(dt.Rows[12 + j][38].ToString()))
  331. RRMNKRI = Int64.Parse(dt.Rows[12 + j][38].ToString());
  332.  
  333. if (!String.IsNullOrEmpty(dt.Rows[12 + j][39].ToString()))
  334. RRMLama = Int64.Parse(dt.Rows[12 + j][39].ToString());
  335.  
  336. if (!String.IsNullOrEmpty(dt.Rows[12 + j][40].ToString()))
  337. RupiahRusakMayor = Int64.Parse(dt.Rows[12 + j][40].ToString());
  338.  
  339. if (!String.IsNullOrEmpty(dt.Rows[12 + j][41].ToString()))
  340. cekLaporan = Int64.Parse(dt.Rows[12 + j][41].ToString());
  341.  
  342. if (!String.IsNullOrEmpty(dt.Rows[12 + j][2].ToString()))
  343. inCabang = Int64.Parse(dt.Rows[12 + j][2].ToString());
  344.  
  345. if (!String.IsNullOrEmpty(dt.Rows[12 + j][3].ToString()))
  346. inRetail = Int64.Parse(dt.Rows[12 + j][3].ToString());
  347.  
  348. //
  349. tanggal = Convert.ToDateTime(dt.Rows[8][1].ToString());
  350.  
  351. //
  352.  
  353.  
  354.  
  355. en.StokPosisis.Add(new StokPosisi()
  356. {
  357. unprocessed = unprocessed,
  358. newBaru = newBaru,
  359. newLama = newLama,
  360. fitBaru = fitBaru,
  361. fitNKRI = fitNKRI,
  362. fitLama = fitLama,
  363. passThrough = passThrough,
  364. unfitBaru = unfitBaru,
  365. unfitNKRI = unfitNKRI,
  366. unfitLama = unfitLama,
  367. RRMBaru = RRMBaru,
  368. RRMNKRI = RRMNKRI,
  369. RRMLama = RRMLama,
  370. RupiahRusakMayor = RupiahRusakMayor,
  371. cekLaporan = cekLaporan,
  372. denom = dt.Rows[12 + j][0].ToString(),
  373. jenis = "Kertas",
  374. tanggal = tanggal,
  375. namaPkt = dt.Rows[5][11].ToString(),
  376. inCabang = inCabang,
  377. inRetail = inRetail
  378.  
  379. });
  380. en.SaveChanges();
  381. }
  382. //koin
  383.  
  384. for (int j = 0; j < 6; j++)
  385. {
  386. Int64 unprocessed = 0;
  387. Int64 newBaru = 0;
  388. Int64 newLama = 0;
  389. Int64 fitBaru = 0;
  390. Int64 fitNKRI = 0;
  391. Int64 fitLama = 0;
  392. Int64 passThrough = 0;
  393. Int64 unfitBaru = 0;
  394. Int64 unfitNKRI = 0;
  395. Int64 unfitLama = 0;
  396. Int64 RRMBaru = 0;
  397. Int64 RRMLama = 0;
  398. Int64 RRMNKRI = 0;
  399. Int64 RupiahRusakMayor = 0;
  400. Int64 cekLaporan = 0;
  401. Int64 inCabang = 0;
  402. Int64 inRetail = 0;
  403. DateTime tanggal;
  404.  
  405. if (!String.IsNullOrEmpty(dt.Rows[23 + j][27].ToString()))
  406. unprocessed = Int64.Parse(dt.Rows[23 + j][27].ToString());
  407.  
  408. if (!String.IsNullOrEmpty(dt.Rows[23 + j][28].ToString()))
  409. newBaru = Int64.Parse(dt.Rows[23 + j][28].ToString());
  410.  
  411. if (!String.IsNullOrEmpty(dt.Rows[23 + j][29].ToString()))
  412. newLama = Int64.Parse(dt.Rows[23 + j][29].ToString());
  413.  
  414. if (!String.IsNullOrEmpty(dt.Rows[23 + j][30].ToString()))
  415. fitBaru = Int64.Parse(dt.Rows[23 + j][30].ToString());
  416.  
  417. if (!String.IsNullOrEmpty(dt.Rows[23 + j][31].ToString()))
  418. fitNKRI = Int64.Parse(dt.Rows[23 + j][31].ToString());
  419.  
  420. if (!String.IsNullOrEmpty(dt.Rows[23 + j][32].ToString()))
  421. fitLama = Int64.Parse(dt.Rows[23 + j][32].ToString());
  422.  
  423. if (!String.IsNullOrEmpty(dt.Rows[23 + j][33].ToString()))
  424. passThrough = Int64.Parse(dt.Rows[23 + j][33].ToString());
  425.  
  426. if (!String.IsNullOrEmpty(dt.Rows[23 + j][34].ToString()))
  427. unfitBaru = Int64.Parse(dt.Rows[23 + j][34].ToString());
  428.  
  429. if (!String.IsNullOrEmpty(dt.Rows[23 + j][35].ToString()))
  430. unfitNKRI = Int64.Parse(dt.Rows[23 + j][35].ToString());
  431.  
  432. if (!String.IsNullOrEmpty(dt.Rows[23 + j][36].ToString()))
  433. unfitLama = Int64.Parse(dt.Rows[23 + j][36].ToString());
  434.  
  435. if (!String.IsNullOrEmpty(dt.Rows[23 + j][37].ToString()))
  436. RRMBaru = Int64.Parse(dt.Rows[23 + j][37].ToString());
  437.  
  438. if (!String.IsNullOrEmpty(dt.Rows[23 + j][38].ToString()))
  439. RRMNKRI = Int64.Parse(dt.Rows[23 + j][38].ToString());
  440.  
  441. if (!String.IsNullOrEmpty(dt.Rows[23 + j][39].ToString()))
  442. RRMLama = Int64.Parse(dt.Rows[23 + j][39].ToString());
  443.  
  444. if (!String.IsNullOrEmpty(dt.Rows[23 + j][40].ToString()))
  445. RupiahRusakMayor = Int64.Parse(dt.Rows[23 + j][40].ToString());
  446.  
  447. if (!String.IsNullOrEmpty(dt.Rows[23 + j][41].ToString()))
  448. cekLaporan = Int64.Parse(dt.Rows[23 + j][41].ToString());
  449.  
  450. if (!String.IsNullOrEmpty(dt.Rows[23 + j][2].ToString()))
  451. inCabang = Int64.Parse(dt.Rows[23 + j][2].ToString());
  452.  
  453. if (!String.IsNullOrEmpty(dt.Rows[23 + j][3].ToString()))
  454. inRetail = Int64.Parse(dt.Rows[23 + j][3].ToString());
  455.  
  456. tanggal = Convert.ToDateTime(dt.Rows[8][1].ToString());
  457.  
  458. en.StokPosisis.Add(new StokPosisi()
  459. {
  460. unprocessed = unprocessed,
  461. newBaru = newBaru,
  462. newLama = newLama,
  463. fitBaru = fitBaru,
  464. fitNKRI = fitNKRI,
  465. fitLama = fitLama,
  466. passThrough = passThrough,
  467. unfitBaru = unfitBaru,
  468. unfitNKRI = unfitNKRI,
  469. unfitLama = unfitLama,
  470. RRMBaru = RRMBaru,
  471. RRMNKRI = RRMNKRI,
  472. RRMLama = RRMLama,
  473. RupiahRusakMayor = RupiahRusakMayor,
  474. cekLaporan = cekLaporan,
  475. denom = dt.Rows[23 + j][0].ToString(),
  476. jenis = "Koin",
  477. tanggal = tanggal,
  478. namaPkt = dt.Rows[5][11].ToString(),
  479. inCabang = inCabang,
  480. inRetail = inRetail
  481. });
  482. en.SaveChanges();
  483. }
  484. }
  485. }
  486. }
  487. loadForm.CloseForm();
  488. }
  489.  
  490. }
  491.  
  492.  
  493. public void insertToDatabase()
  494. {
  495. //hayo cari apa disini
  496. }
  497.  
  498. }
  499. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement