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"));
}
