private void LoadDatas(VmAddCheque objAddCheque)
{
try
{
var dsResult = new DataSet();
var lstDatas = new List <VmAddCheque>();
SqlParameter[] sqlParam = new SqlParameter[5];
sqlParam[0] = new SqlParameter("@Mode", objAddCheque.Mode);
sqlParam[1] = new SqlParameter("@ChequeNumber", objAddCheque.ChequeNumber);
sqlParam[2] = new SqlParameter("@GivenTo", objAddCheque.GivenTo);
sqlParam[3] = new SqlParameter("@GivenDate", objAddCheque.GivenDate);
sqlParam[4] = new SqlParameter("@ValidUpto", objAddCheque.ValidUpto);
dsResult = objHelper.GetDatasetFromProcedure("dbo.Proc_ChequeDetails", sqlParam);
if (dsResult != null && dsResult.Tables.Count > 0)
{
if (dsResult.Tables[0].Rows.Count > 0)
{
lstDatas = dsResult.Tables[0].ToList <VmAddCheque>().ToList();
BindGrid(lstDatas);
}
}
}
catch (Exception ex)
{
log.Error("[FrmAddCheque][LoadDatas][ExceptionMessage = " + ex.Message + "][ExceptionStackTrace = " + ex.StackTrace + "]");
}
}
private void FrmAddChequeLoad(object sender, EventArgs e)
{
var objAddCheque = new VmAddCheque();
objAddCheque.Mode = "GETALL";
LoadDatas(objAddCheque);
}
private void SaveDatas(VmAddCheque objAddCheque)
{
try
{
var dsResult = new DataSet();
var msgs = new VmCommonModel();
var lstDatas = new List <VmAddCheque>();
SqlParameter[] sqlParam = new SqlParameter[9];
sqlParam[0] = new SqlParameter("@Mode", objAddCheque.Mode);
sqlParam[1] = new SqlParameter("@ChequeDetailsId", objAddCheque.ChequeDetailsId);
sqlParam[2] = new SqlParameter("@ChequeNumber", objAddCheque.ChequeNumber);
sqlParam[3] = new SqlParameter("@GivenTo", objAddCheque.GivenTo);
sqlParam[4] = new SqlParameter("@GivenDate", objAddCheque.GivenDate);
sqlParam[5] = new SqlParameter("@ValidUpto", objAddCheque.ValidUpto);
sqlParam[6] = new SqlParameter("@Amount", objAddCheque.Amount);
sqlParam[7] = new SqlParameter("@Notes", objAddCheque.Notes);
sqlParam[8] = new SqlParameter("@UserId", GlobalAccess.GlobalUserId);
dsResult = objHelper.GetDatasetFromProcedure("dbo.Proc_ChequeDetails", sqlParam);
if (dsResult != null && dsResult.Tables.Count > 0)
{
if (dsResult.Tables[0].Rows.Count > 0)
{
msgs = dsResult.Tables[0].ToList <VmCommonModel>().ToList().FirstOrDefault();
}
if (msgs.IsSuccess == true)
{
LblMessageFaliure.Visible = false;
MessageBox.Show(this.MdiParent, msgs.OutputMessage, "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (dsResult.Tables[1].Rows.Count > 0)
{
lstDatas = dsResult.Tables[1].ToList <VmAddCheque>().ToList();
BindGrid(lstDatas);
}
ClearInputs();
}
else
{
LblMessageFaliure.Visible = true;
LblMessageFaliure.Text = msgs.OutputMessage;
}
}
}
catch (Exception ex)
{
log.Error("[FrmAddCheque][SaveDatas][ExceptionMessage = " + ex.Message + "][ExceptionStackTrace = " + ex.StackTrace + "]");
}
}
private void BtnSaveClick(object sender, EventArgs e)
{
var objAddCheque = new VmAddCheque();
if (TxtChequeNumber.Text == "" || string.IsNullOrEmpty(TxtChequeNumber.Text))
{
LblMessageFaliure.Text = "Please Enter Cheque Number";
TxtChequeNumber.Focus();
return;
}
if (TxtGivenTo.Text == "" || string.IsNullOrEmpty(TxtGivenTo.Text))
{
LblMessageFaliure.Text = "Please Enter the Name of the Person whom you gave this Cheque";
TxtGivenTo.Focus();
return;
}
if (TxtGivenDate.Text == "" || string.IsNullOrEmpty(TxtGivenDate.Text))
{
LblMessageFaliure.Text = "Please Select Cheque Issued date";
TxtGivenDate.Focus();
return;
}
if (TxtValidUpto.Text == "" || string.IsNullOrEmpty(TxtValidUpto.Text))
{
LblMessageFaliure.Text = "Please Select Cheque Expiry date";
TxtValidUpto.Focus();
return;
}
if (TxtAmount.Text == "" || string.IsNullOrEmpty(TxtAmount.Text))
{
LblMessageFaliure.Text = "Please Fill the Cheque Amount";
TxtAmount.Focus();
return;
}
objAddCheque.Mode = "INSERT";
objAddCheque.ChequeNumber = TxtChequeNumber.Text;
objAddCheque.GivenTo = TxtGivenTo.Text;
objAddCheque.GivenDate = TxtGivenDate.Text;
objAddCheque.ValidUpto = TxtValidUpto.Text;
objAddCheque.Amount = Convert.ToDecimal(TxtAmount.Text);
objAddCheque.Notes = RtfNotes.Text;
SaveDatas(objAddCheque);
}
