public ActionResult SaveWarpingProdInfo(WarpingProdInfo objWarp, List <WarpingProdDetails> objWarpDetails)
{
var user = (User)Session["CurrentUser"];
objWarp.UserId = user.EMPID;
objWarp.TermId = user.TermID;
objWarp.EDate = DateTime.Now;
var res = _warpingProductionRepo.SaveWarpingProdInfo(objWarp, objWarpDetails);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public WarpingProdInfo SaveWarpingProdInfo(WarpingProdInfo objWarp, DataSet dsWarpDetails)
{
var res = new WarpingProdInfo();
var dt = new DataTable();
try
{
dt = Insert_Update_WarpingProductionInfo("sp_insert_warping_production_info", "save_warping_production_info", objWarp, dsWarpDetails);
res.SaveStatus = Operation.Success.ToString();
res.IdNo = Convert.ToInt32(dt.Rows[0]["IdNo"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public DataTable Insert_Update_WarpingProductionInfo(string procedure, string callname, WarpingProdInfo objWarp, DataSet rqdXmlv1 = null)
{
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("@dsxmlu1", SqlDbType.Xml).Value = (rqdXmlv1 == null ? null : rqdXmlv1.GetXml());
cmd.Parameters.Add(new SqlParameter("@p_IdNo", objWarp.IdNo));
cmd.Parameters.Add(new SqlParameter("@p_PWarpDate", objWarp.PWarpDate.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_WarpLength", objWarp.WarpLength));
cmd.Parameters.Add(new SqlParameter("@p_Remarks", objWarp.Remarks));
cmd.Parameters.Add(new SqlParameter("@p_SetNo", objWarp.SetNo));
cmd.Parameters.Add(new SqlParameter("@p_EndsPerBeam", objWarp.EndsPerBeam));
cmd.Parameters.Add(new SqlParameter("@p_TotalBeam", objWarp.TotalBeam));
cmd.Parameters.Add(new SqlParameter("@p_NoOfBeam", objWarp.NoOfBeam));
cmd.Parameters.Add(new SqlParameter("@p_TotalCreal", objWarp.TotalCreal));
cmd.Parameters.Add(new SqlParameter("@p_NoOfCreal", objWarp.NoOfCreal));
cmd.Parameters.Add(new SqlParameter("@p_TotalEnds", objWarp.TotalEnds));
cmd.Parameters.Add(new SqlParameter("@p_MSpeed", objWarp.MSpeed));
cmd.Parameters.Add(new SqlParameter("@p_YarnTension", objWarp.YarnTension));
cmd.Parameters.Add(new SqlParameter("@p_ProcessingForce", objWarp.ProcessingForce));
cmd.Parameters.Add(new SqlParameter("@p_Code", objWarp.Code));
cmd.Parameters.Add(new SqlParameter("@p_LengthMtr", objWarp.LengthMtr));
cmd.Parameters.Add(new SqlParameter("@p_DeptCode", objWarp.DeptCode));
cmd.Parameters.Add(new SqlParameter("@p_WarpRatio", objWarp.WarpRatio));
cmd.Parameters.Add(new SqlParameter("@p_ProYarnLot", objWarp.ProYarnLot));
cmd.Parameters.Add(new SqlParameter("@p_ProYarnSupp", objWarp.ProYarnSupp));
cmd.Parameters.Add(new SqlParameter("@p_StyleNo", objWarp.StyleNo));
cmd.Parameters.Add(new SqlParameter("@p_StyleCode", objWarp.StyleCode));
cmd.Parameters.Add(new SqlParameter("@p_Construction", objWarp.Construction));
cmd.Parameters.Add(new SqlParameter("@p_Width", objWarp.Width));
cmd.Parameters.Add(new SqlParameter("@p_PTCode", objWarp.PTCode));
cmd.Parameters.Add(new SqlParameter("@p_CustCode", objWarp.CustCode));
cmd.Parameters.Add(new SqlParameter("@p_MCNo", objWarp.MCNo));
cmd.Parameters.Add(new SqlParameter("@p_MCCode", objWarp.MCCode));
cmd.Parameters.Add(new SqlParameter("@p_UCode", objWarp.UCode));
cmd.Parameters.Add(new SqlParameter("@p_YarnCounts", objWarp.YarnCounts));
cmd.Parameters.Add(new SqlParameter("@p_UserId", objWarp.UserId));
cmd.Parameters.Add(new SqlParameter("@p_TermId", objWarp.TermId));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public WarpingProdInfo SaveWarpingProdInfo(WarpingProdInfo objWarp, List <WarpingProdDetails> objWarpDetails)
{
//-------------------Warping Production Details information------------------------------------------
var rv = new WarpingProdInfo();
var res = CheckIsExistSetNo(objWarp.IdNo, objWarp.SetNo);
if (!res)
{
var wpDetailsDt = new DataTable();
wpDetailsDt.Columns.Add("WARPDATE");
wpDetailsDt.Columns.Add("FLANGENO");
wpDetailsDt.Columns.Add("FLANGELENGTH");
wpDetailsDt.Columns.Add("WEAKPOINT");
wpDetailsDt.Columns.Add("SPILER");
wpDetailsDt.Columns.Add("SNARL");
wpDetailsDt.Columns.Add("DOUBLEYARN");
wpDetailsDt.Columns.Add("DUETOMACHINE");
wpDetailsDt.Columns.Add("DUETOCONE");
wpDetailsDt.Columns.Add("BADWDG");
wpDetailsDt.Columns.Add("TOTALYARNBKG");
wpDetailsDt.Columns.Add("TERMINATION");
wpDetailsDt.Columns.Add("TOTAL");
wpDetailsDt.Columns.Add("REMNANTPERCREEL");
wpDetailsDt.Columns.Add("WASTAGEPCREEL");
wpDetailsDt.Columns.Add("OPERATORCARDNO");
wpDetailsDt.Columns.Add("SHIFTCODE");
wpDetailsDt.Columns.Add("SHIFTTIME");
wpDetailsDt.Columns.Add("DESIGNATION");
wpDetailsDt.Columns.Add("ICODE");
wpDetailsDt.Columns.Add("UNIT");
wpDetailsDt.Columns.Add("ICOUNT");
wpDetailsDt.Columns.Add("ENDSBEAM");
wpDetailsDt.Columns.Add("BEAMKG");
wpDetailsDt.Columns.Add("SCODE");
wpDetailsDt.Columns.Add("YARNCODE");
wpDetailsDt.Columns.Add("YARNLOT");
wpDetailsDt.Columns.Add("BREAKAGEPOINT");
wpDetailsDt.Columns.Add("MSPEED");
wpDetailsDt.Columns.Add("MEFFI");
wpDetailsDt.Columns.Add("INTAKE");
wpDetailsDt.Columns.Add("REMINENT");
wpDetailsDt.Columns.Add("RECONE");
wpDetailsDt.Columns.Add("WEASTAGE");
wpDetailsDt.Columns.Add("IQNTY");
wpDetailsDt.Columns.Add("RATE");
wpDetailsDt.Columns.Add("BEAMVALUE");
wpDetailsDt.Columns.Add("WASTAGEVALUE");
wpDetailsDt.Columns.Add("STDBRKG");
wpDetailsDt.Columns.Add("BRUNTIME");
wpDetailsDt.Columns.Add("CAPCODE");
wpDetailsDt.Columns.Add("LAPPER");
if (objWarpDetails != null && objWarpDetails.Count > 0)
{
foreach (var warp in objWarpDetails)
{
DataRow row1;
row1 = wpDetailsDt.NewRow();
row1["WARPDATE"] = warp.WarpDate;
row1["FLANGENO"] = warp.FlangeNo;
row1["FLANGELENGTH"] = warp.FlangeLength;
row1["WEAKPOINT"] = warp.WeakPoint;
row1["SPILER"] = warp.Spiler;
row1["SNARL"] = warp.Snarl;
row1["DOUBLEYARN"] = warp.DoubleYarn;
row1["DUETOMACHINE"] = warp.DueToMachine;
row1["DUETOCONE"] = warp.DueToCone;
row1["BADWDG"] = warp.BadWdg;
row1["TOTALYARNBKG"] = warp.TotalYarnBkg;
row1["TERMINATION"] = warp.Termination;
row1["TOTAL"] = warp.Total;
row1["REMNANTPERCREEL"] = warp.RemnantPerCreel;
row1["WASTAGEPCREEL"] = warp.WastagePCreel;
row1["OPERATORCARDNO"] = warp.OperatorCardNo;
row1["SHIFTCODE"] = warp.ShiftCode;
row1["SHIFTTIME"] = warp.ShiftTime;
row1["DESIGNATION"] = warp.Designation;
row1["ICODE"] = warp.ICode;
row1["UNIT"] = warp.Unit;
row1["ICOUNT"] = warp.ICount;
row1["ENDSBEAM"] = warp.EndsBeam;
row1["BEAMKG"] = warp.BeamKg;
row1["SCODE"] = warp.SCode;
row1["YARNCODE"] = warp.YarnCode;
row1["YARNLOT"] = warp.YarnLot;
row1["BREAKAGEPOINT"] = warp.BreakagePoint;
row1["MSPEED"] = warp.MSpeed;
row1["MEFFI"] = warp.MEffi;
row1["INTAKE"] = warp.Intake;
row1["REMINENT"] = warp.Reminent;
row1["RECONE"] = warp.Recone;
row1["WEASTAGE"] = warp.Weastage;
row1["IQNTY"] = warp.IQnty;
row1["RATE"] = warp.Rate;
row1["BEAMVALUE"] = warp.BeamValue;
row1["WASTAGEVALUE"] = warp.WastageValue;
row1["STDBRKG"] = warp.StdBrkg;
row1["BRUNTIME"] = warp.BRunTime;
row1["CAPCODE"] = warp.CapCode;
row1["LAPPER"] = warp.Lapper;
wpDetailsDt.Rows.Add(row1);
}
}
wpDetailsDt.TableName = "tblwpDetails";
DataSet dsWarpDetails = new DataSet("dsLcDetails");
dsWarpDetails.Tables.Add(wpDetailsDt);
return(_WarpingProductionDataService.SaveWarpingProdInfo(objWarp, dsWarpDetails));
}
else
{
rv.SaveStatus = Operation.Exists.ToString();
return(rv);
}
}
