public SearchCustomer() { InitializeComponent(); SqlCustomerRepository sqlCustomerRepository = new SqlCustomerRepository(); listCustomer = sqlCustomerRepository.listCustomerForPriceList(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } CustomerGridView.DataSource = listCustomer; sqlCustomerRepository = null; }
public newLeadTime(Surat objSurat, rptLeadTimeControl objParent) { InitializeComponent(); this.objParent = objParent; sqlCustomerRepository = new SqlCustomerRepository(); List<Customer> listCustomer = sqlCustomerRepository.listCustomerForPriceList(); cboCustomer.DataSource = listCustomer; cboCustomer.DisplayMember = "CustomerName"; cboCustomer.ValueMember = "ID"; if (objSurat == null) { surat = new Surat(); sqlSuratRepository = new SqlSuratRepository(); isCreateNew = true; Surat tempSurat = sqlSuratRepository.GetlastNoSurat(EnumSurat.LeadTime); String strTempNoSurat = (tempSurat == null) ? "0" : tempSurat.NoSurat.Substring(0, 4); etNoSurat.Text = surat.GenerateNoSurat(Int32.Parse(strTempNoSurat), EnumSurat.LeadTime); listCustomer = null; tempSurat = null; strTempNoSurat = null; sqlSuratRepository = null; } else { isCreateNew = false; surat = objSurat; etNoSurat.Text = objSurat.NoSurat; radDateTimePicker1.Value = objSurat.Tgl; cboCustomer.SelectedValue = objSurat.CustomerID; } sqlCustomerRepository = null; }
private void cbSearch_SelectedIndexChanged(object sender, EventArgs e) { if (cbSearch.Text.ToLower().Equals("all")) { rtsiHal.Visibility = ElementVisibility.Collapsed; rtsiCustomer.Visibility = ElementVisibility.Collapsed; } else if (cbSearch.Text.ToLower().Equals("hal")) { rtsiHal.Visibility = ElementVisibility.Visible; rtsiCustomer.Visibility = ElementVisibility.Collapsed; sqlSuratRepository = new SqlSuratRepository(); listSurat = sqlSuratRepository.ListSurat(EnumSurat.LeadTime); cbHal.DataSource = listSurat; cbHal.DisplayMember = "NoSurat"; sqlSuratRepository = null; } else if (cbSearch.Text.ToLower().Equals("customer")) { rtsiHal.Visibility = ElementVisibility.Collapsed; rtsiCustomer.Visibility = ElementVisibility.Visible; SqlCustomerRepository sqlCustomerRepository = new SqlCustomerRepository(); List<Customer> listCustomer = sqlCustomerRepository.listCustomerForPriceList(); cboCustomer.DataSource = listCustomer; cboCustomer.DisplayMember = "CustomerName"; cboCustomer.ValueMember = "ID"; sqlCustomerRepository = null; listCustomer = null; } }