public JsonResult GenerateGatePass(FormCollection form) { if (ModelState.IsValid) { var js = new JavaScriptSerializer(); OrderNumber on = new OrderNumber(); try { int poPtId = JsonConvert.DeserializeObject <int>(form["poPtId"]); var gatePass = JsonConvert.DeserializeObject <GatePass>(form["GatePassObj"]); gatePass.PurchaseOrder_PtId = poPtId; gatePass.PurchaseOrder_Pt = db.PurchaseOrder_Pts.Where(p => p.POP_Id == poPtId).SingleOrDefault(); string poNumber = gatePass.PurchaseOrder_Pt.POP_PO; gatePass.Customer_Id = db.SaleOrder_Pts.Where(s => s.SOP_SO == poNumber).SingleOrDefault().CustomerId; gatePass.Customer = db.Customers.Where(s => s.Customer_Id == gatePass.Customer_Id).SingleOrDefault(); gatePass.GatePass_No = on.GenerateGatePassNumber().ToString(); gatePass.GatePass_Date = DateTime.Now; gatePass.GatePass_Status = true; db.GatePasses.Add(gatePass); db.SaveChanges(); return(Json("Save", JsonRequestBehavior.AllowGet)); } catch (Exception e) { } } return(Json("", JsonRequestBehavior.AllowGet)); }