public static int AddTombStonesPayment(TombStonesPaymentModel model) { decimal amountPaid = model.AmountPaid.ToString().Contains(",") == true?Convert.ToDecimal((model.AmountPaid / 100).ToString().Replace(",", ".")) : model.AmountPaid; DbParameter[] ObjParam = new DbParameter[9]; ObjParam[0] = new DbParameter("@InvoiceID", DbParameter.DbType.Int, 0, model.InvoiceID); //pIntFnrlID ObjParam[1] = new DbParameter("@TombstoneID", DbParameter.DbType.Int, 0, model.TombstoneID); //pIntFnrlID // ObjParam[2] = new DbParameter("@DatePaid", DbParameter.DbType.DateTime, 0, model.DatePaid);//pIntFnrlID ObjParam[2] = new DbParameter("@AmountPaid", DbParameter.DbType.Decimal, 0, amountPaid); ObjParam[3] = new DbParameter("@RecievedBy", DbParameter.DbType.VarChar, 0, model.RecievedBy); ObjParam[4] = new DbParameter("@PaidBy", DbParameter.DbType.VarChar, 0, model.PaidBy); ObjParam[5] = new DbParameter("@Notes", DbParameter.DbType.VarChar, 0, model.Notes); ObjParam[6] = new DbParameter("@parlourid", DbParameter.DbType.UniqueIdentifier, 0, model.parlourid); ObjParam[7] = new DbParameter("@ModifiedUser", DbParameter.DbType.VarChar, 0, model.ModifiedUser); ObjParam[8] = new DbParameter("@MemberBranch", DbParameter.DbType.VarChar, 0, model.MemberBranch); return(Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, "TombStonesPaymentSave", ObjParam))); }
public static int AddInvoice(TombStonesPaymentModel model) { return(TombStonesPaymentDAL.AddTombStonesPayment(model)); }
public int TombStonesPaymentSave(TombStonesPaymentModel model) { return(TombStonesPaymentBAL.AddInvoice(model)); }
protected void btnPay_Click(object sender, EventArgs e) { try { Int32 intMethod = 0; string strMethod = ""; //wsSMS.API SMS = new wsSMS.API(); string strMsg = string.Empty; if (string.IsNullOrEmpty(txtAmount.Text)) { Common.WebMsgBox.Show("Enter positive amount value.."); txtAmount.Focus(); return; } if (string.IsNullOrEmpty(txtReceivedBy.Text)) { Common.WebMsgBox.Show("Must enter received by."); txtReceivedBy.Focus(); return; } if (string.IsNullOrEmpty(txtMohthPaid.Text)) { Common.WebMsgBox.Show("Must enter month paid."); txtMohthPaid.Focus(); return; } if (btnPay.Text != "Add Reversal") { txtMohthPaid.Text = ddlMethod.SelectedItem.Text + " - " + txtMohthPaid.Text; } intMethod = Strings.InStr(txtMohthPaid.Text, "Cash", CompareMethod.Text); strMethod = ddlMethod.SelectedItem.Text; if (btnPay.Text == "Add Payment") { TombStonesPaymentModel tombstonePayment = new TombStonesPaymentModel(); //tombstonePayment.DatePaid = Convert.ToDateTime(txtNextPaymentDate.Text); tombstonePayment.InvoiceID = 0; tombstonePayment.TombstoneID = this.TombstoneId; tombstonePayment.AmountPaid = Convert.ToDecimal(txtAmount.Text.Replace("R ", "")); tombstonePayment.RecievedBy = txtReceivedBy.Text.ToString(); tombstonePayment.PaidBy = txtReceivedBy.Text.ToString(); tombstonePayment.MemberBranch = string.Empty; tombstonePayment.Notes = txtMohthPaid.Text.ToString(); tombstonePayment.parlourid = ParlourId; tombstonePayment.ModifiedUser = HttpContext.Current.User.Identity.Name; int FuneralID = client.TombStonesPaymentSave(tombstonePayment); if (FuneralID != 0) { Common.WebMsgBox.Show("Payment added successfully."); btnPrint.Enabled = true; } else { Common.WebMsgBox.Show("Payment failes to save."); } } else { //CheckUserAccess - Remain. ScriptManager.RegisterStartupScript(this, this.GetType(), "goToTab5", "confirm('You are about to make a REVERSAL PAYMENT. Continue?')", true); if (Interaction.MsgBox("You are about to make a REVERSAL PAYMENT. Continue?", MsgBoxStyle.YesNo) == MsgBoxResult.Yes) { TombStonesPaymentModel objTomstonePayemnt = new TombStonesPaymentModel(); //tombstonePayment.DatePaid = Convert.ToDateTime(txtNextPaymentDate.Text); objTomstonePayemnt.TombstoneID = TombstoneId; objTomstonePayemnt.AmountPaid = Convert.ToDecimal(txtAmount.Text.Replace("R ", "")); objTomstonePayemnt.RecievedBy = txtReceivedBy.Text.ToString(); objTomstonePayemnt.Notes = txtMohthPaid.Text.ToString(); objTomstonePayemnt.PaidBy = txtReceivedBy.Text.ToString(); objTomstonePayemnt.MemberBranch = string.Empty; objTomstonePayemnt.parlourid = ParlourId; objTomstonePayemnt.ModifiedUser = HttpContext.Current.User.Identity.Name; int FuneralID = client.TombStonesPaymentSave(objTomstonePayemnt); } else { Interaction.MsgBox("Reversal not added successfully", MsgBoxStyle.Information); } } bindInvoices(); txtAmount.Text = ""; hdnAmount.Value = ""; txtMohthPaid.Text = ""; ddlMethod.Enabled = true; } catch (Exception ex) { Common.WebMsgBox.Show(ex.Message); } }