private void FillGroupMappedSourceData(string strBCode, string strSCode)
{
objServicedb = new ServiceDB();
DataTable dt = new DataTable();
string strLogBcode = string.Empty;
string strLoadedEcode = string.Empty;
string[] strDestCode = ((NewCheckboxListItem)(clbDestination.SelectedItem)).Tag.Split('~');
clbSource.Items.Clear();
try
{
dt = objServicedb.LevelGroupServiceEcodeMapped_Get(CommonData.CompanyCode, strBCode, strSCode, Convert.ToInt32(strDestCode[0]), Convert.ToInt32(cbLevels.SelectedValue.ToString()), strLogBcode).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
if (dataRow["mapped"].ToString() == "999999")
{
cbGroupCamp.Text = dataRow["GroupName"].ToString();
cbLogcalBranch.Text = dataRow["logBranchName"].ToString();
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["ECODE"].ToString();
oclBox.Text = dataRow["ENAME"].ToString();
clbSource.Items.Add(oclBox);
oclBox = null;
}
else
{
if (strDestCode[0].IndexOf(dataRow["ECODE"].ToString().Substring(0, dataRow["ECODE"].ToString().IndexOf("~"))) < 0)
{
cbGroupCamp.Text = dataRow["GroupName"].ToString();
cbLogcalBranch.Text = dataRow["logBranchName"].ToString();
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;
}
}
