public void LoadGatePassDataGrid() { PrintLogWin.PrintLog("LoadGatePassDataGrid => GlobalVariables.ProgCode ******************** : " + GlobalVariables.ProgCode); try { gridView_GatePassData.Columns.Clear(); string _storedProcedre = SQL_QUERIES.Sp_GatePassData_Daily_List() + " '" + txtEmpCode.EditValue + "', '" + ConvertTo.DateFormatDb(DtDate.EditValue) + "'"; //DataSet ds = ProgramMasterData.GetData(GlobalVariables.ProgCode, _params); DataSet _ds = ProjectFunctionsUtils.GetDataSet(_storedProcedre); if (_ds.Tables[0].Rows.Count > 0) { gridControl_GatePassData.DataSource = _ds.Tables[0]; gridView_GatePassData.BestFitColumns(); //////////////////// PrintPrivewButton.Enabled = true; PrintButton.Enabled = true; } else { gridControl_GatePassData.DataSource = null; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString().Trim()); } }
public static DataSet GetData(string _ProgCode, string _Parameters = "", string version = "") { DataSet dsMaster = null; try { //DataSet ds = ProjectFunctionsUtils.GetDataSet("sp_ProgramMaster '" + _ProgCode + "'"); //string ProcedureName = ds.Tables[0].Rows[0]["ProgProcName"].ToString(); ProgramMasterModel storedProcObj = GetProgramMasterModel(_ProgCode); string ProcedureName = storedProcObj.ProgProcName; if (!_Parameters.Equals("")) { _Parameters = _Parameters.Trim(); _Parameters = " " + _Parameters; } System.Diagnostics.Debug.WriteLine("ProcedureName ********** " + ProcedureName + _Parameters); //PrintLogWin.PrintLog("ProcedureName ********** " + ProcedureName + _Parameters); dsMaster = ProjectFunctionsUtils.GetDataSet(ProcedureName + version + _Parameters); } catch (Exception) { //throw; } return(dsMaster); }
private void FillGrid() { DataSet dsAccName = ProjectFunctionsUtils.GetDataSet("Select AccCode,AccName,AccCodeBusy from ActMst"); DataSet ds = ProjectFunctionsUtils.GetDataSetBusy("Select Code as AccCodeBusy,Name as AccNameBusy,'' as AccCode,'' as AccName from Master1 where MasterType='2' "); if (ds.Tables[0].Rows.Count > 0) { dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { foreach (DataRow drActMst in dsAccName.Tables[0].Rows) { if (dr["AccCodeBusy"].ToString() == drActMst["AccCodeBusy"].ToString()) { dr["AccCode"] = drActMst["AccCode"].ToString(); dr["AccName"] = drActMst["AccName"].ToString(); } } } AccountGrid.DataSource = dt; AccountGridView.BestFitColumns(); } else { AccountGrid.DataSource = null; AccountGridView.BestFitColumns(); } }
private void SetFormValues(int rowIndex, string _employee_code, string _attendance_date, int _serial_id) { try { string str = "sp_GatePassData_Single '" + _employee_code + "', '" + ConvertTo.DateFormatDb(ConvertTo.DateTimeVal(_attendance_date)) + "', " + _serial_id + string.Empty; PrintLogWin.PrintLog(str); DataSet _ds = ProjectFunctionsUtils.GetDataSet(str); if (ComparisonUtils.IsNotNull_DataSet(_ds)) { DataRow dr = _ds.Tables[0].Rows[rowIndex]; DtDate.EditValue = Convert.ToDateTime(dr["AttendanceDate"]); txtEmpCode.Text = dr["EmpCode"].ToString(); txtEmpCode.Tag = dr["SerialId"].ToString(); txtEmpCodeDesc.Text = dr["EmpName"].ToString(); txtEmpCodeDesc.Tag = dr["DeptDesc"].ToString(); txtStatusCode.Text = dr["StatusCode"].ToString(); txtStatusCode.Tag = dr["UnitName"].ToString(); txtStatusCodeDesc.Text = dr["Status"].ToString(); timeEdit_Time_Out.EditValue = dr["TimeOut"].ToString(); timeEdit_Time_In.EditValue = dr["TimeIn"].ToString(); pictureBox1.Image = ImageUtils.ConvertBinaryToImage((byte[])dr["EmpImage"]); PrintLogWin.PrintLog("TimeOut " + dr["TimeOut"].ToString()); PrintLogWin.PrintLog("TimeIn " + dr["TimeIn"].ToString()); //////////////////////// /*XtraReportGatePass report = new XtraReportGatePass( * dr["EmpCode"].ToString(), * ConvertTo.IntVal(dr["SerialId"].ToString()), * dr["EmpName"].ToString(), * dr["DeptDesc"].ToString() + "", * dr["UnitName"].ToString() + "", * "", * dr["Status"].ToString(), * timeEdit_Time_Out.EditValue + "", * timeEdit_Time_In.EditValue + "", * pictureBox1.Image * );*/ } else { //clear(); } } catch (Exception ex) { PrintLogWin.PrintLog(ex); // clear(); } }
public FrmVouchers() { InitializeComponent(); dt.Columns.Add("CRDR", typeof(String)); dt.Columns.Add("AccCode", typeof(String)); dt.Columns.Add("AccName", typeof(String)); dt.Columns.Add("Amount", typeof(Decimal)); dt.Columns.Add("Narration", typeof(String)); dsPopUps = ProjectFunctionsUtils.GetDataSet("sp_LoadVoucherPopUps '" + GlobalVariables.ProgCode + "'"); }
private void BtnImport_Click(object sender, EventArgs e) { DataRow currentrow = AccountGridView.GetDataRow(AccountGridView.FocusedRowHandle); DataSet ds = ProjectFunctionsUtils.GetDataSetBusy("Select * from MasterAddressInfo where MasterCode='" + currentrow["AccCodeBusy"].ToString() + "'"); if (ds.Tables[0].Rows.Count > 0) { FrmAccountMstAddEdit frm = new FrmAccountMstAddEdit() { S1 = "&Add", Text = "Account Addition" }; frm.StartPosition = FormStartPosition.CenterScreen; // only name block DataSet dsNane = ProjectFunctionsUtils.GetDataSetBusy("Select Code ,Name from MASTER1 Where Code='" + currentrow["AccCodeBusy"].ToString() + "'"); frm.txtAccCodeBusy.Text = dsNane.Tables[0].Rows[0]["Code"].ToString(); frm.txtAccNameBusy.Text = dsNane.Tables[0].Rows[0]["Name"].ToString(); frm.txtAcName.Text = dsNane.Tables[0].Rows[0]["Name"].ToString(); frm.txtBillingName.Text = dsNane.Tables[0].Rows[0]["Name"].ToString(); // only name block //address block & others frm.txtAddress1.Text = ds.Tables[0].Rows[0]["Address1"].ToString(); frm.txtAddress2.Text = ds.Tables[0].Rows[0]["Address2"].ToString(); frm.txtAddress3.Text = ds.Tables[0].Rows[0]["Address3"].ToString(); frm.txtAddress4.Text = ds.Tables[0].Rows[0]["Address4"].ToString(); frm.txtZipCode.Text = ds.Tables[0].Rows[0]["PINCode"].ToString(); DataSet dsCity = ProjectFunctions.GetDataSet("SELECT CITYMASTER.CTSYSID, CITYMASTER.CTNAME,STATEMASTER.STNAME,STATEMASTER.UNDERRG FROM CITYMASTER INNER JOIN STATEMASTER ON CITYMASTER.UNDERSTID = STATEMASTER.STSYSID Where CITYMASTER.CTNAME like'%" + ds.Tables[0].Rows[0]["Station"].ToString() + "%'"); if (dsCity.Tables[0].Rows.Count > 0) { frm.txtCityCode.Text = dsCity.Tables[0].Rows[0]["CTSYSID"].ToString(); frm.txtCityName.Text = dsCity.Tables[0].Rows[0]["CTNAME"].ToString(); frm.txtState.Text = dsCity.Tables[0].Rows[0]["STNAME"].ToString(); frm.txtCountry.Text = dsCity.Tables[0].Rows[0]["UNDERRG"].ToString(); } frm.txtTel.Text = ds.Tables[0].Rows[0]["TelNo"].ToString() + "," + ds.Tables[0].Rows[0]["Mobile"].ToString(); frm.txtEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString(); frm.txtTinNo.Text = ds.Tables[0].Rows[0]["TINNo"].ToString(); frm.txtCstPst.Text = ds.Tables[0].Rows[0]["CST"].ToString(); frm.txtPanNo.Text = ds.Tables[0].Rows[0]["ITPAN"].ToString(); frm.txtGSTNo.Text = ds.Tables[0].Rows[0]["GSTNo"].ToString(); frm.txtWhatsAppNo.Text = ds.Tables[0].Rows[0]["WhatsAppNo"].ToString(); //address block frm.ShowDialog(Parent); FillGrid(); } }
private void BtnBestMatch_Click(object sender, EventArgs e) { DataSet ds = ProjectFunctionsUtils.GetDataSetBusy("Select Code as MasterCode1,Name as PrintName from MASTER1 Where Name like '%" + txtAcName.Text + "%'"); if (ds.Tables[0].Rows.Count > 0) { HelpGrid.Text = "txtAccCodeBusy"; HelpGrid.DataSource = ds.Tables[0]; HelpGrid.BringToFront(); HelpGrid.Show(); HelpGrid.Focus(); HelpGridView.BestFitColumns(); } }
//private DataSet dsMain; private void FrmGatePassTimeAddEdit_Load(object sender, EventArgs e) { securityPassword = ProjectFunctionsUtils.GetDateChangePassword(); PrintLogWin.PrintLog(securityPassword); PrintPrivewButton.Enabled = false; PrintButton.Enabled = false; SetMyControls(); if (S1 == "Add") { //DtDate.Enabled = false; DtDate.EditValue = DateTime.Now; //DtDateforMonth.EditValue = DateTime.Now; //txtAdvanceNo.Text = getNewLoanPassNo().PadLeft(6, '0'); //txtStatusCode.Text = "A"; txtEmpCode.Focus(); } if (S1 == "Edit") { //DtDateforMonth.Enabled = false; DtDate.Enabled = false; txtEmpCode.Enabled = false; DtDate.EditValue = Attendance_date; txtEmpCode.EditValue = Employee_code; try { SetFormValues(0, Employee_code, Attendance_date, 0); //if (ComparisonUtils.IsNotNull_DataSet(dsMain)) //{ //gridControl_GatePassData.DataSource = dsMain.Tables[0]; //gridView_GatePassData.BestFitColumns(); //DtDate.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["AttendanceDate"]); //txtEmpCode.Text = ds.Tables[0].Rows[0]["EmpCode"].ToString(); //txtEmpCodeDesc.Text = ds.Tables[0].Rows[0]["EmpName"].ToString(); //txtStatusCode.Text = ds.Tables[0].Rows[0]["StatusCode"].ToString(); //txtStatusCodeDesc.Text = ds.Tables[0].Rows[0]["Status"].ToString(); //} } catch (Exception ex) { PrintLogWin.PrintLog(ex); } } }
//private projectFunctionsUtils; private void Btn_Chnge_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtOldPass.Text) || string.IsNullOrWhiteSpace(txtOldPass.Text)) { ProjectFunctions.SpeakError("Please Enter Old Password."); txtNewPass.Focus(); return; } if (string.IsNullOrEmpty(txtNewPass.Text) || string.IsNullOrWhiteSpace(txtNewPass.Text)) { ProjectFunctions.SpeakError("Please Enter New Password."); txtNewPass.Focus(); return; } if ((txtNewPass.Text != txtConfirmPass.Text)) { ProjectFunctions.SpeakError("Password doesn't Match."); txtOldPass.Focus(); return; } var validUserPass = ProjectFunctionsUtils.GetDataSet_T(SQL_QUERIES._frm_Chng_Pswd.SQL_UserMaster(GlobalVariables.CurrentUser, txtConfirmPass.Text)); if (validUserPass.Item1) { int intResult = ProjectFunctionsUtils.InsertQuery(SQL_QUERIES._frm_Chng_Pswd.SQL_UserMaster_Update_Pass(GlobalVariables.CurrentUser, txtConfirmPass.Text));//String.Format("Update UserMaster Set UserPwd='{0}' where username='******'", txtConfirmPass.Text, GlobalVariables.CurrentUser) GlobalVariables.UserPwd = txtConfirmPass.Text; ProjectFunctions.SpeakError("Password Changed."); } else { ProjectFunctions.SpeakError("Old Password is Not Valid."); txtOldPass.Focus(); return; } Dispose(); } catch (Exception ex) { ProjectFunctions.SpeakError(ex.Message); } }
public FrmJournalVoucher() { InitializeComponent(); dt.Columns.Add("CRDR", typeof(String)); dt.Columns.Add("AccCode", typeof(String)); dt.Columns.Add("AccName", typeof(String)); dt.Columns.Add("Debit", typeof(Decimal)); dt.Columns.Add("Credit", typeof(Decimal)); dt.Columns.Add("Narration", typeof(String)); // VoucherGrid.DataSource = dt; dsPopUps = ProjectFunctionsUtils.GetDataSet("sp_LoadVoucherPopUps '" + GlobalVariables.ProgCode + "'"); }
private string GetNewLoanPassNo() { var s2 = string.Empty; var strsql = string.Empty; var ds = new DataSet(); strsql = strsql + "select isnull(max(Cast(ExNo as int)),00000) from ExMst"; ds = ProjectFunctionsUtils.GetDataSet(strsql); if (ds.Tables[0].Rows.Count > 0) { s2 = ds.Tables[0].Rows[0][0].ToString().Trim(); s2 = (Convert.ToInt32(s2) + 1).ToString().Trim(); } return(s2); }
private void FrmDesignationAddEdit_Load(object sender, EventArgs e) { SetMyControls(); if (S1 == "&Add") { txtDesc.Focus(); txtDesgCode.Text = ProjectFunctionsUtils.GetNewDesgCode(); } if (S1 == "Edit") { DataSet ds = ProjectFunctions.GetDataSet("SELECT DesgCode, DesgDesc FROM DesgMst Where DesgCode='" + DesgCode + "'"); if (ds.Tables[0].Rows.Count > 0) { txtDesgCode.Text = ds.Tables[0].Rows[0]["DesgCode"].ToString(); txtDesc.Text = ds.Tables[0].Rows[0]["DesgDesc"].ToString(); txtDesc.Focus(); } } }
private void FillDataToGrid() { PrintLogWin.PrintLog("FillGrid ******************** " + GlobalVariables.ProgCode); try { DataSet ds = ProjectFunctions.GetDataSet("Select ProgProcName,ProgDesc from ProgramMaster Where ProgCode='" + GlobalVariables.ProgCode + "'"); string ProcedureName = ds.Tables[0].Rows[0]["ProgProcName"].ToString(); PrintLogWin.PrintLog("FillGrid => ProcedureName ******************** " + ProcedureName); //ProjectFunctions.BindMasterFormToGrid(ProcedureName, gridControl_UserMaster, gridView_UserMaster); DataSet dsMaster = ProjectFunctionsUtils.GetDataSet(ProcedureName); FillTable(dsMaster); AddUnboundColumn(); AddButtonToGrid(); //userMasterBindingSource.DataSource = Binding_DataHelper.GetData(dsMaster); //RepositoryItemPictureEdit pictureEdit = new RepositoryItemPictureEdit(); //pictureEdit.SizeMode = PictureSizeMode.Zoom; //pictureEdit.NullText = " "; //pictureEdit.Padding = new Padding(1); //pictureEdit.Click += gridControl_UserMaster_Click // ; //gridControl_UserMaster.DataSource = CreateData(dsMaster); //gridView_UserMaster.Columns["Edit_Link"].ColumnEdit = pictureEdit ; //gridView_UserMaster.Columns["Edit_Link"].Visible = false; //GridColumn col = gridView_UserMaster.Columns.AddVisible("Edit", "Edit_Link"); //col.UnboundType = DevExpress.Data.UnboundColumnType.Object; //col.ColumnEdit = pictureEdit;// repositoryItemPictureEdit1; //gridView_UserMaster.CustomUnboundColumnData += gridView1_CustomUnboundColumnData; toolStrip_lbl.Text = ds.Tables[0].Rows[0]["ProgDesc"].ToString(); } catch (Exception ex) { MessageBox_Debug.ShowBox("frmMaster => FillGrid() => " + ex); } }
private void FrmDepartmentAddUpdate_Load(object sender, EventArgs e) { SetMyControls(); if (S1 == "&Add") { txtDesc.Focus(); txtDeptCode.Text = ProjectFunctionsUtils.GetNewDeptCode();//.PadLeft(4, '0'); } if (S1 == "Edit") { //txtDesc.Enabled = false; DataSet ds = ProjectFunctions.GetDataSet("SELECT DeptCode,DeptDesc,Remarks FROM DeptMst Where DeptCode='" + DeptCode + "'"); //if (ds.Tables[0].Rows.Count > 0) //{ // txtDeptCode.Text = ds.Tables[0].Rows[0]["DeptCode"].ToString(); // txtDesc.Text = ds.Tables[0].Rows[0]["DeptDesc"].ToString(); // txtRemarks.Text = ds.Tables[0].Rows[0]["Remarks"].ToString(); // txtDesc.Focus(); //} } }
private void TxtUserName_KeyDown(object sender, KeyEventArgs e) { //if (e.KeyCode == Keys.Enter || e.KeyCode == Keys.Tab) { DataSet dsGetUser = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_USERMASTER_BY_USER(txtUserName.Text.Trim())); if (ComparisonUtils.IsNotNull_DataSet(dsGetUser)) { GlobalVariables.CurrentUser = txtUserName.Text; DataSet dsUnit = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_UNITS_BY_USER(txtUserName.Text)); if (ComparisonUtils.IsNotNull_DataSet(dsUnit)) { txtUnit.DataSource = dsUnit.Tables[0]; txtUnit.ValueMember = SQL_COLUMNS.UNITS._UNITID; txtUnit.DisplayMember = SQL_COLUMNS.UNITS._UNITNAME; } DataSet dsFNYear = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_USER_FN_ACCESS_BY_USER(txtUserName.Text)); if (ComparisonUtils.IsNotNull_DataSet(dsFNYear)) { txtFNYear.DataSource = dsFNYear.Tables[0]; txtFNYear.ValueMember = SQL_COLUMNS.FN_YEAR._FNYearCode; txtFNYear.DisplayMember = SQL_COLUMNS.FN_YEAR._FNYearCode; } DataSet dsFNYear2 = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_FN_YEAR_ACTIVE("Y")); if (ComparisonUtils.IsNotNull_DataSet(dsFNYear2)) { txtFNYear.SelectedValue = dsFNYear2.Tables[0].Rows[0]["FNYearCode"].ToString(); //txtFNYear.ValueMember = SQL_COLUMNS.FN_YEAR._FNYearCode; //txtFNYear.DisplayMember = SQL_COLUMNS.FN_YEAR._FNYearCode; } } else { ProjectFunctions.SpeakError("Invalid UserName"); } } }
private void EmployeeFormData_Load() { SetMyControls(); if (S1 == "&Add") { chkDailyWage.Checked = true; chkDailyWage.Checked = false; chkTeaBreak.Checked = true; chkTeaBreak.Checked = false; txtEmpName.Select(); txtEmpCode.Text = ProjectFunctionsUtils.GetNewEmpCode();//.PadLeft(5, '0'); form_loaded = true; } if (S1 == "Edit") { RepList <EmployeeMasterModel> lista = new RepList <EmployeeMasterModel>(); DynamicParameters param = new DynamicParameters(); param.Add("@EmpCode", EmpCode); EmployeeMasterModel empData = lista.returnClass_SP(SQL_QUERIES._frmEmployeeMstAddEdit.sp_LoadEmpMstFEditing(), param); //PrintLogWin.PrintLog("**************** =========> Line 120 => listData => " + listData.Count + ""); if (empData != null) { if (empData.EmpTeaTag == "Y") { chTeaTag.Checked = true; } else { chTeaTag.Checked = false; } txtEmpCode.Text = empData.EmpCode; // ds.Tables[0].Rows[0]["EmpCode"].ToString(); txtEmpName.Text = empData.EmpName; txtRelationTag.Text = empData.EmpFHRelationTag; //ds.Tables[0].Rows[0]["EmpFHRelationTag"].ToString(); txtFHName.Text = empData.EmpFHName; //ds.Tables[0].Rows[0]["EmpFHName"].ToString(); txtDeptCode.Text = empData.EmpDeptCode; //ds.Tables[0].Rows[0]["EmpDeptCode"].ToString(); txtDeptDesc.Text = empData.DeptDesc; //ds.Tables[0].Rows[0]["DeptDesc"].ToString(); txtDesgCode.Text = empData.EmpDesgCode; //ds.Tables[0].Rows[0]["EmpDesgCode"].ToString(); txtDesgDesc.Text = empData.DesgDesc; //ds.Tables[0].Rows[0]["DesgDesc"].ToString(); txtUnitCode.Text = empData.UnitCode; //ds.Tables[0].Rows[0]["EmpDesgCode"].ToString(); txtUnitDesc.Text = empData.UnitName; //ds.Tables[0].Rows[0]["DesgDesc"].ToString(); txtEmpSex.Text = empData.EmpSex; //ds.Tables[0].Rows[0]["EmpSex"].ToString(); if (empData.EmpDOJ.ToString() == string.Empty) { } else { txtDOJ.EditValue = Convert.ToDateTime(empData.EmpDOJ); } if (empData.EmpDOL.ToString() == string.Empty) { } else { txtDOL.EditValue = Convert.ToDateTime(empData.EmpDOL); } txtEPFTag.Text = empData.EmpPFDTag; //ds.Tables[0].Rows[0]["EmpPFDTag"].ToString(); txtESIDTag.Text = empData.EmpESIDTag; //ds.Tables[0].Rows[0]["EmpESIDTag"].ToString(); txtEPFNo.Text = empData.EmpPFno; //ds.Tables[0].Rows[0]["EmpPFno"].ToString(); txtESICNo.Text = empData.EmpESIno; //ds.Tables[0].Rows[0]["EmpESIno"].ToString(); txtTDS.Text = empData.EmpTDS.ToString(); //ds.Tables[0].Rows[0]["EmpTDS"].ToString(); txtEmpLeft.Text = empData.EmpLeft; //ds.Tables[0].Rows[0]["EmpLeft"].ToString(); txtRemarks.Text = empData.EmpRemarks; //ds.Tables[0].Rows[0]["EmpRemarks"].ToString(); txtMotherName.Text = empData.EmpMotherNm; //ds.Tables[0].Rows[0]["EmpMotherNm"].ToString(); txtState.Text = empData.EmpPerState; //ds.Tables[0].Rows[0]["EmpPerState"].ToString(); txtState.Text = empData.EmpPerCountry; //ds.Tables[0].Rows[0]["EmpPerCountry"].ToString(); txtNationality.Text = empData.EmpNationality; //ds.Tables[0].Rows[0]["EmpNationality"].ToString(); txtEmail.Text = empData.EmpEmail; //ds.Tables[0].Rows[0]["EmpEmail"].ToString(); txtCategoryCode.Text = empData.EmpCategory; //ds.Tables[0].Rows[0]["EmpCategory"].ToString(); txtCategoryDesc.Text = empData.CatgDesc; //ds.Tables[0].Rows[0]["CatgDesc"].ToString(); txtDOB.EditValue = Convert.ToDateTime(empData.EmpDoB); txtPanNo.Text = empData.EmpPanNo; //ds.Tables[0].Rows[0]["EmpPanNo"].ToString(); txtPassPortNo.Text = empData.EmpPassportNo; //ds.Tables[0].Rows[0]["EmpPassportNo"].ToString(); txtEmployeeReligion.Text = empData.EmpReligion; //ds.Tables[0].Rows[0]["EmpReligion"].ToString(); txtMaritalStatus.Text = empData.EmpMaritalStatus; //ds.Tables[0].Rows[0]["EmpMaritalStatus"].ToString(); txtPaymentMode.Text = empData.EmpPymtMode; //ds.Tables[0].Rows[0]["EmpPymtMode"].ToString(); txtIfscCode.Text = empData.EmpBankIFSCode; //ds.Tables[0].Rows[0]["EmpBankIFSCode"].ToString(); txtBankAccountNo.Text = empData.EmpBankAcNo; //ds.Tables[0].Rows[0]["EmpBankAcNo"].ToString(); txtBankName.Text = empData.EmpBankName; //ds.Tables[0].Rows[0]["EmpBankName"].ToString(); txtNomineeName.Text = empData.EmpNominee; //ds.Tables[0].Rows[0]["EmpNominee"].ToString(); txtNomineeRelation.Text = empData.EmpNomineeRelation; //ds.Tables[0].Rows[0]["EmpNomineeRelation"].ToString(); if (empData.EmpNomineeDOB.ToString() == string.Empty) { } else { txtNomineeDOB.EditValue = Convert.ToDateTime(empData.EmpNomineeDOB); } txtAdharCardNo.Text = empData.EmpAdharCardNo; //ds.Tables[0].Rows[0]["EmpAdharCardNo"].ToString(); txtHealthInsurance.Text = empData.EmpGHISDed.ToString(); //ds.Tables[0].Rows[0]["EmpGHISDed"].ToString(); txtMiscDed.Text = empData.EmpMscD1.ToString(); //ds.Tables[0].Rows[0]["EmpMscD1"].ToString(); txtAddress1.Text = empData.EmpAddress1; //ds.Tables[0].Rows[0]["EmpAddress1"].ToString(); txtAddress2.Text = empData.EmpAddress2; //ds.Tables[0].Rows[0]["EmpAddress2"].ToString(); txtAddress3.Text = empData.EmpAddress3; //ds.Tables[0].Rows[0]["EmpAddress3"].ToString(); txtState.Text = empData.EmpState; //ds.Tables[0].Rows[0]["EmpState"].ToString(); txtCountry.Text = empData.EmpCountry; //ds.Tables[0].Rows[0]["EmpCountry"].ToString(); txtEFPFTag.Text = empData.EmpFpfDTag; //ds.Tables[0].Rows[0]["EmpFpfDTag"].ToString(); //NULL Exception //txtUANNo.Text = ds.Tables[0].Rows[0]["EmpUANNo"].ToString(); //txtUnitCode.Text = ds.Tables[0].Rows[0]["UnitCode"].ToString(); //txtUnitName.Text = ds.Tables[0].Rows[0]["UnitName"].ToString(); //txtAccCode.Text = ds.Tables[0].Rows[0]["EmpPartyCode"].ToString(); //txtBankBranchCode.Text = ds.Tables[0].Rows[0]["EmpBankBranchCode"].ToString(); txtCategoryCode.Focus(); timeEdit_Time_In_First.EditValue = empData.TimeInFirst.ToString(); timeEdit_Time_Out_First.EditValue = empData.TimeOutFirst.ToString(); timeEdit_Time_In_Last.EditValue = empData.TimeInLast.ToString(); timeEdit_Time_Out_Last.EditValue = empData.TimeOutLast.ToString(); totalWorkingHours_Text.EditValue = empData.WorkingHours; pictureBox1.Image = ConvertBinaryToImage(empData.EmpImage); chkTeaBreak.Checked = (empData.TeaBreak == 1) ? true : false; txtTeaBreakTime.EditValue = empData.TeaBreakTime; PrintLogWin.PrintLog("chkTeaBreak.Checked =========> " + chkTeaBreak.Checked + string.Empty); PrintLogWin.PrintLog("empData.TeaBreak =========> " + empData.TeaBreak + string.Empty); chkDailyWage.Checked = empData.DailyWage; PrintLogWin.PrintLog("chkDailyWage.Checked =========> " + chkDailyWage.Checked + string.Empty); PrintLogWin.PrintLog("empData.DailyWage =========> " + empData.DailyWage + string.Empty); //DAILY WAGER////////////////////////////// if (chkDailyWage.Checked) { if (empData.DailyWageRate != null && empData.DailyWageRate != 0) { txtDailyWageRate.EditValue = empData.DailyWageRate; txtDailyWageRate.Tag = empData.DailyWageRate; } else { txtDailyWageRate.EditValue = null; } if (empData.DailyWageMinutes != null && empData.DailyWageMinutes != 0) { txtDailyWageHours.EditValue = empData.DailyWageMinutes / 60; txtDailyWageHours.Tag = empData.DailyWageMinutes / 60; } else { txtDailyWageHours.EditValue = null; } } else { txtDailyWageRate.Enabled = false; txtDailyWageRate.EditValue = null; txtDailyWageHours.Enabled = false; txtDailyWageHours.EditValue = null; } //TEA BREAK////////////////////////////// if (chkTeaBreak.Checked) { if (empData.TeaBreakTime != null && empData.TeaBreakTime != 0) { txtTeaBreakTime.EditValue = empData.TeaBreakTime; txtTeaBreakTime.Tag = empData.TeaBreakTime; } else { txtTeaBreakTime.EditValue = null; } } else { txtTeaBreakTime.Enabled = false; txtTeaBreakTime.EditValue = null; } } form_loaded = true; txtEmpName.Enabled = false; PrintLogWin.PrintLog("frmEmployeeMstAddEdit_Load =========> Line 131 => sp_LoadEmpMstFEditing '" + EmpCode + "'"); } }
public static void Roles(string ProgCode, string CurrentUser, ToolStripButton btnAdd, ToolStripButton btnEdit = null, ToolStripButton btnDelete = null, ToolStripButton btnPrint = null) { string Query4Controls = string.Format("SELECT ProgAdd_F, ProgUpd_F, ProgDel_F, ProgRep_p, ProgRep_p,ProgSpl_U FROM UserProgAccess WHERE (ProgActive is Null or progActive= 'Y') AND (ProgCode = N'" + ProgCode + "') AND (UserName = N'{0}'); ", CurrentUser); using (var Tempds = ProjectFunctionsUtils.GetDataSet(Query4Controls)) { if (Tempds != null) { if (Tempds.Tables[0].Rows.Count > 0) { if (btnAdd != null) { if (Tempds.Tables[0].Rows[0]["ProgAdd_F"].ToString() == "-1") { btnAdd.Enabled = true; } else { btnAdd.Enabled = false; } } if (btnEdit != null) { if (Tempds.Tables[0].Rows[0]["ProgUpd_F"].ToString() == "-1") { btnEdit.Enabled = true; } else { btnEdit.Enabled = false; } } if (btnDelete != null) { if (Tempds.Tables[0].Rows[0]["ProgDel_F"].ToString() == "-1") { btnDelete.Enabled = true; } else { btnDelete.Enabled = false; } } if (btnPrint != null) { if (Tempds.Tables[0].Rows[0]["ProgRep_p"].ToString() == "-1") { btnPrint.Enabled = true; } else { btnPrint.Enabled = false; } } } } } }
private void HelpGrid_DoubleClick(object sender, EventArgs e) { try { DataRow row = HelpGridView.GetDataRow(HelpGridView.FocusedRowHandle); if (HelpGrid.Text == "txtAccCodeBusy") { txtAccCodeBusy.Text = row["MasterCode1"].ToString(); txtAccNameBusy.Text = row["PRINTNAME"].ToString(); HelpGrid.Visible = false; txtAccCodeBusy.Focus(); if (chImportAll.Checked) { DataSet ds = ProjectFunctionsUtils.GetDataSetBusy("Select * from MasterAddressInfo where MasterCode='" + txtAccCodeBusy.Text + "'"); if (ds.Tables[0].Rows.Count > 0) { txtAcName.Text = txtAccNameBusy.Text; txtBillingName.Text = txtAccNameBusy.Text; txtAddress1.Text = ds.Tables[0].Rows[0]["Address1"].ToString(); txtAddress2.Text = ds.Tables[0].Rows[0]["Address2"].ToString(); txtAddress3.Text = ds.Tables[0].Rows[0]["Address3"].ToString(); txtAddress4.Text = ds.Tables[0].Rows[0]["Address4"].ToString(); txtZipCode.Text = ds.Tables[0].Rows[0]["PINCode"].ToString(); DataSet dsCity = ProjectFunctions.GetDataSet("SELECT CITYMASTER.CTSYSID, CITYMASTER.CTNAME,STATEMASTER.STNAME,STATEMASTER.UNDERRG FROM CITYMASTER INNER JOIN STATEMASTER ON CITYMASTER.UNDERSTID = STATEMASTER.STSYSID Where CITYMASTER.CTNAME like'%" + ds.Tables[0].Rows[0]["Station"].ToString() + "%'"); if (dsCity.Tables[0].Rows.Count > 0) { txtCityCode.Text = dsCity.Tables[0].Rows[0]["CTSYSID"].ToString(); txtCityName.Text = dsCity.Tables[0].Rows[0]["CTNAME"].ToString(); txtState.Text = dsCity.Tables[0].Rows[0]["STNAME"].ToString(); txtCountry.Text = dsCity.Tables[0].Rows[0]["UNDERRG"].ToString(); } txtTel.Text = ds.Tables[0].Rows[0]["TelNo"].ToString() + "," + ds.Tables[0].Rows[0]["Mobile"].ToString(); txtEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString(); txtTinNo.Text = ds.Tables[0].Rows[0]["TINNo"].ToString(); txtCstPst.Text = ds.Tables[0].Rows[0]["CST"].ToString(); txtPanNo.Text = ds.Tables[0].Rows[0]["ITPAN"].ToString(); txtGSTNo.Text = ds.Tables[0].Rows[0]["GSTNo"].ToString(); txtWhatsAppNo.Text = ds.Tables[0].Rows[0]["WhatsAppNo"].ToString(); } } } if (HelpGrid.Text == "txtSLCode") { txtSLCode.Text = row["LgrCode"].ToString(); txtSLDesc.Text = row["LgrDesc"].ToString(); HelpGrid.Visible = false; txtBSCode.Focus(); } if (HelpGrid.Text == "txtBSCode") { txtBSCode.Text = row["BSCode"].ToString(); txtBSDesc.Text = row["BSDesc"].ToString(); HelpGrid.Visible = false; txtBSCode.Focus(); } if (HelpGrid.Text == "txtMainLedgerCode") { txtMainLedgerCode.Text = row["GrpCode"].ToString(); txtMainLedgerDesc.Text = row["GrpDesc"].ToString(); txtSubLedgerCode.Text = row["GrpSubCode"].ToString(); txtSubLedgerDesc.Text = row["GrpSubDesc"].ToString(); HelpGrid.Visible = false; txtBSCode.Focus(); } if (HelpGrid.Text == "txtEmpCode") { txtEmpCode.Text = row["EmpCode"].ToString(); txtEmpName.Text = row["EmpName"].ToString(); HelpGrid.Visible = false; txtChequeName.Focus(); } if (HelpGrid.Text == "txtGSTStateCode") { txtGSTStateCode.Text = row["GSTStateCode"].ToString(); txtGSTStateDesc.Text = row["GSTStateDesc"].ToString(); HelpGrid.Visible = false; txtChequeName.Focus(); } if (HelpGrid.Text == "txtCityCode") { txtCityCode.Text = row["CTSYSID"].ToString(); txtCityName.Text = row["CTNAME"].ToString(); txtState.Text = row["STNAME"].ToString(); txtCountry.Text = row["UNDERRG"].ToString(); HelpGrid.Visible = false; txtContactPerson.Focus(); } if (HelpGrid.Text == "txtAgentCode") { txtAgentCode.Text = row["AgentCode"].ToString(); txtAgentName.Text = row["AgentName"].ToString(); HelpGrid.Visible = false; txtAgentCode.Focus(); } if (HelpGrid.Text == "txtUnitCode") { txtUnitCode.Text = row["UNITID"].ToString(); txtUnitName.Text = row["UNITNAME"].ToString(); HelpGrid.Visible = false; txtUnitCode.Focus(); } if (HelpGrid.Text == "txtDelCitycode") { txtDelCitycode.Text = row["CTSYSID"].ToString(); txtDelCityName.Text = row["CTNAME"].ToString(); HelpGrid.Visible = false; txtDelGSTNo.Focus(); } } catch (Exception ex) { ProjectFunctions.SpeakError(ex.Message); } }
private void SetGridViewStyle() { gridView_Style_List = ProjectFunctionsUtils.GridView_Style("frmProcessSalary", "gridControl_SalaryProcess"); if (gridView_Style_List != null) { int rowIndex = 0; foreach (GridColumn Col in gridView_SalaryProcess.Columns) { try { if (gridView_Style_List.Exists(x => x.column_name.Equals(Col.FieldName))) { GridView_Style_Model item = gridView_Style_List.Single <GridView_Style_Model>(x => x.column_name.Equals(Col.FieldName)); bool colShow = true; try { if (ComparisonUtils.IsNotEmpty(item.column_show)) { if (item.column_show == 0) { colShow = false; Col.Visible = false; //gridView_SalaryProcess.Columns[Col.FieldName].Visible = false; } else { colShow = true; Col.Visible = true; //gridView_SalaryProcess.Columns[Col.FieldName].Visible = true; } } } catch (Exception ex) { PrintLogWin.PrintLog("SetGridViewStyle => Color => Exception => " + ex); } if (colShow) { try { if (ComparisonUtils.IsNotEmpty(item.color_code)) { string hex = item.color_code; Color color = System.Drawing.ColorTranslator.FromHtml(hex); Col.AppearanceCell.BackColor = color; } } catch (Exception ex) { PrintLogWin.PrintLog("SetGridViewStyle => Color => Exception => " + ex); } try { if (ComparisonUtils.IsNotEmpty(item.font_style)) { if (item.font_style.ToLower().Equals("bold")) { Col.AppearanceCell.FontStyleDelta = FontStyle.Bold; } if (item.font_style.ToLower().Equals("Italic")) { Col.AppearanceCell.FontStyleDelta = FontStyle.Italic; } } } catch (Exception ex) { PrintLogWin.PrintLog("SetGridViewStyle => FontStyle => Exception => " + ex); } } } } catch (Exception ex) { PrintLogWin.PrintLog("SetGridViewStyle => Exception => " + ex); } if (Col.FieldName == "SalaryLocked") { } rowIndex++; } } }
private void FillGrid() { ClearGrid(); //DECLARE @Salary_Month DATETIME = '2020-06-01 00:00:00'; var str = "sp_Salary_Process '','" + ConvertTo.DateFormatDb(ConvertTo.DateTimeVal(DtStartDate.EditValue)) + "', 1, 1,'1','" + txtteatrate.Text + "','0'"; PrintLogWin.PrintLog(str); DataSet ds = ProjectFunctionsUtils.GetDataSet(str); ds.Tables[0].Columns.Add(new DataColumn("Balance_1", typeof(double))); ds.Tables[0].Columns.Add(new DataColumn("Arrears_1", typeof(double))); ds.Tables[0].Columns.Add(new DataColumn("Loan_1", typeof(double))); ds.Tables[0].Columns.Add(new DataColumn("SalaryCalculated_1", typeof(double))); for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { ds.Tables[0].Rows[i]["Balance_1"] = ConvertTo.DoubleVal(ds.Tables[0].Rows[i]["Balance"]); ds.Tables[0].Rows[i]["Arrears_1"] = ds.Tables[0].Rows[i]["Arrears"]; ds.Tables[0].Rows[i]["Loan_1"] = ds.Tables[0].Rows[i]["Loan"]; ds.Tables[0].Rows[i]["SalaryCalculated_1"] = ds.Tables[0].Rows[i]["SalaryCalculated"]; } if (ComparisonUtils.IsNotNull_DataSet(ds)) { if (ds.Tables[0].Rows.Count > 0) { gridControl_SalaryProcess.DataSource = ds.Tables[0]; gridView_SalaryProcess.BestFitColumns(); gridView_SalaryProcess.Columns["EmpSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "EmpSalary", string.Empty); gridView_SalaryProcess.Columns["SalaryEarned"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryEarned", string.Empty); gridView_SalaryProcess.Columns["OT_Salary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "OT_Salary", string.Empty); gridView_SalaryProcess.Columns["DeductionSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "DeductionSalary", string.Empty); gridView_SalaryProcess.Columns["SalaryGenerateBasic"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryGenerateBasic", string.Empty); gridView_SalaryProcess.Columns["AdvanceSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "AdvanceSalary", string.Empty); object p = gridView_SalaryProcess.Columns["Loan"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Loan", string.Empty); gridView_SalaryProcess.Columns["SalaryCalculated"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryCalculated", string.Empty); gridView_SalaryProcess.Columns["SalaryPaid"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryPaid", string.Empty); gridView_SalaryProcess.Columns["Balance"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Balance", string.Empty); gridView_SalaryProcess.Columns["Arrears"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Arrears", string.Empty); gridView_SalaryProcess.Columns["TotalTeaAmount"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "TotalTeaAmount", string.Empty); //gridView_SalaryProcess.Columns["EmpSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Custom); gridView_SalaryProcess.UpdateTotalSummary(); } } else { } gridView_SalaryProcess.OptionsBehavior.Editable = true; foreach (DevExpress.XtraGrid.Columns.GridColumn Col in gridView_SalaryProcess.Columns) { if (Col.FieldName == "LoanIntsallment" || Col.FieldName == "SalaryPaid" || Col.FieldName == "Loan" || Col.FieldName == "NoOfCups") { } else { Col.OptionsColumn.AllowEdit = false; } } SetGridViewStyle(); }
private void FrmAdvanceAddEdit_Load(object sender, EventArgs e) { SetMyControls(); if (S1 == "Add") { DtDate.Enabled = true; DtDate.EditValue = DateTime.Now; DtDateforMonth.EditValue = DateTime.Now; txtAdvanceNo.Text = GetNewLoanPassNo().PadLeft(6, '0'); txtType.Text = "A"; DtDate.Focus(); } if (S1 == "Edit") { DtDateforMonth.Enabled = false; DtDate.Enabled = false; txtType.Enabled = false; string str = "SELECT " + " ExMst.ExPostHead, " + " ExMst.ExVoucherType, " + " ExMst.ExVoucherNo, " + " ExMst.ExVoucherDt, " + " ExMst.ExNo, " + " ExMst.ExId, " + " ExMst.ExDate, " + " ExMst.ExEmpCode, " + " ExMst.ExAmt, " + " ExMst.ExTag, " + " ExMst.ExDatePost, " + " ExMst.ExLoadTag, " + " ExMst.ExEmpCCode, " + " ExMst.ExFedDate, " + " ExMst.ExLoadedDate, " + " empmst.EmpName, " + " actmst.AccName " + " FROM ExMst " + " LEFT OUTER JOIN EmpMST ON ExMst.ExEmpCode = empmst.EmpCode " + " LEFT OUTER JOIN ActMst ON ExMst.ExPostHead = actmst.AccCode " + " WHERE ExId='" + ExId + "';" + string.Empty; //var qr = " SELECT ExMst.ExPostHead, ExMst.ExVoucherType, ExMst.ExVoucherNo, ExMst.ExVoucherDt, ExMst.ExNo, ExMst.ExId, ExMst.ExDate, ExMst.ExEmpCode, ExMst.ExAmt, ExMst.ExTag, ExMst.ExDatePost, "; //qr = qr + " ExMst.ExLoadTag, ExMst.ExEmpCCode, ExMst.ExFedDate, ExMst.ExLoadedDate, empmst.EmpName, EmpEmplrRef.ERMDesc, actmst.AccName "; //qr = qr + " FROM ExMst LEFT OUTER JOIN "; //qr = qr + " empmst ON ExMst.ExEmpCode = empmst.EmpCode LEFT OUTER JOIN "; //qr = qr + " EmpEmplrRef ON ExMst.ExEmpCCode = EmpEmplrRef.ERMCode LEFT OUTER JOIN "; //qr = qr + " actmst ON ExMst.ExPostHead = actmst.AccCode "; //qr = qr + " WHERE ExId='" + ExId + "'"; PrintLogWin.PrintLog(str); var ds = ProjectFunctionsUtils.GetDataSet(str); try { txtAdvanceNo.Text = ds.Tables[0].Rows[0]["ExNo"].ToString(); DtDate.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["ExDate"]); DtDateforMonth.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["ExDatePost"]); txtEmpCode.Text = ds.Tables[0].Rows[0]["ExEmpCode"].ToString(); txtEmpCodeDesc.Text = ds.Tables[0].Rows[0]["EmpName"].ToString(); txtType.Text = ds.Tables[0].Rows[0]["ExTag"].ToString(); txtAmount.Text = ds.Tables[0].Rows[0]["ExAmt"].ToString(); } catch (Exception ex) { PrintLogWin.PrintLog(ex); } //GetBasicDetail(); } }
private void FrmLogincs_Load(object sender, EventArgs e) { if (System.IO.Directory.Exists("C:\\Application")) { } else { System.IO.Directory.CreateDirectory("C:\\Application"); } if (System.IO.Directory.Exists("C:\\Temp")) { } else { System.IO.Directory.CreateDirectory("C:\\Temp"); } if (System.IO.Directory.Exists("C:\\ERP To Busy")) { } else { System.IO.Directory.CreateDirectory("C:\\ERP To Busy"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\PTFile")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\PTFile"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\EWAY")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\EWAY"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\EWayDetailed")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\EWayDetailed"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\LABEL")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\LABEL"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\PI")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\PI"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\Salary")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\salary"); } if (System.IO.Directory.Exists("C:\\Temp\\GST")) { } else { System.IO.Directory.CreateDirectory("C:\\Temp\\GST"); } defaultLookAndFeel1.LookAndFeel.SkinName = "McSkin"; ProjectFunctions.TextBoxVisualize(this); ProjectFunctions.ButtonVisualize(this); SqlConnection cnn = new SqlConnection(ProjectFunctions.ConnectionString); try { cnn.Open(); cnn.Close(); } catch (Exception) { Master.FrmServer frm = new Master.FrmServer(); this.Hide(); frm.ShowDialog(); frm.BringToFront(); return; } DataSet dsCompany = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_COMCONF()); if (ComparisonUtils.IsNotNull_DataSet(dsCompany)) { txtCompany.DataSource = dsCompany.Tables[0]; txtCompany.ValueMember = SQL_COLUMNS.COMCONF._COMSYSID; // "COMSYSID"; txtCompany.DisplayMember = SQL_COLUMNS.COMCONF._COMNAME; // "COMNAME"; } if (isDebug) { //MessageBox.Show(dsFNYear.Tables[0].Rows.Count.ToString()); txtPassword.Text = "123"; txtUserName.Text = "HAPPY"; SendKeys.Send("{Enter}"); txtUserName.Focus(); TxtUserName_KeyDown(null, null); BtnLogin_Click(null, null); } }