protected void btnXoa_Click(object sender, EventArgs e) { try { if (txtMaVanChuyen.Text.Length > 0) { tbl_Payment tsp = db.tbl_Payment.Find(int.Parse(txtMaVanChuyen.Text)); db.tbl_Payment.Remove(tsp); db.SaveChanges(); load(); lbThongBao.Text = "Xóa thành công"; lbThongBao.ForeColor = System.Drawing.Color.Green; } else { lbThongBao.Text = "Chưa Chọn dữ liệu"; lbThongBao.ForeColor = System.Drawing.Color.Red; } } catch (Exception ex) { lbThongBao.Text = "Đã có lỗi xảy ra. Vui lòng thử lại sau."; lbThongBao.ForeColor = System.Drawing.Color.Red; } }
public IHttpActionResult Puttbl_Payment(int id, tbl_Payment tbl_Payment) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_Payment.Id) { return(BadRequest()); } db.Entry(tbl_Payment).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_PaymentExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
protected void btnSua_Click(object sender, EventArgs e) { try { if (txtTenVanChuyen.Text.Length > 0 && txtMaVanChuyen.Text.Length > 0) { tbl_Payment tsp = db.tbl_Payment.Find(int.Parse(txtMaVanChuyen.Text)); tsp.Pay_Name = txtTenVanChuyen.Text; tsp.PhiTT = double.Parse(txtCK.Text); db.SaveChanges(); load(); lbThongBao.Text = "sửa thành công"; lbThongBao.ForeColor = System.Drawing.Color.Green; } else { lbThongBao.Text = "Chưa nhập dữ liệu"; lbThongBao.ForeColor = System.Drawing.Color.Red; } } catch (Exception ex) { lbThongBao.Text = "Đã có lỗi xảy ra. Vui lòng thử lại sau."; lbThongBao.ForeColor = System.Drawing.Color.Red; } }
public ActionResult DeleteConfirmed(short id) { tbl_Payment tbl_Payment = db.tbl_Payment.Find(id); db.tbl_Payment.Remove(tbl_Payment); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <ActionResult> DeleteConfirmed(string id) { tbl_Payment tbl_Payment = await db.tbl_Payment.FindAsync(id); db.tbl_Payment.Remove(tbl_Payment); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public IHttpActionResult Posttbl_Payment(tbl_Payment tbl_Payment) { List <string> successDetails = new List <string>(); string[] success = new string[6]; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } tbl_Payment.Payment_Date = DateTime.Now; tbl_Payment.Payment_Status = "Done"; db.tbl_Payment.Add(tbl_Payment); db.SaveChanges(); //int? vehicleid = db.tbl_Policy.ToList().Find(m => m.Id == tbl_Policy.Id).Veh_Id; //tbl_VehicleInfo tbl_VehicleInfo = db.tbl_VehicleInfo.Where(m => m.Id == vehicleid).First(); //int? customerId = db.tbl_VehicleInfo.ToList().Find(m => m.Id == vehicleid).Cust_Id; int?policyid = db.tbl_Payment.ToList().Find(m => m.Id == tbl_Payment.Id).Pol_Id; tbl_Policies tbl_Policiesss = db.tbl_Policies.Find(policyid); if (tbl_Policiesss == null) { return(NotFound()); } tbl_Policies tbl_Policy = db.tbl_Policies.Where(m => m.Id == policyid).First(); int? vehicleId = db.tbl_Policies.ToList().Find(m => m.Id == policyid).Veh_Id; tbl_VehicleInfo tbl_VehicleInfo2 = db.tbl_VehicleInfo.Where(m => m.Id == vehicleId).First(); int? customerId = db.tbl_VehicleInfo.ToList().Find(m => m.Id == vehicleId).Cust_Id; tbl_User tbl_User = db.tbl_User.Where(m => m.Id == customerId).First(); string carModel = tbl_VehicleInfo2.Veh_Model; string carManufacturer = tbl_VehicleInfo2.Manufacturer; string registerationNumber = tbl_VehicleInfo2.Registration_Number; string userName = tbl_User.Firstname; success[0] = carModel; success[1] = carManufacturer; success[2] = registerationNumber; success[3] = userName; success[4] = tbl_Payment.Pol_Id.Value.ToString(); success[5] = tbl_Payment.Id.ToString(); //db.sp_paymentStatuses(tbl_Payment.Pol_Id); db.sp_PaymentStatuss(tbl_Payment.Pol_Id); // db.sp_paymentStatusesforRenew(tbl_Payment.Pol_Id); return(CreatedAtRoute("DefaultApi", new { id = tbl_Payment.Id }, success)); }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { Label lblMa = (Label)GridView1.Rows[e.NewEditIndex].FindControl("lbMa"); tbl_Payment p = db.tbl_Payments.SingleOrDefault(c => c.Pay_ID == int.Parse(lblMa.Text)); txtMa.Text = p.Pay_ID.ToString(); txtTenTT.Text = p.Pay_Name.ToString(); GridView1.EditIndex = e.NewEditIndex; load(); }
public ActionResult Edit([Bind(Include = "id,customerName,phone,serviceUnitName,doctor,totalFee,paidFee,debtFee,billId,payTime,status,paymentType,createdTime,updatedTime,createdBy,updatedBy")] tbl_Payment tbl_Payment) { if (ModelState.IsValid) { db.Entry(tbl_Payment).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.billId = new SelectList(db.tbl_MedicalBill, "id", "billCode", tbl_Payment.billId); return(View(tbl_Payment)); }
protected void btnXoa_Click(object sender, EventArgs e) { tbl_Payment t = db.tbl_Payments.SingleOrDefault(c => c.Pay_ID == int.Parse(txtMa.Text)); db.tbl_Payments.DeleteOnSubmit(t); db.SubmitChanges(); load(); Label3.Text = "Xoá thành công."; rong(); txtTenTT.Focus(); }
public IHttpActionResult Gettbl_Payment(int id) { tbl_Payment tbl_Payment = db.tbl_Payment.Find(id); if (tbl_Payment == null) { return(NotFound()); } return(Ok(tbl_Payment)); }
protected void btnNhap_Click(object sender, EventArgs e) { tbl_Payment t = new tbl_Payment(); t.Pay_Name = txtTenTT.Text; db.tbl_Payments.InsertOnSubmit(t); db.SubmitChanges(); load(); Label3.Text = "Thêm thành công"; rong(); txtTenTT.Focus(); }
public async Task <ActionResult> Edit([Bind(Include = "AutoID,ID,PaymentDate,PartyName,Amount,PaymentMode,Remark,CreatedDatetime")] tbl_Payment tbl_Payment) { if (ModelState.IsValid) { db.Entry(tbl_Payment).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.PartyName = new SelectList(db.tbl_vendor, "ID", "Name", tbl_Payment.PartyName); return(View(tbl_Payment)); }
// GET: tbl_Payment/Details/5 public ActionResult Details(short?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Payment tbl_Payment = db.tbl_Payment.Find(id); if (tbl_Payment == null) { return(HttpNotFound()); } return(View(tbl_Payment)); }
public IHttpActionResult Deletetbl_Payment(int id) { tbl_Payment tbl_Payment = db.tbl_Payment.Find(id); if (tbl_Payment == null) { return(NotFound()); } db.tbl_Payment.Remove(tbl_Payment); db.SaveChanges(); return(Ok(tbl_Payment)); }
// GET: Payment/Details/5 public async Task <ActionResult> Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Payment tbl_Payment = await db.tbl_Payment.FindAsync(id); if (tbl_Payment == null) { return(HttpNotFound()); } return(View(tbl_Payment)); }
// GET: tbl_Debt/Edit/5 public ActionResult Edit(short?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Payment tbl_Payment = db.tbl_Payment.Find(id); if (tbl_Payment == null) { return(HttpNotFound()); } ViewBag.billId = new SelectList(db.tbl_MedicalBill, "id", "billCode", tbl_Payment.billId); return(View(tbl_Payment)); }
// GET: Payment/Edit/5 public async Task <ActionResult> Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Payment tbl_Payment = await db.tbl_Payment.FindAsync(id); if (tbl_Payment == null) { return(HttpNotFound()); } ViewBag.PartyName = new SelectList(db.tbl_vendor, "ID", "Name", tbl_Payment.PartyName); return(View(tbl_Payment)); }
private void action() { pay = new tbl_Payment { id_booking = int.Parse(tbIdBooking.Text), total_payment = int.Parse(tbTotalPayment.Text), paid = int.Parse(tbPaid.Text) }; var f = from b in db.tbl_BookingMasters where b.id_booking == int.Parse(tbIdBooking.Text) select b; foreach (var w in f) { w.status = "PAID"; } }
public void AddPayments(PaymentViewModel entity) { var data = new tbl_Payment { PaymentId = entity.paymentId, ActualAmount = entity.actualAmount, BatchNo = entity.batchNo, PaymentModeId = entity.paymentModeId, PaymentDate = DateTime.Now, RecievedAmount = entity.recievedAmount, SalesTypeId = entity.salesTypeId, TransactionStatusId = entity.transactionStatusId, CreatedOn = DateTime.Now, CreatedBy = "admin", ModifiedOn = DateTime.Now, ModifiedBy = "admin" }; context.tbl_Payment.Add(data); }
public static string Pay(tbl_Payment payment, tbl_Sites site) { string formName = "rbkmoneyform"; var dataManager = new DataManager(); var user = dataManager.User.SelectById(site.MainUserID.Value); var sb = new StringBuilder(); sb.Append(string.Format("<form name='{0}' method='post' action='https://rbkmoney.ru/acceptpurchase.aspx'>", formName)); sb.Append(string.Format("<input type='hidden' name='eshopId' value='{0}' />", EshopId)); sb.Append(string.Format("<input type='hidden' name='user_email' value='{0}' />", user.Login)); sb.Append(string.Format("<input type='hidden' name='orderId' value='{0}' />", payment.ID)); sb.Append(string.Format("<input type='hidden' name='serviceName' value='{0}' />", payment.Assignment)); sb.Append(string.Format("<input type='hidden' name='recipientAmount' value='{0}' />", payment.Total)); sb.Append("<input type='hidden' name='recipientCurrency' value='RUR' />"); sb.Append("</form>"); var result = string.Format("$('body').append(\"{0}\");document.{1}.submit();", sb.ToString(), formName); return(result); }
public ActionResult Payment(tbl_Payment GetPayment) { return(View()); }
protected void BtnUpdate_Click(object sender, EventArgs e) { if (DataManager.PaymentStatus.SelectById(CurrentUser.Instance.SiteID, ucPaymentStatus.PaymentStatusId).IsLast) { double?total = 0.0; bool isValid = true; if (ucPaymentPass.PaymentPasses != null && ucPaymentPass.PaymentPasses.Count > 0) { foreach (var paymentPass in ucPaymentPass.PaymentPasses) { if (paymentPass.IncomeCFOID == null || paymentPass.IncomePaymentArticleID == null || paymentPass.OutgoCFOID == null || paymentPass.OutgoPaymentArticleID == null) { isValid = false; cvGroupUpdate.ErrorMessage = "Не указан ЦФО или статья"; break; } total += paymentPass.Amount; } if (total != rntxtTotal.Value) { isValid = false; cvGroupUpdate.ErrorMessage = "Сумма проводок не равна сумме оплаты"; } } else { isValid = false; cvGroupUpdate.ErrorMessage = "Не указаны проводки"; } cvGroupUpdate.IsValid = isValid; } if (cvGroupUpdate.IsValid) { paymentData = DataManager.Payment.SelectById(SiteId, _paymentID); var isUpdate = paymentData != null; paymentData = DataManager.Payment.Save( SiteId, paymentData == null ? Guid.Empty : paymentData.ID, txtAssignment.Text, rdpDatePlan.SelectedDate ?? DateTime.Now, rdpDateFact.SelectedDate, int.Parse(ddlPaymentType.SelectedValue), ucPaymentStatus.PaymentStatusId, dcbPayer.SelectedIdNullable, dcbPayerLegalAccount.SelectedIdNullable, dcbRecipient.SelectedIdNullable, dcbRecipientLegalAccount.SelectedIdNullable, dcbCurrency.SelectedId, rntxtCourse.Value ?? 1, rntxtAmount.Value.HasValue ? decimal.Parse(rntxtAmount.Value.ToString()) : 0, rntxtTotal.Value.HasValue ? decimal.Parse(rntxtTotal.Value.ToString()) : 0, dcbOrder.SelectedIdNullable, dcbInvoice.SelectedIdNullable ); var oldPaymentPasses = DataManager.PaymentPass.SelectAll(CurrentUser.Instance.SiteID, paymentData.ID); List <tbl_PaymentPass> ids = new List <tbl_PaymentPass>(); foreach (var old in oldPaymentPasses) { if (ucPaymentPass.PaymentPasses.Where(a => a.ID == old.ID).Select(a => a.ID).SingleOrDefault() == Guid.Empty) { ids.Add(old); } } foreach (var tblPaymentPass in ids) { if (tblPaymentPass.ProcessedByCron) { tblPaymentPass.ProcessedByCron = false; tblPaymentPass.ToDelete = true; DataManager.PaymentPass.Update(tblPaymentPass); //tblPaymentPass.OldCreatedAt = tblPaymentPass.CreatedAt; //tblPaymentPass.OldAmount = tblPaymentPass.Amount; //tblPaymentPass.OldOutgoCFOID = tblPaymentPass.OldOutgoCFOID; //tblPaymentPass.OldOutgoPaymentArticleID = tblPaymentPass.OutgoPaymentArticleID; } else { DataManager.PaymentPass.Delete(tblPaymentPass); } } foreach (var paymentPass in ucPaymentPass.PaymentPasses) { var oldPaymentPass = DataManager.PaymentPass.SelectById(paymentData.ID, paymentPass.ID); if (oldPaymentPass != null) { oldPaymentPass.SiteID = CurrentUser.Instance.SiteID; oldPaymentPass.PaymentID = paymentData.ID; oldPaymentPass.IncomePaymentPassCategoryID = paymentPass.IncomePaymentPassCategoryID; oldPaymentPass.IncomeCFOID = paymentPass.IncomeCFOID; oldPaymentPass.IncomePaymentArticleID = paymentPass.IncomePaymentArticleID; oldPaymentPass.OutgoPaymentPassCategoryID = paymentPass.OutgoPaymentPassCategoryID; if (oldPaymentPass.OutgoCFOID != paymentPass.OutgoCFOID) { oldPaymentPass.OldOutgoCFOID = oldPaymentPass.OutgoCFOID; oldPaymentPass.ProcessedByCron = false; } if (oldPaymentPass.OutgoPaymentArticleID != paymentPass.OutgoPaymentArticleID) { oldPaymentPass.OldOutgoPaymentArticleID = oldPaymentPass.OldOutgoPaymentArticleID; oldPaymentPass.ProcessedByCron = false; } if (rdpDateFact.SelectedDate != null && oldPaymentPass.CreatedAt != rdpDateFact.SelectedDate || rdpDateFact.SelectedDate == null && rdpDatePlan.SelectedDate != null && oldPaymentPass.CreatedAt != rdpDatePlan.SelectedDate) { oldPaymentPass.OldCreatedAt = oldPaymentPass.CreatedAt; oldPaymentPass.ProcessedByCron = false; } if (oldPaymentPass.Amount != paymentPass.Amount) { oldPaymentPass.Amount = oldPaymentPass.Amount; oldPaymentPass.ProcessedByCron = false; } oldPaymentPass.CreatedAt = rdpDateFact.SelectedDate ?? rdpDatePlan.SelectedDate; oldPaymentPass.OutgoCFOID = paymentPass.OutgoCFOID; oldPaymentPass.OutgoPaymentArticleID = paymentPass.OutgoPaymentArticleID; oldPaymentPass.FormulaID = paymentPass.FormulaID; oldPaymentPass.Value = paymentPass.Value; oldPaymentPass.Amount = paymentPass.Amount; if (DataManager.PaymentStatus.SelectById(CurrentUser.Instance.SiteID, ucPaymentStatus.PaymentStatusId).IsLast) { oldPaymentPass.IsFact = true; } DataManager.PaymentPass.Update(oldPaymentPass); } else { DataManager.PaymentPass.Add(new tbl_PaymentPass() { SiteID = CurrentUser.Instance.SiteID, PaymentID = paymentData.ID, CreatedAt = rdpDateFact.SelectedDate ?? rdpDatePlan.SelectedDate, IncomePaymentPassCategoryID = paymentPass.IncomePaymentPassCategoryID, IncomeCFOID = paymentPass.IncomeCFOID, IncomePaymentArticleID = paymentPass.IncomePaymentArticleID, OutgoPaymentPassCategoryID = paymentPass.OutgoPaymentPassCategoryID, OutgoCFOID = paymentPass.OutgoCFOID, OutgoPaymentArticleID = paymentPass.OutgoPaymentArticleID, FormulaID = paymentPass.FormulaID, Value = paymentPass.Value, Amount = paymentPass.Amount }); } } if (!isUpdate) { Response.Redirect(UrlsData.AP_PaymentsEdit(paymentData.ID)); } } }
/// <summary> /// Binds the data. /// </summary> private void BindData() { BindPaymentType(); paymentData = DataManager.Payment.SelectById(SiteId, _paymentID); dcbOrder.SiteID = dcbInvoice.SiteID = dcbPayer.SiteID = dcbRecipient.SiteID = dcbPayerLegalAccount.SiteID = dcbRecipientLegalAccount.SiteID = SiteId; var filter = new DictionaryOnDemandComboBox.DictionaryFilterColumn() { Name = "IsActive", DbType = DbType.Boolean, Value = "TRUE" }; dcbPayerLegalAccount.Filters.Add(filter); dcbRecipientLegalAccount.Filters.Add(filter); dcbPayer.BindData(); dcbRecipient.BindData(); dcbPayerLegalAccount.BindData(); dcbRecipientLegalAccount.BindData(); BindPaymentPassRule(0, null, null, null, null); BindSelectPaymentPassRule(0); if (paymentData != null) { txtAssignment.Text = paymentData.Assignment; rdpDatePlan.SelectedDate = paymentData.DatePlan; rdpDateFact.SelectedDate = paymentData.DateFact; if (paymentData.PaymentTypeID.HasValue) { ddlPaymentType.SelectedIndex = ddlPaymentType.FindItemIndexByValue(((int)paymentData.PaymentTypeID).ToString()); } ucPaymentStatus.PaymentStatusId = paymentData.StatusID ?? Guid.Empty; if (paymentData.PayerID.HasValue) { dcbPayer.SelectedId = (Guid)paymentData.PayerID; dcbPayer.SelectedText = DataManager.Company.SelectById(SiteId, (Guid)paymentData.PayerID).Name; dcbPayerLegalAccount.Filters.Add(new DictionaryOnDemandComboBox.DictionaryFilterColumn() { Name = "CompanyID", DbType = DbType.Guid, Value = paymentData.PayerID.ToString() }); } if (paymentData.RecipientID.HasValue) { dcbRecipient.SelectedId = (Guid)paymentData.RecipientID; dcbRecipient.SelectedText = DataManager.Company.SelectById(SiteId, (Guid)paymentData.RecipientID).Name; dcbRecipientLegalAccount.Filters.Add(new DictionaryOnDemandComboBox.DictionaryFilterColumn() { Name = "CompanyID", DbType = DbType.Guid, Value = paymentData.RecipientID.ToString() }); } if (paymentData.PayerLegalAccountID.HasValue) { dcbPayerLegalAccount.SelectedId = (Guid)paymentData.PayerLegalAccountID; dcbPayerLegalAccount.SelectedText = DataManager.CompanyLegalAccount.SelectById((Guid)paymentData.PayerLegalAccountID).Title; } if (paymentData.RecipientLegalAccountID.HasValue) { dcbRecipientLegalAccount.SelectedId = (Guid)paymentData.RecipientLegalAccountID; dcbRecipientLegalAccount.SelectedText = DataManager.CompanyLegalAccount.SelectById((Guid)paymentData.RecipientLegalAccountID).Title; } if (paymentData.OrderID.HasValue) { dcbOrder.SelectedId = (Guid)paymentData.OrderID; dcbOrder.SelectedText = DataManager.Order.SelectById(SiteId, (Guid)paymentData.OrderID).Number; } if (paymentData.InvoiceID.HasValue) { dcbInvoice.SelectedId = (Guid)paymentData.InvoiceID; dcbInvoice.SelectedText = DataManager.Invoice.SelectById(SiteId, (Guid)paymentData.InvoiceID).Number; } if (paymentData.PaymentTypeID.HasValue) { switch (paymentData.PaymentTypeID) { case (int)PaymentType.Income: dcbRecipient.Filters.Add(new DictionaryOnDemandComboBox.DictionaryFilterColumn() { Name = "CompanyTypeID", DbType = DbType.Guid, Value = DataManager.CompanyType.SelectOurCompanyTypeID(SiteId).ToString() }); break; case (int)PaymentType.Outgo: dcbPayer.Filters.Add(new DictionaryOnDemandComboBox.DictionaryFilterColumn() { Name = "CompanyTypeID", DbType = DbType.Guid, Value = DataManager.CompanyType.SelectOurCompanyTypeID(SiteId).ToString() }); break; case (int)PaymentType.Transfer: dcbRecipient.Filters.Add(new DictionaryOnDemandComboBox.DictionaryFilterColumn() { Name = "CompanyTypeID", DbType = DbType.Guid, Value = DataManager.CompanyType.SelectOurCompanyTypeID(SiteId).ToString() }); dcbPayer.Filters.Add(new DictionaryOnDemandComboBox.DictionaryFilterColumn() { Name = "CompanyTypeID", DbType = DbType.Guid, Value = DataManager.CompanyType.SelectOurCompanyTypeID(SiteId).ToString() }); break; } BindSelectPaymentPassRule((int)paymentData.PaymentTypeID); } if (paymentData.PaymentPassRuleID.HasValue) { rcbPaymentPassRule.SelectedIndex = rcbPaymentPassRule.FindItemIndexByValue(paymentData.PaymentPassRuleID.ToString()); } dcbCurrency.SelectedId = paymentData.CurrencyID; rntxtCourse.Value = paymentData.Course; rntxtAmount.Value = (double)paymentData.Amount; rntxtTotal.Value = (double)paymentData.Total; BindPaymentPassRule((int)paymentData.PaymentTypeID, paymentData.PayerID, paymentData.PayerLegalAccountID, paymentData.RecipientID, paymentData.RecipientLegalAccountID); if (paymentData.tbl_PaymentPass != null) { ucPaymentPass.PaymentPasses = paymentData.tbl_PaymentPass.Select(op => new PaymentPass.PaymentPassMap() { ID = op.ID, OutgoPaymentPassCategoryID = op.OutgoPaymentPassCategoryID, OutgoPaymentPassCategory = op.tbl_PaymentPassCategory != null ? op.tbl_PaymentPassCategory.Title :"", OutgoCFOID = op.OutgoCFOID, OutgoCFO = op.tbl_PaymentCFO != null ? op.tbl_PaymentCFO.Title:"", OutgoPaymentArticleID = op.OutgoPaymentArticleID, OutgoPaymentArticle = op.tbl_PaymentArticle != null ? op.tbl_PaymentArticle.Title:"", IncomePaymentPassCategoryID = op.IncomePaymentPassCategoryID, IncomePaymentPassCategory = op.tbl_PaymentPassCategory1 != null ? op.tbl_PaymentPassCategory1.Title:"", IncomeCFOID = op.IncomeCFOID, IncomeCFO = op.tbl_PaymentCFO1 != null ? op.tbl_PaymentCFO1.Title:"", IncomePaymentArticleID = op.IncomePaymentArticleID, IncomePaymentArticle = op.tbl_PaymentArticle1 != null ? op.tbl_PaymentArticle1.Title:"", FormulaID = op.FormulaID, Amount = op.Amount, Value = op.Value }).ToList(); } ucPaymentPass.Total = double.Parse(paymentData.Amount.ToString()); } else { ucPaymentPass.PaymentPasses = new List <PaymentPass.PaymentPassMap>(); ucPaymentPass.Total = 0; } }
public ActionResult AddPurchase(string request) { using (var transaction = db.Database.BeginTransaction()) // new System.Transactions.TransactionScope()) { tbl_Purchase tbl_Purchase = JsonConvert.DeserializeObject <tbl_Purchase>(request); if (PurchaseItemStock.Count > 0) { var t = JsonConvert.SerializeObject(tbl_Purchase); db.tbl_Purchase.Add(tbl_Purchase); PurchaseItemStock.ForEach(q => q.tbl_Items = null); db.tbl_ItemStock.AddRange(PurchaseItemStock); tbl_Sequence NewSequenceValue = Helper.GenericHelper.GetNextUpdatedData(SequenceTable.tbl_Purchase.ToString()); db.Entry(NewSequenceValue).State = EntityState.Modified; tbl_Sequence NewSequenceValueItemStock = Helper.GenericHelper.GetNextUpdatedData(SequenceTable.tbl_ItemStock.ToString()); db.Entry(NewSequenceValueItemStock).State = EntityState.Modified; //db.SaveChanges(); // 1 hold -- only save purchase & Item with status hold // 2 CREDIT PURCHASE -- one transaction entry with credit (out) with unpaid status // 3 CASH PAY -- one transaction entry with credit (out)/ Paid // one payment Entry with full amount // one transaction entry with Debit (in) with payment ID // 4 MULTI MODE PAY -- one transaction entry with credit (out) // one payment Entry // one transaction entry with Debit (in) if (tbl_Purchase.PaymentMode.Value != PaymentMode.HOLD) // not hold { decimal amount = tbl_Purchase.Amount; string creditTID = Helper.GenericHelper.GetMaxValue(SequenceTable.tbl_TransactionCredit.ToString()); tbl_Transaction tbl_Transactioncredit = new tbl_Transaction() { ID = creditTID, CreatedDatetime = tbl_Purchase.CreatedDatetime, EntryDate = tbl_Purchase.PurchaseDate.ToString(), EntryType = TransactionEntryType.Purchase.ToString(), //"Purchase", // Purchase/Sales/Recipt/Payment Status = TransactionStatus.Unpaid, ///Paid/Unpaid/Pending/Paid Against entries : // Recive Against entries TransactionType = TransactionType.Credit.ToString(), ///Debit/ credit -- For Real: Debit what comes in, credit what goes out. //TransactionRef = null, EntryID = tbl_Purchase.ID, PurchaseID = tbl_Purchase.ID, //SalesID = null, Amount = tbl_Purchase.GrandTotal, VendorID = tbl_Purchase.PartyName }; db.tbl_Transaction.Add(tbl_Transactioncredit); //db.SaveChanges(); tbl_Sequence NewSequenceValuetbl_Transaction = Helper.GenericHelper.GetNextUpdatedData("tbl_TransactionCredit"); db.Entry(NewSequenceValuetbl_Transaction).State = EntityState.Modified; //db.SaveChanges(); if (tbl_Purchase.PaymentMode == 2) //CREDIT PURCHASE { } else if (tbl_Purchase.PaymentMode == 3) //CASH PAY { string tbl_PaymentID = Helper.GenericHelper.GetMaxValue("tbl_Payment"); tbl_Payment tbl_Payment = new tbl_Payment() { ID = tbl_PaymentID, Amount = tbl_Purchase.GrandTotal, CreatedDatetime = tbl_Purchase.CreatedDatetime, PartyName = tbl_Purchase.PartyName, PaymentDate = tbl_Purchase.PurchaseDate.ToString(), PaymentMode = "CASH", //Remark = "", //TransactionID = creditTID, }; db.tbl_Payment.Add(tbl_Payment); tbl_Sequence NewSequenceValuetbl_Payment = Helper.GenericHelper.GetNextUpdatedData("tbl_Payment"); db.Entry(NewSequenceValuetbl_Payment).State = EntityState.Modified; //db.SaveChanges(); tbl_Transaction tbl_TransactionDebit = new tbl_Transaction() { ID = Helper.GenericHelper.GetMaxValue("tbl_TransactionDebit"), CreatedDatetime = tbl_Purchase.CreatedDatetime, EntryDate = tbl_Purchase.PurchaseDate.ToString(), EntryType = TransactionEntryType.Purchase.ToString(), // "Purchase", // Purchase/Sales/Recipt/Payment Status = TransactionStatus.PaidAgainstEntries + tbl_Purchase.ID, ///Paid/Unpaid/Pending/Paid Against entries : // Recive Against entries TransactionType = TransactionType.Debit.ToString(), ///Debit/ credit -- For Real: Debit what comes in, credit what goes out. TransactionRef = tbl_Purchase.ID, EntryID = tbl_PaymentID, //PurchaseID = null, //SalesID = null, PaymentID = tbl_PaymentID, Amount = tbl_Purchase.GrandTotal, VendorID = tbl_Purchase.PartyName }; db.tbl_Transaction.Add(tbl_TransactionDebit); tbl_Sequence NewSequenceValuetbl_Transaction2 = Helper.GenericHelper.GetNextUpdatedData("tbl_TransactionDebit"); db.Entry(NewSequenceValuetbl_Transaction2).State = EntityState.Modified; //db.SaveChanges(); //var tbl_Transactionresult = db.tbl_Transaction.Where(q => q.ID == creditTID).FirstOrDefault(); tbl_Transactioncredit.Status = TransactionStatus.Paid; //db.Entry(tbl_Transactionresult).State = EntityState.Modified; //db.SaveChanges(); } else if (tbl_Purchase.PaymentMode == 4) //MULTI MODE PAY { string tbl_PaymentID = Helper.GenericHelper.GetMaxValue("tbl_Payment"); tbl_Payment tbl_Payment = new tbl_Payment() { ID = tbl_PaymentID, Amount = amount, CreatedDatetime = tbl_Purchase.CreatedDatetime, PartyName = tbl_Purchase.PartyName, PaymentDate = tbl_Purchase.PurchaseDate.ToString(), PaymentMode = "CASH", //Remark = "", //TransactionID = creditTID, }; db.tbl_Payment.Add(tbl_Payment); tbl_Sequence NewSequenceValuetbl_Payment = Helper.GenericHelper.GetNextUpdatedData("tbl_Payment"); db.Entry(NewSequenceValuetbl_Payment).State = EntityState.Modified; //db.SaveChanges(); tbl_Transaction tbl_TransactionDebit = new tbl_Transaction() { ID = Helper.GenericHelper.GetMaxValue("tbl_TransactionDebit"), CreatedDatetime = tbl_Purchase.CreatedDatetime, EntryDate = tbl_Purchase.PurchaseDate.ToString(), EntryType = TransactionEntryType.Purchase.ToString(), // "Purchase", // Purchase/Sales/Recipt/Payment Status = TransactionStatus.PaidAgainstEntries + tbl_Purchase.ID, ///Paid/Unpaid/Pending/Paid Against entries : // Recive Against entries TransactionType = TransactionType.Debit.ToString(), ///Debit/ credit -- For Real: Debit what comes in, credit what goes out. TransactionRef = tbl_Purchase.ID, EntryID = tbl_PaymentID, //PurchaseID = null, //SalesID = null, PaymentID = tbl_PaymentID, Amount = amount, VendorID = tbl_Purchase.PartyName }; db.tbl_Transaction.Add(tbl_TransactionDebit); tbl_Sequence NewSequenceValuetbl_Transaction2 = Helper.GenericHelper.GetNextUpdatedData("tbl_TransactionDebit"); db.Entry(NewSequenceValuetbl_Transaction2).State = EntityState.Modified; } } bool saved = false; try { db.SaveChanges(); saved = true; } catch (Exception e) { throw new InvalidOperationException(e.Message); } finally { if (saved) { transaction.Commit(); } } //if (tbl_Purchase.PaymentMode == 4) //MULTI MODE PAY // return JavaScript("window.location = '/purchase/index'"); //else return(JavaScript("window.location = '/purchase/index'")); } else { ViewBag.PaymentMode = new SelectList(db.tbl_PaymentMode, "ID", "Mode", tbl_Purchase.PaymentMode); ViewBag.PartyName = new SelectList(db.tbl_vendor, "ID", "Name", tbl_Purchase.PartyName); throw new InvalidOperationException("Please add item to continue!!"); } } //return RedirectToAction("Index"); }