public void bindMemberPlanDetailsWithBalance()
{
Guid ParlourId = new Guid(Request.QueryString["ParlourId"]);
MembersPaymentDetailsModel model = client.GetMemberPlanDetailsWithBalance(Request.QueryString["ID"].ToString(), new Guid(Request.QueryString["ParlourId"]));
if ((model == null))
{
}
else
{
txtNextPaymentDate.Text = FormatDateTime(DateTime.Now.ToString());
txtReceivedBy.Text = HttpContext.Current.User.Identity.Name;
txtMember.Text = model.FullNames;
txtMemberNo.Text = model.MemeberNumber;
txtPlan.Text = model.PlanName;
txtPremium.Text = model.PlanSubscription;
txtSpouse.Text = model.Spouse.ToString();
txtChildren.Text = model.Children.ToString();
txtAdults.Text = model.Adults.ToString();
txtWaitingPeriod.Text = model.WaitingPeriod.ToString();
txtCover.Text = model.Cover.ToString(Currency.Trim() + " 0.00");
txtPolicyLaps.Text = model.PolicyLaps.ToString();
txtMemberStauts.Text = model.PolicyStatus;
if (model.PolicyStatus == "1" || model.PolicyStatus == "Active")
{
txtMemberStauts.Text = "Active";
}
if (model.PolicyStatus == "0" || model.PolicyStatus == "waiting")
{
txtMemberStauts.Text = "waiting";
}
txtJoiningFee.Text = model.JoiningFee.ToString("0.00");
//txtNextPaymentDate.Text = model.NextPaymentDate.ToString();
txtPolicyBalance.Text = model.Balance.ToString(Currency.Trim() + " 0.00");
txtMonthOwing.Text = model.MonthOwing.ToString();
txtLatePenalty.Text = model.LatePaymentPenalty.ToString(Currency.Trim() + " 0.00");
txtMohthPaid.Text = model.NextPaymentDate.ToString("MMM-yyyy");
hdnLastpaymentDate.Value = model.NextPaymentDate.ToString();
ViewState["_memberId"] = Convert.ToInt32(model.pkiMemberID);
ViewState["NextPaymentDate"] = model.NextPaymentDate.ToString("MMM-yyyy");
txtTotalPremium.Text = Convert.ToDouble(client.SumPremium(Convert.ToInt32(model.pkiMemberID), new Guid(Request.QueryString["ParlourId"]))).ToString(Currency.Trim() + " 0.00");
if (txtMemberStauts.Text == "Trial" || txtMemberStauts.Text == "Active" || txtMemberStauts.Text == "1")
{
btnReunstate.Enabled = false;
btnRejoin.Enabled = false;
}
else
{
btnReunstate.Enabled = true;
btnRejoin.Enabled = true;
}
bindInvoices(new Guid(Request.QueryString["ParlourId"]), Convert.ToInt32(model.pkiMemberID));
}
}
public void PrintPayment(MembersPaymentDetailsModel model)
{
/*
* Response.Redirect("PrinterReciept.aspx?PolicyNr=" + model.MemeberNumber.ToString() +
* "&DatePaid=" + model.PaymentDate.ToString("YYYY-MMM-dd") +
* "&AmountPaid=" + model.Amount.ToString() +
* "&LateAmountPaid=" + model.LatePaymentPenalty.ToString() +
* "&PolicyHolder=" + model.FullNames +
* "&ReceivedBy=" + model.ReceivedBy +
* "&TimePrinted=" + DateTime.Now.ToString("YYYY-MMM-dd hh:mm") +
* "&Method=" + model.MethodOfPayment +
* "&Notes=" + model.Notes +
* "&Plan=" + model.PlanName );
*
* Dim zlabel As New Com.SharpZebra.Example.BorderedLabel(" Branch Name...... " & vbTab & vbTab & ConfigurationManager.AppSettings("branch"), _
* " Receipt Nr....... " & vbTab & vbTab & intReceipt, _
* " Policy Nr........ " & vbTab & vbTab & txtMemberNo.Text.ToUpper, _
* " Date Paid:....... " & vbTab & vbTab & dtDatepaid.ToString("dd-MMM-yyyy"), _
* " Amount Paid...... " & vbTab & vbTab & FormatCurrency(txtAmount.Text, 2), _
* " Policy Holder.... " & vbTab & vbTab & BL.pFullNames & " " & BL.pSurname, _
* " Received By...... " & vbTab & vbTab & txtRecievedBy.Text, _
* " Time Printed..... " & vbTab & vbTab & DateTime.Now.ToString("dd-MMM-yyyy hh:mm"), _
* " Method........... " & vbTab & vbTab & strMethod, _
* notes, _
* " Underwriter...... " & vbTab & vbTab & BL.pAddress4, "123", strAppName, dtAdditionalAppSettings.Rows(0).Item("slogan"))
*
*
*/
}
protected void txtMemberNo_TextChanged(object sender, EventArgs e)
{
MembersPaymentDetailsModel model = client.GetMemberPlanDetailsWithByMemberNo(Convert.ToString(txtMemberNo.Text));
if ((model == null))
{
}
else
{
txtNextPaymentDate.Text = FormatDateTime(DateTime.Now.ToString());
txtReceivedBy.Text = HttpContext.Current.User.Identity.Name;
txtMember.Text = model.FullNames;
txtMemberNo.Text = model.MemeberNumber;
txtPlan.Text = model.PlanName;
txtPremium.Text = model.PlanSubscription;
txtSpouse.Text = model.Spouse.ToString();
txtChildren.Text = model.Children.ToString();
txtAdults.Text = model.Adults.ToString();
txtWaitingPeriod.Text = model.WaitingPeriod.ToString();
txtCover.Text = model.Cover.ToString(Currency.Trim() + " 0.00");
txtPolicyLaps.Text = model.PolicyLaps.ToString();
txtMemberStauts.Text = model.PolicyStatus;
txtJoiningFee.Text = model.JoiningFee.ToString("0.00");
//txtNextPaymentDate.Text = model.NextPaymentDate.ToString();
txtPolicyBalance.Text = model.Balance.ToString(Currency.Trim() + " 0.00");
txtMonthOwing.Text = model.MonthOwing.ToString();
txtLatePenalty.Text = model.LatePaymentPenalty.ToString(Currency.Trim() + " 0.00");
txtMohthPaid.Text = model.NextPaymentDate.ToString("MMM-yyyy");
ViewState["_memberId"] = Convert.ToInt32(model.pkiMemberID);
ViewState["NextPaymentDate"] = model.NextPaymentDate.ToString("MMM-yyyy");
txtTotalPremium.Text = Convert.ToDouble(client.SumPremium(Convert.ToInt32(model.pkiMemberID), model.ParlourId)).ToString(Currency.Trim() + " 0.00");
if (txtMemberStauts.Text == "Trial" || txtMemberStauts.Text == "Active")
{
btnReunstate.Enabled = false;
btnRejoin.Enabled = false;
}
else
{
btnReunstate.Enabled = true;
btnRejoin.Enabled = true;
}
bindInvoices(model.ParlourId, Convert.ToInt32(model.pkiMemberID));
}
}
public void PaymentRemindersms(MembersPaymentDetailsModel model)
{
if (model.pkiMemberID > 0)
{
//Member New Registration Welcome SMS Send
int SmsGrupId = Convert.ToInt32(SmsGroupType.Payment);
smsSendingGroupModel modelSSG = client.GetsmsGroupbyID(SmsGrupId, ParlourId);
if (modelSSG != null)
{
StringBuilder strsb = new StringBuilder();
smsTempletModel _EmailTemplate = client.GetEmailTemplateByID(SmsGrupId, ParlourId);
if (_EmailTemplate != null)
{
MembersModel objMemberModel = client.GetMemberByID(model.pkiMemberID, ParlourId);
strsb = new StringBuilder(_EmailTemplate.smsText);
strsb = strsb.Replace("@Name", "<p>" + objMemberModel.FullNames + " " + objMemberModel.Surname + "</p>");
strsb = strsb.Replace("@DatePayment", "<p>" + model.PaymentDate + "</p>");
strsb = strsb.Replace("@NextDatePayment", "<p>" + model.Notes + "</p>");
strsb = strsb.Replace("@Paymentby", "<p>" + model.MethodOfPayment + "</p>");
string CellNo = (objMemberModel.Cellphone == string.Empty ? "0" : objMemberModel.Cellphone);
if (CellNo == "0")
{
CellNo = (objMemberModel.Telephone == string.Empty ? "0" : objMemberModel.Telephone);
}
SendReminderModel smsModel = new SendReminderModel();
smsModel.MemeberID = UserID.ToString();
smsModel.MemberData = strsb.ToString();
smsModel.MemeberToNumber = Convert.ToInt64(CellNo.Replace(" ", ""));
smsModel.parlourid = ParlourId;
int SendOpration = client.InsertSendReminder(smsModel);
}
}
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
MembersPaymentDetailsModel objPayment = new MembersPaymentDetailsModel();
}
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(txtReceivedBy.Text))
{
Common.WebMsgBox.Show("Incorrect data provided");
txtReceivedBy.Focus();
return;
}
if (txtMemberStauts.Text == "Lapsed" & !txtMohthPaid.Text.Contains("Reinstate Policy") & !txtMohthPaid.Text.Contains("Rejoin Policy"))
{
Common.WebMsgBox.Show("This policy has Lapsed, please take the corrective action.");
return;
}
if (ddlNoOfMonths.SelectedIndex == -1 & !blnFuneralPayment & btnPay.Text != "Add Reversal" & !txtMohthPaid.Text.Contains("Joining Fee") & !txtMohthPaid.Text.Contains("Reinstate Policy") & !txtMohthPaid.Text.Contains("Rejoin Policy"))
{
Common.WebMsgBox.Show("Select Number of Months");
ddlNoOfMonths.Focus();
return;
}
if (string.IsNullOrEmpty(txtMohthPaid.Text))
{
Common.WebMsgBox.Show("Incorrect data provided");
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;
//Remain
//if (txtMohthPaid.Text.Contains("Reinstate Policy") | txtMohthPaid.Text.Contains("Rejoin Policy"))
//{
// //SupervisorLogin frmSupervisorLogin = default(SupervisorLogin);
// //blnAuthenticated = false;
// //frmSupervisorLogin = new SupervisorLogin();
// //frmSupervisorLogin.ShowDialog();
// //if (!blnAuthenticated)
// //{
// // break; // TODO: might not be correct. Was : Exit Try
// //}
//}
Guid ParlID = new Guid(Request.QueryString["ParlourId"]);
MembersModel objmember = client.GetMemberByID(MemberId, ParlID);
if (!blnFuneralPayment)
{
if (btnPay.Text != "Add Reversal" & !string.IsNullOrEmpty(txtTotalPremium.Text) & !txtMohthPaid.Text.Contains("Joining Fee"))
{
if (Convert.ToDouble(hdnAmount.Value.Replace(Currency.Trim() + " ", "")) < Convert.ToDouble(txtTotalPremium.Text.Replace(Currency.Trim() + " ", "")))
{
ShowMessage(ref lblMessage, MessageType.Danger, "Payment cannot be less than premium amount.");
Common.WebMsgBox.Show("Payment cannot be less than premium amount.");
return;
}
}
if (btnPay.Text == "Add Payment")
{
MembersPaymentDetailsModel objPayment = new MembersPaymentDetailsModel();
objPayment.pkiMemberID = MemberId;
objPayment.Amount = Convert.ToDecimal(hdnAmount.Value.Replace(Currency.Trim() + " ", ""));
objPayment.LatePaymentPenalty = Convert.ToDecimal(txtLatePenalty.Text.Replace(Currency.Trim() + " ", ""));
objPayment.ReceivedBy = txtReceivedBy.Text.ToString();
objPayment.Notes = txtMohthPaid.Text.ToString();
objPayment.MethodOfPayment = strMethod;
objPayment.MemeberNumber = txtMemberNo.Text.ToString();
objPayment.PaymentDate = Convert.ToDateTime(txtNextPaymentDate.Text);
objPayment.NextPaymentDate = Convert.ToDateTime(hdnLastpaymentDate.Value).AddMonths(Convert.ToInt32(ddlNoOfMonths.SelectedValue));
objPayment.Branch = objmember.MemberBranch;
objPayment.parlourid = ParlID;
bool IsJoiningFee = false;
IsJoiningFeePaid(out IsJoiningFee);
int PaymentID = client.AddPayments(objPayment, IsJoiningFee);
if (PaymentID != 0)
{
Common.WebMsgBox.Show("Payment not added successfully.");
}
else
{
Common.WebMsgBox.Show("Payment added successfully.");
PrintPayment(objPayment);
PaymentRemindersms(objPayment);
bindMemberPlanDetailsWithBalance();
}
}
else
{
if (Interaction.MsgBox("You are about to make a REVERSAL PAYMENT. Continue?", MsgBoxStyle.YesNo) == MsgBoxResult.Yes)
{
//MembersPaymentDetailsModel objPayment = new MembersPaymentDetailsModel();
//objPayment.pkiMemberID = MemberId;
//objPayment.Amount = Convert.ToDecimal(hdnAmount.Value.Replace("R ", ""));
//objPayment.LatePaymentPenalty = Convert.ToDecimal(txtLatePenalty.Text.Replace("R ", ""));
//objPayment.ReceivedBy = txtReceivedBy.Text.ToString();
//objPayment.Notes = txtMohthPaid.Text.ToString();
//objPayment.MethodOfPayment = strMethod;
//objPayment.MemeberNumber = txtMemberNo.Text.ToString();
//objPayment.PaymentDate = Convert.ToDateTime(txtNextPaymentDate.Text);
//objPayment.NextPaymentDate = Convert.ToDateTime(hdnLastpaymentDate.Value).AddMonths(Convert.ToInt32(ddlNoOfMonths.SelectedValue));
////
//objPayment.Branch = objmember.MemberBranch;
//objPayment.parlourid = ParlID;
//int PaymentID = client.AddReversalPayments(objPayment);
//if (PaymentID != 0)
//{
// Common.WebMsgBox.Show("Reversal added successfully.");
//}
//else
//{
// Common.WebMsgBox.Show("Reversal not added successfully.");
//}
}
}
//ReturnMemberPayment - Done
//FuneralPaymentsModel[] objFuneralPaymentModel = client.ReturnMemberPayment(Convert.ToString(MemberId));
//gvInvoices.DataSource = objFuneralPaymentModel;
//gvInvoices.DataBind();
}
else
{
if (btnPay.Text == "Add Payment")
{
FuneralPaymentsModel funeralPayment = new FuneralPaymentsModel();
funeralPayment.FuneralID = FuneralId;
funeralPayment.AmountPaid = Convert.ToDecimal(hdnAmount.Value.Replace(Currency.Trim() + " ", ""));
funeralPayment.RecievedBy = txtReceivedBy.Text.ToString();
funeralPayment.Notes = txtMohthPaid.Text.ToString();
funeralPayment.ParlourId = new Guid(Request.QueryString["ParlourId"]);
funeralPayment.UserName = HttpContext.Current.User.Identity.Name;
int FuneralID = client.AddFuneralPayments(funeralPayment);
if (FuneralID != 0)
{
Common.WebMsgBox.Show("Payment added successfully.");
//ReadFuneralInvoiceIntoDatatable - Remain.
btnPrint.Enabled = true;
}
else
{
Common.WebMsgBox.Show("Payment not added successfully.");
}
}
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)
{
FuneralPaymentsModel objFunerals = new FuneralPaymentsModel();
objFunerals.FuneralID = FuneralId;
objFunerals.AmountPaid = Convert.ToDecimal(hdnAmount.Value.Replace(Currency.Trim() + " ", ""));
objFunerals.RecievedBy = txtReceivedBy.Text.ToString();
objFunerals.Notes = txtMohthPaid.Text.ToString();
objFunerals.ParlourId = new Guid(Request.QueryString["ParlourId"]);
objFunerals.UserName = HttpContext.Current.User.Identity.Name;
int FuneralID = client.AddFuneralPayments(objFunerals);
}
else
{
Interaction.MsgBox("Reversal not added successfully", MsgBoxStyle.Information);
}
}
//ReturnFuneralPayments - Done
//FuneralPaymentsModel[] objFuneralPaymentModel = client.ReturnFuneralPayments(Convert.ToString(0));
//gvInvoices.DataSource = objFuneralPaymentModel;
//gvInvoices.DataBind();
}
Guid ParlourId = new Guid(Request.QueryString["ParlourId"]);
bindInvoices(ParlourId, MemberId);
txtAmount.Text = "";
hdnAmount.Value = "";
txtMohthPaid.Text = "";
ddlMethod.Enabled = true;
ddlNoOfMonths.Enabled = true;
}
catch (Exception ex)
{
Common.WebMsgBox.Show(ex.Message.ToString());
//this.Cursor = Cursors.Default;
//Interaction.MsgBox("Error:- " + ex.Message, MsgBoxStyle.Information, strAppName);
}
}
public static int AddPayments(MembersPaymentDetailsModel ModelPayment, bool IsJoiningFee)
{
int returnValue = 0;
int invNumber = 0;
DataSet dsData = GetInvoiceNumberByParlourID(ModelPayment.parlourid);
if (dsData.Tables[0].Rows.Count > 0)
{
invNumber = Convert.ToInt32(dsData.Tables[0].Rows[0][0]);
}
else
{
returnValue = 0;
return(returnValue);
}
DataTable dtMember = SearchMemberIDByMemberNo(ModelPayment.MemeberNumber, "", ModelPayment.parlourid);
if (dtMember.Rows.Count > 0 && ModelPayment.pkiMemberID != 0)
{
DbParameter[] ObjParam = new DbParameter[13];
ObjParam[0] = new DbParameter("@MemberID", DbParameter.DbType.Int, 0, ModelPayment.pkiMemberID);
//ObjParam[1] = new DbParameter("@AmountPaid", DbParameter.DbType.Decimal, 0, (ModelPayment.Amount / 100).ToString().Replace(",", "."));
ObjParam[1] = new DbParameter("@AmountPaid", DbParameter.DbType.Decimal, 0, ModelPayment.Amount);
ObjParam[2] = new DbParameter("@ReceivedBy", DbParameter.DbType.VarChar, 0, ModelPayment.ReceivedBy);
ObjParam[3] = new DbParameter("@Notes", DbParameter.DbType.VarChar, 0, ModelPayment.Notes);
ObjParam[4] = new DbParameter("@parlourid", DbParameter.DbType.UniqueIdentifier, 0, ModelPayment.parlourid);
ObjParam[5] = new DbParameter("@PaymentBranch", DbParameter.DbType.VarChar, 0, ModelPayment.Branch);
ObjParam[6] = new DbParameter("@ModifiedUser", DbParameter.DbType.VarChar, 0, ModelPayment.UserName);
ObjParam[7] = new DbParameter("@PaidUntil", DbParameter.DbType.DateTime, 0, ModelPayment.NextPaymentDate.ToString("yyyy-MM-dd"));
ObjParam[8] = new DbParameter("@InvNumber", DbParameter.DbType.Int, 0, invNumber);
if (DateTime.Now.ToString("yyyy-MM-dd") == ModelPayment.PaymentDate.ToString("yyyy-MM-dd"))
{
ObjParam[9] = new DbParameter("@DatePaid", DbParameter.DbType.DateTime, 0, DateTime.Now);
}
else
{
ObjParam[9] = new DbParameter("@DatePaid", DbParameter.DbType.DateTime, 0, ModelPayment.PaymentDate.ToString("yyyy-MM-dd"));
}
ObjParam[10] = new DbParameter("@PaidBy", DbParameter.DbType.VarChar, 0, "");
ObjParam[11] = new DbParameter("@MethodOfPayment", DbParameter.DbType.VarChar, 0, ModelPayment.MethodOfPayment);
ObjParam[12] = new DbParameter("@IsJoiningFee", DbParameter.DbType.Bit, 0, IsJoiningFee);
returnValue = Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, "AddPayment", ObjParam));
if (ModelPayment.LatePaymentPenalty > 0)
{
DbParameter[] ObjLatePaymentParam = new DbParameter[3];
ObjLatePaymentParam[0] = new DbParameter("@pkiMemberid", DbParameter.DbType.Int, 0, ModelPayment.pkiMemberID);
ObjLatePaymentParam[1] = new DbParameter("@Amount", DbParameter.DbType.Decimal, 0, (ModelPayment.LatePaymentPenalty / 100).ToString().Replace(",", "."));
ObjLatePaymentParam[2] = new DbParameter("@Notes", DbParameter.DbType.VarChar, 0, "Penalty Payment :- RecievedBy" + ModelPayment.ReceivedBy);
returnValue = Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, "MemberLatePaymentPenaltyPayment", ObjLatePaymentParam));
}
string PolicyStatus = string.Empty;
if (ModelPayment.Notes.Contains("Reinstate Policy"))
{
PolicyStatus = "Active";
}
else if (ModelPayment.Notes.Contains("Rejoin Policy"))
{
PolicyStatus = "On Trial";
}
else
{
PolicyStatus = "";
}
DbParameter[] ObjNotesParams = new DbParameter[2];
ObjNotesParams[0] = new DbParameter("@pkiMemberid", DbParameter.DbType.Int, 0, ModelPayment.pkiMemberID);
ObjNotesParams[1] = new DbParameter("@PolicyStatus", DbParameter.DbType.VarChar, 0, PolicyStatus);
returnValue = Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, "UpdateMemberPolicy", ObjNotesParams));
AddAudit(ModelPayment.ReceivedBy, ModelPayment.parlourid, "AddPayments MemberNumber=('" + ModelPayment.MemeberNumber + "')");
}
return(returnValue);
}
public static int AddPayments(MembersPaymentDetailsModel ModelPayment, bool IsJoiningFee)
{
return(MemberPaymetsDAL.AddPayments(ModelPayment, IsJoiningFee));
}
public int AddPayments(MembersPaymentDetailsModel model, bool IsJoiningFee)
{
return(MemberPaymentBAL.AddPayments(model, IsJoiningFee));
}
