public ActionResult Create([Bind(Include = "Rate_Id,Plan_Id,StartDate,EndDate,Amount,Status")] Rate_Card rate_Card)
{
ViewBag.Plan_Id = new SelectList(db.Plan_Master.OrderBy(m => m.Plan), "Plan_ID", "Plan");
try
{
//if (ModelState.IsValid)
//{
if (rate_Card.StartDate > rate_Card.EndDate)
{
ViewBag.message = ToasterMessage.Message(ToastType.info, "End date should be greater then start date");
return(View());
}
else
{
var getName = db.Rate_Card.Where(u => u.Plan_Id == rate_Card.Plan_Id && u.StartDate == rate_Card.StartDate &&
u.EndDate == rate_Card.EndDate && u.Status == rate_Card.Status).ToList();
if (getName.Count > 0)
{
ViewBag.message = ToasterMessage.Message(ToastType.info, "Record already exist");
return(View());
}
else
{
db.Rate_Card.Add(rate_Card);
db.SaveChanges();
TempData["message"] = ToasterMessage.Message(ToastType.success, "Saved successfully");
return(RedirectToAction("Index"));
}
//}
}
}
catch (DbEntityValidationException e)
{
string errorMessage = string.Empty;
foreach (DbEntityValidationResult eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (DbValidationError ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
errorMessage = ve.ErrorMessage;
ViewBag.message = ViewBag.message + ToasterMessage.Message(ToastType.error, errorMessage);
}
}
return(View());
}
catch (Exception)
{
ViewBag.message = ToasterMessage.Message(ToastType.error, "Something went wrong");
return(View());
}
//return View();
}
// GET: Rate_Card/Details/5
public ActionResult Details(decimal?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Rate_Card rate_Card = db.Rate_Card.Find(id);
if (rate_Card == null)
{
return(HttpNotFound());
}
return(View(rate_Card));
}
// GET: Rate_Card/Edit/5
public ActionResult Edit(decimal?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Rate_Card rate_Card = db.Rate_Card.Find(id);
if (rate_Card == null)
{
return(HttpNotFound());
}
ViewBag.Plan_Id = new SelectList(db.Plan_Master.OrderBy(m => m.Plan), "Plan_ID", "Plan", rate_Card.Plan_Id);
return(View(rate_Card));
}
public ActionResult DeleteConfirmed(decimal?id)
{
try
{
Rate_Card rate_Card = db.Rate_Card.Find(id);
db.Rate_Card.Remove(rate_Card);
db.SaveChanges();
TempData["message"] = ToasterMessage.Message(ToastType.success, "Deleted successfully");
return(RedirectToAction("Index"));
}
catch (DbEntityValidationException e)
{
string errorMessage = string.Empty;
foreach (DbEntityValidationResult eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (DbValidationError ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
errorMessage = ve.ErrorMessage;
ViewBag.message = ViewBag.message + ToasterMessage.Message(ToastType.error, errorMessage);
}
}
return(View());
}
catch (Exception)
{
ViewBag.message = ToasterMessage.Message(ToastType.error, "Something went wrong");
}
return(View());
}
public ActionResult Success(decimal planId, string payerId, string paymentId)
{
try
{
decimal userId = Convert.ToDecimal(UserHelper.GetUserId());
//-----For sending Invoice mail------
decimal recordId = 0;
using (LaxNarroEntities ctx = new LaxNarroEntities())
{
using (var transaction = ctx.Database.BeginTransaction())
{
int?maxInvoice = ctx.User_Transaction_Master.Max(u => u.Invoice_No);
Rate_Card rate_card = ctx.Rate_Card.Include(x => x.Plan_Master)
.Where(m => m.Plan_Id == planId && m.Status == "Active").FirstOrDefault();
User_Transaction_Master userTransaction = new User_Transaction_Master();
IEnumerable <User_Transaction_Master> userAllTransaction = ctx.User_Transaction_Master
.Where(x => x.User_ID == userId);
// Set the payer for the payment
var paymentExecution = new PaymentExecution()
{
payer_id = payerId
};
// Identify the payment to execute
var payment = new Payment()
{
id = paymentId
};
var apiContext = GetAPIContext();
// Execute the Payment
var executedPayment = payment.Execute(apiContext, paymentExecution);
int?max = userAllTransaction.Max(u => (int?)u.Invoice_No);
User_Transaction_Master maxedInvoicedTransaction = userAllTransaction
.FirstOrDefault(x => x.User_ID == userId && x.Invoice_No == max);
int?maxedInvoiceNo = ctx.User_Transaction_Master.Max(u => (int?)u.Invoice_No);
if (executedPayment.state == "approved")
{
//---------For new payment record (second time payment and so on)-------
if (maxedInvoicedTransaction.Payment_Status != "N/A")
{
userTransaction.Amount = Convert.ToDecimal(rate_card.Amount);
DateTime?endDate = maxedInvoicedTransaction.End_Date;
string strEndDate = string.Empty;
if (endDate != null)
{
strEndDate = endDate.ToString();
}
userTransaction.Start_Date = Convert.ToDateTime(strEndDate);
if (rate_card.Plan_Master.Plan == "Yearly")
{
userTransaction.End_Date = userTransaction.Start_Date.AddYears(1);
}
else
{
userTransaction.End_Date = userTransaction.Start_Date.AddYears(2);
}
if (maxInvoice == null)
{
userTransaction.Invoice_No = 1;
}
else
{
userTransaction.Invoice_No = maxInvoice + 1;
}
userTransaction.Payment_Date = DateTime.Today;
userTransaction.Payment_Method = "Online";
userTransaction.Payment_Status = "Paid";
userTransaction.Paypal_PayerId = payerId;
userTransaction.PlanID = rate_card.Plan_Id;
userTransaction.Rate_ID = rate_card.Rate_Id;
userTransaction.Status = "Active";
userTransaction.Transaction_Status = executedPayment.state;
userTransaction.Transection_ID = executedPayment.id;
userTransaction.User_ID = userId;
ctx.User_Transaction_Master.Add(userTransaction);
ctx.SaveChanges();
recordId = userTransaction.Id;
}
//---------For updating the demo record (First time payment)-------
else
{
maxedInvoicedTransaction.Amount = Convert.ToDecimal(rate_card.Amount);
if (rate_card.Plan_Master.Plan == "Yearly")
{
maxedInvoicedTransaction.End_Date = DateTime.Today.AddYears(1);
}
else
{
maxedInvoicedTransaction.End_Date = DateTime.Today.AddYears(2);
}
if (maxInvoice == null)
{
maxedInvoicedTransaction.Invoice_No = 1;
}
else
{
maxedInvoicedTransaction.Invoice_No = maxInvoice + 1;
}
maxedInvoicedTransaction.Payment_Date = DateTime.Today;
maxedInvoicedTransaction.Payment_Method = "Online";
maxedInvoicedTransaction.Payment_Status = "Paid";
maxedInvoicedTransaction.Paypal_PayerId = payerId;
maxedInvoicedTransaction.PlanID = rate_card.Plan_Id;
maxedInvoicedTransaction.Rate_ID = rate_card.Rate_Id;
//DateTime? endDate = maxedInvoicedTransaction.End_Date;
//string strEndDate = string.Empty;
//if (endDate != null)
// strEndDate = endDate.ToString();
maxedInvoicedTransaction.Start_Date = DateTime.Today;
maxedInvoicedTransaction.Status = "Active";
maxedInvoicedTransaction.Transaction_Status = executedPayment.state;
maxedInvoicedTransaction.Transection_ID = executedPayment.id;
maxedInvoicedTransaction.User_ID = userId;
ctx.Entry(maxedInvoicedTransaction).State = EntityState.Modified;
ctx.SaveChanges();
recordId = maxedInvoicedTransaction.Id;
}
PaypalResponse paypalResponse = new PaypalResponse
{
user_id = userId,
Paypal_ReferenceId = executedPayment.id,
intent = executedPayment.intent,
payer = Convert.ToString(executedPayment.payer),
payee = Convert.ToString(executedPayment.payee),
note_to_payer = executedPayment.note_to_payer,
update_time = executedPayment.update_time,
create_time = executedPayment.create_time,
response_state = executedPayment.state,
failure_reason = executedPayment.failure_reason
};
ctx.PaypalResponses.Add(paypalResponse);
ctx.SaveChanges();
transaction.Commit();
MailLog user = ctx.MailLogs.FirstOrDefault(x => x.UserID == userId);
user.LastReminderStatus = "Deactive";
ctx.SaveChanges();
}
Thread thread = new Thread(() => SendInvoice(recordId));
thread.Start();
User_Profile userMail = ctx.User_Profile.Where(p => p.ID == userId).FirstOrDefault();
Thread thread2 = new Thread(() => SendMail(userMail.FirstName, userMail.LastName, userMail.EmailAddress, "",
"Lexnarro - Subscription Successful", "~/EmailTemplate/SubscriptionMail.html"));
thread2.Start();
//SendMail(userMail.FirstName, userMail.LastName, userMail.EmailAddress, "",
// "Lexnarro - Subscription Successful", "~/EmailTemplate/SubscriptionMail.html");
TempData["message"] = ToasterMessage.Message(ToastType.success, "Subscription successful. Thank you.");
}
}
}
catch (DbEntityValidationException e)
{
string errorMessage = string.Empty;
foreach (DbEntityValidationResult eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (DbValidationError ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
errorMessage = ve.ErrorMessage;
TempData["message"] = ViewBag.message + ToasterMessage.Message(ToastType.error, errorMessage);
}
}
}
catch (Exception r)
{
TempData["message"] = ToasterMessage.Message(ToastType.error, "Something went wrong");
}
return(RedirectToAction("Index"));
}
public ReturnData PostTransaction(string email, string Plan_ID, string payerId, string Rate_Id,
string paymentId, string Amount, string Transection_ID)
{
ReturnData rd = new ReturnData();
if (email == string.Empty || Plan_ID == string.Empty || payerId == string.Empty || paymentId == string.Empty ||
Rate_Id == string.Empty || Amount == string.Empty || Transection_ID == string.Empty)
{
rd.Status = "Failure";
rd.Message = "Missing Parameters";
rd.Requestkey = "PostTransactions";
return(rd);
}
try
{
decimal userId = db.User_Profile.Where(x => x.EmailAddress == email).Select(x => x.ID).First();
//-----For sending Invoice mail------
decimal recordId = 0;
decimal planId = Convert.ToDecimal(Plan_ID);
using (LaxNarroEntities ctx = new LaxNarroEntities())
{
using (var transaction = ctx.Database.BeginTransaction())
{
int?maxInvoice = ctx.User_Transaction_Master.Max(u => u.Invoice_No);
Rate_Card rate_card = ctx.Rate_Card.Include(x => x.Plan_Master)
.Where(m => m.Plan_Id == planId && m.Status == "Active" && m.Plan_Master.Plan != "Demo").FirstOrDefault();
if (rate_card == null)
{
rd.Status = "Failure";
rd.Message = "Invalid Plan (Demo)";
rd.Requestkey = "PostTransactions";
return(rd);
}
//if(rate_card.Amount !=Convert.ToDecimal(Amount))
//{
// PaypalResponse paypalResponse1 = new PaypalResponse
// {
// user_id = userId,
// Paypal_ReferenceId = paymentId,
// intent = "sale",
// payer = "Android",
// payee = string.Empty,
// note_to_payer = "From Android",
// update_time = Convert.ToString(DateTime.Today),
// create_time = Convert.ToString(DateTime.Today),
// response_state = "created",
// failure_reason = "Invalid Amount"
// };
// ctx.PaypalResponses.Add(paypalResponse1);
// ctx.SaveChanges();
// transaction.Commit();
// rd.Status = "Failure";
// rd.Message = "Invalid Amount";
// rd.Requestkey = "PostTransactions";
// return rd;
//}
User_Transaction_Master userTransaction = new User_Transaction_Master();
List <User_Transaction_Master> userAllTransaction = ctx.User_Transaction_Master
.Where(x => x.User_ID == userId).ToList();
// Set the payer for the payment
var paymentExecution = new PaymentExecution()
{
payer_id = payerId
};
// Identify the payment to execute
var payment = new Payment()
{
id = paymentId
};
//var apiContext = GetAPIContext();
// Execute the Payment
//var executedPayment = payment.Execute(apiContext, paymentExecution);
int?max = userAllTransaction.Max(u => (int?)u.Invoice_No);
User_Transaction_Master maxedInvoicedTransaction = userAllTransaction
.FirstOrDefault(x => x.User_ID == userId && x.Invoice_No == max);
int?maxedInvoiceNo = ctx.User_Transaction_Master.Max(u => (int?)u.Invoice_No);
//if (executedPayment.state == "approved")
//{
//---------For new payment record (second time payment and so on)-------
if (maxedInvoicedTransaction.Payment_Status != "N/A")
{
userTransaction.Amount = Convert.ToDecimal(rate_card.Amount);
DateTime?endDate = maxedInvoicedTransaction.End_Date;
string strEndDate = string.Empty;
if (endDate != null)
{
strEndDate = endDate.ToString();
}
userTransaction.Start_Date = Convert.ToDateTime(strEndDate);
if (rate_card.Plan_Master.Plan == "Yearly")
{
userTransaction.End_Date = userTransaction.Start_Date.AddYears(1);
}
else
{
userTransaction.End_Date = userTransaction.Start_Date.AddYears(2);
}
if (maxInvoice == null)
{
userTransaction.Invoice_No = 1;
}
else
{
userTransaction.Invoice_No = maxInvoice + 1;
}
userTransaction.Payment_Date = DateTime.Today;
userTransaction.Payment_Method = "Online";
userTransaction.Payment_Status = "Paid";
userTransaction.Paypal_PayerId = payerId;
userTransaction.PlanID = rate_card.Plan_Id;
userTransaction.Rate_ID = rate_card.Rate_Id;
userTransaction.Status = "Active";
userTransaction.Transaction_Status = "approved";
userTransaction.Transection_ID = Transection_ID;
userTransaction.User_ID = userId;
ctx.User_Transaction_Master.Add(userTransaction);
ctx.SaveChanges();
recordId = userTransaction.Id;
rd.Status = "Success";
rd.Message = "Transaction Saved";
rd.Requestkey = "PostTransactions";
//return rd;
}
//---------For updating the demo record (First time payment)-------
else
{
maxedInvoicedTransaction.Amount = Convert.ToDecimal(rate_card.Amount);
if (rate_card.Plan_Master.Plan == "Yearly")
{
maxedInvoicedTransaction.End_Date = DateTime.Today.AddYears(1);
}
else
{
maxedInvoicedTransaction.End_Date = DateTime.Today.AddYears(2);
}
if (maxInvoice == null)
{
maxedInvoicedTransaction.Invoice_No = 1;
}
else
{
maxedInvoicedTransaction.Invoice_No = maxInvoice + 1;
}
maxedInvoicedTransaction.Payment_Date = DateTime.Today;
maxedInvoicedTransaction.Payment_Method = "Online";
maxedInvoicedTransaction.Payment_Status = "Paid";
maxedInvoicedTransaction.Paypal_PayerId = payerId;
maxedInvoicedTransaction.PlanID = rate_card.Plan_Id;
maxedInvoicedTransaction.Rate_ID = rate_card.Rate_Id;
//DateTime? endDate = maxedInvoicedTransaction.End_Date;
//string strEndDate = string.Empty;
//if (endDate != null)
// strEndDate = endDate.ToString();
maxedInvoicedTransaction.Start_Date = DateTime.Today;
maxedInvoicedTransaction.Status = "Active";
maxedInvoicedTransaction.Transaction_Status = "approved";
maxedInvoicedTransaction.Transection_ID = Transection_ID;
maxedInvoicedTransaction.User_ID = userId;
ctx.Entry(maxedInvoicedTransaction).State = EntityState.Modified;
ctx.SaveChanges();
recordId = maxedInvoicedTransaction.Id;
rd.Status = "Success";
rd.Message = "Transaction Saved";
rd.Requestkey = "PostTransactions";
//return rd;
}
PaypalResponse paypalResponse = new PaypalResponse
{
user_id = userId,
Paypal_ReferenceId = paymentId,
intent = "sale",
payer = "Android",
payee = string.Empty,
note_to_payer = "From Android",
update_time = Convert.ToString(DateTime.Today),
create_time = Convert.ToString(DateTime.Today),
response_state = "approved",
failure_reason = string.Empty
};
ctx.PaypalResponses.Add(paypalResponse);
ctx.SaveChanges();
MailLog user = ctx.MailLogs.FirstOrDefault(x => x.UserID == userId);
if (user != null)
{
user.LastReminderStatus = "Deactive";
ctx.SaveChanges();
}
transaction.Commit();
}
Thread thread = new Thread(() => SendInvoice(recordId, userId));
thread.Start();
User_Profile userMail = ctx.User_Profile.Where(p => p.ID == userId).FirstOrDefault();
Thread thread2 = new Thread(() => SendMail(userMail.FirstName, userMail.LastName, userMail.EmailAddress, "",
"Lexnarro - Subscription Successful", "~/EmailTemplate/SubscriptionMail.html"));
thread2.Start();
return(rd);
}
}
//catch (DbEntityValidationException e)
//{
// string errorMessage = string.Empty;
// foreach (DbEntityValidationResult eve in e.EntityValidationErrors)
// {
// Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
// eve.Entry.Entity.GetType().Name, eve.Entry.State);
// foreach (DbValidationError ve in eve.ValidationErrors)
// {
// Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
// ve.PropertyName, ve.ErrorMessage);
// errorMessage = ve.ErrorMessage;
// //TempData["message"] = ViewBag.message + ToasterMessage.Message(ToastType.error, errorMessage);
// }
// }
//}
catch (Exception r)
{
rd.Status = "Failure";
rd.Message = "Something went wrong. Please contact administrator";
rd.Requestkey = "PostTransactions";
return(rd);
}
}
