private void FrmAdvanceAddEdit_Load(object sender, EventArgs e) { SetMyControls(); if (S1 == "&Add") { DtDate.Enabled = false; DtDate.EditValue = DateTime.Now; DtDateforMonth.EditValue = DateTime.Now; txtAdvanceNo.Text = GetNewLoanPassNo().PadLeft(6, '0'); txtType.Text = "A"; DtDateforMonth.Focus(); } if (S1 == "Edit") { DtDate.Enabled = false; txtType.Enabled = false; txtEmpCode.Focus(); var ds = ProjectFunctions.GetDataSet(" SELECT ExMst.ExNo, ExMst.ExId, ExMst.ExDate, ExMst.ExEmpCode, ExMst.ExAmt, ExMst.ExTag, ExMst.ExDatePost, empmst.EmpName FROM ExMst LEFT OUTER JOIN empmst ON ExMst.ExEmpCode = empmst.EmpCode WHERE ExId='" + ExId + "'"); 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(); } }
private bool ValidateData() { if (DtDate.Text.Trim().Length == 0) { ProjectFunctions.SpeakError("Invalid Date"); DtDate.Focus(); return(false); } if (DtDateforMonth.Text.Trim().Length == 0) { ProjectFunctions.SpeakError("Invalid Date Of Month"); DtDateforMonth.Focus(); return(false); } if (txtEmpCode.Text.Trim().Length == 0) { ProjectFunctions.SpeakError("Invalid EmpName"); txtEmpCode.Focus(); return(false); } if (txtEmpCodeDesc.Text.Trim().Length == 0) { ProjectFunctions.SpeakError("Invalid EmpName"); txtEmpCode.Focus(); return(false); } if (txtAmount.Text.Length == 0) { txtAmount.Text = "0"; } if (txtType.Text == "A" || txtType.Text == "C" || txtType.Text == "F") { } else { ProjectFunctions.SpeakError("Valid Values are Advance(A),Fine(F),Coupon(C)"); txtType.Focus(); return(false); } return(true); }
private bool ValidateData() { if (DtDate.Text.Trim().Length == 0) { DevExpress.XtraEditors.XtraMessageBox.Show("Invalid Date", "Save", MessageBoxButtons.OK, MessageBoxIcon.Hand); DtDate.Focus(); return(false); } if (Convert.ToDateTime(DtDate.Text).Date > DateTime.Now.Date) { DevExpress.XtraEditors.XtraMessageBox.Show("Wrong Date Selected", "Save", MessageBoxButtons.OK, MessageBoxIcon.Hand); DtDate.Focus(); return(false); } if (DtDateforMonth.Text.Trim().Length == 0) { DevExpress.XtraEditors.XtraMessageBox.Show("Invalid Date Of Month", "Save", MessageBoxButtons.OK, MessageBoxIcon.Hand); DtDateforMonth.Focus(); return(false); } if (txtEmpCode.Text.Trim().Length == 0) { DevExpress.XtraEditors.XtraMessageBox.Show("Invalid EmpName", "Save", MessageBoxButtons.OK, MessageBoxIcon.Hand); txtEmpCode.Focus(); return(false); } if (txtEmpCodeDesc.Text.Trim().Length == 0) { DevExpress.XtraEditors.XtraMessageBox.Show("Invalid EmpName", "Save", MessageBoxButtons.OK, MessageBoxIcon.Hand); txtEmpCode.Focus(); return(false); } if (S1 == "Add") { DataSet ds = ProjectFunctions.GetDataSet("Select * from ExMst Where ExEmpCode='" + txtEmpCode.Text + "' And ExDate='" + Convert.ToDateTime(DtDate.Text).ToString("yyyy-MM-dd") + "'"); if (ds.Tables[0].Rows.Count > 0) { DevExpress.XtraEditors.XtraMessageBox.Show("Advance Already Feeded", "Save", MessageBoxButtons.OK, MessageBoxIcon.Hand); txtEmpCode.Focus(); return(false); } } if (txtAmount.Text.Length == 0) { txtAmount.Text = "0"; } if (txtSalary.Text.Length == 0) { txtSalary.Text = "0"; } if (txtType.Text == "A" || txtType.Text == "C" || txtType.Text == "F" || txtType.Text == "L" | txtType.Text == "T") { } else { DevExpress.XtraEditors.XtraMessageBox.Show("Valid Values are Advance(a),Fine(F),Coupon(C),Lunch(L),Telephone(T)", "Save", MessageBoxButtons.OK, MessageBoxIcon.Hand); txtType.Focus(); return(false); } return(true); }