protected void btnSendToRoute_Click(object sender, EventArgs e) { int fullcounter = 0; //move the job card routes into the meter reading routes tables and then redirect to Management console //first we need to check if all the instructions were filled in foreach (GridDataItem row in gvSearchResults.Items) { CheckBox chk = (CheckBox)row["MarkCHK"].Controls[0]; //CheckBox tempbox = (CheckBox)row.FindControl("CheckBox1"); Classes.IDBHandler db = new Classes.DBHandler(); Common.ReadingsDetailDBHandler rddb = new Common.ReadingsDetailDBHandler(); if (chk.Checked) { //string statusdescr = gvSearchResults.SelectedItems[row.RowIndex].OwnerTableView.DataKeyValues[3].ToString(); int jobHeaderID = Convert.ToInt32(row.GetDataKeyValue("JobCardHeaderID").ToString()); //check instructions int counter = 0; counter = rddb.CheckInstructions(jobHeaderID); if (counter == 0) { //all instructions have been inserted. move the routes. Boolean correct = rddb.MoveJobCardsToRoutes(jobHeaderID); //change contractID int ContractID = rddb.GetWorkOrderContract(); Users_UserDetail uud = (Users_UserDetail)Session["userDetails"]; Common.ICommonDBHandler cdb = new Common.CommonDBHandler(); UserContract uclst = cdb.GetUserContractList(uud).Where(x => x.EnableContract == true && x.ClientContract.ContractActive == true && x.ContractID == ContractID).FirstOrDefault(); Common.CommonTasks.UserContractDet ucd = cdb.LoadUserContractDetByUserContractID(uclst.UserContractID); Session["UserContractDet"] = ucd; //Redirect to Management Console Response.Redirect("RouteManagementConsole.aspx"); } else { //there are missing instructions - dont allow. lblError.Text = "Cannot transfer routes, please ensure you have added instructions to each meter."; lblError.Visible = true; } fullcounter++; } } if (fullcounter > 0) { gvSearchResults.Rebind(); } else { lblError.Text = "Please select at least one item to send."; lblError.ForeColor = System.Drawing.Color.Red; lblError.Visible = true; } //Response.Redirect("RouteManagementConsole.aspx"); }
protected void Page_Load(object sender, EventArgs e) { Users_UserDetail uud = (Users_UserDetail)Session["userDetails"]; ucd = (Common.CommonTasks.UserContractDet)Session["UserContractDet"]; if (!IsPostBack) { Classes.IDBHandler db = new Classes.DBHandler(); if (Request.QueryString["MeterNo"] != null) { MeterNoRec = Request.QueryString["MeterNo"]; lblMeterNo.Text = MeterNoRec; } } }
protected void Page_Load(object sender, EventArgs e) { uud = (Users_UserDetail)Session["userDetails"]; ucd = (Common.CommonTasks.UserContractDet)Session["UserContractDet"]; isWebAdmin = uud.IsWebAdmin == true ? "Y" : ""; isClientAdmin = uud.IsClientAdmin == true ? "Y" : ""; isOperator = uud.IsOperator == true ? "Y" : ""; isMetermanClient = ucd.isMetermanClient == true ? "Y" : ""; lblContractName.Text = "<br/>Client: " + ucd.ClientName + " | Contract: " + ucd.ContractName; if (!IsPostBack) { Classes.IDBHandler db = new Classes.DBHandler(); gvSearchResults.AllowPaging = uud.ShowPaging; //Set the current sort field and order ViewState["SearchResultSortDirection"] = "ASC"; ViewState["SearchResultSortExpression"] = "RouteName"; if (Request.QueryString["new"] == null) { string routeName = db.getJobCardRouteName(Convert.ToInt32(Request.QueryString["JobCardHeaderID"]), uud.UserID); if (routeName.Substring(0, 3) == "MAN") { //we can add more items } else { //it came from validations, can't add more items. btnAddOther.Visible = false; btnDelete.Visible = false; } } else { if (Request.QueryString["JobCardHeaderID"] == null) { btnSame.Visible = false; } else { string RouteName = db.getJobCardRouteName(Convert.ToInt32(Request.QueryString["JobCardHeaderID"]), uud.UserID).ToString(); btnSame.Visible = true; if (Request.QueryString["create"] == null) { lblError.Text = "Route " + RouteName + " was updated successfully."; } else { lblError.Text = "Route " + RouteName + " was created successfully."; } lblError.ForeColor = System.Drawing.Color.Black; lblError.Visible = true; } } if (Session["alreadyRun"] == null) { Session.Add("alreadyRun", "n"); } else { Session["alreadyRun"] = "n"; } } if ((Session["alreadyRun"] == "y")) { //gvSearchResults.DataSource = null; Session["alreadyRun"] = "n"; //gvSearchResults.Rebind(); Response.Redirect(Request.Url.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { uud = (Users_UserDetail)Session["userDetails"]; ucd = (Common.CommonTasks.UserContractDet)Session["UserContractDet"]; isWebAdmin = uud.IsWebAdmin == true ? "Y" : ""; isClientAdmin = uud.IsClientAdmin == true ? "Y" : ""; isOperator = uud.IsOperator == true ? "Y" : ""; isMetermanClient = ucd.isMetermanClient == true ? "Y" : ""; lblContractName.Text = "<br/>Client: " + ucd.ClientName + " | Contract: " + ucd.ContractName; if (!IsPostBack) { Classes.IDBHandler db = new Classes.DBHandler(); //List<WebNM_GetUniqueRouteByContractID_proc_Result> routelst = db.GetUniqueRoutesByContractID(ucd, false).ToList(); //Common.CommonTasks.Binddropdownlist<WebNM_GetUniqueRouteByContractID_proc_Result>(ddlRoute, routelst, "RouteName", "RouteName", "--Select--"); //List<WebNM_RouteReadingStatus> statuslst = db.GetAllActiveRouteStatus().ToList(); //Common.CommonTasks.Binddropdownlist<WebNM_RouteReadingStatus>(ddlReadingStatus, statuslst, "Description", "RouteReadingStatusID", "--Select--"); //ddlReadingStatus.SelectedIndex = 1; //List<WebNM_GetMeterReaderDetailsByContract_proc_Result> readerlst = db.GetReaderDetailsByContractID(int.Parse(ucd.ContractID.ToString())).ToList(); gvSearchResults.AllowPaging = uud.ShowPaging; loadGrid("RouteName ASC"); //gvSearchResults.Columns[13].Visible = false; //Set the current sort field and order ViewState["SearchResultSortDirection"] = "ASC"; ViewState["SearchResultSortExpression"] = "RouteName"; //if (ucd.isMetermanClient || (uud.IsWebAdmin != true && uud.IsClientAdmin != true && uud.IsOperator != true)) //{ // //btDelete.Visible = false; //commented out 28062013 by Jerome Dimairho as requested by Rudolf Earle // btArchiveComplete.Visible = false; //} if (Session["alreadyRun"] == null) { Session.Add("alreadyRun", "n"); } else { Session["alreadyRun"] = "n"; } if (Session["openPopUp"] == null) { Session.Add("openPopUp", "n"); } else { Session["openPopUp"] = "n"; } } if ((Session["alreadyRun"] == "y")) { gvSearchResults.AllowPaging = uud.ShowPaging; loadGrid("RouteName ASC"); Session["alreadyRun"] = "n"; } }