public void GivenIHaveAddedValidDataToAllSectionsOfTheProcessAForm() { FormF01Page = new FormF01Page(driver); FormA01Page = new FormA01Page(driver); var retailerDetails = new Retailer.RetailDetails("ret", "id", "reference", "contact name", "0242420420", "*****@*****.**"); var developmentDetails = new DevelopmentDetails("School", "", "500", "1000", "200000", DateTime.Now.ToString(), "previous reference value", "this is sitename", "Site addres", "orsurveyRef", "location", "TR10 8JD", "development name", "contact", "07818192929", "*****@*****.**"); var planningInformation = new PlanningInformation("localAuthority", "Yes", "No", "Yes", "", "planRef"); var siteServingDetails = new SiteServicing("Greenfield", "dump", DateTime.Now.ToString()); var waterDetails = new WaterDetails("1000", "300", "2000", "400", "10"); var sewerageDetails = new SewerageDetails("Totally separate Foul Sewage and Surface Water", "", "350", "400", "Combined", "30", "80", "100"); var surfaceWaterDrainage = new SurfaceWaterDrainage("100", "Rain water harvesting", "", "", "", "200", "300", "Soak-away", "", "", "", "", "processa1.txt"); var surfaceWaterDesign = new SurfaceWaterDesign("All", ""); var tradeEffluent = new TradeEffluent("No", "", "", "", "", ""); var declaration = new Retailer.Declaration("locationPlan", "drawings", "calculations", "supportingDocs", "", DateTime.Now.ToString(), "", "arrrghghg"); FormF01Page.AddRetailerDetails(retailerDetails); FormA01Page.AddDevelopmentDetails(developmentDetails); FormA01Page.AddPlanningInformationDetails(planningInformation); FormA01Page.AddSiteServicingDetails(siteServingDetails); FormA01Page.AddWaterDetails(waterDetails); FormA01Page.AddSewerageDetails(sewerageDetails); FormA01Page.AddSurfaceWaterDrainage(surfaceWaterDrainage); FormA01Page.AddSurfaceWaterDesign(surfaceWaterDesign); FormA01Page.AddTradeEffluent(tradeEffluent); FormA01Page.AddDeclaration(declaration); }
public void AddPlanningInformationDetails(PlanningInformation planningInformation) { ClearAndSendKeys(_txtLocalAuthorityArea, planningInformation.LocalAuthority); var developmentIncluded = new Dictionary <string, IWebElement>(); developmentIncluded.Add("Yes", _radDevelopmentIncluded); developmentIncluded.Add("No", _radDevelopmentNotIncluded); developmentIncluded[planningInformation.InTheCurrentLocalPlan].Click(); var outlinePlanningPermission = new Dictionary <string, IWebElement>(); outlinePlanningPermission.Add("Yes", _radNoOutlinePlanningPermission); outlinePlanningPermission.Add("No", _radNoOutlinePlanningPermission); outlinePlanningPermission[planningInformation.OutlinePlanning].Click(); var detailedPlanningPermisison = new Dictionary <string, IWebElement>(); detailedPlanningPermisison.Add("Yes", _radDetailedPlanningPermission); detailedPlanningPermisison.Add("No", _radNoDetailedPlanningPermission); detailedPlanningPermisison[planningInformation.DetailedPlanning].Click(); _dateDetailedPlanningPermissionReceived.SendKeys(DateTime.Now.ToString()); ClearAndSendKeys(_txtPlanningReference, planningInformation.PlanningReferenceNumber); }
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 DataTable Insert_Update_Planning_Info(string procedure, string callname, PlanningInformation objPlan) { //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", objPlan.PID)); cmd.Parameters.Add(new SqlParameter("@p_PDate", objPlan.PDate)); cmd.Parameters.Add(new SqlParameter("@p_UnitCode", objPlan.UnitCode)); cmd.Parameters.Add(new SqlParameter("@p_SetNo", objPlan.SetNo)); cmd.Parameters.Add(new SqlParameter("@p_SetLength", objPlan.SetLength)); cmd.Parameters.Add(new SqlParameter("@p_CustCode", objPlan.CustCode)); cmd.Parameters.Add(new SqlParameter("@p_MerkUserId", objPlan.MerkUserId)); cmd.Parameters.Add(new SqlParameter("@p_OQnty", objPlan.OQnty)); cmd.Parameters.Add(new SqlParameter("@p_Rate", objPlan.Rate)); cmd.Parameters.Add(new SqlParameter("@p_Value", objPlan.Value)); cmd.Parameters.Add(new SqlParameter("@p_PIWidth", objPlan.PIWidth)); cmd.Parameters.Add(new SqlParameter("@p_PIShrink", objPlan.PIShrink)); cmd.Parameters.Add(new SqlParameter("@p_SetPlaned", objPlan.SetPlaned)); cmd.Parameters.Add(new SqlParameter("@p_TotalTgtLngth", objPlan.TotalTargetLength)); cmd.Parameters.Add(new SqlParameter("@p_TakenProd", objPlan.TakenProd)); cmd.Parameters.Add(new SqlParameter("@p_RemainingProd", objPlan.RemainingProd)); cmd.Parameters.Add(new SqlParameter("@p_Remarks", objPlan.Remarks)); cmd.Parameters.Add(new SqlParameter("@p_ProdTypeId", objPlan.ProdTypeId)); cmd.Parameters.Add(new SqlParameter("@p_OrderTypeId", objPlan.OrderTypeId)); cmd.Parameters.Add(new SqlParameter("@p_OrderStatus", objPlan.OrderStatus)); cmd.Parameters.Add(new SqlParameter("@p_BuyerId", objPlan.BuyerId)); cmd.Parameters.Add(new SqlParameter("@p_DeliDate", objPlan.DeliDate)); cmd.Parameters.Add(new SqlParameter("@p_OrderRef", objPlan.OrderRef)); cmd.Parameters.Add(new SqlParameter("@p_StyleNo", objPlan.StyleNo)); cmd.Parameters.Add(new SqlParameter("@p_StyleCode", objPlan.StyleCode)); cmd.Parameters.Add(new SqlParameter("@p_WpLength", objPlan.WpLength)); cmd.Parameters.Add(new SqlParameter("@p_DyLength", objPlan.DyLength)); cmd.Parameters.Add(new SqlParameter("@p_WvLength", objPlan.WvLength)); cmd.Parameters.Add(new SqlParameter("@p_FiLength", objPlan.FiLength)); cmd.Parameters.Add(new SqlParameter("@p_InsLength", objPlan.InsLength)); cmd.Parameters.Add(new SqlParameter("@p_Rej", objPlan.Rej)); cmd.Parameters.Add(new SqlParameter("@p_DyeProd", objPlan.DyeProd)); cmd.Parameters.Add(new SqlParameter("@p_EndBuyer", objPlan.EndBuyer)); cmd.Parameters.Add(new SqlParameter("@p_CSV", objPlan.CSV)); cmd.Parameters.Add(new SqlParameter("@p_UserId", objPlan.UserId)); cmd.Parameters.Add(new SqlParameter("@p_TermId", objPlan.TermId)); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); // dbConn.Close(); return(dt); }
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); } }