private void FillGroupMappedSourceDataGrid(int intRow)
{
objServicedb = new ServiceDB();
DataTable dt = new DataTable();
string strLogBcode = string.Empty;
string strLoadedEcode = string.Empty;
string[] strLvlEcode = gvMappedGroups.Rows[intRow].Cells["ecode"].Value.ToString().Split('~');
cbGroupCamp.Text = gvMappedGroups.Rows[intRow].Cells["GroupName"].Value.ToString();
clbSource.Items.Clear();
try
{
dt = objServicedb.ServiceLevelGroupEcodeMapped_Get(CommonData.CompanyCode, cbBranches.SelectedValue.ToString(), cbStates.SelectedValue.ToString(), Convert.ToInt32(strLvlEcode[1]), Convert.ToInt32(strLvlEcode[0]), strLogBcode).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
if (dataRow["ENAME"].ToString().Trim().Length > 0)
{
if (dataRow["mapped"].ToString() == "999999")
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["ECODE"].ToString();
oclBox.Text = dataRow["ENAME"].ToString();
clbSource.Items.Add(oclBox);
oclBox = null;
}
else
{
if (strLvlEcode[0].IndexOf(dataRow["ECODE"].ToString().Substring(0, dataRow["ECODE"].ToString().IndexOf("~"))) < 0)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["ECODE"].ToString();
oclBox.Text = dataRow["ENAME"].ToString();
if (!strLoadedEcode.Contains(dataRow["ECODE"].ToString()))
{
clbSource.Items.Add(oclBox, CheckState.Checked);
}
strLoadedEcode += dataRow["ECODE"].ToString() + ",";
//clbSource.Items.Add(oclBox, CheckState.Checked);
oclBox = null;
}
}
}
}
}
dt = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objServicedb = null;
}
}
