public void Insert_Update_Warping_Info(string procedure, string callname, PlanningInfoDetailsWp objWarp, DataSet rqdXmlv1 = null) { //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("@dsxmlu1", SqlDbType.Xml).Value = (rqdXmlv1 == null ? null : rqdXmlv1.GetXml());//warping Info cmd.Parameters.Add(new SqlParameter("@p_PID", objWarp.PID)); cmd.Parameters.Add(new SqlParameter("@p_EndsPerBeam", objWarp.EndsPerBeam)); cmd.Parameters.Add(new SqlParameter("@p_NoOfBeam", objWarp.NoOfBeam)); cmd.Parameters.Add(new SqlParameter("@p_NoOfCreal", objWarp.NoOfCreal)); cmd.Parameters.Add(new SqlParameter("@p_TotalEnds", objWarp.TotalEnds)); cmd.Parameters.Add(new SqlParameter("@p_MSpeed", objWarp.MSpeed)); cmd.Parameters.Add(new SqlParameter("@p_YarnTension", objWarp.YarnTension)); cmd.Parameters.Add(new SqlParameter("@p_ProcessingForce", objWarp.ProcessingForce)); cmd.Parameters.Add(new SqlParameter("@p_YarnCounts", objWarp.YarnCounts)); cmd.Parameters.Add(new SqlParameter("@p_WarpRatio", objWarp.WarpRatio)); cmd.Parameters.Add(new SqlParameter("@p_ProYarnLot", objWarp.ProYarnLot)); cmd.Parameters.Add(new SqlParameter("@p_ProYarnSupp", objWarp.ProYarnSupp)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); // dbConn.Close(); }
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); }
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); } }