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