public JsonResult SaveProductionData(WeavingMaster master, WeavingProduction detail)
{
master.WeaveDate = DateTime.Now;
master.TrackDate = DateTime.Now;
master.EntryDate = DateTime.Now;
detail.EDate = DateTime.Now;
var res = _repository.SaveProductionData(master, detail);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public WeavingProduction SaveWeavingProduction(WeavingProduction production)
{
var res = new WeavingProduction();
var dt = new DataTable();
try
{
dt = Insert_Update_WeavingProduction("sp_insert_weaving_production_info", "save_weaving_production", production);
res.SaveStatus = Operation.Success.ToString();
res.WIID = Convert.ToInt32(dt.Rows[0]["WIID"].ToString());
//
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public DataTable Insert_Update_WeavingProduction(string procedure, string callname, WeavingProduction production)
{
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("@WIID", production.WIID));
cmd.Parameters.Add(new SqlParameter("@WID", production.WID));
cmd.Parameters.Add(new SqlParameter("@Shift", production.Shift));
cmd.Parameters.Add(new SqlParameter("@WorkerShift", production.WorkerShift));
cmd.Parameters.Add(new SqlParameter("@Loom", production.Loom));
cmd.Parameters.Add(new SqlParameter("@RPM", production.RPM));
cmd.Parameters.Add(new SqlParameter("@StyleCode", production.StyleCode));
cmd.Parameters.Add(new SqlParameter("@StyleNo", production.StyleNo));
cmd.Parameters.Add(new SqlParameter("@Weight", production.Weight));
cmd.Parameters.Add(new SqlParameter("@PPI", production.PPI));
cmd.Parameters.Add(new SqlParameter("@TotalPicks", production.TotalPicks));
cmd.Parameters.Add(new SqlParameter("@MCEfficiency", production.MCEfficiency));
cmd.Parameters.Add(new SqlParameter("@ProdEfficiency", production.ProdEfficiency));
cmd.Parameters.Add(new SqlParameter("@TotalProd", production.TotalProd));
cmd.Parameters.Add(new SqlParameter("@WarpStop", production.WarpStop));
cmd.Parameters.Add(new SqlParameter("@WeftStop", production.WeftStop));
cmd.Parameters.Add(new SqlParameter("@Remarks", production.Remarks));
cmd.Parameters.Add(new SqlParameter("@OCode", production.OCode));
cmd.Parameters.Add(new SqlParameter("@OName", production.OName));
cmd.Parameters.Add(new SqlParameter("@LoomCode", production.LoomCode));
cmd.Parameters.Add(new SqlParameter("@SetNo", production.SetNo));
cmd.Parameters.Add(new SqlParameter("@SL", production.SL));
cmd.Parameters.Add(new SqlParameter("@Flange", production.Flange));
cmd.Parameters.Add(new SqlParameter("@Constraction", production.Constraction));
cmd.Parameters.Add(new SqlParameter("@WarpCmpx", production.WarpCmpx));
cmd.Parameters.Add(new SqlParameter("@WeftCmpx", production.WeftCmpx));
cmd.Parameters.Add(new SqlParameter("@OtherStop", production.OtherStop));
cmd.Parameters.Add(new SqlParameter("@RunTime", production.RunTime));
cmd.Parameters.Add(new SqlParameter("@ShiftCode", production.ShiftCode));
cmd.Parameters.Add(new SqlParameter("@UserName", production.UserName));
cmd.Parameters.Add(new SqlParameter("@EDate", production.EDate.Value.ToString("yyyy-MM-dd")));
cmd.Parameters.Add(new SqlParameter("@GConstraction", production.GConstraction));
cmd.Parameters.Add(new SqlParameter("@FConstraction", production.FConstraction));
cmd.Parameters.Add(new SqlParameter("@Width", production.Width));
cmd.Parameters.Add(new SqlParameter("@Weave", production.Weave));
cmd.Parameters.Add(new SqlParameter("@Colour", production.Colour));
cmd.Parameters.Add(new SqlParameter("@RunTime1", production.RunTime1));
cmd.Parameters.Add(new SqlParameter("@RunTime2", production.RunTime2));
cmd.Parameters.Add(new SqlParameter("@GaraYarn", production.GaraYarn));
cmd.Parameters.Add(new SqlParameter("@LineManName", production.LineManName));
cmd.Parameters.Add(new SqlParameter("@LineManCode", production.LineManCode));
cmd.Parameters.Add(new SqlParameter("@FitterName", production.FitterName));
cmd.Parameters.Add(new SqlParameter("@FitterCode", production.FitterCode));
cmd.Parameters.Add(new SqlParameter("@ShortLength", production.ShortLength));
cmd.Parameters.Add(new SqlParameter("@UCode", production.UCode));
cmd.Parameters.Add(new SqlParameter("@UName", production.UName));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
