private void FrmROEntry_Load(object sender, EventArgs e)
{
cs.FrmStyle(this);
IsNewRo = true;
DataSet ds;
//ds = db.GetMasterData("Select agency_code, agency_name || '('|| agency_code ||')' Agency_name, action_type from mas_agency");
//CmbAgency.DataSource = ds.Tables[0];
//CmbAgency.DisplayMember = "Agency_name";
//CmbAgency.ValueMember = "Agency_Code";
//ds = db.GetMasterData("select client_code, client_name ||'('|| client_code ||')' client_name, action_type from mas_client");
//CmbClient.DataSource = ds.Tables[0];
//CmbClient.DisplayMember = "Client_Name";
//CmbClient.ValueMember = "Client_code";
ds = db.GetMasterData("Select region_code, region_name || '('|| region_code ||')' region_name, action_type from mas_region");
CmbRegion.DataSource = ds.Tables[0];
CmbRegion.DisplayMember = "REgion_name";
CmbRegion.ValueMember = "Region_code";
ds = db.GetTableData("select ad_category_code, ad_category_name ||'('|| ad_category_code ||')' ad_category_name, action_type from mas_ad_category");
CmbADCategory.DataSource = ds.Tables[0];
CmbADCategory.DisplayMember = "ad_category_name";
CmbADCategory.ValueMember = "AD_category_Code";
ds = db.GetMasterData("select emp_code, emp_name ||'('|| emp_code ||')' emp_name, action_type from mas_employee");
CmbExecutive.DataSource = ds.Tables[0];
CmbExecutive.DisplayMember = "emp_name";
CmbExecutive.ValueMember = "emp_Code";
ds = db.GetMasterData("Select spot_code,spot_details ||'('|| spot_code ||')' Spot_Details, action_type from mas_spot_category");
CmbSpotCategory.DataSource = ds.Tables[0];
CmbSpotCategory.DisplayMember = "spot_details";
CmbSpotCategory.ValueMember = "spot_code";
TxtROCode.Text = GetROCode();
}