public ActionResult AddProductionEntry() { Production_Entry data = new Production_Entry(); data.Emp_id = 2; data.REI = 2; data.Shift_superviser = 2; data.Shift = 2; data.Operator_Emp = 2; ViewData["Employee"] = binddropdown("Employee", 0); ViewData["REI"] = binddropdown("REI", 0); ViewData["ShiftSuperviser"] = binddropdown("ShiftSuperviser", 0); ViewData["Shift"] = binddropdown("Shift", 0); ViewData["OperatorEmp"] = binddropdown("OperatorEmp", 0); return(View("AddProductionEntry", data)); }
public ActionResult UpdateProductionEntry(Production_Entry PE) { ReydeldbContext _db = new ReydeldbContext(); var res = _db.Database.ExecuteSqlCommand(@"exec USPUpdateUpdateProductionEntry @Entry_Id,@Entry_Date,@Calender_Id,@Emp_Id,@Shift_Id,@Machine_Id,@REI_Id,@Part_Id,@Plan_Qty,@Cumm_Accepted_Qty,@Accepted_Qty,@Operator_Emp_Id,@Shift_superviser", new SqlParameter("@Entry_Id", PE.Entry_Id), new SqlParameter("@Entry_Date", PE.Entry_Date), new SqlParameter("@Calender_Id", PE.Calendar_id), new SqlParameter("@Emp_Id", PE.Emp_id), new SqlParameter("@Shift_Id", PE.Shift), new SqlParameter("@Machine_Id", PE.Machine), new SqlParameter("@REI_Id", PE.REI), new SqlParameter("@Part_Id", PE.Part), new SqlParameter("@Plan_Qty", PE.Plan_Qty), new SqlParameter("@Cumm_Accepted_Qty", PE.Cumm_Accepted_Qty), new SqlParameter("@Accepted_Qty", PE.Accepted_Qty), new SqlParameter("@Operator_Emp_Id", PE.Operator_Emp), new SqlParameter("@Shift_superviser", PE.Shift_superviser)); return(Json("data Updated")); }