public JsonResult SaveDyeingProcessInfo(DyeingProcess dyeingProcess)
{
var user = (User)Session["CurrentUser"];
if (dyeingProcess != null)
{
dyeingProcess.UserName = user.USERNAME;
}
var res = _dyeingUtilityRepo.SaveDyeingProcessInfo(dyeingProcess);
return(Json(res, JsonRequestBehavior.AllowGet));
}
//Insert Data
public DyeingProcess SaveDyeingProcessInfo(DyeingProcess dyeingProcess)
{
var res = new DyeingProcess();
var dt = new DataTable();
try
{
dt = InserOrUpdateDyeingProcessInfo("SP_INSERT_DYEING_UTILITY_INFO", "SAVE_DYEING_PROCESS_INFO", dyeingProcess);
res.SaveStatus = Operation.Success.ToString();
res.ID = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public DataTable InserOrUpdateDyeingProcessInfo(string procedure, string callname, DyeingProcess dyeingProcess)
{
dbConn = new SqlConnection(connectionString);
dbConn.Open();
cmd = new SqlCommand(procedure, dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@call_name", callname));
cmd.Parameters.Add(new SqlParameter("@p_ID", dyeingProcess.ID));
cmd.Parameters.Add(new SqlParameter("@p_DyeingID", dyeingProcess.DyeingID));
cmd.Parameters.Add(new SqlParameter("@p_DyeDate", dyeingProcess.DyeDate));
cmd.Parameters.Add(new SqlParameter("@p_SetNo", dyeingProcess.SetNo));
cmd.Parameters.Add(new SqlParameter("@p_LengthMtr", dyeingProcess.LengthMtr));
cmd.Parameters.Add(new SqlParameter("@p_LengthKg", dyeingProcess.LengthKg));
cmd.Parameters.Add(new SqlParameter("@p_SortNo", dyeingProcess.SortNo));
cmd.Parameters.Add(new SqlParameter("@p_Colour", dyeingProcess.Colour));
cmd.Parameters.Add(new SqlParameter("@p_DyeColour", dyeingProcess.DyeColour));
cmd.Parameters.Add(new SqlParameter("@p_YarnCode", dyeingProcess.YarnCode));
cmd.Parameters.Add(new SqlParameter("@p_WarpRatio", dyeingProcess.WarpRatio));
cmd.Parameters.Add(new SqlParameter("@p_EndsPerBeam", dyeingProcess.EndsPerBeam));
cmd.Parameters.Add(new SqlParameter("@p_NoOfBeam", dyeingProcess.NoOfBeam));
cmd.Parameters.Add(new SqlParameter("@p_NoOfCreel", dyeingProcess.NoOfCreel));
cmd.Parameters.Add(new SqlParameter("@p_TotalEnd", dyeingProcess.TotalEnd));
cmd.Parameters.Add(new SqlParameter("@p_MCSpeed", dyeingProcess.MCSpeed));
cmd.Parameters.Add(new SqlParameter("@p_DyeMCSpeed", dyeingProcess.DyeMCSpeed));
cmd.Parameters.Add(new SqlParameter("@p_ProYarnLot", dyeingProcess.ProYarnLot));
cmd.Parameters.Add(new SqlParameter("@p_ProYarnSupplier", dyeingProcess.ProYarnSupplier));
cmd.Parameters.Add(new SqlParameter("@p_AvgCount", dyeingProcess.AvgCount));
cmd.Parameters.Add(new SqlParameter("@p_MCStartTime", dyeingProcess.MCStartTime));
cmd.Parameters.Add(new SqlParameter("@p_MCStopTime", dyeingProcess.MCStopTime));
cmd.Parameters.Add(new SqlParameter("@p_MCRunTimeHour", dyeingProcess.MCRunTimeHour));
cmd.Parameters.Add(new SqlParameter("@p_MCRunTimeMinute", dyeingProcess.MCRunTimeMinute));
cmd.Parameters.Add(new SqlParameter("@p_ShadeIndigoPercent", dyeingProcess.ShadeIndigoPercent));
cmd.Parameters.Add(new SqlParameter("@p_ShadeBlackPercent", dyeingProcess.ShadeBlackPercent));
cmd.Parameters.Add(new SqlParameter("@p_ShadeMatchWith", dyeingProcess.ShadeMatchWith));
cmd.Parameters.Add(new SqlParameter("@p_Bath", dyeingProcess.Bath));
cmd.Parameters.Add(new SqlParameter("@p_Feeding", dyeingProcess.Feeding));
cmd.Parameters.Add(new SqlParameter("@p_Refraction", dyeingProcess.Refraction));
cmd.Parameters.Add(new SqlParameter("@p_Viscosity", dyeingProcess.Viscosity));
cmd.Parameters.Add(new SqlParameter("@p_Buyer", dyeingProcess.Buyer));
cmd.Parameters.Add(new SqlParameter("@p_StyleNo", dyeingProcess.StyleNo));
cmd.Parameters.Add(new SqlParameter("@p_StyleCode", dyeingProcess.StyleCode));
cmd.Parameters.Add(new SqlParameter("@p_GreyConstruction", dyeingProcess.GreyConstruction));
cmd.Parameters.Add(new SqlParameter("@p_FabricConstruction", dyeingProcess.FabricConstruction));
cmd.Parameters.Add(new SqlParameter("@p_Weight", dyeingProcess.Weight));
cmd.Parameters.Add(new SqlParameter("@p_Weave", dyeingProcess.Weave));
cmd.Parameters.Add(new SqlParameter("@p_Width", dyeingProcess.Width));
cmd.Parameters.Add(new SqlParameter("@p_AfterLengthMeter", dyeingProcess.AfterLengthMeter));
cmd.Parameters.Add(new SqlParameter("@p_AfterLengthKg", dyeingProcess.AfterLengthKg));
cmd.Parameters.Add(new SqlParameter("@p_ColorRequired", dyeingProcess.ColorRequired));
cmd.Parameters.Add(new SqlParameter("@p_PH", dyeingProcess.PH));
cmd.Parameters.Add(new SqlParameter("@p_Redox", dyeingProcess.Redox));
cmd.Parameters.Add(new SqlParameter("@p_ColorCode", dyeingProcess.ColorCode));
cmd.Parameters.Add(new SqlParameter("@p_IndigoRedox", dyeingProcess.IndigoRedox));
cmd.Parameters.Add(new SqlParameter("@p_IndigoPH", dyeingProcess.IndigoPH));
cmd.Parameters.Add(new SqlParameter("@p_IndigoDosing", dyeingProcess.IndigoDosing));
cmd.Parameters.Add(new SqlParameter("@p_SulpherRedox", dyeingProcess.SulpherRedox));
cmd.Parameters.Add(new SqlParameter("@p_SulpherPH", dyeingProcess.SulpherPH));
cmd.Parameters.Add(new SqlParameter("@p_SulpherDosing", dyeingProcess.SulpherDosing));
cmd.Parameters.Add(new SqlParameter("@p_SulpherTemperature", dyeingProcess.SulpherTemperature));
cmd.Parameters.Add(new SqlParameter("@p_HydroDosing", dyeingProcess.HydroDosing));
cmd.Parameters.Add(new SqlParameter("@p_CusticDosing", dyeingProcess.CusticDosing));
cmd.Parameters.Add(new SqlParameter("@p_CusticConcentration", dyeingProcess.CusticConcentration));
cmd.Parameters.Add(new SqlParameter("@p_UserName", dyeingProcess.UserName));
cmd.Parameters.Add(new SqlParameter("@p_EntryDate", DateTime.Now));
cmd.Parameters.Add(new SqlParameter("@p_Remark", dyeingProcess.Remark));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public DyeingProcess SaveDyeingProcessInfo(DyeingProcess dyeingProcess)
{
return(dataService.SaveDyeingProcessInfo(dyeingProcess));
}
