public static int?GetValueComboBoxInt(ComboBox cmd)
{
try
{
DropdownData castedItem = (DropdownData)cmd.SelectedItem;
return(Utility.GetInteger(castedItem.Code));
}
catch (Exception)
{
}
return(null);
}
private void SetComboBoxControl()
{
try
{
DateTime datenow = Program.GetServerDateTime();
var objmst_health_checkup = (from t1 in dbc.mst_health_checkups
where t1.mhc_status == 'A' &&
datenow >= t1.mhc_effective_date.Value &&
(t1.mhc_expire_date != null ? (datenow <= t1.mhc_expire_date.Value) : true)
select new DropdownData {
Code = t1.mhc_id, Name = t1.mhc_ename
}).ToList();
DropdownData newselect = new DropdownData();
newselect.Code = null;
newselect.Name = "- Select -";
objmst_health_checkup.Insert(0, newselect);
CBHealthCheckUPProgram.DataSource = objmst_health_checkup;
CBHealthCheckUPProgram.DisplayMember = "Name";
CBHealthCheckUPProgram.ValueMember = "Code";
if (objmst_health_checkup.Count > 0)
{
CBHealthCheckUPProgram.SelectedIndex = 0;
}
//Doctorcategory
var listdoctorCat = (from t1 in dbc.mst_doc_categories
where t1.mdc_status == 'A' &&
datenow >= t1.mdc_effective_date.Value &&
(t1.mdc_expire_date != null ? (datenow <= t1.mdc_expire_date.Value) : true)
orderby t1.mdc_ename ascending
select new DropdownData {
Code = t1.mdc_id, Name = t1.mdc_ename
}).ToList();
DropdownData newselect2 = new DropdownData();
newselect2.Code = null;
newselect2.Name = "- Select -";
listdoctorCat.Insert(0, newselect2);
CBDoctorCategory.DataSource = listdoctorCat;
CBDoctorCategory.ValueMember = "Code";
CBDoctorCategory.DisplayMember = "Name";
if (listdoctorCat.Count > 0)
{
CBDoctorCategory.SelectedIndex = 0;
}
var listAviationCat = (from t1 in dbc.mst_aviation_categories
where t1.mac_status == 'A' &&
datenow >= t1.mac_effective_date.Value &&
(t1.mac_expire_date != null ? (datenow <= t1.mac_expire_date.Value) : true)
orderby t1.mac_ename ascending
select new DropdownData {
Code = t1.mac_id, Name = t1.mac_ename
}).ToList();
DropdownData newselect3 = new DropdownData();
newselect3.Code = null;
newselect3.Name = "- Select -";
listAviationCat.Insert(0, newselect3);
CBAviationCategory.DataSource = listAviationCat;
CBAviationCategory.ValueMember = "Code";
CBAviationCategory.DisplayMember = "Name";
if (listAviationCat.Count > 0)
{
CBAviationCategory.SelectedIndex = 0;
}
}
catch (Exception ex)
{
Program.MessageError(this.Name, "SetComboBoxControl", ex, false);
throw;
}
}
