public void AddSubscriptionsInvoice(SusbscriptionInvoice sbi)
{
string command = "INSERT INTO dbo.SubscriptionInvoice(SubscriptionID, Total_Amount,Paid_Amount, Due_Amount , Paid_Status , CreatedAt) VALUES(@SubscriptionID, @Total_Amount,@Paid_Amount, @Due_Amount , @Paid_Status ,CURRENT_TIMESTAMP)";
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@SubscriptionID", sbi.SubscriptionID);
param[1] = new SqlParameter("@Total_Amount", sbi.Total_Amount);
param[2] = new SqlParameter("@Paid_Amount", sbi.Paid_Amount);
param[3] = new SqlParameter("@Due_Amount", sbi.Due_Amount);
param[4] = new SqlParameter("@Paid_Status", sbi.Paid_Status);
da.Insert(param, command);
}
public ActionResult addSubscription(SusbscriptionInvoice subInv)
{
//Add Susbcription Invocie.
//Update Susbcription
if (ModelState.IsValid)
{
decimal Last_Paid_Amount = subInv.Total_Amount - subInv.LeftSubscriptionCost;
decimal Paid_Amount = subInv.Paid_Amount + Last_Paid_Amount;
decimal Due_Amount = subInv.Due_Amount;
subs.updateSubscription(subInv.SubscriptionID, Paid_Amount, Due_Amount, subInv.Paid_Status);
subs.AddSubscriptionsInvoice(subInv);
}
return(RedirectToAction("Subscriptions", "Membership"));
}
public ActionResult addSubscriptions1(Subscriptions sbs)
{
SusbscriptionInvoice si = new SusbscriptionInvoice();
if (ModelState.IsValid)
{
sbs.Status = "";
si.Paid_Amount = sbs.Paid_Amount;
si.Due_Amount = sbs.Due_Amount;
si.Paid_Status = sbs.Paid_Status;
si.Total_Amount = sbs.Total_Amount;
subs.AddSubscriptions(sbs);
si.SubscriptionID = subs.getLastSubscriptionID(sbs.MembershipID, sbs.MemberID);
subs.AddSubscriptionsInvoice(si);
}
return(RedirectToAction("Subscriptions"));
}
