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;
        }
Example #2
0
        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;
            }

        }