public SettingSales(IDbConnection conn) { InitializeComponent(); _conn = conn; DAL shipper = null; try { shipper = new DAL(); DataSet ds = shipper.Get_Sales_Data_Full(_conn); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { textBoxKodeSales.Text = dr["kodeSales"].ToString(); textBoxUsername.Text = dr["username"].ToString(); textBoxPassword.Text = dr["password"].ToString(); textBoxRWPassword.Text = dr["password"].ToString(); textBoxNamaSales.Text = dr["namaSales"].ToString(); textBoxAlamat.Text = dr["alamat"].ToString(); textBoxNoTelp.Text = dr["noTelp"].ToString(); textBoxEmail.Text = dr["email"].ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ForgetPass(IDbConnection conn) { InitializeComponent(); _conn = conn; DAL shipper = null; IDataReader reader = null; try { shipper = new DAL(); reader = shipper.Cek_Sales(_conn); if (reader.Read()) { textBoxUsername.Text = reader[0].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (reader != null) { reader.Close(); reader.Dispose(); } } }
public AddCarForm(IDbConnection conn, int tmpidCustomer) { InitializeComponent(); _conn = conn; DAL shipper = null; try { shipper = new DAL(); DataSet ds = shipper.Get_Customer_Data_ADDCAR(_conn, tmpidCustomer); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { tbidCustomer.Text = tmpidCustomer.ToString(); namacus_db.Text = dr["namaCustomer"].ToString(); DateTime dob = Convert.ToDateTime(dr["tglLahir"].ToString()); tgllahircus_db.Text = dob.ToString("dd MMMM yyyy"); tbAgama.Text = dr["agama"].ToString(); alamat_db.Text = dr["alamat"].ToString(); notlpn_db.Text = dr["noTelp"].ToString(); hp1_db.Text = dr["noHP1"].ToString(); hp2_db.Text = dr["noHP2"].ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { if (textBoxKodeSales.Text.Length == 0 || textBoxNamaSales.Text.Length == 0 || textBoxNoTelp.Text.Length == 0 || textBoxPassword.Text.Length == 0 || textBoxRWPassword.Text.Length == 0 || textBoxUsername.Text.Length == 0) { MessageBox.Show("There are some field that empty"); } else { DAL shipper = null; try { shipper = new DAL(); shipper.Register_Sales(_conn, textBoxKodeSales.Text, textBoxUsername.Text, textBoxPassword.Text, textBoxNamaSales.Text, textBoxAlamat.Text, textBoxNoTelp.Text, textBoxEmail.Text); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Register Success"); Hide(); using (Login l = new Login(_conn)) //if data ok, form will close it self! { if (l.ShowDialog() == DialogResult.OK) { this.DialogResult = DialogResult.OK; this.Close(); } this.DialogResult = DialogResult.OK; } } }
private void buttonLogin_Click(object sender, EventArgs e) { DAL shipper = null; IDataReader reader = null; try { shipper = new DAL(); reader = shipper.Cek_Sales(_conn); if (reader.Read()) { if (!textBoxUsername.Text.Equals(reader.GetString(0)) || !textBoxPassword.Text.Equals(reader.GetString(1)) ) { MessageBox.Show("Username atau Password Salah"); } else { MessageBox.Show("Login Berhasil"); this.DialogResult = DialogResult.OK; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (reader != null) { reader.Close(); reader.Dispose(); } } }
private void button1_Click(object sender, EventArgs e) { if (textBoxKodeSales.Text.Length == 0 || textBoxNamaSales.Text.Length == 0 || textBoxNoTelp.Text.Length == 0 || textBoxPassword.Text.Length == 0 || textBoxRWPassword.Text.Length == 0 || textBoxUsername.Text.Length == 0) { MessageBox.Show("There are some field that empty"); } else { DAL shipper = null; try { shipper = new DAL(); shipper.update_Setting_Sales(_conn, textBoxKodeSales.Text, textBoxUsername.Text, textBoxPassword.Text, textBoxNamaSales.Text, textBoxAlamat.Text, textBoxNoTelp.Text, textBoxEmail.Text); MessageBox.Show("Data have been update."); this.Close(); } catch(Exception ex) { MessageBox.Show(ex.Message); } } }
private void buttonChange_Click(object sender, EventArgs e) { if (flagPass == 1 && flagConPass == 1 && textBoxUsername.Text.Length != 0 && textBoxNPass.Text.Length != 0 && textBoxCNPass.Text.Length != 0) { DAL shipper = null; try { shipper = new DAL(); shipper.updateSales(_conn, textBoxUsername.Text, textBoxCNPass.Text); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Password Change Succeed."); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Errors Occured"); } }
private void getData() { try { aksesLayer = new DAL(); DataSet ds = null; if (keySearch != null && wordSearch != null && keySort != null) { if (keySearch.Equals("idCustomer")) { queryPlus = "AND c." + keySearch + " = " + wordSearch + " ORDER BY " + keySort; } else { queryPlus = "AND " + keySearch + " LIKE '" + wordSearch + "%'" + "ORDER BY " + keySort; } } if (keySearch != null || wordSearch != null || keySort != null) { ds = aksesLayer.Get_AllCustomer_Data(_conn, queryPlus); } else { ds = aksesLayer.Get_AllCustomer_Data(_conn); } if (ds != null && ds.Tables.Count > 0) { listView1.Items.Clear(); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { ListViewItem lvi = new ListViewItem(); lvi.Text = dr["idCustomer"].ToString(); lvi.SubItems.Add(dr["namaCustomer"].ToString()); lvi.SubItems.Add(dr["alamat"].ToString()); lvi.SubItems.Add(dr["noTelp"].ToString()); lvi.SubItems.Add(dr["noHP1"].ToString()); lvi.SubItems.Add(dr["email"].ToString()); lvi.SubItems.Add(dr["tipeMobil"].ToString()); lvi.SubItems.Add(dr["tglDelivery"].ToString()); lvi.SubItems.Add(dr["tglSTNK"].ToString()); lvi.SubItems.Add(dr["caraPembayaran"].ToString()); listView1.Items.Add(lvi); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void retrieve_salesData() { DAL toyota = new DAL(); IDataReader reader = null; //SALES DATA try { statusData.Text = "Retreiving sales data"; reader = toyota.Get_Sales_Data(_conn); if (reader.Read()) { labelKodeSales.Text = reader[0].ToString(); GKodeSales = reader[0].ToString(); labelNamaSales.Text = reader[1].ToString(); labelAlamat.Text = reader[2].ToString(); labelNoTelepon.Text = reader[3].ToString(); labelEmail.Text = reader[4].ToString(); } } catch(Exception ex) { throw new Exception("Faild to retrieve sales data", ex); } }
public MenuUtama(IDbConnection conn) { InitializeComponent(); _conn = conn; DAL shipper = null; IDataReader reader = null; current = DateTime.Now; try { shipper = new DAL(); reader = shipper.Cek_Sales(_conn); if (reader.Read()) { Hide(); using (Login l = new Login(_conn)) //if data ok, form will close it self! { if (l.ShowDialog() == DialogResult.OK) { this.Visible = true; } else { _conn.Close(); _conn.Dispose(); Application.Exit(); } } } else { Hide(); using (Register c = new Register(_conn)) //if data ok, form will close it self! { if (c.ShowDialog() == DialogResult.OK) { this.Visible = true; } else { _conn.Close(); _conn.Dispose(); Application.Exit(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (reader != null) { reader.Close(); reader.Dispose(); } } retrieve_salesData(); retrieve_pageData(current); }
private void retrieve_pageData(DateTime currentDate) { DAL toyota = new DAL(); DateTime shortDate = Convert.ToDateTime(currentDate.ToShortDateString()); int amount = 0; try { //BIRTHDAY DATA try { statusData.Text = "Retreiving birthday data"; DataSet bds = toyota.Get_Birthday_Data(_conn, currentDate); if (bds != null && bds.Tables.Count > 0) { listViewBirthday.Items.Clear(); DataTable bdt = bds.Tables[0]; foreach (DataRow bdr in bdt.Rows) { ListViewItem blvi = new ListViewItem(); blvi.Text = bdr["namaCustomer"].ToString(); blvi.SubItems.Add(bdr["noTelp"].ToString()); blvi.SubItems.Add(bdr["noHP1"].ToString()); blvi.SubItems.Add(bdr["noHP2"].ToString()); listViewBirthday.Items.Add(blvi); amount++; } } else { lblJmlBirthday.Text = "No birthday found"; } lblJmlBirthday.Text = amount.ToString(); } catch (Exception ex) { throw new Exception("Failed to retrieve birthday data", ex); } //STNK DATA try { statusData.Text = "Retreiving STNK data"; DataSet sds = toyota.Get_STNK_Data(_conn, currentDate); amount = 0; if (sds != null && sds.Tables.Count > 0) { listViewSTNK.Items.Clear(); DataTable sdt = sds.Tables[0]; foreach (DataRow sdr in sdt.Rows) { String stnkTimeLeft = null; int hitunganLeftSTNK = 0; DateTime datelineSTNK = Convert.ToDateTime(sdr["habisSTNK"].ToString()); hitunganLeftSTNK = (6 - Convert.ToInt32(currentDate.DayOfWeek)) + Convert.ToInt32(datelineSTNK.DayOfWeek); if (hitunganLeftSTNK > 6) stnkTimeLeft = (Convert.ToInt32(datelineSTNK.DayOfWeek) - Convert.ToInt32(currentDate.DayOfWeek)).ToString() + " days left"; else if (currentDate.ToShortDateString().Equals(datelineSTNK.ToShortDateString())) stnkTimeLeft = "Last Date"; else stnkTimeLeft = hitunganLeftSTNK.ToString() + " days left"; ListViewItem slvi = new ListViewItem(); slvi.Text = sdr["namaCustomer"].ToString(); slvi.SubItems.Add(sdr["noTelp"].ToString()); slvi.SubItems.Add(sdr["noHP1"].ToString()); slvi.SubItems.Add(sdr["noHP2"].ToString()); slvi.SubItems.Add(stnkTimeLeft); listViewSTNK.Items.Add(slvi); amount++; } } else { ListViewItem slvi = new ListViewItem(); slvi.Text = "No"; slvi.SubItems.Add("STNK"); slvi.SubItems.Add("Data"); slvi.SubItems.Add("Found"); listViewSTNK.Items.Add(slvi); } lblJmlSTNK.Text = amount.ToString(); } catch (Exception ex) { throw new Exception("Failed to retrieve STNK data", ex); } //ASURANSI DATA try { statusData.Text = "Retreiving asuransi data"; DataSet ads = toyota.Get_Asuransi_Data(_conn, currentDate); amount = 0; if (ads != null && ads.Tables.Count > 0) { listViewAsuransi.Items.Clear(); DataTable adt = ads.Tables[0]; foreach (DataRow adr in adt.Rows) { String asuransiTimeLeft = null; int hitunganLeftAsuransi = 0; DateTime datelineAsuransi = Convert.ToDateTime(adr["habisAsuransi"].ToString()); hitunganLeftAsuransi = (6 - Convert.ToInt32(currentDate.DayOfWeek)) + Convert.ToInt32(datelineAsuransi.DayOfWeek); if (hitunganLeftAsuransi > 6) asuransiTimeLeft = (Convert.ToInt32(datelineAsuransi.DayOfWeek) - Convert.ToInt32(currentDate.DayOfWeek)).ToString() + " days left"; else if (currentDate == datelineAsuransi) asuransiTimeLeft = "Last Date"; else asuransiTimeLeft = hitunganLeftAsuransi.ToString() + " days left"; ListViewItem alvi = new ListViewItem(); alvi.Text = adr["namaCustomer"].ToString(); alvi.SubItems.Add(adr["noTelp"].ToString()); alvi.SubItems.Add(adr["noHP1"].ToString()); alvi.SubItems.Add(adr["noHP2"].ToString()); alvi.SubItems.Add(asuransiTimeLeft); listViewAsuransi.Items.Add(alvi); amount++; } } else { ListViewItem alvi = new ListViewItem(); alvi.Text = "No"; alvi.SubItems.Add("ASURANSI"); alvi.SubItems.Add("Data"); alvi.SubItems.Add("Found"); listViewAsuransi.Items.Add(alvi); } lbljmlAsuransi.Text = amount.ToString(); } catch (Exception ex) { throw new Exception("Failed to retrieve asuransi data", ex); } } catch (Exception ex) { throw new Exception("Fail to retrieve home data", ex); } }
private void btn_submit_Click(object sender, EventArgs e) { String namaPerusahaanAsuransi = ""; DateTime? tglAsuransi = null; int jumlahTahunAsuransi = 0; int tmpJmlTahunKredit = 0; int tmpidCustomer = Convert.ToInt32(tbidCustomer.Text); if (tipeMobilTxt.Text == null || warnaMobilTxt.Text == null || tgldo_hari.Text.Length == 0 || tgldo_bulan.Text.Length == 0 || tgldo_tahun.Text.Length == 0 || tglstnk_hari.Text.Length == 0 || tglstnk_bulan.Text.Length == 0 || tglstnk_tahun.Text.Length == 0) { MessageBox.Show("There are some field that empty"); } else { DAL shipper = null; DateTime tanggaldo = convertToDate(tgldo_hari.Text, tgldo_bulan.Text, tgldo_tahun.Text); if (npa.Text != "") { namaPerusahaanAsuransi = npa.Text; if (tglasuransi_hari.Text != "" && tglasuransi_bulan.Text != "" && tglasuransi_tahun.Text != "") tglAsuransi = convertToDate(tglasuransi_hari.Text, tglasuransi_bulan.Text, tglasuransi_tahun.Text); if (combobox_jta.SelectedItem.ToString() != "") jumlahTahunAsuransi = Convert.ToInt32(combobox_jta.SelectedItem.ToString()); } DateTime tanggalSTNK = convertToDate(tglstnk_hari.Text, tglstnk_bulan.Text, tglstnk_tahun.Text); try { shipper = new DAL(); string pembayaran; if (radiobtn_credit.Checked) { pembayaran = "Credit"; tmpJmlTahunKredit = Convert.ToInt32(combobox_jtk.SelectedItem.ToString()); } else { pembayaran = "Cash"; } //Insert Transaksi shipper.Add_Transaksi(_conn, tmpidCustomer, tipeMobilTxt.Text , warnaMobilTxt.Text, tanggaldo, tanggalSTNK, tglAsuransi, namaPerusahaanAsuransi, jumlahTahunAsuransi, pembayaran, tmpJmlTahunKredit); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Add Car Success"); this.DialogResult = DialogResult.OK; this.Close(); } }
private void btn_submit_Click(object sender, EventArgs e) { DateTime? tglLahirKeluarga1 = null; DateTime? tglLahirKeluarga2 = null; DateTime? tglLahirKeluarga3 = null; DateTime? tglLahirKeluarga4 = null; String namaPerusahaanAsuransi = ""; DateTime? tglAsuransi = null; string tmpAgama = null; string tmpJenKel = null; int tmpidCustomer=0; int jumlahTahunAsuransi = 0; int tmpJmlTahunKredit =0; if (namacus.Text.Length == 0 || alamat.Text.Length == 0 || notlpn.Text.Length == 0 || hp1.Text.Length == 0 || tgllahircus_hari.Text.Length == 0 || tgllahircus_bulan.Text.Length == 0 || tgllahircus_tahun.Text.Length == 0 || tipeMobilTxt.Text == null || warnaMobilTxt.Text == null || tgldo_hari.Text.Length == 0 || tgldo_bulan.Text.Length == 0 || tgldo_tahun.Text.Length == 0 || tglstnk_hari.Text.Length == 0 || tglstnk_bulan.Text.Length == 0 || tglstnk_tahun.Text.Length == 0) { MessageBox.Show("There are some field that empty"); } else { DAL shipper = null; DateTime tglLahirCustomer = convertToDate(tgllahircus_hari.Text, tgllahircus_bulan.Text, tgllahircus_tahun.Text); if (ak1.Text != "") if (tgllahir1_hari.Text != "" && tgllahir1_bulan.Text != "" && tgllahir1_tahun.Text != "") tglLahirKeluarga1 = convertToDate(tgllahir1_hari.Text, tgllahir1_bulan.Text, tgllahir1_tahun.Text); if (ak2.Text != "") if (tgllahir2_hari.Text != "" && tgllahir2_bulan.Text != "" && tgllahir2_tahun.Text != "") tglLahirKeluarga2 = convertToDate(tgllahir2_hari.Text, tgllahir2_bulan.Text, tgllahir2_tahun.Text); if (ak3.Text != "") if (tgllahir3_hari.Text != "" && tgllahir3_bulan.Text != "" && tgllahir3_tahun.Text != "") tglLahirKeluarga3 = convertToDate(tgllahir3_hari.Text, tgllahir3_bulan.Text, tgllahir3_tahun.Text); if (ak4.Text != "") if (tgllahir4_hari.Text != "" && tgllahir4_bulan.Text != "" && tgllahir4_tahun.Text != "") tglLahirKeluarga4 = convertToDate(tgllahir4_hari.Text, tgllahir4_bulan.Text, tgllahir4_tahun.Text); DateTime tanggaldo = convertToDate(tgldo_hari.Text, tgldo_bulan.Text, tgldo_tahun.Text); if (npa.Text != "") { namaPerusahaanAsuransi = npa.Text; if (tglasuransi_hari.Text != "" && tglasuransi_bulan.Text != "" && tglasuransi_tahun.Text != "") tglAsuransi = convertToDate(tglasuransi_hari.Text, tglasuransi_bulan.Text, tglasuransi_tahun.Text); if (combobox_jta.SelectedItem.ToString() != "") jumlahTahunAsuransi = Convert.ToInt32(combobox_jta.SelectedItem.ToString()); } DateTime tanggalSTNK = convertToDate(tglstnk_hari.Text, tglstnk_bulan.Text, tglstnk_tahun.Text); if (combobox_agama.SelectedIndex == -1) { tmpAgama = ""; } else { tmpAgama = combobox_agama.SelectedItem.ToString(); } if (radiobtn_pria.Checked) { tmpJenKel = "Pria"; } else if (radiobtn_wania.Checked) { tmpJenKel = "Wanita"; } else { tmpJenKel = "Pria"; } try { shipper = new DAL(); string pembayaran; if (radiobtn_credit.Checked) { pembayaran = "Credit"; tmpJmlTahunKredit = Convert.ToInt32(combobox_jtk.SelectedItem.ToString()); } else { pembayaran = "Cash"; } //Insert Biodata Customer shipper.Add_Customer(_conn, _kodeSales, namacus.Text, tmpJenKel, alamat.Text, notlpn.Text, hp1.Text, hp2.Text, email.Text, tglLahirCustomer, tmpAgama, ak1.Text, ak2.Text, ak3.Text, ak4.Text, tglLahirKeluarga1, tglLahirKeluarga2, tglLahirKeluarga3, tglLahirKeluarga4); //Get idCustomer IDataReader reader = null; try { reader = shipper.Cek_idCustomer(_conn,namacus.Text); if (reader.Read()) { tmpidCustomer = Convert.ToInt32( reader[0].ToString()); } } catch (Exception ex) { throw new Exception("Faild to retrieve sales data", ex); } finally { if (reader != null) { reader.Close(); reader.Dispose(); } } //Insert Transaksi shipper.Add_Transaksi(_conn, tmpidCustomer, tipeMobilTxt.Text, warnaMobilTxt.Text, tanggaldo, tanggalSTNK, tglAsuransi, namaPerusahaanAsuransi, jumlahTahunAsuransi, pembayaran, tmpJmlTahunKredit); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Register Success"); this.DialogResult = DialogResult.OK; this.Close(); } }
private void getCustomer() { aksesLayer = new DAL(); DataSet ds = null; DateTime dob; int jta; ds = aksesLayer.Get_Customer_Data(_conn, _idCustomer, _tipeMobil); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { namacus.Text = dr["namaCustomer"].ToString(); dob = Convert.ToDateTime(dr["tglLahir"].ToString()); tgllahircus_hari.Text = dob.Day.ToString(); tgllahircus_bulan.Text = dob.Month.ToString(); tgllahircus_tahun.Text = dob.Year.ToString(); if (dr["jenisKelamin"].Equals("Pria")) { radiobtn_pria.Select(); } else { radiobtn_wanita.Select(); } if (dr["agama"].Equals("Katholik")) { combobox_agama.SelectedIndex = 1; } else if (dr["agama"].Equals("Kristen")) { combobox_agama.SelectedIndex = 2; } else if (dr["agama"].Equals("Islam")) { combobox_agama.SelectedIndex = 3; } else if (dr["agama"].Equals("Hindu")) { combobox_agama.SelectedIndex = 4; } else if (dr["agama"].Equals("Buddha")) { combobox_agama.SelectedIndex = 5; } alamat.Text = dr["alamat"].ToString(); notlpn.Text = dr["noTelp"].ToString(); hp1.Text = dr["noHP1"].ToString(); hp2.Text = dr["noHP2"].ToString(); email.Text = dr["email"].ToString(); ak1.Text = dr["anggotaKeluarga1"].ToString(); ak2.Text = dr["anggotaKeluarga2"].ToString(); ak3.Text = dr["anggotaKeluarga3"].ToString(); ak4.Text = dr["anggotaKeluarga4"].ToString(); if (dr["tglLahirKeluarga1"].ToString().Length == 0) { tgllahir1_hari.Text = null; tgllahir1_bulan.Text = null; tgllahir1_tahun.Text = null; } else { dob = Convert.ToDateTime(dr["tglLahirKeluarga1"].ToString()); tgllahir1_hari.Text = dob.Day.ToString(); tgllahir1_bulan.Text = dob.Month.ToString(); tgllahir1_tahun.Text = dob.Year.ToString(); } if (dr["tglLahirKeluarga2"].ToString().Length == 0) { tgllahir2_hari.Text = null; tgllahir2_bulan.Text = null; tgllahir2_tahun.Text = null; } else { dob = Convert.ToDateTime(dr["tglLahirKeluarga2"].ToString()); tgllahir2_hari.Text = dob.Day.ToString(); tgllahir2_bulan.Text = dob.Month.ToString(); tgllahir2_tahun.Text = dob.Year.ToString(); } if (dr["tglLahirKeluarga3"].ToString().Length == 0) { tgllahir3_hari.Text = null; tgllahir3_bulan.Text = null; tgllahir3_tahun.Text = null; } else { dob = Convert.ToDateTime(dr["tglLahirKeluarga3"].ToString()); tgllahir3_hari.Text = dob.Day.ToString(); tgllahir3_bulan.Text = dob.Month.ToString(); tgllahir3_tahun.Text = dob.Year.ToString(); } if (dr["tglLahirKeluarga4"].ToString().Length == 0) { tgllahir4_hari.Text = null; tgllahir4_bulan.Text = null; tgllahir4_tahun.Text = null; } else { dob = Convert.ToDateTime(dr["tglLahirKeluarga4"].ToString()); tgllahir4_hari.Text = dob.Day.ToString(); tgllahir4_bulan.Text = dob.Month.ToString(); tgllahir4_tahun.Text = dob.Year.ToString(); } tipeMobilTxt.Text = dr["tipeMobil"].ToString(); warnaMobilTxt.Text = dr["warnaMobil"].ToString(); dob = Convert.ToDateTime(dr["tglDelivery"].ToString()); tgldo_hari.Text = dob.Day.ToString(); tgldo_bulan.Text = dob.Month.ToString(); tgldo_tahun.Text = dob.Year.ToString(); dob = Convert.ToDateTime(dr["tglSTNK"].ToString()); tglstnk_hari.Text = dob.Day.ToString(); tglstnk_bulan.Text = dob.Month.ToString(); tglstnk_tahun.Text = dob.Year.ToString(); npa.Text = dr["namaAsuransi"].ToString(); dob = Convert.ToDateTime(dr["tglAsuransi"].ToString()); tglasuransi_hari.Text = dob.Day.ToString(); tglasuransi_bulan.Text = dob.Month.ToString(); tglasuransi_tahun.Text = dob.Year.ToString(); jta = Convert.ToInt32(dr["jmlTahunAsuransi"].ToString()); if (jta == 1) { combobox_jta.SelectedIndex = 1; } else if (jta == 2) { combobox_jta.SelectedIndex = 2; } else if (jta == 3) { combobox_jta.SelectedIndex = 3; } else if (jta == 4) { combobox_jta.SelectedIndex = 4; } else if (jta == 5) { combobox_jta.SelectedIndex = 5; } else { combobox_jta.SelectedIndex = 0; } if (dr["caraPembayaran"].ToString().Equals("cash") || dr["caraPembayaran"].ToString().Equals("Cash")) { radiobtn_cash.Select(); } else { radiobtn_credit.Select(); } if (dr["jmlTahunKredit"].ToString().Equals("1")) { combobox_jtk.SelectedIndex = 1; } else if (dr["jmlTahunKredit"].ToString().Equals("2")) { combobox_jtk.SelectedIndex = 2; } else if (dr["jmlTahunKredit"].ToString().Equals("3")) { combobox_jtk.SelectedIndex = 3; } else if (dr["jmlTahunKredit"].ToString().Equals("4")) { combobox_jtk.SelectedIndex = 4; } else if (dr["jmlTahunKredit"].ToString().Equals("5")) { combobox_jtk.SelectedIndex = 5; } } } }
private void btn_submit_Click(object sender, EventArgs e) { DateTime? tglLahirKeluarga1 = null; DateTime? tglLahirKeluarga2 = null; DateTime? tglLahirKeluarga3 = null; DateTime? tglLahirKeluarga4 = null; String namaPerusahaanAsuransi = ""; DateTime? tglAsuransi = null; string tmpAgama = null; string jenkel = null; int jumlahTahunAsuransi = 0; int tmpJmlTahunKredit =0; if (namacus.Text.Length == 0 || alamat.Text.Length == 0 || notlpn.Text.Length == 0 || hp1.Text.Length == 0 || tgllahircus_hari.Text.Length == 0 || tgllahircus_bulan.Text.Length == 0 || tgllahircus_tahun.Text.Length == 0 || tipeMobilTxt.Text == null || warnaMobilTxt.Text == null || tgldo_hari.Text.Length == 0 || tgldo_bulan.Text.Length == 0 || tgldo_tahun.Text.Length == 0 || tglstnk_hari.Text.Length == 0 || tglstnk_bulan.Text.Length == 0 || tglstnk_tahun.Text.Length == 0) { MessageBox.Show("There are some field that empty"); } else { DAL shipper = null; DateTime tglLahirCustomer = convertToDate(tgllahircus_hari.Text, tgllahircus_bulan.Text, tgllahircus_tahun.Text); if (ak1.Text != "") if (tgllahir1_hari.Text != "" && tgllahir1_bulan.Text != "" && tgllahir1_tahun.Text != "") tglLahirKeluarga1 = convertToDate(tgllahir1_hari.Text, tgllahir1_bulan.Text, tgllahir1_tahun.Text); if (ak2.Text != "") if (tgllahir2_hari.Text != "" && tgllahir2_bulan.Text != "" && tgllahir2_tahun.Text != "") tglLahirKeluarga2 = convertToDate(tgllahir2_hari.Text, tgllahir2_bulan.Text, tgllahir2_tahun.Text); if (ak3.Text != "") if (tgllahir3_hari.Text != "" && tgllahir3_bulan.Text != "" && tgllahir3_tahun.Text != "") tglLahirKeluarga3 = convertToDate(tgllahir3_hari.Text, tgllahir3_bulan.Text, tgllahir3_tahun.Text); if (ak4.Text != "") if (tgllahir4_hari.Text != "" && tgllahir4_bulan.Text != "" && tgllahir4_tahun.Text != "") tglLahirKeluarga4 = convertToDate(tgllahir4_hari.Text, tgllahir4_bulan.Text, tgllahir4_tahun.Text); DateTime tanggaldelivery = convertToDate(tgldo_hari.Text, tgldo_bulan.Text, tgldo_tahun.Text); if (npa.Text != "") { namaPerusahaanAsuransi = npa.Text; if (tglasuransi_hari.Text != "" && tglasuransi_bulan.Text != "" && tglasuransi_tahun.Text != "") tglAsuransi = convertToDate(tglasuransi_hari.Text, tglasuransi_bulan.Text, tglasuransi_tahun.Text); if (combobox_jta.SelectedItem.ToString() != ("")) jumlahTahunAsuransi = Convert.ToInt32(combobox_jta.SelectedItem.ToString()); } DateTime tanggalSTNK = convertToDate(tglstnk_hari.Text, tglstnk_bulan.Text, tglstnk_tahun.Text); if (radiobtn_pria.Checked) { jenkel = "Pria"; } else { jenkel = "Wanita"; } if (combobox_agama.SelectedIndex == -1) { tmpAgama = ""; } else { tmpAgama = combobox_agama.SelectedItem.ToString(); } try { shipper = new DAL(); string pembayaran; if (radiobtn_credit.Checked) { pembayaran = "Credit"; tmpJmlTahunKredit = Convert.ToInt32(combobox_jtk.SelectedItem.ToString()); } else { pembayaran = "Cash"; } //Update Biodata Customer shipper.Update_Customer_Data(_conn, _idCustomer, namacus.Text, alamat.Text, notlpn.Text, hp1.Text, hp2.Text, email.Text, tglLahirCustomer, jenkel, tmpAgama, ak1.Text, ak2.Text, ak3.Text, ak4.Text, tglLahirKeluarga1, tglLahirKeluarga2, tglLahirKeluarga3, tglLahirKeluarga4); //Update Transaksi shipper.Update_Customer_Car_Data(_conn, _idCustomer, _tipeMobil, tipeMobilTxt.Text, warnaMobilTxt.Text, tanggaldelivery, tanggalSTNK, tglAsuransi, namaPerusahaanAsuransi, jumlahTahunAsuransi, pembayaran, tmpJmlTahunKredit); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Register Success"); this.DialogResult = DialogResult.OK; this.Close(); } }