public ActionResult Create(SubBnd subBnd) { if (Session["ID"] == null) { return(RedirectToAction("Index", "Home")); } int empid = Convert.ToInt32(Session["ID"]); if (ModelState.IsValid) { try { subBnd.id = db.SubBnds.OrderByDescending(x => x.id).FirstOrDefault().id + 1; } catch (Exception) { subBnd.id = 1; } subBnd.CreatedBy = empid; subBnd.Date = DateTime.Now.Date; subBnd.SumPrice = subBnd.PeacePrice * subBnd.Quantity; PaymentsRecord paymentsRecord = new PaymentsRecord(); try { paymentsRecord.id = db.PaymentsRecords.OrderByDescending(x => x.id).FirstOrDefault().id + 1; } catch (Exception) { paymentsRecord.id = 1; } db.SubBnds.Add(subBnd); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CenterID = new SelectList(db.Centers, "id", "Name"); ViewBag.TitleSideBar = "Study_subject"; return(View(subBnd)); }
public async Task InsertPaymentsData(PaymentsRecord paymentsRecord) { await WithConnection(async c => await c.InsertAsync(paymentsRecord)); }