private void FillBranchComboBox(string strStateCode) { objData = new StaffLevel(); try { DataTable dt = objData.GetStateBranchesDS(CommonData.CompanyCode, strStateCode, CommonData.BranchCode).Tables[0]; if (dt.Rows.Count > 0) { //DataRow dr = dt.NewRow(); //dr[0] = "--Select--"; //dr[1] = "--Select--"; //dt.Rows.InsertAt(dr, 0); cbBranches.DataSource = dt; cbBranches.DisplayMember = "branch_name"; cbBranches.ValueMember = "branch_code"; } cbBranches.SelectedValue = CommonData.BranchCode; dt = null; } catch (Exception ex) { MessageBox.Show(ex.Message, "Group To Destination", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objData = null; } }
private void FillLogicalBranchComboBox() { objData = new StaffLevel(); try { DataTable dt = objData.LevelsLogicalBranchList_Get(cbBranches.SelectedValue.ToString()).Tables[0]; DataRow dr = dt.NewRow(); dr[0] = "--Select--"; dr[1] = "--Select--"; dt.Rows.InsertAt(dr, 0); if (dt.Rows.Count > 1) { cbLogcalBranch.DataSource = dt; cbLogcalBranch.DisplayMember = "Lbranch_name"; cbLogcalBranch.ValueMember = "Lbranch_code"; } dt = null; } catch (Exception ex) { MessageBox.Show(ex.Message, "Group To Destination", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objData = null; } }
private void FillBranchComboBox(string strStateCode) { objData = new StaffLevel(); try { DataTable dt = objData.LevelCompanyBranches_Proc(cbCompany.SelectedValue.ToString(), "BR").Tables[0]; cbBranches.DataSource = null; cbBranches.Items.Clear(); DataRow dr = dt.NewRow(); dr[0] = "Select"; dr[1] = "Select"; dt.Rows.InsertAt(dr, 0); if (dt.Rows.Count > 0) { cbBranches.DataSource = dt; cbBranches.DisplayMember = "branch_name"; cbBranches.ValueMember = "branch_code"; cbBranches.SelectedValue = CommonData.BranchCode; } dt = null; } catch (Exception ex) { MessageBox.Show(ex.Message, "Camp To BR-Head Above", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objData = null; } }
private void FillStateComboBox() { objData = new StaffLevel(); try { DataTable dt = objData.GetStatesDS().Tables[0]; if (dt.Rows.Count > 1) { cbStates.DataSource = dt; cbStates.DisplayMember = "State"; cbStates.ValueMember = "CDState"; } cbStates.SelectedValue = CommonData.StateCode; cbStates.Enabled = false; dt = null; } catch (Exception ex) { MessageBox.Show(ex.Message, "Group To Destination", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objData = null; } }
public override Guid Insert(StaffLevel entity) { var g = base.Insert(entity); LevelModel.Load(); return(g); }
private void FillBranchComboBox(string strStateCode) { objData = new StaffLevel(); try { strStateCode = cbStates.SelectedValue.ToString(); DataTable dt = objData.GetStateBranchesDS(CommonData.CompanyCode, strStateCode, CommonData.BranchCode).Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.NewRow(); dr[0] = "Select"; dr[1] = "Select"; dt.Rows.InsertAt(dr, 0); cbBranches.DataSource = dt; cbBranches.DisplayMember = "branch_name"; cbBranches.ValueMember = "branch_code"; } cbBranches.SelectedValue = CommonData.BranchCode; dt = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { objData = 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 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 FillCampComboBox() { objData = new StaffLevel(); try { DataTable dt = objData.LevelCampList_Get("T").Tables[0]; DataRow dr = dt.NewRow(); dr[0] = "--Select--"; dr[1] = "--Select--"; dt.Rows.InsertAt(dr, 0); if (dt.Rows.Count > 1) { cbGroupCamp.DataSource = dt; cbGroupCamp.DisplayMember = "CAMP_NAME"; cbGroupCamp.ValueMember = "CAMP_CODE"; } dt = null; } catch (Exception ex) { MessageBox.Show(ex.Message, "Source To Destination", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objData = null; } }
private void FillGroupDetailMappedData(int intRow) { if (intRow >= 0) { objData = new StaffLevel(); string strLogBcode = string.Empty; string[] strDestCode = gvMappedGroups.Rows[intRow].Cells["ecode"].Value.ToString().Split('~'); try { clbDestination.Items.Clear(); DataTable dt = objData.LevelGroupDetailEcodesMapped_Get(CommonData.CompanyCode, cbStates.SelectedValue.ToString(), cbBranches.SelectedValue.ToString(), Convert.ToInt32(strDestCode[1]), Convert.ToInt32(strDestCode[0]), strLogBcode).Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow dataRow in dt.Rows) { if (dataRow["mapped"].ToString() == "999999") { NewCheckboxListItem oclBox = new NewCheckboxListItem(); oclBox.Tag = dataRow["ECODE"].ToString(); oclBox.Text = dataRow["ENAME"].ToString(); clbDestination.Items.Add(oclBox, false); oclBox = null; } else { NewCheckboxListItem oclBox = new NewCheckboxListItem(); oclBox.Tag = dataRow["ECODE"].ToString(); oclBox.Text = dataRow["ENAME"].ToString(); clbDestination.Items.Add(oclBox, true); oclBox = null; } } } dt = null; } catch (Exception ex) { MessageBox.Show(ex.Message, "Group To Destination", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objData = null; } } }
private void FillBranchList() { objUtil = new UtilityDB(); DataTable dt = null; //string sqlText = ""; try { if (strRep == "STOCKPOINT_DC" || strRep == "STOCKPOINT_DCST" || strRep == "STOCKPOINT_GRN" || strRep == "STOCK_REC" || strRep == "STOCK_SUMMARY" || strRep == "STOCK_LEDGER" || strRep == "STOCKPOINT_RECONSILATION" || strRep == "SP_PENDING_DC") { dt = objUtil.UserBranch(CommonData.LogUserId, "SP"); } else if (strRep == "VEHICLE_LOAN" || strRep == "VEHICLE_INFO" || strRep == "SALES_STAFF_ALL" || strRep == "SaleSummaryBulletin" || strRep == "SERVICE_CONSOLIDATION") { dt = objUtil.UserBranch(CommonData.LogUserId, "BR"); } else { dt = objUtil.dtUserBranch(CommonData.LogUserId); } clbGLList.Items.Clear(); foreach (DataRow dataRow in dt.Rows) { if (dataRow["branch_Code"] + "" != "") { NewCheckboxListItem oclBox = new NewCheckboxListItem(); oclBox.Tag = dataRow["branch_Code"].ToString(); oclBox.Text = dataRow["branch_name"].ToString(); clbGLList.Items.Add(oclBox); oclBox = null; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { objStfLvl = null; } }
private void frmDocuments_Load(object sender, EventArgs e) { objData = new StaffLevel(); UtilityLibrary.PopulateControl(cmbDocument, objData.GetDocuments().Tables[0].DefaultView, 0, 1, "--PLEASE SELECT--", 0); objData = null; dtpDate.Value = System.DateTime.Now; if (drs != null) { cmbDocument.Text = drs[0][1].ToString(); if (Convert.ToBoolean(drs[0][2]) == false) { cbRecieved.SelectedIndex = 2; } else { cbRecieved.SelectedIndex = 1; } dtpDate.Value = Convert.ToDateTime(drs[0][3]); txtRemarks.Text = drs[0][4].ToString(); } }
private int DeleteMappedData() { string[] strArrDestCode = null; int nDelete = 0; objDA = new SQLDB(); objData = new StaffLevel(); string strDelete = ""; try { for (int row = 0; row < gvMappedGroups.Rows.Count; row++) { if (clbDestination.Items.Count > 0) { string strSCodes = gvMappedGroups.Rows[row].Cells["ecode"].Value.ToString(); strArrDestCode = strSCodes.Split('~'); strDelete += " DELETE from LevelGroup_map_Detl " + "WHERE lgmd_company_code='" + cbCompany.SelectedValue.ToString() + "' AND lgmd_branch_code='" + cbBranches.SelectedValue.ToString() + "' AND lgmd_doc_month='" + CommonData.DocMonth.ToString().ToUpper() + "' AND lgmd_group_ecode=" + strArrDestCode[0] + " AND lgmd_map_type='HO';"; } } nDelete = objDA.ExecuteSaveData(strDelete); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { objDA = null; } return(nDelete); }
private void fillGridMappedData() { string strLogBcode = string.Empty; objData = new StaffLevel(); gvMappedGroups.Rows.Clear(); DataTable dt = objData.LevelMappedGroupList_Get(CommonData.CompanyCode, CommonData.StateCode, CommonData.BranchCode).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DataGridViewRow tempRow = new DataGridViewRow(); DataGridViewCell cellECODE = new DataGridViewTextBoxCell(); cellECODE.Value = dt.Rows[i]["ECODE"]; tempRow.Cells.Add(cellECODE); DataGridViewCell cellGROUPName = new DataGridViewTextBoxCell(); cellGROUPName.Value = dt.Rows[i]["GroupName"]; tempRow.Cells.Add(cellGROUPName); DataGridViewCell cellGroupEname = new DataGridViewTextBoxCell(); cellGroupEname.Value = dt.Rows[i]["ENAME"]; tempRow.Cells.Add(cellGroupEname); DataGridViewCell celllogBranchCode = new DataGridViewTextBoxCell(); celllogBranchCode.Value = dt.Rows[i]["logBranchCode"]; tempRow.Cells.Add(celllogBranchCode); DataGridViewCell cellLogicalBranch = new DataGridViewTextBoxCell(); cellLogicalBranch.Value = dt.Rows[i]["logBranchName"]; tempRow.Cells.Add(cellLogicalBranch); gvMappedGroups.Rows.Add(tempRow); } } }
private void FillStateComboBox() { objState = new StaffLevel(); try { DataTable dt = objState.GetStatesDS().Tables[0]; if (dt.Rows.Count > 1) { cbStates.DataSource = dt; cbStates.DisplayMember = "State"; cbStates.ValueMember = "CDState"; } dt = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { objState = null; } }
private void EcodeSearch() { objInvoiceDB = new InvoiceDB(); DataSet dsEmp = null; try { Cursor.Current = Cursors.WaitCursor; cbEcode.DataSource = null; cbEcode.Items.Clear(); dsEmp = objInvoiceDB.OrderSheetIssueEcodeSearch_Get(CommonData.CompanyCode, CommonData.BranchCode, CommonData.DocMonth, txtEcodeSearch.Text.ToString()); DataTable dtEmp = dsEmp.Tables[0]; if (dtEmp.Rows.Count > 0) { cbEcode.DataSource = dtEmp; cbEcode.DisplayMember = "ENAME"; cbEcode.ValueMember = "ECODE"; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (cbEcode.SelectedIndex > -1) { cbEcode.SelectedIndex = 0; strECode = ((System.Data.DataRowView)(cbEcode.SelectedItem)).Row.ItemArray[0].ToString(); } objData = null; Cursor.Current = Cursors.Default; } //objInvoiceDB = new InvoiceDB(); //objDA = new SQLDB(); //DataSet dsEmp = null; //string sqlText = ""; //try //{ // sqlText = "SELECT ECODE,MEMBER_NAME ENAME FROM EORA_MASTER WHERE ECODE LIKE '%"+txtEcodeSearch.Text.ToString()+"%' AND BRANCH_CODE = '"+CommonData.BranchCode+"';"; // Cursor.Current = Cursors.WaitCursor; // cbEcode.DataSource = null; // cbEcode.Items.Clear(); // //dsEmp = objInvoiceDB.InvLevelEcodeSearch_Get(CommonData.CompanyCode, CommonData.BranchCode, CommonData.DocMonth, txtEcodeSearch.Text.ToString()); // dsEmp = objDA.ExecuteDataSet(sqlText); // DataTable dtEmp = dsEmp.Tables[0]; // if (dtEmp.Rows.Count > 0) // { // cbEcode.DataSource = dtEmp; // cbEcode.DisplayMember = "ENAME"; // cbEcode.ValueMember = "ECODE"; // } //} //catch (Exception ex) //{ // MessageBox.Show(ex.Message); //} //finally //{ // if (cbEcode.SelectedIndex > -1) // { // cbEcode.SelectedIndex = 0; // strECode = ((System.Data.DataRowView)(cbEcode.SelectedItem)).Row.ItemArray[0].ToString(); // } // objInvoiceDB = null; // Cursor.Current = Cursors.Default; //} }
private void fillGridMappedData() { //string strBcode = string.Empty; //objData = new StaffLevel(); //gvMappedGroups.Rows.Clear(); //if (cbBranches.SelectedIndex>0) //strBcode = cbBranches.SelectedValue.ToString(); //DataTable dt = objData.LevelMappedGroupList_Get(cbCompany.SelectedValue.ToString(), CommonData.StateCode, cbBranches.SelectedValue.ToString()).Tables[0]; ////DataTable dt = objData.LevelGroupAboveBranchList(cbCompany.SelectedValue.ToString(), CommonData.StateCode, strBcode).Tables[0]; ////DataTable dt = objData.LevelGroupAboveBranchListGet(cbCompany.SelectedValue.ToString(), CommonData.StateCode, strBcode, "").Tables[0]; //if (dt.Rows.Count > 0) //{ // for (int i = 0; i < dt.Rows.Count; i++) // { // DataGridViewRow tempRow = new DataGridViewRow(); // DataGridViewCell cellECODE = new DataGridViewTextBoxCell(); // cellECODE.Value = dt.Rows[i]["ECODE"]; // tempRow.Cells.Add(cellECODE); // DataGridViewCell cellBRANCHName = new DataGridViewTextBoxCell(); // cellBRANCHName.Value = dt.Rows[i]["BRANCH_NAME"]; // tempRow.Cells.Add(cellBRANCHName); // DataGridViewCell cellHEADEname = new DataGridViewTextBoxCell(); // cellHEADEname.Value = dt.Rows[i]["ENAME"]; // tempRow.Cells.Add(cellHEADEname); // DataGridViewCell cellBranchCode = new DataGridViewTextBoxCell(); // cellBranchCode.Value = dt.Rows[i]["BRANCH_CODE"]; // tempRow.Cells.Add(cellBranchCode); // //DataGridViewCell cellLogicalBranch = new DataGridViewTextBoxCell(); // //cellLogicalBranch.Value = dt.Rows[i]["logBranchName"]; // //tempRow.Cells.Add(cellLogicalBranch); // gvMappedGroups.Rows.Add(tempRow); // } //} string strLogBcode = string.Empty; objData = new StaffLevel(); gvMappedGroups.Rows.Clear(); DataTable dt = objData.LevelMappedGroupList_Get(cbCompany.SelectedValue.ToString(), cbBranches.SelectedValue.ToString().Substring(3, 2), cbBranches.SelectedValue.ToString()).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DataGridViewRow tempRow = new DataGridViewRow(); DataGridViewCell cellECODE = new DataGridViewTextBoxCell(); cellECODE.Value = dt.Rows[i]["ECODE"]; tempRow.Cells.Add(cellECODE); DataGridViewCell cellGROUPName = new DataGridViewTextBoxCell(); cellGROUPName.Value = dt.Rows[i]["GroupName"] + ""; tempRow.Cells.Add(cellGROUPName); DataGridViewCell cellGroupEname = new DataGridViewTextBoxCell(); cellGroupEname.Value = dt.Rows[i]["ENAME"] + ""; tempRow.Cells.Add(cellGroupEname); DataGridViewCell celllogBranchCode = new DataGridViewTextBoxCell(); celllogBranchCode.Value = dt.Rows[i]["logBranchCode"] + ""; tempRow.Cells.Add(celllogBranchCode); DataGridViewCell cellLogicalBranch = new DataGridViewTextBoxCell(); cellLogicalBranch.Value = dt.Rows[i]["logBranchName"] + ""; tempRow.Cells.Add(cellLogicalBranch); gvMappedGroups.Rows.Add(tempRow); } } }