private void cboMeterBoxCode_SelectedIndexChanged(object sender, EventArgs e) { mbmsEntities = new MBMSEntities(); if (cboMeterBoxCode.SelectedIndex > 0) { cboMeterSequence.Items.Clear(); string meterBoxID = Convert.ToString(cboMeterBoxCode.SelectedValue); var meterBoxData = (from m in mbmsEntities.MeterBoxes where m.MeterBoxID == meterBoxID select m).FirstOrDefault(); if (meterBoxData.MeterBoxName == "Single Box" || meterBoxData.MeterBoxName == "Three Phase Box") { cboMeterSequence.Enabled = true; cboMeterSequence.Items.Add(meterBoxData.Box + "1"); } else if (meterBoxData.MeterBoxName == "Single Phase 4 Unit Box") { cboMeterSequence.Enabled = true; cboMeterSequence.Items.Add(meterBoxData.Box + "1"); cboMeterSequence.Items.Add(meterBoxData.Box + "2"); cboMeterSequence.Items.Add(meterBoxData.Box + "3"); cboMeterSequence.Items.Add(meterBoxData.Box + "4"); } } else { cboMeterSequence.Enabled = false; } }
public static void BindShop(ComboBox cboCompanyName, bool includeALL = false) { if (includeALL) { MBMSEntities entity = new MBMSEntities(); List <CompanyProfile> companyProfileList = new List <CompanyProfile>(); CompanyProfile companyProfile = new CompanyProfile(); companyProfile.CompanyName = "ALL"; companyProfile.CompanyProfileID = null; var companys = entity.CompanyProfiles.ToList(); companyProfileList.Add(companyProfile); companyProfileList.AddRange(companys); cboCompanyName.DataSource = companyProfileList; cboCompanyName.DisplayMember = "CompanyName"; cboCompanyName.ValueMember = "CompanyProfileID"; cboCompanyName.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cboCompanyName.AutoCompleteSource = AutoCompleteSource.ListItems; } else { MBMSEntities entity = new MBMSEntities(); List <CompanyProfile> companyProfileList = new List <CompanyProfile>(); cboCompanyName.DataSource = companyProfileList; cboCompanyName.DisplayMember = "CompanyName"; cboCompanyName.ValueMember = "CompanyProfileID"; cboCompanyName.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cboCompanyName.AutoCompleteSource = AutoCompleteSource.ListItems; } }
private void cboQuarterName_SelectedIndexChanged(object sender, EventArgs e) { if (!isEdit) { if (cboQuarterName.SelectedIndex > 0) { mbmsEntities = new MBMSEntities(); string quarterID = Convert.ToString(cboQuarterName.SelectedValue); var quarterData = (from q in mbmsEntities.Quarters where q.QuarterID == quarterID select q).FirstOrDefault(); txtCustomerCode.Text = townsipCode + "-" + quarterData.QuarterCode; } } }
private void cboPoleNo_SelectedIndexChanged(object sender, EventArgs e) { mbmsEntities = new MBMSEntities(); if (cboPoleNo.SelectedIndex > 0) { string poleID = Convert.ToString(cboPoleNo.SelectedValue); var PoleData = (from t in mbmsEntities.Poles where t.PoleID == poleID select t).FirstOrDefault(); txtQuarterName.Text = PoleData.Transformer.Quarter.QuarterNameInEng; } else { txtQuarterName.Text = string.Empty; } }
private void cboTownshipName_SelectedIndexChanged(object sender, EventArgs e) { if (cboTownshipName.SelectedIndex > 0) { mbmsEntities = new MBMSEntities(); string townshipID = Convert.ToString(cboTownshipName.SelectedValue); List <Quarter> quarterList = new List <Quarter>(); Quarter quarter = new Quarter(); quarter.QuarterID = Convert.ToString(0); quarter.QuarterNameInEng = "Select"; quarterList.Add(quarter); quarterList.AddRange(mbmsEntities.Quarters.Where(x => x.Active == true && x.TownshipID == townshipID).OrderBy(x => x.QuarterNameInEng).ToList()); cboQuarterName.DataSource = quarterList; cboQuarterName.DisplayMember = "QuarterNameInEng"; cboQuarterName.ValueMember = "QuarterID"; var towshipData = (from t in mbmsEntities.Townships where t.TownshipID == townshipID select t).FirstOrDefault(); } }