public ActionResult SaveFinishingDetailInfo(FinishingProductionDetail objDetail)
{
var user = (User)Session["CurrentUser"];
//objMaster.UserId = user.EMPID;
//objDetail.UName = user.EMPID;
var res = _repository.SaveDetailInfo(objDetail);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public DataTable Insert_Update_DetailInfo(string procedure, string callname, FinishingProductionDetail objDetail)
{
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("@FPID ", objDetail.FPID));
cmd.Parameters.Add(new SqlParameter("@FID ", objDetail.FID));
cmd.Parameters.Add(new SqlParameter("@BeamNo ", objDetail.BeamNo));
cmd.Parameters.Add(new SqlParameter("@SizingNo ", objDetail.SizingNo));
cmd.Parameters.Add(new SqlParameter("@LoomNo ", objDetail.LoomNo));
cmd.Parameters.Add(new SqlParameter("@StyleCode ", objDetail.StyleCode));
cmd.Parameters.Add(new SqlParameter("@Weave ", objDetail.Weave));
cmd.Parameters.Add(new SqlParameter("@Color ", objDetail.Color));
cmd.Parameters.Add(new SqlParameter("@Weight ", objDetail.Weight));
cmd.Parameters.Add(new SqlParameter("@Width ", objDetail.Width));
cmd.Parameters.Add(new SqlParameter("@BeamLenght ", objDetail.BeamLenght));
cmd.Parameters.Add(new SqlParameter("@FabShrinkage ", objDetail.FabShrinkage));
cmd.Parameters.Add(new SqlParameter("@BeforeFin ", objDetail.BeforeFin));
cmd.Parameters.Add(new SqlParameter("@AfterFin ", objDetail.AfterFin));
cmd.Parameters.Add(new SqlParameter("@AfterFinShrinkage ", objDetail.AfterFinShrinkag));
cmd.Parameters.Add(new SqlParameter("@TotalProd ", objDetail.TotalProd));
cmd.Parameters.Add(new SqlParameter("@TotalPoint ", objDetail.TotalPoint));
cmd.Parameters.Add(new SqlParameter("@Remnarks ", objDetail.Remnarks));
cmd.Parameters.Add(new SqlParameter("@SetNo ", objDetail.SetNo));
cmd.Parameters.Add(new SqlParameter("@TrollyNo ", objDetail.TrollyNo));
cmd.Parameters.Add(new SqlParameter("@BeforeWidth ", objDetail.BeforeWidth));
cmd.Parameters.Add(new SqlParameter("@AfterWidth ", objDetail.AfterWidth));
cmd.Parameters.Add(new SqlParameter("@Skew ", objDetail.Skew));
cmd.Parameters.Add(new SqlParameter("@Buyer ", objDetail.Buyer));
cmd.Parameters.Add(new SqlParameter("@OCode ", objDetail.OCode));
cmd.Parameters.Add(new SqlParameter("@OName ", objDetail.OName));
cmd.Parameters.Add(new SqlParameter("@OpCode ", objDetail.OpCode));
cmd.Parameters.Add(new SqlParameter("@OpName ", objDetail.OpName));
cmd.Parameters.Add(new SqlParameter("@ShiftCode ", objDetail.ShiftCode));
cmd.Parameters.Add(new SqlParameter("@Conostration ", objDetail.Conostration));
cmd.Parameters.Add(new SqlParameter("@FConstraction ", objDetail.FConstraction));
cmd.Parameters.Add(new SqlParameter("@UserName ", objDetail.UserName));
cmd.Parameters.Add(new SqlParameter("@MCRunTime ", objDetail.MCRunTime));
cmd.Parameters.Add(new SqlParameter("@MCOffTime ", objDetail.MCOffTime));
cmd.Parameters.Add(new SqlParameter("@Temparature ", objDetail.Temparature));
cmd.Parameters.Add(new SqlParameter("@RPM ", objDetail.RPM));
cmd.Parameters.Add(new SqlParameter("@ProdCode ", objDetail.ProdCode));
cmd.Parameters.Add(new SqlParameter("@ProdType ", objDetail.ProdType));
cmd.Parameters.Add(new SqlParameter("@FinishRoute ", objDetail.FinishRoute));
cmd.Parameters.Add(new SqlParameter("@UCode ", objDetail.UCode));
cmd.Parameters.Add(new SqlParameter("@Moisture ", objDetail.Moisture));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public string SaveDetailInfo(FinishingProductionDetail objDetail)
{
string rv = "";
try
{
var result = Insert_Update_DetailInfo("sp_insert_finishing_Production_detail_info", "SAVE_FINISHING_PRODUCTION_DETAIL", objDetail);
rv = Operation.Success.ToString();
return(result.Rows[0]["FPID"].ToString());
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public string SaveDetailInfo(FinishingProductionDetail objDetail)
{
return(_service.SaveDetailInfo(objDetail));
}
