private void FillCampGroups(string CompCode, string BranCode, string DocMonth)
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
clbCamps.Items.Clear();
try
{
dt = GetServiceCampGroups(CompCode, BranCode, DocMonth).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = item["lgm_group_name"].ToString();
oclBox.Text = item["lgm_group_name"].ToString();
clbCamps.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objSQLdb = null;
dt = null;
}
}
private void GetFilesInFolder(string sPath)
{
clbFiles.Items.Clear();
string folder = sPath;
if (sPath.Length > 1)
{
//@"C:\\Program Files\\RS Solution\\Realsoft 8.8\\McDataFiles";
var files = Directory.GetFiles(folder, "*.dat", SearchOption.AllDirectories);
if (files != null)
{
foreach (string file in files)
{
string fname = Path.GetFileNameWithoutExtension(file);
if (fname.Length < 9)
{
//string sDate = fname.Substring(0, 2) + "-" + fname.Substring(2, 2) + "-" + fname.Substring(4, 2);
//DateTime dtPunchDate = Convert.ToDateTime(sDate);
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = Path.GetFileName(file);
oclBox.Text = Path.GetFileName(file);
clbFiles.Items.Add(oclBox);
oclBox = null;
}
}
}
}
}
private void FillActivityTypes(string CategoryCode)
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
string strCmd = "";
clbActivityTypes.Items.Clear();
try
{
strCmd = "SELECT DISTINCT SAM_ACTIVITY_SHORT_NAME ActivityName " +
" FROM SERVICES_ACTIVITIES_MAS " +
"INNER JOIN SERVICES_TNA ON TNA_ACTIVITY_ID=SAM_ACTIVITY_ID " +
" where SAM_CATEGORY_ID in (" + CategoryCode + ") ";
dt = objSQLdb.ExecuteDataSet(strCmd).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = item["ActivityName"].ToString();
oclBox.Text = item["ActivityName"].ToString();
clbActivityTypes.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
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;
}
}
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;
}
}
private void FillUserCompanyData()
{
objSQLDB = new SQLDB();
DataTable dt = new DataTable();
//string strCommand = "";
clbCompany.Items.Clear();
try
{
dt = Get_UserCompanyBranchFilterCursor("", CommonData.LogUserId, "", "PARENT").Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = item["COMPANY_CODE"].ToString();
oclBox.Text = item["COMPANY_NAME"].ToString();
clbCompany.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void FillGLList()
{
objStfLvl = new StaffLevel();
DataTable dt = null;
try
{
dt = objStfLvl.BranchGLList_Get(CommonData.CompanyCode, CommonData.BranchCode, Convert.ToDateTime(dtpDate.Value).ToString("MMMyyyy")).Tables[0];
clbGLList.Items.Clear();
foreach (DataRow dataRow in dt.Rows)
{
if (dataRow["ECODE"] + "" != "")
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["ECODE"].ToString();
oclBox.Text = dataRow["ENAME"].ToString();
clbGLList.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objStfLvl = null;
}
}
private void FillBranchGroupData()
{
IndentDB objIndent = new IndentDB();
try
{
cbGroup.DataSource = null;
cbGroup.Items.Clear();
DataTable dtGroup = objIndent.IndentGroupList_Get(CommonData.CompanyCode.ToString(), CommonData.BranchCode, CommonData.DocMonth).Tables[0];
if (dtGroup.Rows.Count > 0)
{
foreach (DataRow dataRow in dtGroup.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
string[] ename = dataRow["ENAME"].ToString().Split('~');
oclBox.Tag = dataRow["ENAME"].ToString();
oclBox.Text = dataRow["GroupName"].ToString();
cbGroup.Items.Add(oclBox);
oclBox = null;
}
}
dtGroup = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objIndent = null;
}
}
private void FillEmployeeDetails(string strDevSlNo)
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
try
{
dt = GetEmployeeDetails("", strBranCode, strDevSlNo, strFrmDate, strToDate, "").Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Text = dataRow["DisplayMenber"].ToString();
oclBox.Tag = dataRow["ValueMember"].ToString();
clbEmployees.Items.Add(oclBox);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void FillCompanyData()
{
objData = new SQLDB();
DataTable dt = new DataTable();
try
{
string strCommand = "SELECT DISTINCT(CM_COMPANY_NAME),CM_COMPANY_CODE FROM COMPANY_MAS WHERE CM_COMPANY_CODE in (SELECT DAMH_COMPANY_CODE FROM DL_APPL_MASTER_HEAD)";
dt = objData.ExecuteDataSet(strCommand).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
//clbCompany.Items.Add(item["CM_COMPANY_NAME"].ToString(), false);
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = item["CM_COMPANY_CODE"].ToString();
oclBox.Text = item["CM_COMPANY_NAME"].ToString();
clbCompany.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objData = null;
dt = null;
}
}
private void FillEmployeeList()
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
string strCmd = "";
clbEmployees.Items.Clear();
GetSelectedValues();
if (Company.Length > 0 && Branches.Length > 3)
{
try
{
strCmd = "exec Get_ServiceEmployeeList '" + Company + "','" + Branches + "', '" + dtpFrmDocMonth.Value.ToString("MMMyyyy").ToUpper() +
"', '" + dtpToDocMonth.Value.ToString("MMMyyyy").ToUpper() + "'";
dt = objSQLdb.ExecuteDataSet(strCmd).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = item["Ecode"].ToString();
oclBox.Text = item["EmpName"].ToString();
clbEmployees.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void FillDesignationsData(string strDeptCode)
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
try
{
string strCmd = "SELECT DISTINCT(desig_name), desig_code FROM DESIG_MAS " +
" WHERE CAST(dept_code AS VARCHAR)IN(" + strDeptCode + ") ORDER BY desig_name";
dt = objSQLdb.ExecuteDataSet(strCmd).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Text = dataRow["desig_name"].ToString();
oclBox.Tag = dataRow["desig_code"].ToString();
clbDesigs.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objSQLdb = null;
dt = null;
}
}
private void FillDepartmentData()
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
clbDesigs.Items.Clear();
try
{
string strCommand = "SELECT DISTINCT dept_name,dept_code FROM Dept_Mas ORDER BY dept_name";
dt = objSQLdb.ExecuteDataSet(strCommand).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Text = dataRow["dept_name"].ToString();
oclBox.Tag = dataRow["dept_code"].ToString();
clbDepartments.Items.Add(oclBox);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objSQLdb = null;
dt = null;
}
}
private void FillIndentCompanyData()
{
objSQLDB = new SQLDB();
DataTable dt = new DataTable();
//string strCommand = "";
clbCompany.Items.Clear();
try
{
dt = Get_IndentCompanyBranchFilterCursor(Convert.ToInt32(txtIndentNo.Text), FinYear, "PARENT").Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = item["SIH_COMPANY_CODE"].ToString();
oclBox.Text = item["COMPANY_NAME"].ToString();
//clbCompany.Items.Add(oclBox);
clbCompany.Items.Add(oclBox, CheckState.Checked);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void FillDestinationComboBox(int nLevelId)
{
objServicedb = new ServiceDB();
DataTable dt = new DataTable();
clbDestination.Items.Clear();
GetUserBranches();
try
{
dt = objServicedb.EcodesForService_Get(strBranch, nLevelId, "").Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["ECODE"].ToString();
oclBox.Text = dataRow["Ename"].ToString();
clbDestination.Items.Add(oclBox);
oclBox = null;
}
}
dt = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objServicedb = null;
}
}
private void FillBranchData()
{
IndentDB objIndent = new IndentDB();
try
{
DataTable dtBranch = objIndent.IndentStockPointList_Get(CommonData.CompanyCode.ToString()).Tables[0];
if (dtBranch.Rows.Count > 0)
{
foreach (DataRow dataRow in dtBranch.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["branch_code"].ToString();
oclBox.Text = dataRow["branch_name"].ToString();
cbBranches.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (cbBranches.SelectedIndex > -1)
{
strBranchCode = ((System.Data.DataRowView)(cbBranches.SelectedItem)).Row.ItemArray[0].ToString();
FillBranchGroupData();
}
objIndent = null;
}
}
private void FillUsers()
{
objMaster = new Master();
DataTable dt = null;
try
{
dt = objMaster.UserMasterList_Get(CommonData.CompanyCode, CommonData.BranchCode).Tables[0];
foreach (DataRow dataRow in dt.Rows)
{
if (dataRow["UM_USER_ID"] + "" != "")
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["UM_USER_ID"].ToString();
oclBox.Text = dataRow["UM_USER_NAME"].ToString() + " ( " + dataRow["UM_USER_ID"].ToString() + " )";
clbUsers.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objMaster = null;
}
}
private void FillMappedSourceECodes()
{
DataTable dt = null;
objStaffLevel = new StaffLevel();
clbdlinkSource.Items.Clear();
try
{
dt = objStaffLevel.AboveBranchLeaders_InQ_Get(cbDocmonth.SelectedValue.ToString(), ((NewCheckboxListItem)(clbdlinkEmplist.SelectedItem)).Tag.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["xDest_ecode"].ToString();
oclBox.Text = dataRow["xDest_ecode"].ToString() + "-" + dataRow["xDest_eName"].ToString() + "-(" + dataRow["xDest_NoG"].ToString() + ")";
clbdlinkSource.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objStaffLevel = null;
dt = null;
}
}
private void FillBranchData()
{
IndentDB objIndent = new IndentDB();
try
{
DataTable dtBranch = objIndent.IndentStockPointList_Get(CommonData.CompanyCode.ToString()).Tables[0];
DataRow dr = dtBranch.NewRow();
dr[0] = "0";
dr[1] = "Select";
dtBranch.Rows.InsertAt(dr, 0);
dr = null;
if (dtBranch.Rows.Count > 0)
{
foreach (DataRow dataRow in dtBranch.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["branch_code"].ToString();
oclBox.Text = dataRow["branch_name"].ToString();
cbBranches.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objIndent = null;
}
}
private void FillBranchData()
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
try
{
string strCommand = "SELECT BRANCH_NAME,BRANCH_CODE FROM BRANCH_MAS" +
" WHERE COMPANY_CODE='" + CommonData.CompanyCode +
"' AND BRANCH_TYPE IN('BR') ORDER BY BRANCH_NAME ";
dt = objSQLdb.ExecuteDataSet(strCommand).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Text = dataRow["BRANCH_NAME"].ToString();
oclBox.Tag = dataRow["BRANCH_CODE"].ToString();
clbBranches.Items.Add(oclBox);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objSQLdb = null;
dt = null;
}
}
private void FillAssets()
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
try
{
string strCommand = "SELECT DISTINCT(FAH_ASSET_TYPE) FROM FIXED_ASSETS_HEAD ORDER BY FAH_ASSET_TYPE ASC;";
dt = objSQLdb.ExecuteDataSet(strCommand).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["FAH_ASSET_TYPE"].ToString();
oclBox.Text = dataRow["FAH_ASSET_TYPE"].ToString();
clbAssets.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objSQLdb = null;
dt = null;
}
}
private void FillUserBranchData()
{
objData = new SQLDB();
//string sqlText = "";
DataTable dt = new DataTable();
try
{
string strCommand = "SELECT UB_BRANCH_CODE ,BRANCH_NAME FROM USER_BRANCH " +
" INNER JOIN BRANCH_MAS ON UB_BRANCH_CODE=BRANCH_CODE WHERE UB_USER_ID='" + CommonData.LogUserId + "'";
dt = objData.ExecuteDataSet(strCommand).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
if (dataRow["BRANCH_NAME"] + "" != "")
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["UB_BRANCH_CODE"].ToString();
oclBox.Text = dataRow["BRANCH_NAME"].ToString();
cblBranchesList.Items.Add(oclBox);
oclBox = null;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objData = null;
dt = null;
}
//objData = new SQLDB();
//string sqlText = "";
//DataTable dt = new DataTable();
////sqlText = "SELECT DISTINCT COMPANY_CODE FROM USER_BRANCH INNER JOIN BRANCH_MAS ON BRANCH_CODE = UB_BRANCH_CODE WHERE UB_USER_ID = '" + CommonData.LogUserId + "'";
////dt = objData.ExecuteDataSet(sqlText).Tables[0];
////if (dt.Rows.Count > 0)
////{
//// for (int i = 0; i < dt.Rows.Count; i++)
//// {
//// if (strComp != "")
//// strComp += ",";
//// strComp += dt.Rows[i]["COMPANY_CODE"].ToString();
//// }
////}
////else
////{
//// strComp += CommonData.CompanyCode.ToString();
////}
}
private void FillBranches(string strStates, string strType)
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
string strCmd = "";
clbbranch.Items.Clear();
if (strStates.Length > 0)
{
try
{
if (chkBrTypeAll.Checked == true)
{
strCmd = "SELECT DISTINCT BRANCH_NAME,BRANCH_CODE+'@'+STATE_CODE as BranchCode FROM USER_BRANCH " +
" INNER JOIN BRANCH_MAS ON BRANCH_CODE = UB_BRANCH_CODE " +
" WHERE UB_USER_ID ='" + CommonData.LogUserId +
"' and STATE_CODE in (" + strStates + ") and ACTIVE='T' " +
" ORDER BY BRANCH_NAME ASC";
}
else
{
if (strType.Length > 0)
{
strCmd = "SELECT DISTINCT BRANCH_NAME,BRANCH_CODE+'@'+STATE_CODE as BranchCode FROM USER_BRANCH " +
" INNER JOIN BRANCH_MAS ON BRANCH_CODE = UB_BRANCH_CODE " +
" WHERE UB_USER_ID ='" + CommonData.LogUserId +
"' and STATE_CODE in (" + strStates + ") and ACTIVE='T' " +
" and BRANCH_TYPE IN (" + strBrType + ") ORDER BY BRANCH_NAME ASC";
}
}
if (strCmd.Length > 0)
{
dt = objSQLdb.ExecuteDataSet(strCmd).Tables[0];
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dr["BranchCode"].ToString();
oclBox.Text = dr["BRANCH_NAME"].ToString();
clbbranch.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
dt = null;
objSQLdb = null;
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtDestEName.Text.Trim().Length > 0)
{
if (txtSourceEname.Text.Trim().Length > 0)
{
objDB = new SQLDB();
DataTable dt = new DataTable();
string sqlText = "select * from LevelSource_Dest_mapping where lsd_source_ecode = " + txtSorceEcode.Text + " and lsd_doc_month = '" + cbDocmonth.Text + "'";
try
{
dt = objDB.ExecuteDataSet(sqlText).Tables[0];
if (dt.Rows.Count == 0)
{
for (int i = 0; i < clbSource.Items.Count; i++)
{
if (((SSAdmin.NewCheckboxListItem)(clbSource.Items[i])).Tag.ToString() == txtSorceEcode.Text + "^" + cmbSourceDesig.SelectedValue.ToString())
{
MessageBox.Show("Allready Added to list", "SSERP", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = txtSorceEcode.Text + "^" + cmbSourceDesig.SelectedValue.ToString();
oclBox.Text = txtSourceEname.Text;
clbSource.Items.Add(oclBox);
oclBox = null;
clbSource.SetItemCheckState(clbSource.Items.Count - 1, CheckState.Checked);
}
else
{
MessageBox.Show("Allready Mapped With " + dt.Rows[0]["lsd_dest_ecode"].ToString(), "SSERP", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objDB = null;
}
}
else
{
MessageBox.Show("Enter Source Employee Ecode", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Enter Destination Employee Ecode", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Retrieves audio and subtitle streams through FFDShow
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void getFFDShowStreams_Click(object sender, EventArgs e)
{
this.audioStreamlistBox.ItemCheck -= new System.Windows.Forms.ItemCheckEventHandler(this.audioStreamlistBox_ItemCheck);
this.subtitleStreamlistBox.ItemCheck -= new System.Windows.Forms.ItemCheckEventHandler(this.subtitleStreamlistBox_ItemCheck);
audioStreamlistBox.Items.Clear();
subtitleStreamlistBox.Items.Clear();
using (FFDShowAPI ffdshowAPI = new FFDShowAPI())
{
if (!ffdshowAPI.checkFFDShowActive())
{
return;
}
SortedDictionary <int, FFDShowAPI.Stream> audioStreams = ffdshowAPI.AudioStreams;
SortedDictionary <int, FFDShowAPI.Stream> subtitleStreams = ffdshowAPI.SubtitleStreams;
int currentAudioStream = ffdshowAPI.AudioStream;
int currentSubtitleStream = ffdshowAPI.SubtitleStream;
foreach (KeyValuePair <int, FFDShowAPI.Stream> stream in audioStreams)
{
NewCheckboxListItem chk = new NewCheckboxListItem();
chk.Text = stream.Value.name + "(" + stream.Value.languageName + ")";
chk.Tag = stream.Key;
audioStreamlistBox.Items.Add(chk);
if (stream.Key == currentAudioStream)
{
audioStreamlistBox.SetItemChecked(audioStreamlistBox.Items.Count - 1, true);
}
}
foreach (KeyValuePair <int, FFDShowAPI.Stream> stream in subtitleStreams)
{
NewCheckboxListItem chk = new NewCheckboxListItem();
chk.Text = stream.Value.name + "(" + stream.Value.languageName + ")";
chk.Tag = stream.Key;
subtitleStreamlistBox.Items.Add(chk);
if (stream.Key == currentSubtitleStream)
{
subtitleStreamlistBox.SetItemChecked(subtitleStreamlistBox.Items.Count - 1, true);
}
}
subtitleStreamlistBox.Refresh();
audioStreamlistBox.Refresh();
tabControl1.SelectedTab = tabPage3;
this.audioStreamlistBox.ItemCheck += new System.Windows.Forms.ItemCheckEventHandler(this.audioStreamlistBox_ItemCheck);
this.subtitleStreamlistBox.ItemCheck += new System.Windows.Forms.ItemCheckEventHandler(this.subtitleStreamlistBox_ItemCheck);
}
}
/// <summary>
/// Switch of subtitle stream
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void subtitleStreamlistBox_ItemCheck(object sender, ItemCheckEventArgs e)
{
NewCheckboxListItem item = (NewCheckboxListItem)subtitleStreamlistBox.SelectedItem;
int streamNb = (int)item.Tag;
using (FFDShowAPI ffdshowAPI = new FFDShowAPI())
{
if (!ffdshowAPI.checkFFDShowActive())
{
return;
}
SortedDictionary <int, FFDShowAPI.Stream> subtitleStreams = ffdshowAPI.SubtitleStreams;
ffdshowAPI.SubtitleStream = streamNb;
getFFDShowStreams_Click(null, null);
}
}
private void FillActualTrainerDetails()
{
objSQLdb = new SQLDB();
DataTable dt = new DataTable();
clbPrograms.Items.Clear();
string strCommand = "";
try
{
strCommand = "SELECT DISTINCT(CAST(HTAH_TRAINER_ECODE AS VARCHAR)+'-'+MEMBER_NAME) EmpName " +
", HTAH_TRAINER_ECODE EmpEcode " +
" FROM HR_TRAINING_ACTUAL_HEAD " +
" inner JOIN EORA_MASTER ON ECODE=HTAH_TRAINER_ECODE " +
" WHERE HTAH_TRAINER_FLAG='INTERNAL' " +
" and HTAH_ACTUAL_PROGRAM_FROM_DATE BETWEEN '" + dtpFromdate.Value.ToString("dd/MMM/yyyy") +
"' AND '" + dtpToDate.Value.ToString("dd/MMM/yyyy") + "' ORDER BY EmpName asc";
if (strCommand.Length > 5)
{
dt = objSQLdb.ExecuteDataSet(strCommand).Tables[0];
}
if (dt.Rows.Count > 0)
{
chkAllPrgs.Visible = true;
btnReport.Enabled = true;
foreach (DataRow dataRow in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Text = dataRow["EmpName"].ToString();
oclBox.Tag = dataRow["EmpEcode"].ToString();
clbPrograms.Items.Add(oclBox);
oclBox = null;
}
}
else
{
btnReport.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void GetMappedData()
{
objDB = new SQLDB();
DataTable dt = new DataTable();
clbSource.Items.Clear();
try
{
string sqlText = "SELECT " +
"lsd_doc_month," +
"lsd_source_desig_id," +
"lsd_source_elevel_id," +
"lsd_source_ecode," +
"CAST(ES.ECODE AS VARCHAR)+'-'+ES.MEMBER_NAME+'-('+ES.DESIG+')' lsd_source_ename," +
"lsd_dest_desig_id," +
"lsd_dest_elevel_id," +
"lsd_dest_ecode," +
"CAST(ED.ECODE AS VARCHAR)+'-'+ED.MEMBER_NAME+'-('+ED.DESIG+')' lsd_dest_ename " +
"from LevelSource_Dest_mapping " +
"INNER JOIN EORA_MASTER ES ON ES.ECODE = lsd_source_ecode " +
"INNER JOIN EORA_MASTER ED ON ED.ECODE = lsd_dest_ecode " +
"WHERE lsd_dest_ecode = " + txtDestEcode.Text + " AND lsd_doc_month = '" + cbDocmonth.SelectedValue.ToString() + "'";
dt = objDB.ExecuteDataSet(sqlText).Tables[0];
if (dt.Rows.Count > 0)
{
cmbDestDesig.SelectedValue = dt.Rows[0]["lsd_dest_desig_id"].ToString() + "^" + dt.Rows[0]["lsd_dest_elevel_id"].ToString();
foreach (DataRow dataRow in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["lsd_source_ecode"].ToString() + "^" + dataRow["lsd_source_desig_id"].ToString() + "^" + dataRow["lsd_source_elevel_id"].ToString();
oclBox.Text = dataRow["lsd_source_ename"].ToString();
clbSource.Items.Add(oclBox);
oclBox = null;
clbSource.SetItemCheckState(clbSource.Items.Count - 1, CheckState.Checked);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
dt = null;
objDB = null;
}
}
private void FillStates(string sCmp)
{
//string[] sCmps
DataTable dt = null;
objData = new SQLDB();
string strCmd = "";
clbState.Items.Clear();
strChkState = "";
strChkDistrict = "";
if (sCmp.Length > 0)
{
sCmp = sCmp.Remove(sCmp.Length - 1);
strCmd = "SELECT DISTINCT(DAMH_FIRM_HEAD_STATE),BM.STATE_CODE StateCode FROM DL_APPL_MASTER_HEAD INNER JOIN BRANCH_MAS BM ON STATE = DAMH_FIRM_HEAD_STATE WHERE DAMH_COMPANY_CODE IN(" + sCmp + ")";
}
//else
//{
// //strCmd = " SELECT DISTINCT(STATE) FROM BRANCH_MAS WHERE BRANCH_CODE in(SELECT damh_branch_code FROM DL_APPL_MASTER_HEAD)";
// strCmd = "SELECT DISTINCT(DAMH_FIRM_HEAD_STATE),BM.STATE_CODE StateCode FROM DL_APPL_MASTER_HEAD INNER JOIN BRANCH_MAS BM ON STATE = DAMH_FIRM_HEAD_STATE";
//}
try
{
dt = objData.ExecuteDataSet(strCmd).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = item["DAMH_FIRM_HEAD_STATE"].ToString();
oclBox.Text = item["DAMH_FIRM_HEAD_STATE"].ToString();
clbState.Items.Add(oclBox);
oclBox = null;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objData = null;
dt = null;
}
}
private void FillSourceComboBox()
{
objAuditdb = new AuditDB();
DataTable dt = new DataTable();
string[] strDestCode = ((NewCheckboxListItem)(clbDestination.SelectedItem)).Tag.Split('~');
clbSource.Items.Clear();
try
{
dt = objAuditdb.LevelGroupAuditEcodes_Get(Convert.ToInt32(strDestCode[0]), Convert.ToDateTime(dtpDocMonth.Value).ToString("MMMyyyy").ToUpper()).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
if (dataRow["Mapped"].ToString() == "99999")
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["ECODE"].ToString();
oclBox.Text = dataRow["ENAME"].ToString();
clbSource.Items.Add(oclBox);
oclBox = null;
}
else
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["ECODE"].ToString();
oclBox.Text = dataRow["ENAME"].ToString();
clbSource.Items.Add(oclBox, CheckState.Checked);
oclBox = null;
}
}
}
dt = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objAuditdb = null;
}
}
/// <summary>
/// Retrieves audio and subtitle streams through FFDShow
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void getFFDShowStreams_Click(object sender, EventArgs e)
{
this.audioStreamlistBox.ItemCheck -= new System.Windows.Forms.ItemCheckEventHandler(this.audioStreamlistBox_ItemCheck);
this.subtitleStreamlistBox.ItemCheck -= new System.Windows.Forms.ItemCheckEventHandler(this.subtitleStreamlistBox_ItemCheck);
audioStreamlistBox.Items.Clear();
subtitleStreamlistBox.Items.Clear();
using (FFDShowAPI ffdshowAPI = new FFDShowAPI())
{
if (!ffdshowAPI.checkFFDShowActive()) return;
SortedDictionary<int, FFDShowAPI.Stream> audioStreams = ffdshowAPI.AudioStreams;
SortedDictionary<int, FFDShowAPI.Stream> subtitleStreams = ffdshowAPI.SubtitleStreams;
int currentAudioStream = ffdshowAPI.AudioStream;
int currentSubtitleStream = ffdshowAPI.SubtitleStream;
foreach (KeyValuePair<int,FFDShowAPI.Stream> stream in audioStreams)
{
NewCheckboxListItem chk = new NewCheckboxListItem();
chk.Text = stream.Value.name + "(" + stream.Value.languageName + ")";
chk.Tag = stream.Key;
audioStreamlistBox.Items.Add(chk);
if (stream.Key == currentAudioStream)
{
audioStreamlistBox.SetItemChecked(audioStreamlistBox.Items.Count - 1, true);
}
}
foreach (KeyValuePair<int, FFDShowAPI.Stream> stream in subtitleStreams)
{
NewCheckboxListItem chk = new NewCheckboxListItem();
chk.Text = stream.Value.name + "(" + stream.Value.languageName + ")";
chk.Tag = stream.Key;
subtitleStreamlistBox.Items.Add(chk);
if (stream.Key == currentSubtitleStream)
{
subtitleStreamlistBox.SetItemChecked(subtitleStreamlistBox.Items.Count-1, true);
}
}
subtitleStreamlistBox.Refresh();
audioStreamlistBox.Refresh();
tabControl1.SelectedTab = tabPage3;
this.audioStreamlistBox.ItemCheck += new System.Windows.Forms.ItemCheckEventHandler(this.audioStreamlistBox_ItemCheck);
this.subtitleStreamlistBox.ItemCheck += new System.Windows.Forms.ItemCheckEventHandler(this.subtitleStreamlistBox_ItemCheck);
}
}