public static string Save(Entity.Common.SMSPayment payment)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pPaymentId", SqlDbType.Int, payment.PaymentId);
oDm.Add("@pSMSMemberId", SqlDbType.Int, payment.SMSMemberId);
oDm.Add("@pPaymentMode", SqlDbType.VarChar, 50, payment.PaymentMode);
oDm.Add("@pPaymentDate", SqlDbType.Date, payment.PaymentDate);
oDm.Add("@pPaymentAmount", SqlDbType.Decimal, payment.PaymentAmount);
oDm.Add("@pNarration", SqlDbType.VarChar, 500, payment.Narration);
oDm.Add("@pCreatedBy", SqlDbType.Int, payment.CreatedBy);
oDm.Add("@pCreatedByUserType", SqlDbType.VarChar, 50, payment.CreatedByUserType);
oDm.Add("@pCashBankLedgerId", SqlDbType.Int, payment.CashBankLedgerId);
oDm.Add("@pFeesXml", SqlDbType.Xml, payment.FeesXml);
oDm.Add("@pPaymentNo", SqlDbType.VarChar, 50, ParameterDirection.InputOutput, "");
oDm.Add("@pSMSEndDate", SqlDbType.Date, payment.SMSEndDate);
if (payment.IsApproved == null)
{
oDm.Add("@pIsApproved", SqlDbType.Bit, DBNull.Value);
}
else
{
oDm.Add("@pIsApproved", SqlDbType.Bit, payment.IsApproved);
}
if (payment.ApprovedBy == null)
{
oDm.Add("@pApprovedBy", SqlDbType.Int, DBNull.Value);
}
else
{
oDm.Add("@pApprovedBy", SqlDbType.Int, payment.ApprovedBy);
}
if (payment.ApprovedDate == null)
{
oDm.Add("@pApprovedDate", SqlDbType.DateTime, DBNull.Value);
}
else
{
oDm.Add("@pApprovedDate", SqlDbType.DateTime, payment.ApprovedDate);
}
oDm.Add("@pIsExcelUpload", SqlDbType.Bit, payment.IsExcelUpload);
oDm.CommandType = CommandType.StoredProcedure;
oDm.ExecuteNonQuery("usp_SMSPayment_Save");
return((string)oDm["@pPaymentNo"].Value);
}
}
private void Save(bool?IsApproved)
{
Message.Show = false;
FeesXml = "<NewDataSet>";
foreach (GridViewRow gvr in dgvSMS.Rows)
{
if (gvr.RowType == DataControlRowType.DataRow)
{
if (((CheckBox)gvr.FindControl("ChkSelect")).Checked)
{
FeesXml += "<Row";
FeesXml += " SMSCategoryId = \"" + dgvSMS.DataKeys[gvr.RowIndex].Values["SMSCategoryId"].ToString() + "\"";
FeesXml += " SMSAmount = \"" + gvr.Cells[2].Text + "\"";
//FeesXml += " TaxAmount = \"" + gvr.Cells[5].Text + "\"";
FeesXml += " TaxAmount = \"" + (string.IsNullOrEmpty(((TextBox)gvr.FindControl("txtTaxPaymentAmount")).Text.Trim()) ? "0" : ((TextBox)gvr.FindControl("txtTaxPaymentAmount")).Text.Trim()) + "\"";
FeesXml += " />";
}
}
}
FeesXml += "</NewDataSet>";
BusinessLayer.Common.SMSPayment objSMSPayment = new BusinessLayer.Common.SMSPayment();
Entity.Common.SMSPayment payment = new Entity.Common.SMSPayment();
payment.PaymentId = PaymentId;
payment.SMSMemberId = Convert.ToInt32(ddlSMSMember.SelectedValue);
payment.PaymentMode = ddlPaymentMode.SelectedValue;
payment.PaymentDate = Convert.ToDateTime(txtPaymentDate.Text.Split('/')[2] + "-" + txtPaymentDate.Text.Split('/')[1] + "-" + txtPaymentDate.Text.Split('/')[0]);
payment.SMSEndDate = Convert.ToDateTime(txtSubscriptionEndDate.Text.Split('/')[2] + "-" + txtSubscriptionEndDate.Text.Split('/')[1] + "-" + txtSubscriptionEndDate.Text.Split('/')[0]);
payment.PaymentAmount = Convert.ToDecimal(txtPaymentAmount.Text.Trim());
payment.Narration = txtNarration.Text.Trim();
payment.CreatedBy = Convert.ToInt32(Session["UserId"].ToString());
payment.CreatedByUserType = Session["UserType"].ToString();
payment.CashBankLedgerId = Convert.ToInt32(ddlCashBankLedger.SelectedValue);
payment.FeesXml = FeesXml;
payment.IsExcelUpload = false;
if (IsApproved != null)
{
payment.IsApproved = true;
payment.ApprovedBy = Convert.ToInt32(Session["UserId"].ToString());
payment.ApprovedDate = DateTime.Now;
}
else
{
payment.IsApproved = null;
payment.ApprovedBy = null;
payment.ApprovedDate = null;
}
PaymentId = 0;
string strPaymentNo = objSMSPayment.Save(payment);
txtPaymentNo.Text = strPaymentNo;
LoadSMSCategoryWiseDetail();
txtPaymentAmount.Text = "0.00";
CalendarExtenderPaymentDate.Enabled = true;
txtNarration.Text = "";
LoadLedgerOpeningBalance();
Message.IsSuccess = true;
Message.Text = "Payment detail saved successfully";
Message.Show = true;
btnPrint.Visible = true;
if (Session["UserType"].ToString().Equals("Member") && ddlPaymentMode.SelectedItem.Text.ToUpper().Equals("ONLINE PAYMENT"))
{
Response.Redirect(@"https://www.onlinesbi.com/prelogin/icollecthome.htm?corpid=649959");
}
}
public string Save(Entity.Common.SMSPayment payment)
{
return(DataAccess.Common.SMSPayment.Save(payment));
}
