public ActionResult RejectionReasonList()
{
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <RejectionReasonMaster> result = _db.RejectionReasonMasters.SqlQuery(@"exec uspGetRejectionReasonList").ToList <RejectionReasonMaster>();
return(View("RejectionReasonList", result));
}
public ActionResult ExportImportTypeList()
{
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <ExcelImportTypeMaster> result = _db.ExcelImportTypeMasters.SqlQuery(@"exec uspGetExportImportTypeList").ToList <ExcelImportTypeMaster>();
return(View("ExportImportTypeList", result));
}
public JsonResult GetRejecteionReason()
{
ReydeldbContext _db = new ReydeldbContext();
var lstItem = binddropdown("City", 0).Select(i => new { i.Value, i.Text }).ToList();
return(Json(lstItem, JsonRequestBehavior.AllowGet));
}
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 SupportFunctionMasterList()
{
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <SupportFunctionMaster> result = _db.SupportFunctionMasters.SqlQuery(@"exec USPGetSupportFunctionMaster").ToList <SupportFunctionMaster>();
return(View("SupportFunctionMasterList", result));
}
public ActionResult ChangeTypeConfigurationList()
{
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <ChangeTypeConfiguration> result = _db.ChangeTypeConfigurations.SqlQuery(@"exec USPGetChangeTypeConfiguration").ToList <ChangeTypeConfiguration>();
return(View("ChangeTypeConfigurationList", result));
}
public ActionResult ChangeTypeMasterList()
{
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <ChangeTypeMaster> result = _db.ChangeTypeMasters.SqlQuery(@"exec USPGetChangeTypeMaster").ToList <ChangeTypeMaster>();
return(View("ChangeTypeMasterList", result));
}
public ActionResult AddColourMaster(String ColourName)
{
ReydeldbContext dbc = new ReydeldbContext();
var res = dbc.Database.ExecuteSqlCommand(@"exec USPInsertColourMaster @ColourName",
new SqlParameter("@ColourName", ColourName));
return(Json("data inserted"));
}
public ActionResult AddRejectionReasonMaster(string RejectionReasonName)
{
ReydeldbContext dbc = new ReydeldbContext();
var res = dbc.Database.ExecuteSqlCommand(@"exec USPInsertRejectionReasonMaster @RejectionReasonName",
new SqlParameter("@RejectionReasonName", RejectionReasonName));
return(Json("data inserted"));
}
public ActionResult REIMasterList()
{
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <REIMaster> result = _db.REIMasters.SqlQuery(@"exec USPGetREIMaster").ToList <REIMaster>();
return(View("REIMasterList", result));
}
public ActionResult MaterialGradeList()
{
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <MaterialGradeMaster> result = _db.MaterialGradeMasters.SqlQuery(@"exec USPGetMaterialGrade").ToList <MaterialGradeMaster>();
return(View("MaterialGradeList", result));
}
public ActionResult RejectionTypeList()
{
ViewData["RejectionReason"] = binddropdown("RejectionReason", 0);
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <RejectionReasonTypeMaster> result = _db.RejectionReasonTypeMasters.SqlQuery(@"exec uspGetRejectionTypeList").ToList <RejectionReasonTypeMaster>();
return(View("RejectionTypeList", result));
}
public ActionResult AddSupportFunctionMaster(String SupportFunctionName, string SupportFunctionCode)
{
ReydeldbContext dbc = new ReydeldbContext();
var res = dbc.Database.ExecuteSqlCommand(@"exec USPInsertSupportFunctionMaster @SupportFunctionName,@SupportFunctionCode",
new SqlParameter("@SupportFunctionName", SupportFunctionName),
new SqlParameter("@SupportFunctionCode", SupportFunctionCode));
return(Json("data inserted"));
}
public ActionResult UpdateColourMaster(int Colour_Id, string Colour_Name)
{
ReydeldbContext _db = new ReydeldbContext();
var res = _db.Database.ExecuteSqlCommand(@"exec USPUpdateColourMaster @Colour_Id,@Colour_Name",
new SqlParameter("@Colour_Id", Colour_Id),
new SqlParameter("@Colour_Name", Colour_Name));
return(Json("data Updated"));
}
public ActionResult AddChangeTypeMaster(String ChangeTypeName, string ChangeTypeCode)
{
ReydeldbContext dbc = new ReydeldbContext();
var res = dbc.Database.ExecuteSqlCommand(@"exec USPInsertChangeTypeMaster @ChangeTypeName,@ChangeTypeCode",
new SqlParameter("@ChangeTypeName", ChangeTypeName),
new SqlParameter("@ChangeTypeCode", ChangeTypeCode));
return(Json("data inserted"));
}
public ActionResult AddMaterialGrade(String GradeName, String GradeRate)
{
ReydeldbContext dbc = new ReydeldbContext();
var res = dbc.Database.ExecuteSqlCommand(@"exec USPInsertMaterialGrade @GradeName,@GradeRate",
new SqlParameter("@GradeName", GradeName),
new SqlParameter("@GradeRate", GradeRate));
return(Json("data inserted"));
}
public ActionResult UpdateRejectionReasonMaster(int Rejection_Reason_Id, string Rejection_Reason_Name)
{
ReydeldbContext _db = new ReydeldbContext();
var res = _db.Database.ExecuteSqlCommand(@"exec USPUpdateRejectionReasonMaster @Rejection_Reason_Id,@Rejection_Reason_Name",
new SqlParameter("@Rejection_Reason_Id", Rejection_Reason_Id),
new SqlParameter("@Rejection_Reason_Name", Rejection_Reason_Name));
return(Json("data Updated"));
}
public ActionResult DownTimeEntryList()
{
ViewData["Employee"] = binddropdown("Employee", 0);
ViewData["SupportFunction"] = binddropdown("SupportFunction", 0);
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <DownTimeEntryList> result = _db.DownTimeEntryList.SqlQuery(@"exec USPGetDownTimeEntry").ToList <DownTimeEntryList>();
return(View("DownTimeEntryList", result));
}
public ActionResult UpdateExcelImportsTypes(int M_Import_Type_ID, string M_Import_Type_Name, string M_Import_Type_Modes)
{
ReydeldbContext _db = new ReydeldbContext();
var res = _db.Database.ExecuteSqlCommand(@"exec USPUpdateExcelImportsTypes @Change_Type_Id, @M_Import_Type_Name, @M_Import_Type_Modes",
new SqlParameter("@Change_Type_Id", M_Import_Type_ID),
new SqlParameter("@M_Import_Type_Name", M_Import_Type_Name),
new SqlParameter("@M_Import_Type_Modes", M_Import_Type_Modes));
return(Json("data Updated"));
}
public ActionResult UpdateSupportFunctionMaster(int SupportFunction_Id, string SupportFunction_Name, string SupportFunction_Code)
{
ReydeldbContext _db = new ReydeldbContext();
var res = _db.Database.ExecuteSqlCommand(@"exec USPUpdateSupportFunctionMaster @SupportFunction_Id,@SupportFunction_Name,@SupportFunction_Code",
new SqlParameter("@SupportFunction_Id", SupportFunction_Id),
new SqlParameter("@SupportFunction_Name", SupportFunction_Name),
new SqlParameter("@SupportFunction_Code", SupportFunction_Code));
return(Json("data Updated"));
}
public ActionResult UpdateChangeTypeMaster(int Change_Type_Id, string Change_Type_Name, string Change_Type_Code)
{
ReydeldbContext _db = new ReydeldbContext();
var res = _db.Database.ExecuteSqlCommand(@"exec USPUpdateChangeTypeMaster @Change_Type_Id, @Change_Type_Name, @Change_Type_Code",
new SqlParameter("@Change_Type_Id", Change_Type_Id),
new SqlParameter("@Change_Type_Name", Change_Type_Name),
new SqlParameter("@Change_Type_Code", Change_Type_Code));
return(Json("data Updated"));
}
public ActionResult UpdateMaterialGrade(int Material_Grade_Id, string Material_Grade_Name, float Material_Grade_Rate = 0)
{
ReydeldbContext _db = new ReydeldbContext();
var res = _db.Database.ExecuteSqlCommand(@"exec USPUpdateMaterialGrade @Material_Grade_Id,@Material_Grade_Name ,@Material_Grade_Rate",
new SqlParameter("@Material_Grade_Id", Material_Grade_Id),
new SqlParameter("@Material_Grade_Name", Material_Grade_Name),
new SqlParameter("@Material_Grade_Rate", Material_Grade_Rate));
return(Json("data Updated"));
}
public ActionResult AddExcelImportType(string ImportTypeName, string ImportTypeModes)
{
ReydeldbContext dbc = new ReydeldbContext();
var res = dbc.Database.ExecuteSqlCommand(@"exec USPInsertExcelImportsTypes @ImportTypeName,@ImportTypeModes",
new SqlParameter("@ImportTypeName", ImportTypeName),
new SqlParameter("@ImportTypeModes", ImportTypeModes));
return(Json("data inserted"));
// return View("AddExcelImportType");
}
public ActionResult RejectionEntryDetailsList()
{
ViewData["RejectionReason"] = binddropdown("RejectionReason", 0);
ViewData["RejectionType"] = binddropdown("RejectionType", 0);
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <RejectionEntryDetailsList> result = _db.RejectionEntryDetailsList.SqlQuery(@"exec USPGetRejectionEntryDetails").ToList <RejectionEntryDetailsList>();
return(View("RejectionEntryDetailsList", result));
}
public ActionResult ChangeOver_EntryList()
{
ViewData["Employee"] = binddropdown("Employee", 0);
ViewData["REI"] = binddropdown("REI", 0);
ViewData["MaterialGradeId"] = binddropdown("MaterialGradeId", 0);
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <ChangeOverEntryList> result = _db.ChangeOverEntryList.SqlQuery(@"exec USPGetChangeOver_Entry").ToList <ChangeOverEntryList>();
return(View("ChangeOver_EntryList", result));
}
public ActionResult ProductionEntryList()
{
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);
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <ProductionEntryList> result = _db.ProductionEntryList.SqlQuery(@"exec USPGetProduction_Entry").ToList <ProductionEntryList>();
return(View("ProductionEntryList", result));
}
public ActionResult MaterialGradeList()
{
ReydeldbContext _db = new ReydeldbContext();
IEnumerable <MaterialGradeMaster> result = _db.MaterialGradeMasters.SqlQuery(@"exec USPGetMaterialGrade").ToList <MaterialGradeMaster>();
//totalCount = 0;
//if (result.Count() > 0)
//{
// totalCount = Convert.ToInt32(result.FirstOrDefault().TotalRows);
//}
///var itemsAsIPagedList = new StaticPagedList<EmployeeDetails>(result, pageIndex, pageSize, totalCount);
// return itemsAsIPagedList;
return(View("MaterialGradeList", result));
}
public ActionResult UpadteRejectionEntryDetails(RejectionEntryDetails RED)
{
ReydeldbContext _db = new ReydeldbContext();
var res = _db.Database.ExecuteSqlCommand(@"exec USPUpdateUpadteRejectionEntryDetails @Rejection_Entry_Id,@Rejection_From, @Prod_Entry_Id, @Rejection_Type_Id, @Rejection_Reason_Id, @Rejection_Qty, @lumps",
new SqlParameter("@Rejection_Entry_Id", RED.Rejection_Entry_Id),
new SqlParameter("@Rejection_From", RED.Rejection_from),
new SqlParameter("@Prod_Entry_Id", RED.Prod_Entry_Id),
new SqlParameter("@Rejection_Type_Id", RED.Rejection_Type_Id),
new SqlParameter("@Rejection_Reason_Id", RED.Rejection_Reason_Id),
new SqlParameter("@Rejection_Qty", RED.Rejection_Qty),
new SqlParameter("@lumps", RED.Lumps));
return(Json("data Updated"));
}
public ActionResult AddRejectionEntryDetails(RejectionEntryDetails RED)
{
ReydeldbContext dbc = new ReydeldbContext();
var res = dbc.Database.ExecuteSqlCommand(@"exec USPInsertRejection_Entry_Details @Rejection_from,@Prod_Entry_Id,@Rejection_Type_Id,@Rejection_Reason_Id,@Rejection_Qty,@Lumps",
new SqlParameter("@Rejection_from", RED.Rejection_from),
new SqlParameter("@Prod_Entry_Id", RED.Prod_Entry_Id),
new SqlParameter("@Rejection_Type_Id", RED.Rejection_Type_Id),
new SqlParameter("@Rejection_Reason_Id", RED.Rejection_Reason_Id),
new SqlParameter("@Rejection_Qty", RED.Rejection_Qty),
new SqlParameter("@Lumps", RED.Lumps));
return(Json("data inserted"));
}
public List <SelectListItem> binddropdown(string action, int val = 0)
{
ReydeldbContext _db = new ReydeldbContext();
var res = _db.Database.SqlQuery <SelectListItem>("exec USP_BindDropDown @action , @val",
new SqlParameter("@action", action),
new SqlParameter("@val", val))
.ToList()
.AsEnumerable()
.Select(r => new SelectListItem
{
Text = r.Text.ToString(),
Value = r.Value.ToString(),
Selected = r.Value.Equals(Convert.ToString(val))
}).ToList();
return(res);
}
