public WeavingMaster SaveProductionData(WeavingMaster master, Entities.HDL.WeavingProduction detail)
{
var weavingMaster = _service.SaveWeavingMaster(master);
detail.WID = weavingMaster.WID;
_service.SaveWeavingProduction(detail);
return(weavingMaster);
}
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 WeavingMaster SaveWeavingMaster(WeavingMaster master)
{
var res = new WeavingMaster();
var dt = new DataTable();
try
{
dt = Insert_Update_WeavingMaster("sp_insert_weaving_master_info", "save_weaving_master", master);
res.SaveStatus = Operation.Success.ToString();
res.WID = Convert.ToInt32(dt.Rows[0]["WID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public DataTable Insert_Update_WeavingMaster(string procedure, string callname, WeavingMaster master)
{
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("@WID", master.WID));
cmd.Parameters.Add(new SqlParameter("@WeaveDate", master.WeaveDate.ToString("yyyy-MM-dd")));
cmd.Parameters.Add(new SqlParameter("@TrackDate", master.TrackDate.Value.ToString("yyyy-MM-dd")));
cmd.Parameters.Add(new SqlParameter("@DeptNo", master.DeptNo));
cmd.Parameters.Add(new SqlParameter("@DeptName", master.DeptName));
cmd.Parameters.Add(new SqlParameter("@ShiftCode", master.ShiftCode));
cmd.Parameters.Add(new SqlParameter("@ShiftName", master.ShiftName));
cmd.Parameters.Add(new SqlParameter("@WorkerShift", master.WorkerShift));
cmd.Parameters.Add(new SqlParameter("@UserName", master.UserName));
cmd.Parameters.Add(new SqlParameter("@EntryDate", master.EntryDate.Value.ToString("yyyy-MM-dd")));
cmd.Parameters.Add(new SqlParameter("@UnitNo", master.UnitNo));
cmd.Parameters.Add(new SqlParameter("@UnitCode", master.UnitCode));
cmd.Parameters.Add(new SqlParameter("@NoOfMC", master.NoOfMC));
cmd.Parameters.Add(new SqlParameter("@POName", master.POName));
cmd.Parameters.Add(new SqlParameter("@POCode", master.POCode));
cmd.Parameters.Add(new SqlParameter("@CaptainName", master.CaptainName));
cmd.Parameters.Add(new SqlParameter("@CaptainCode", master.CaptainCode));
cmd.Parameters.Add(new SqlParameter("@AstSuperName", master.AstSuperName));
cmd.Parameters.Add(new SqlParameter("@AstSuperCode", master.AstSuperCode));
cmd.Parameters.Add(new SqlParameter("@LineManName", master.LineManName));
cmd.Parameters.Add(new SqlParameter("@LineManCode", master.LineManCode));
cmd.Parameters.Add(new SqlParameter("@MC", master.MC));
cmd.Parameters.Add(new SqlParameter("@LineManName2", master.LineManName2));
cmd.Parameters.Add(new SqlParameter("@MC2", master.MC2));
cmd.Parameters.Add(new SqlParameter("@BeamFitterName", master.BeamFitterName));
cmd.Parameters.Add(new SqlParameter("@BeamFitterCode", master.BeamFitterCode));
cmd.Parameters.Add(new SqlParameter("@FitterName", master.FitterName));
cmd.Parameters.Add(new SqlParameter("@FitterCode", master.FitterCode));
cmd.Parameters.Add(new SqlParameter("@UCode", master.UCode));
cmd.Parameters.Add(new SqlParameter("@UName", master.UName));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
