public ActionResult SavePlanningInfo(PlanningInformation objPlan, PlanningInfoDetails objPlanDetails, PlanningInfoDetailsWp objWarp, List <PlanningInfoDetailsWp1> objWarpList, PlanningInfoDetailsDye objDye, List <PlanningInfoDetailsDye1> objDyeList, PlanningInfoDetailsWv objWeav, List <PlanningInfoDetailsWv1> objWeavList)
{
var user = (User)Session["CurrentUser"];
objPlan.UserId = user.EMPID;
objPlan.TermId = user.TermID;
var res = _planningInfoRepository.SavePlanningInfo(objPlan, objPlanDetails, objWarp, objWarpList, objDye, objDyeList, objWeav, objWeavList);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public PlanningInformation SavePlanningInfo(PlanningInformation objPlan, PlanningInfoDetails objPlanDetails, PlanningInfoDetailsWp objWarp, PlanningInfoDetailsDye objDyeing, PlanningInfoDetailsWv objWeav, DataSet dsWarping, DataSet dsDyeing, DataSet dsWeaving)
{
string rv = "";
var objplan2 = new PlanningInformation();
try
{
dbConn = new SqlConnection(ConnectionString);
dbConn.Open();
transaction = dbConn.BeginTransaction();
// cmd.Transaction = transaction;
var dt = new DataTable();
dt = Insert_Update_Planning_Info("sp_insert_planning_info", "save_planning_info", objPlan);
var pid = Convert.ToInt32(dt.Rows[0]["PID"].ToString());
objPlanDetails.PID = pid;
objWarp.PID = pid;
objDyeing.PID = pid;
objWeav.PID = pid;
Insert_Update_Planning_DetailsInfo("sp_insert_planning_details_info", "save_planning_details_info",
objPlanDetails);
Insert_Update_Warping_Info("sp_insert_planning_details_info_warping", "save_warping_info", objWarp,
dsWarping);
Insert_Update_Dyeing_Info("sp_insert_planning_details_info_dyeing", "save_dyeing_info", objDyeing,
dsDyeing);
Insert_Update_Weaving_Info("sp_insert_planning_details_info_weaving", "save_weaving_info", objWeav,
dsWeaving);
objplan2.PID = Convert.ToInt32(dt.Rows[0]["PID"].ToString());
objplan2.SaveStatus = Operation.Success.ToString();
}
catch (Exception ex)
{
objplan2.SaveStatus = ex.Message;
transaction.Rollback();
}
finally
{
transaction.Commit();
dbConn.Close();
}
return(objplan2);
}
private void Insert_Update_Planning_DetailsInfo(string procedure, string callname, PlanningInfoDetails plantDetails)
{
//dbConn = new SqlConnection(ConnectionString);
//dbConn.Open();
cmd = new SqlCommand(procedure, dbConn, transaction);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@call_name", callname));
cmd.Parameters.Add(new SqlParameter("@p_PID", plantDetails.PID));
cmd.Parameters.Add(new SqlParameter("@p_StyleCode", plantDetails.StyleCode));
cmd.Parameters.Add(new SqlParameter("@p_StyleNo", plantDetails.StyleNo));
cmd.Parameters.Add(new SqlParameter("@p_Weight", plantDetails.Weight));
cmd.Parameters.Add(new SqlParameter("@p_TypeId", plantDetails.TypeId));
cmd.Parameters.Add(new SqlParameter("@p_Construction", plantDetails.Construction));
cmd.Parameters.Add(new SqlParameter("@p_FConstruction", plantDetails.FConstruction));
cmd.Parameters.Add(new SqlParameter("@p_Weave", plantDetails.Weave));
// cmd.Parameters.Add(new SqlParameter("@p_Width1", plantDetails.Width1));
cmd.Parameters.Add(new SqlParameter("@p_ColourId", plantDetails.ColourId));
cmd.Parameters.Add(new SqlParameter("@p_FabricDesc", plantDetails.FabricDesc));
cmd.Parameters.Add(new SqlParameter("@p_TCode", plantDetails.TCode));
cmd.Parameters.Add(new SqlParameter("@p_FEPIxPPI", plantDetails.FEPIxPPI));
cmd.Parameters.Add(new SqlParameter("@p_FinishingRoute", plantDetails.FinishingRoute));
cmd.Parameters.Add(new SqlParameter("@p_WarpRatio", plantDetails.WarpRatio));
cmd.Parameters.Add(new SqlParameter("@p_WeftRatio", plantDetails.WeftRatio));
cmd.Parameters.Add(new SqlParameter("@p_TEnds", plantDetails.TEnds));
cmd.Parameters.Add(new SqlParameter("@p_ShadeIndigo", plantDetails.ShadeIndigo));
cmd.Parameters.Add(new SqlParameter("@p_ShadeBlack", plantDetails.ShadeBlack));
cmd.Parameters.Add(new SqlParameter("@p_YarnCode", plantDetails.YarnCode));
cmd.Parameters.Add(new SqlParameter("@p_SetStd", plantDetails.SetStd));
cmd.Parameters.Add(new SqlParameter("@p_WashStd", plantDetails.WashStd));
cmd.Parameters.Add(new SqlParameter("@p_Appearnce", plantDetails.Appearnce));
cmd.Parameters.Add(new SqlParameter("@p_WarpShrinkage", plantDetails.WarpShrinkage));
cmd.Parameters.Add(new SqlParameter("@p_WeftShrinkage", plantDetails.WeftShrinkage));
cmd.Parameters.Add(new SqlParameter("@p_WeightFinish", plantDetails.WeightFinish));
cmd.Parameters.Add(new SqlParameter("@p_WeightWash", plantDetails.WeightWash));
cmd.Parameters.Add(new SqlParameter("@p_StretchAbblity", plantDetails.StretchAbblity));
cmd.Parameters.Add(new SqlParameter("@p_Skew", plantDetails.Skew));
cmd.Parameters.Add(new SqlParameter("@p_Movement", plantDetails.Movement));
cmd.Parameters.Add(new SqlParameter("@p_FinishWidth", plantDetails.FinishWidth));
cmd.Parameters.Add(new SqlParameter("@p_FinishLength", plantDetails.FinishLength));
cmd.Parameters.Add(new SqlParameter("@p_GreyWidth", plantDetails.GreyWidth));
cmd.Parameters.Add(new SqlParameter("@p_GreyWeight", plantDetails.GreyWeight));
cmd.Parameters.Add(new SqlParameter("@p_GreyEPI", plantDetails.GreyEPI));
cmd.Parameters.Add(new SqlParameter("@p_GreyPPI", plantDetails.GreyPPI));
cmd.Parameters.Add(new SqlParameter("@p_ReedSpace", plantDetails.ReedSpace));
cmd.Parameters.Add(new SqlParameter("@p_ReedCount", plantDetails.ReedCount));
cmd.Parameters.Add(new SqlParameter("@p_EndDent", plantDetails.EndDent));
cmd.Parameters.Add(new SqlParameter("@p_Remarks", plantDetails.Remarks));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
// dbConn.Close();
}
public PlanningInformation SavePlanningInfo(PlanningInformation objPlan, PlanningInfoDetails objPlanDetails, PlanningInfoDetailsWp objWarp, List <PlanningInfoDetailsWp1> objWarpList, PlanningInfoDetailsDye objDyeing, List <PlanningInfoDetailsDye1> objDyeList, PlanningInfoDetailsWv objWeav, List <PlanningInfoDetailsWv1> objWeavList)
{
var objPlanning = new PlanningInformation();
bool rv = false;
rv = CheckIsExist(objPlan.PID, objPlan.SetNo.ToString());//check set no is exist or not
if (!rv)
{
//-------------------warping information------------------------------------------
var warpingInfo_dt = new DataTable();
warpingInfo_dt.Columns.Add("PID");
warpingInfo_dt.Columns.Add("ICODE");
warpingInfo_dt.Columns.Add("SCODE");
warpingInfo_dt.Columns.Add("YCODE");
warpingInfo_dt.Columns.Add("YCOUNT");
warpingInfo_dt.Columns.Add("LOT");
warpingInfo_dt.Columns.Add("NOOFBEEM");
warpingInfo_dt.Columns.Add("NOOFCREEL");
warpingInfo_dt.Columns.Add("ENDSPERBEEM");
warpingInfo_dt.Columns.Add("TENDS");
warpingInfo_dt.Columns.Add("RATE");
warpingInfo_dt.Columns.Add("VALUE");
warpingInfo_dt.Columns.Add("COST");
warpingInfo_dt.Columns.Add("COSTYDS");
warpingInfo_dt.Columns.Add("COSTKG");
warpingInfo_dt.Columns.Add("QNTY");
warpingInfo_dt.Columns.Add("SETLENGTH");
if (objWarpList != null && objWarpList.Count > 0)
{
foreach (var objwarp in objWarpList)
{
DataRow row1;
row1 = warpingInfo_dt.NewRow();
row1["PID"] = objwarp.PID;
row1["ICODE"] = objwarp.ICode;
row1["SCODE"] = objwarp.SCode;
row1["YCODE"] = objwarp.YCode;
row1["YCOUNT"] = objwarp.YCount;
row1["LOT"] = objwarp.Lot;
row1["NOOFBEEM"] = objwarp.NoOfBeem;
row1["NOOFCREEL"] = objwarp.NoOfCreel;
row1["ENDSPERBEEM"] = objwarp.EndsPerBeem;
row1["TENDS"] = objwarp.TEnds;
row1["RATE"] = objwarp.Rate;
row1["VALUE"] = objwarp.Value;
row1["COST"] = objwarp.Cost;
row1["COSTYDS"] = objwarp.CostYds;
row1["COSTKG"] = objwarp.CostKg;
row1["QNTY"] = objwarp.Qnty;
row1["SETLENGTH"] = objwarp.SetLength;
warpingInfo_dt.Rows.Add(row1);
}
}
warpingInfo_dt.TableName = "tblWarping";
DataSet dsWarping = new DataSet("dsWarping");
dsWarping.Tables.Add(warpingInfo_dt);
//-------------------dyeing information------------------------------------------
var dyeingInfo_dt = new DataTable();
dyeingInfo_dt.Columns.Add("PID");
dyeingInfo_dt.Columns.Add("ICODE");
dyeingInfo_dt.Columns.Add("SCODE");
dyeingInfo_dt.Columns.Add("YCODE");
dyeingInfo_dt.Columns.Add("YCOUNT");
dyeingInfo_dt.Columns.Add("RATE");
dyeingInfo_dt.Columns.Add("VALUE");
dyeingInfo_dt.Columns.Add("QNTY");
dyeingInfo_dt.Columns.Add("REMARKS");
if (objDyeList != null && objDyeList.Count > 0)
{
foreach (var objDye in objDyeList)
{
DataRow row1;
row1 = dyeingInfo_dt.NewRow();
row1["PID"] = objDye.PID;
row1["ICODE"] = objDye.ICode;
row1["SCODE"] = objDye.SCode;
row1["YCODE"] = objDye.YCode;
row1["YCOUNT"] = objDye.YCount;
row1["RATE"] = objDye.Rate;
row1["VALUE"] = objDye.Value;
row1["QNTY"] = objDye.Qnty;
row1["REMARKS"] = objDye.Remarks;
dyeingInfo_dt.Rows.Add(row1);
}
}
dyeingInfo_dt.TableName = "tblDyeing";
DataSet dsDyeing = new DataSet("dsDyeing");
dsDyeing.Tables.Add(dyeingInfo_dt);
//-------------------Weaving information------------------------------------------
var weavingInfo_dt = new DataTable();
weavingInfo_dt.Columns.Add("PID");
weavingInfo_dt.Columns.Add("ICODE");
weavingInfo_dt.Columns.Add("SCODE");
weavingInfo_dt.Columns.Add("YCODE");
weavingInfo_dt.Columns.Add("YCOUNT");
weavingInfo_dt.Columns.Add("RATE");
weavingInfo_dt.Columns.Add("VALUE");
weavingInfo_dt.Columns.Add("QNTY");
weavingInfo_dt.Columns.Add("LOT");
weavingInfo_dt.Columns.Add("WEFTRATIO");
weavingInfo_dt.Columns.Add("COST");
weavingInfo_dt.Columns.Add("COSTYDS");
weavingInfo_dt.Columns.Add("COSTKG");
weavingInfo_dt.Columns.Add("EPI");
weavingInfo_dt.Columns.Add("PPI");
weavingInfo_dt.Columns.Add("TWEFTRATIO");
weavingInfo_dt.Columns.Add("NEEDSPERYDSKG");
if (objWeavList != null && objWeavList.Count > 0)
{
foreach (var objWv in objWeavList)
{
DataRow row1;
row1 = weavingInfo_dt.NewRow();
row1["PID"] = objWv.PID;
row1["ICODE"] = objWv.ICode;
row1["SCODE"] = objWv.SCode;
row1["YCODE"] = objWv.YCode;
row1["YCOUNT"] = objWv.YCount;
row1["RATE"] = objWv.Rate;
row1["VALUE"] = objWv.Value;
row1["QNTY"] = objWv.Qnty;
row1["LOT"] = objWv.Lot;
row1["WEFTRATIO"] = objWv.WeftRatio;
row1["COST"] = objWv.Cost;
row1["COSTYDS"] = objWv.CostYds;
row1["COSTKG"] = objWv.CostKg;
row1["EPI"] = objWv.EPI;
row1["PPI"] = objWv.PPI;
row1["TWEFTRATIO"] = objWv.TWeftRatio;
row1["NEEDSPERYDSKG"] = objWv.NeedPerYdsKg;
weavingInfo_dt.Rows.Add(row1);
}
}
weavingInfo_dt.TableName = "tblWeaving";
DataSet dsWeaving = new DataSet("dsWeaving");
dsWeaving.Tables.Add(weavingInfo_dt);
return(_planningInfoDataService.SavePlanningInfo(objPlan, objPlanDetails, objWarp, objDyeing, objWeav, dsWarping, dsDyeing, dsWeaving));
}
else
{
objPlanning.SaveStatus = Operation.Exists.ToString();
return(objPlanning);
}
}
