public DyeingYarn SaveYarnDyeingInfo(DyeingYarn dyeingYarn, DataSet dyeingYarnDetail)
{
var res = new DyeingYarn();
var dt = new DataTable();
try
{
dt = InsertOrUpdateYarnDyeingInfo("SP_INSERT_DYEING_YARN_INFO", "SAVE_DYEING_YARN_INFO", dyeingYarn, dyeingYarnDetail);
res.SaveStatus = Operation.Success.ToString();
res.DID = Convert.ToInt32(dt.Rows[0]["DID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public JsonResult SaveYarnDyeingInfo(DyeingYarn dyeingYarn, List <DyeingYarnDetail> dyeingYarnDetail)
{
var res = new DyeingYarn();
var user = (User)Session["CurrentUser"];
if (dyeingYarn != null && dyeingYarnDetail != null)
{
dyeingYarn.UCode = 2;
dyeingYarn.UName = "Rope";
dyeingYarn.EDate = DateTime.Now;
dyeingYarn.TracDate = DateTime.Now;
dyeingYarn.UserName = user.USERNAME;
res = yarnDyeingRepository.SaveYarnDyeingInfo(dyeingYarn, dyeingYarnDetail);
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public DyeingYarn SaveYarnDyeingInfo(DyeingYarn dyeingYarn, List <DyeingYarnDetail> dyeingYarnDetail)
{
DataSet dsYarnDye = new DataSet("dsYarnDye");
if (dyeingYarn != null)
{
var yarnDyeDetail = new DataTable("tblYarnDyeDetail");
yarnDyeDetail.Columns.Add("DIID");
yarnDyeDetail.Columns.Add("DID");
yarnDyeDetail.Columns.Add("SetNo");
yarnDyeDetail.Columns.Add("PDate");
yarnDyeDetail.Columns.Add("BeamNo");
yarnDyeDetail.Columns.Add("YName");
yarnDyeDetail.Columns.Add("YCode");
yarnDyeDetail.Columns.Add("YCount");
yarnDyeDetail.Columns.Add("BeamLength");
yarnDyeDetail.Columns.Add("BeamWeight");
yarnDyeDetail.Columns.Add("EndsBeam");
yarnDyeDetail.Columns.Add("ProdCone");
yarnDyeDetail.Columns.Add("ShiftName");
yarnDyeDetail.Columns.Add("ShiftCode");
yarnDyeDetail.Columns.Add("MPM");
yarnDyeDetail.Columns.Add("Tension");
yarnDyeDetail.Columns.Add("OPName");
yarnDyeDetail.Columns.Add("OPCode");
yarnDyeDetail.Columns.Add("PackingManName");
yarnDyeDetail.Columns.Add("PackingManCode");
yarnDyeDetail.Columns.Add("STime");
yarnDyeDetail.Columns.Add("FTime");
yarnDyeDetail.Columns.Add("TTime");
yarnDyeDetail.Columns.Add("Breakge");
yarnDyeDetail.Columns.Add("BreakgePoint");
yarnDyeDetail.Columns.Add("LooseEnds");
yarnDyeDetail.Columns.Add("Crossing");
yarnDyeDetail.Columns.Add("Lapper");
yarnDyeDetail.Columns.Add("Knotting");
yarnDyeDetail.Columns.Add("Remarks");
yarnDyeDetail.Columns.Add("EDate");
yarnDyeDetail.Columns.Add("UserName");
if (dyeingYarnDetail != null && dyeingYarnDetail.Count > 0)
{
foreach (var dyeYarnDetail in dyeingYarnDetail)
{
DataRow row;
row = yarnDyeDetail.NewRow();
row["DID"] = dyeYarnDetail.DID;
row["SetNo"] = dyeYarnDetail.SetNo;
row["PDate"] = DateTime.Now.ToString("dd-MM-yyyy");
row["BeamNo"] = dyeYarnDetail.BeamNo;
row["YName"] = dyeYarnDetail.YName;
row["YCode"] = dyeYarnDetail.YCode;
row["YCount"] = dyeYarnDetail.YCount;
row["BeamLength"] = dyeYarnDetail.BeamLength;
row["BeamWeight"] = dyeYarnDetail.BeamWeight;
row["EndsBeam"] = dyeYarnDetail.EndsBeam;
row["ProdCone"] = dyeYarnDetail.ProdCone;
row["ShiftName"] = dyeYarnDetail.ShiftName;
row["ShiftCode"] = dyeYarnDetail.ShiftCode;
row["MPM"] = dyeYarnDetail.MPM;
row["Tension"] = dyeYarnDetail.Tension;
row["OPName"] = dyeYarnDetail.OPName;
row["OPCode"] = dyeYarnDetail.OPCode;
row["PackingManName"] = dyeYarnDetail.PackingManName;
row["PackingManCode"] = dyeYarnDetail.PackingManCode;
row["STime"] = dyeYarnDetail.STime;
row["FTime"] = dyeYarnDetail.FTime;
row["TTime"] = dyeYarnDetail.TTime;
row["Breakge"] = dyeYarnDetail.Breakge;
row["BreakgePoint"] = dyeYarnDetail.BreakgePoint;
row["LooseEnds"] = dyeYarnDetail.LooseEnds;
row["Crossing"] = dyeYarnDetail.Crossing;
row["Lapper"] = dyeYarnDetail.Lapper;
row["Knotting"] = dyeYarnDetail.Knotting;
row["Remarks"] = dyeYarnDetail.Remarks;
row["EDate"] = DateTime.Now.ToString("dd-MM-yyyy");
row["UserName"] = dyeYarnDetail.UserName;
yarnDyeDetail.Rows.Add(row);
}
}
dsYarnDye.Tables.Add(yarnDyeDetail);
}
return(yarnDyeingDataService.SaveYarnDyeingInfo(dyeingYarn, dsYarnDye));
}
public DataTable InsertOrUpdateYarnDyeingInfo(string procedure, string callname, DyeingYarn dyeingYarn, DataSet dyeingYarnDetail = 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("@DetailXml", SqlDbType.Xml).Value = dyeingYarnDetail == null ? null : dyeingYarnDetail.GetXml();
cmd.Parameters.Add(new SqlParameter("@DID", dyeingYarn.DID));
cmd.Parameters.Add(new SqlParameter("@DyeDate", dyeingYarn.DyeDate));
cmd.Parameters.Add(new SqlParameter("@EDate", dyeingYarn.EDate));
cmd.Parameters.Add(new SqlParameter("@MCCode", dyeingYarn.MCCode));
cmd.Parameters.Add(new SqlParameter("@MCNo", dyeingYarn.MCNo));
cmd.Parameters.Add(new SqlParameter("@PTCode", dyeingYarn.PTCode));
cmd.Parameters.Add(new SqlParameter("@PType", dyeingYarn.PType));
cmd.Parameters.Add(new SqlParameter("@Remarks", dyeingYarn.Remarks));
cmd.Parameters.Add(new SqlParameter("@TracDate", dyeingYarn.TracDate));
cmd.Parameters.Add(new SqlParameter("@UCode", dyeingYarn.UCode));
cmd.Parameters.Add(new SqlParameter("@UName", dyeingYarn.UName));
cmd.Parameters.Add(new SqlParameter("@UserName", dyeingYarn.UserName));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
