public ActionResult VerifyPayment(Models.VerifyResult Vresult) { try { if (!string.IsNullOrEmpty(Request.Form["transId"])) { Payment ob = new Payment(); string result = ob.verify(Request.Form["transId"].ToString()); JsonParameters Parmeters = JsonConvert.DeserializeObject <JsonParameters>(result); string transId = Request.Form["transId"].ToString(); var thiscart = db.tbl_purchasekart.Where(a => a.transId == transId).SingleOrDefault(); if (Parmeters.status == 1) { thiscart.ispaid = true; thiscart.purchasedateend = DateTime.Now; db.SaveChanges(); Vresult.success = true; Vresult.TransActionID += Request.Form["transId"].ToString(); Vresult.Amount += Parmeters.amount.ToString(); Vresult.SuccessMessage = "پرداخت با موفقیت انجام شد."; Cls_SMS.ClsSend sms_Single = new Cls_SMS.ClsSend(); string[] ret1 = new string[2]; string smstext = $"مبلغ {Vresult.Amount} ریال به حساب شما بابت خرید اینترنتی سبد شماره {thiscart.id} توسط کاربر {thiscart.user.username} در تاریخ {shamsi.ToShamsi(DateTime.Now).ToString("yyyy/MM/dd")}به شماره سند : {Vresult.TransActionID} واریز شد."; ret1 = sms_Single.SendSMS_Single(smstext, "09177017801", "100008001", "koohi8", "87g5820", "http://193.104.22.14:2055/CPSMSService/Access", "KOOHI", false); tbl_transaction t = new tbl_transaction(); t.cartid = thiscart.id; t.amount = decimal.Parse(Vresult.Amount); t.sharh = "تسویه حساب کاربری : " + thiscart.user.username; t.transid = Vresult.TransActionID; t.user_id = thiscart.user.id; t.varizdate = DateTime.Now; db.tbl_transaction.Add(t); db.SaveChanges(); } else { Vresult.error = true; Vresult.ErrorMessage = "کدخطا : " + Parmeters.errorCode + "<br />" + "پیغام خطا : " + Parmeters.errorMessage; } } } catch (Exception) { Vresult.error = true; Vresult.ErrorMessage = "متاسفانه پرداخت ناموفق بوده است."; } return(View(Vresult)); }
public void AddTransaction(dtoTransaction t, int userId) { var transaction = new tbl_transaction { documentId = t.documentId, productId = t.productId, transactionType = t.transactionType, quantity = t.quantity, unitPrice = t.unitPrice, dateCreated = DateTime.Now, discountA = t.discountA ?? 0, discountB = t.discountB ?? 0, discountC = t.discountC ?? 0, }; var product = DBContext.tbl_product.FirstOrDefault(d => d.productId == t.productId); if (product != null) { if (t.transactionType == 1) { if (t.unitPrice > 0) { var priceHistory = new tbl_productPriceHistory() { productId = product.productId, dateCreated = DateTime.Now, createdBy = userId, price = product.unitPrice }; DBContext.tbl_productPriceHistory.Add(priceHistory); product.unitPrice = t.unitPrice; } product.incoming = product.incoming + t.quantity; product.ending = (product.beginning + product.incoming) - product.outgoing; } else if (t.transactionType == 6) { //product.unitPrice = t.unitPrice; product.outgoing = product.outgoing + t.quantity; product.ending = (product.beginning + product.incoming) - product.outgoing; } } DBContext.tbl_transaction.Add(transaction); t.transactionId = transaction.transactionId; }
public ActionResult Withdraw(TransectionVModel model) { ViewBag.PageTitle = "Payment MANAGEMENT"; Dictionary <string, string> PanelTitles = new Dictionary <string, string>(); PanelTitles["PaymentWithdraw"] = "ADD NEW Payment"; ViewBag.PanelTitles = PanelTitles; if (ModelState.IsValid) { using (var tr = db.Database.BeginTransaction()) { try { tbl_transaction transection = new tbl_transaction(); transection.CreditACcount = model.CreditACcount; transection.DebitAccount = model.DebitAccount; transection.Amount = model.Amount; transection.PostingDates = DateTime.Now; transection.Particulars = model.Particulars; transection.TFNumber = ""; db.tbl_transaction.Add(transection); db.SaveChanges(); tr.Commit(); ViewBag.SMsg = "Payment Withdraw successful."; return(View()); } catch { tr.Rollback(); ViewBag.EMsg = "Payment Withdraw failed"; return(View(model)); } } } else { return(View(model)); } }
public void AddTransaction(dtoTransaction t) { var transaction = new tbl_transaction { documentId = t.documentId, productId = t.productId, transactionType = t.transactionType, quantity = t.quantity, unitPrice = t.unitPrice, dateCreated = DateTime.Now, discountA = t.discountA ?? 0, discountB = t.discountB ?? 0, discountC = t.discountC ?? 0, }; if (t.transactionType == 1) { var product = DBContext.tbl_product.FirstOrDefault(d => d.productId == t.productId); product.unitPrice = t.unitPrice; } DBContext.tbl_transaction.Add(transaction); t.transactionId = transaction.transactionId; }