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);
}
}
