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