// to insert for renewal public int InsertIndividualContribution(IndividualContribution individualContribution) { int result = 0; try { List <SqlCommand> transcommand = new List <SqlCommand>(); SqlCommand mycmd = new SqlCommand(); SqlCommand mycmd1 = new SqlCommand(); string commandtext_Contribution = "INSERT INTO shared.TBL_CONTRIBUTION (MEMBER_ID, TOTAL_AMOUNT, CONTRIBUTION_DT, CREATED_DT, CONTRIBUTION_STATUS) VALUES ((select" + " Member_Id from membership.TBL_Membership where Person_Id=@personId), @totalamount, @contributiondt, @createddate,@status)"; mycmd1 = dbhelp.CreateCommand(commandtext_Contribution, CommandType.Text, "@personId", individualContribution.PersonId, "@totalamount", individualContribution.TotalAmount, "@contributiondt", individualContribution.ContributionDate, "@createddate", individualContribution.ContributionCreatedDate, "@status", individualContribution.Status); string commandtext_contributiontransaction = "INSERT INTO shared.TBL_CONTRIBUTION_TRANSACTION (CONTRIBUTION_ID, AMOUNT, PAYMENT_RECEIVED_DT, CREATED_DT, PAYMENT_DETAILS, PAYMENT_MODE," + " PAYMENT_PURPOSE) VALUES ((SELECT MAX(CONTRIBUTION_ID) FROM shared.TBL_CONTRIBUTION), @amount, @paymentreceiveddate, @createddate, @paymentdets, @paymentmode, @paymentpurpose)"; mycmd = dbhelp.CreateCommand(commandtext_contributiontransaction, CommandType.Text, "@amount", individualContribution.Amoount, "@paymentreceiveddate", individualContribution.PaymentReceivedDate, "@createddate", individualContribution.CreatedDate, "@paymentdets", individualContribution.PaymentDetails, "@paymentmode", individualContribution.PaymentMode, "@paymentpurpose", individualContribution.PaymentPurpose); dbhelp.ExecNonQuery("UPDATE c SET c.CONTRIBUTION_PAID = CONTRIBUTION_PAID + @amount FROM shared.TBL_CONTRIBUTION c inner join shared.TBL_CONTRIBUTION_TRANSACTION ct ON c.CONTRIBUTION_ID = ct.CONTRIBUTION_ID"); transcommand.Add(mycmd1); transcommand.Add(mycmd); result = dbhelp.ExecTrans(transcommand); } catch (Exception ex) { ErrorLog.WriteErrorLog(ex.ToString()); } UpdatePaymentStatus(individualContribution); return(result); }
// to insert for renewal public int InsertIndividualContributionInstallmentOrganisation(IndividualContribution individualContribution) { int result = 0; try { List <SqlCommand> transcommand = new List <SqlCommand>(); SqlCommand mycmd = new SqlCommand(); string commandtext_contributiontransaction = "INSERT INTO shared.TBL_CONTRIBUTION_TRANSACTION (CONTRIBUTION_ID, AMOUNT, PAYMENT_RECEIVED_DT, CREATED_DT, PAYMENT_DETAILS, PAYMENT_MODE," + " PAYMENT_PURPOSE) VALUES (@contributionId, @amount, @paymentreceiveddate, @createddate, @paymentdets, @paymentmode, @paymentpurpose)"; mycmd = dbhelp.CreateCommand(commandtext_contributiontransaction, CommandType.Text, "@contributionId", individualContribution.ContributionId, "@amount", individualContribution.Amoount, "@paymentreceiveddate", individualContribution.PaymentReceivedDate, "@createddate", individualContribution.CreatedDate, "@paymentdets", individualContribution.PaymentDetails, "@paymentmode", individualContribution.PaymentMode, "@paymentpurpose", individualContribution.PaymentPurpose); transcommand.Add(mycmd); result = dbhelp.ExecTrans(transcommand); UpdatePaymentStatusOrganisation(individualContribution); } catch (Exception ex) { ErrorLog.WriteErrorLog(ex.ToString()); } return(result); }
public void UpdatePaymentStatus(IndividualContribution individualContribution) { List <SqlCommand> transcommand = new List <SqlCommand>(); SqlCommand mycmd = new SqlCommand(); try { string commandtext_Contribution = string.Format(@"SELECT top 1 ct.TOTAL_AMOUNT, Sum(c.AMOUNT) as Total_Paid from shared.TBL_CONTRIBUTION_TRANSACTION c INNER JOIN shared.TBL_CONTRIBUTION ct on c.CONTRIBUTION_ID = ct.CONTRIBUTION_ID where ct.Contribution_Id={1} and ct.Member_Id = (select Member_Id from membership.TBL_Membership where Person_Id = {0}) group by ct.TOTAL_AMOUNT, ct.CONTRIBUTION_ID order by ct.CONTRIBUTION_ID desc", individualContribution.PersonId, individualContribution.ContributionId); mycmd = dbhelp.CreateCommand(commandtext_Contribution, CommandType.Text); transcommand.Add(mycmd); mycmd.Connection = dbhelp._conn; dbhelp._conn.Open(); var dataReader = mycmd.ExecuteReader(); individualContribution.Status = "Installment"; if (dataReader != null && dataReader.HasRows) { dataReader.Read(); var TotalAmount = dataReader.GetDecimal(0); var paidAmount = dataReader.GetDecimal(1); if (paidAmount >= TotalAmount) { individualContribution.Status = "Full"; } dataReader.Close(); } string newQuery = string.Format("update shared.TBL_CONTRIBUTION set CONTRIBUTION_STATUS ='{0}', Contribution_Paid=Contribution_Paid+{1} Where Member_Id=(select Member_Id from membership.TBL_Membership " + " where Person_Id={3}) and Contribution_Id={2}", individualContribution.Status, individualContribution.Amoount, individualContribution.ContributionId, individualContribution.PersonId); mycmd.CommandText = newQuery; mycmd.ExecuteNonQuery(); dbhelp._conn.Close(); } catch (Exception ex) { ErrorLog.WriteErrorLog(ex.ToString()); } }
public void UpdatePaymentStatus(IndividualContribution individualContribution) { List <SqlCommand> transcommand = new List <SqlCommand>(); SqlCommand mycmd = new SqlCommand(); try { string commandtext_Contribution = "SELECT c.MEMBER_ID, c.TOTAL_AMOUNT, c.CONTRIBUTION_PAID from shared.TBL_CONTRIBUTION c INNER JOIN shared.TBL_CONTRIBUTION_TRANSACTION ct" + " on c.CONTRIBUTION_ID = ct.CONTRIBUTION_ID where c.Member_Id=(Select Member_Id from membership.TBL_MEMBERSHIP VALUES ((select Member_Id from membership.TBL_Membership " + " where Person_Id=@personId))"; mycmd = dbhelp.CreateCommand(commandtext_Contribution, CommandType.Text, "@personId", individualContribution.PersonId); transcommand.Add(mycmd); DataTable dataTable = dbhelp.ExecDataReader(commandtext_Contribution); var dataReader = mycmd.ExecuteReader(); individualContribution.Status = "Partial"; if (dataReader.HasRows) { while (dataReader.Read()) { var TotalAmount = dataReader.GetDecimal(1); var paidAmount = dataReader.GetDecimal(2); if (paidAmount >= TotalAmount) { individualContribution.Status = "Paid"; } } dataReader.Close(); } string newQuery = string.Format("update shared.TBL_CONTRIBUTION set CONTRIBUTION_STATUS ='{0}' (Select Member_Id from membership.TBL_MEMBERSHIP VALUES ((select Member_Id from membership.TBL_Membership " + " where Person_Id=@personId))", individualContribution.Status); mycmd.CommandText = newQuery; mycmd.ExecuteNonQuery(); } catch (Exception ex) { ErrorLog.WriteErrorLog(ex.ToString()); } }
protected void Submit_Renewal(object sender, EventArgs e) { if (cbpaid.Checked) { int createindcheck = 0; IndividualContribution individualContribution = new IndividualContribution(); individualContribution.Amoount = decimal.Parse(memfee.Value); individualContribution.PaymentReceivedDate = DateTime.Parse(paymentreceiveddate.Value); individualContribution.PaymentPurpose = "Membership"; individualContribution.PaymentMode = PaymentMode.Value; individualContribution.ExpiryDate = datetime.Value; individualContribution.DonorTier = Donor_Tier.Value; individualContribution.TotalAmount = decimal.Parse(memfee.Value); individualContribution.PaymentDetails = remarks.Value; individualContribution.CreatedDate = DateTime.Now; individualContribution.ContributionCreatedDate = DateTime.Now; individualContribution.ContributionDate = DateTime.Now; individualContribution.PersonId = int.Parse(Session["PersonId"].ToString()); individualContribution.Status = "Full"; if (cbInstallment.Checked) { individualContribution.Amoount = decimal.Parse(txtInstallment.Value); individualContribution.Status = "Installment"; } if (!string.IsNullOrEmpty(individualContribution.DonorTier) && !string.IsNullOrEmpty(individualContribution.PaymentMode)) { if (individualContribution.DonorTier == "Friend of IPS") { individualContribution.ExpiryDate = datetime.Value; } else if (individualContribution.DonorTier == "Lifetime Friend of IPS" || individualContribution.DonorTier == "Lifetime Benefactor of IPS" || individualContribution.DonorTier == "Lifetime Patron of IPS") { datetime.Value = individualContribution.ExpiryDate = "NA"; } DALMembership mem = new DALMembership(); // individual int updateindcheck = mem.EditIndividual(individualContribution.DonorTier, individualContribution.ExpiryDate, individualID.Value, DateTime.Now); createindcheck = mem.InsertIndividualContribution(individualContribution); //decimal amt, string paymentreceiveddate, DateTime createddate, string paymentdets, string paymentmode, string paymentpurpose, decimal totalamt, DateTime contridate if (createindcheck == 0) { //ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "displaySuccess('Successfully Renewed!');", true); ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "showControlsAfterPostBackChecked();", true); } } else { //ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true); ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "showControlsAfterPostBackCheckedFailure();", true); } } else { //Update Membership Table if unchecked var expiry_date = datetime.Value; var donortier = Donor_Tier.Value; if (!string.IsNullOrEmpty(donortier)) { if (donortier == "Friend of IPS") { expiry_date = datetime.Value; } else if (donortier == "Lifetime Friend of IPS" || donortier == "Lifetime Benefactor of IPS" || donortier == "Lifetime Patron of IPS") { expiry_date = "NA"; datetime.Value = expiry_date; } DALMembership mem = new DALMembership(); //individual int indcheck = mem.EditIndividual(donortier, expiry_date, individualID.Value, DateTime.Now); if (indcheck > 0) { // ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "displaySuccess('Successfully Renewed!');", true); ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "showControlsAfterPostBackUnchecked();", true); } } else { ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true); } } }
protected void Submit_Renewal(object sender, EventArgs e) { var expiry_date = datetime.Value; var donortier = Donor_Tier.Value; if (donortier == "Friend of IPS") { expiry_date = datetime.Value; } else if (donortier == "Lifetime Friend of IPS" || donortier == "Lifetime Benefactor of IPS" || donortier == "Lifetime Patron of IPS") { expiry_date = "NA"; datetime.Value = expiry_date; datetime.Disabled = true; } DALMembership mem = new DALMembership(); if (cbpaid.Checked) { int createindcheck = 0; IndividualContribution individualContribution = new IndividualContribution(); individualContribution.PaymentReceivedDate = DateTime.Parse(paymentreceiveddate.Value); individualContribution.PaymentPurpose = "Membership"; individualContribution.PaymentMode = PaymentMode.Value; individualContribution.ExpiryDate = datetime.Value; individualContribution.DonorTier = Donor_Tier.Value; individualContribution.PaymentDetails = remarks.Value; individualContribution.CreatedDate = DateTime.Now; individualContribution.ContributionCreatedDate = DateTime.Now; individualContribution.ContributionId = (string)(Session["ContributionID"]); individualContribution.ContributionDate = DateTime.Now; individualContribution.PersonId = int.Parse(Session["PersonId"].ToString()); individualContribution.Status = "Full"; if (hdnStatus.Value.Contains("Partial")) { if (!string.IsNullOrEmpty(individualContribution.PaymentMode)) { if (cbInstallment.Checked) { individualContribution.Amoount = decimal.Parse(txtInstallment.Value); individualContribution.Status = "Installment"; } int insertInstallment = 0; insertInstallment = mem.InsertIndividualContributionInstallment(individualContribution); if (insertInstallment > 0) { ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "showControlsAfterPostBackChecked();", true); DALMembership dao = new DALMembership(); int contributionId = Convert.ToInt32(Session["ContributionID"]); float amountPaid = dao.GetPartialPayment(contributionId); hdnInstallment.Value = amountPaid.ToString(); hdnStatus.Value = "Partial"; memfee.Disabled = true; txtInstallment.Value = amountPaid.ToString(); } } else { ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "showControlsAfterPostBackCheckedInstallmentFailure();", true); } } else if (memfee.Disabled.Equals(false)) { if (cbInstallment.Checked.Equals(false)) { if (!string.IsNullOrEmpty(individualContribution.DonorTier) && !string.IsNullOrEmpty(individualContribution.PaymentMode)) { individualContribution.Amoount = decimal.Parse(memfee.Value); individualContribution.TotalAmount = decimal.Parse(memfee.Value); if (cbInstallment.Checked) { individualContribution.Amoount = decimal.Parse(txtInstallment.Value); individualContribution.Status = "Installment"; } int updateindcheck = mem.EditIndividual(individualContribution.DonorTier, individualContribution.ExpiryDate, individualID.Value, DateTime.Now); createindcheck = mem.InsertIndividualContribution(individualContribution); if (createindcheck > 0) { ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "showControlsAfterPostBackCheckedNoInstallment();", true); } } else { ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "showControlsAfterPostBackCheckedFailure();", true); } } else { if (!string.IsNullOrEmpty(individualContribution.DonorTier) && !string.IsNullOrEmpty(individualContribution.PaymentMode)) { individualContribution.Amoount = decimal.Parse(memfee.Value); individualContribution.TotalAmount = decimal.Parse(memfee.Value); if (cbInstallment.Checked) { individualContribution.Amoount = decimal.Parse(txtInstallment.Value); individualContribution.Status = "Installment"; } int updateindcheck = mem.EditIndividual(individualContribution.DonorTier, individualContribution.ExpiryDate, individualID.Value, DateTime.Now); createindcheck = mem.InsertIndividualContribution(individualContribution); if (createindcheck > 0 && cbInstallment.Checked.Equals(true)) { ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "showControlsAfterPostBackCheckedFirst();", true); // ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "showControlsAfterPostBackCheckedWithInstallment();", true); } } else { // hdnStatus.Value = "PartialFirst"; ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "showControlsAfterPostBackCheckedInstallmentFailureFirst();", true); // ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "showControlsAfterPostBackCheckedFailureWithInstallment();", true); } } } } else { //Update Membership Table if unchecked if (!string.IsNullOrEmpty(donortier)) { int indcheck = mem.EditIndividual(donortier, expiry_date, individualID.Value, DateTime.Now); if (indcheck > 0) { ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "showControlsAfterPostBackUnchecked();", true); } } else { ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true); } } }