public ActionResult UpdateChangeOver_Entry(ChangeOver_Entry COE) { ReydeldbContext dbc = new ReydeldbContext(); var res = dbc.Database.ExecuteSqlCommand(@"exec USPUpdateChangeOver_Entry @Entry_Id, @Entry_Date,@Calendar_id,@Emp_Id,@ChangeOver_Config_Type,@Change_From_REI_ID,@Change_From_Part_Id,@Change_From_Mat_Grade_Id,@Change_To_REI_ID,@Change_To_Part_Id,@Change_To_Mat_Grade_Id,@StandardRunQty,@Actual_RunQty,@Increase_in_Scrap_Percent,@Increase_in_scrap_Value,@ChangeOver_Start,@ChangeOver_End,@TotalChangeOver,@Std_ChangeOverTime,@Difference,@LossInPrecentage,@Expected_Lumps,@Actual_Lumps,@Difference_Lumps,@ScrapPercentIncrease", new SqlParameter("@Entry_Id", COE.Entry_Id), new SqlParameter("@Entry_Date", COE.Entry_Date), new SqlParameter("@Calendar_id", COE.Calendar_id), new SqlParameter("@Emp_Id", COE.Emp_Id), new SqlParameter("@ChangeOver_Config_Type", COE.ChangeOver_Config_Type), new SqlParameter("@Change_From_REI_ID", COE.Change_From_REI_ID), new SqlParameter("@Change_From_Part_Id", COE.Change_From_Part_Id), new SqlParameter("@Change_From_Mat_Grade_Id", COE.Change_From_Mat_Grade_Id), new SqlParameter("@Change_To_REI_ID", COE.Change_To_REI_ID), new SqlParameter("@Change_To_Part_Id", COE.Change_To_Part_Id), new SqlParameter("@Change_To_Mat_Grade_Id", COE.Change_To_Mat_Grade_Id), new SqlParameter("@StandardRunQty", COE.StandardRunQty), new SqlParameter("@Actual_RunQty", COE.Actual_RunQty), new SqlParameter("@Increase_in_Scrap_Percent", COE.Increase_in_Scrap_Percent), new SqlParameter("@Increase_in_scrap_Value", COE.Increase_in_scrap_Value), new SqlParameter("@ChangeOver_Start", COE.ChangeOver_Start), new SqlParameter("@ChangeOver_End", COE.ChangeOver_End), new SqlParameter("@TotalChangeOver", COE.TotalChangeOver), new SqlParameter("@Std_ChangeOverTime", COE.Std_ChangeOverTime), new SqlParameter("@Difference", COE.Difference), new SqlParameter("@LossInPrecentage", COE.LossInPrecentage), new SqlParameter("@Expected_Lumps", COE.Expected_Lumps), new SqlParameter("@Actual_Lumps", COE.Actual_Lumps), new SqlParameter("@Difference_Lumps", COE.Difference_Lumps), new SqlParameter("@ScrapPercentIncrease", COE.ScrapPercentIncrease)); return(Json("data Updated")); }
public ActionResult AddChangeOver_Entry() { ChangeOver_Entry data = new ChangeOver_Entry(); data.Emp_Id = 2; data.Change_From_REI_ID = 2; data.Change_To_REI_ID = 2; data.Change_From_Mat_Grade_Id = 2; data.Change_To_Mat_Grade_Id = 2; ViewData["Employee"] = binddropdown("Employee", 0); ViewData["REI"] = binddropdown("REI", 0); ViewData["MaterialGradeId"] = binddropdown("MaterialGradeId", 0); return(View("AddChangeOver_Entry", data)); }