public JsonResult SaveInspectionProductionDetail(TblStock21 productionDetail)
{
if (productionDetail != null)
{
var user = (User)Session["CurrentUser"];
productionDetail.UserName = user.USERNAME;
productionDetail.EDate = DateTime.Now;
}
var res = _repository.SaveInspectionProductionDetail(productionDetail);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public TblStock21 SaveInspectionProductionDetail(TblStock21 productionDetail)
{
var res = new TblStock21();
var dt = new DataTable();
try
{
dt = InsertOrUpdateInspectionProductionDetail("SP_INSERT_INSPECTION_PRODUCTION_PRODUCTION_INFO", "SAVE_INSPECTION_PRODUCTION", productionDetail);
res.SaveStatus = Operation.Success.ToString();
res.DID = Convert.ToInt32(dt.Rows[0]["DID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public TblStock21 SaveInspectionProductionDetail(TblStock21 productionDetail)
{
return(_service.SaveInspectionProductionDetail(productionDetail));
}
public DataTable InsertOrUpdateInspectionProductionDetail(string procedure, string callname, TblStock21 productionDetail)
{
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("@DID", productionDetail.DID));
cmd.Parameters.Add(new SqlParameter("@ID", productionDetail.ID));
cmd.Parameters.Add(new SqlParameter("@StyleCode", productionDetail.StyleCode));
cmd.Parameters.Add(new SqlParameter("@StyleNo", productionDetail.StyleNo));
cmd.Parameters.Add(new SqlParameter("@Weight", productionDetail.Weight));
cmd.Parameters.Add(new SqlParameter("@Constraction", productionDetail.Constraction));
cmd.Parameters.Add(new SqlParameter("@Weave", productionDetail.Weave));
cmd.Parameters.Add(new SqlParameter("@Colour", productionDetail.Colour));
cmd.Parameters.Add(new SqlParameter("@Width", productionDetail.Width));
cmd.Parameters.Add(new SqlParameter("@QCode", productionDetail.QCode));
cmd.Parameters.Add(new SqlParameter("@FabQuality", productionDetail.FabQuality));
cmd.Parameters.Add(new SqlParameter("@Prod", productionDetail.Prod));
cmd.Parameters.Add(new SqlParameter("@FabReturn", productionDetail.FabReturn));
cmd.Parameters.Add(new SqlParameter("@Remarks", productionDetail.Remarks));
cmd.Parameters.Add(new SqlParameter("@CCode", productionDetail.CCode));
cmd.Parameters.Add(new SqlParameter("@CName", productionDetail.CName));
cmd.Parameters.Add(new SqlParameter("@TotalRoll", productionDetail.TotalRoll));
cmd.Parameters.Add(new SqlParameter("@TotalPoint", productionDetail.TotalPoint));
cmd.Parameters.Add(new SqlParameter("@SetNo", productionDetail.SetNo));
cmd.Parameters.Add(new SqlParameter("@SS", productionDetail.SS));
cmd.Parameters.Add(new SqlParameter("@Loom", productionDetail.Loom));
cmd.Parameters.Add(new SqlParameter("@Beam", productionDetail.Beam));
cmd.Parameters.Add(new SqlParameter("@ProdB", productionDetail.ProdB));
cmd.Parameters.Add(new SqlParameter("@ProdC", productionDetail.ProdC));
cmd.Parameters.Add(new SqlParameter("@CutPieece", productionDetail.CutPieece));
cmd.Parameters.Add(new SqlParameter("@Wastage", productionDetail.Wastage));
cmd.Parameters.Add(new SqlParameter("@ProdG", productionDetail.ProdG));
cmd.Parameters.Add(new SqlParameter("@TotalProd", productionDetail.TotalProd));
cmd.Parameters.Add(new SqlParameter("@FCode", productionDetail.FCode));
cmd.Parameters.Add(new SqlParameter("@FType", productionDetail.FType));
cmd.Parameters.Add(new SqlParameter("@UserName", productionDetail.UserName));
cmd.Parameters.Add(new SqlParameter("@EDate", productionDetail.EDate));
cmd.Parameters.Add(new SqlParameter("@PType", productionDetail.PType));
cmd.Parameters.Add(new SqlParameter("@PCode", productionDetail.PCode));
cmd.Parameters.Add(new SqlParameter("@UCode", productionDetail.UCode));
cmd.Parameters.Add(new SqlParameter("@UName", productionDetail.UName));
cmd.Parameters.Add(new SqlParameter("@FinishMCName", productionDetail.FinishMCName));
cmd.Parameters.Add(new SqlParameter("@FinishMCCode", productionDetail.FinishMCCode));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
