public ActionResult SaveOrder(int mr, int cons, TBL_MPROC_DETAIL[] order) { string result = "Error! Order Is Not Complete!"; if (mr != 0 && cons != 0) { //int cutomerId = Guid.NewGuid(); TBL_MASTER_PROCEDURE model = new TBL_MASTER_PROCEDURE(); model.MR = mr; model.MP_CONS = cons; model.MP_USER_ID = Convert.ToInt32(Session["user_id"]); model.MP_USER_ORG = Convert.ToInt32(Session["user_org"]); model.MP_USER_dATE = DateTime.Now; db.TBL_MASTER_PROCEDURE.Add(model); db.SaveChanges(); int last_insert_id = model.MP_CODE; foreach (var item in order) { //var orderId = Guid.NewGuid(); TBL_MPROC_DETAIL tmd = new TBL_MPROC_DETAIL(); //O.OrderId = orderId; tmd.MP_CODE = last_insert_id; tmd.pro_id = item.pro_id; tmd.PRICE = item.PRICE; db.TBL_MPROC_DETAIL.Add(tmd); } db.SaveChanges(); } result = "Success! Order Is Complete!"; return(Json(result, JsonRequestBehavior.AllowGet)); //return RedirectToAction("reporting"); }
public JsonResult InsertCustomers(List <TBL_MPROC_DETAIL> customers) { using (Pathology_dbEntities1 db = new Pathology_dbEntities1()) { TBL_MASTER_PROCEDURE mp = new TBL_MASTER_PROCEDURE(); //Truncate Table to delete all old records. db.Database.ExecuteSqlCommand("TRUNCATE TABLE [TBL_MPROC_DETAIL]"); //Check for NULL. if (customers == null) { customers = new List <TBL_MPROC_DETAIL>(); } //Loop and insert records. foreach (TBL_MPROC_DETAIL customer in customers) { db.TBL_MPROC_DETAIL.Add(customer); } int insertedRecords = db.SaveChanges(); return(Json(insertedRecords)); } }
public ActionResult Add_Departments(TBL_R_DEPT objdept) { db.TBL_R_DEPT.Add(objdept); db.SaveChanges(); return(RedirectToAction("Departments")); }