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();
}
}
