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 btnAddSameInstruction_Click(object sender, EventArgs e)
{
string listIDs = "";
int counter = 0;
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());
if (counter == 0)
{
listIDs = jobHeaderID.ToString();
}
else
{
listIDs = listIDs + "," + jobHeaderID.ToString();
}
counter++;
}
}
if (Session["jobIDs"] == null)
{
Session.Add("jobIDs", listIDs);
}
else
{
if (Session["jobIDs"].ToString() != listIDs)
{
Session["jobIDs"] = listIDs;
Session["openPopUp"] = "n";
}
else
{
Session["jobIDs"] = listIDs;
Session["openPopUp"] = "y";
}
}
if (counter > 0)//Session["openPopUp"] = "n";
{
if ((Session["openPopUp"] == "n") || (Session["openPopUp"] == null))
{
ClientScript.RegisterStartupScript(this.GetType(), "setInstruction", "<script>window.open('SetComment.aspx?all=y&JobCardHeaderID=" + listIDs + "', 'setInstruction', 'toolbar=0,location=0,status=1,menubar=0,scrollbars=1,top=50,left=50,width=550,height=270,resizable=1');</script>");
}
}
else
{
lblError.Visible = true;
lblError.Text = "Please select at least one route to edit the instructions of.";
}
}
protected void btnDeleteRoutes_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());
if (rddb.DeleteJobCards(jobHeaderID))
{
lblError.Text = "Route(s) successfully deleted.";
lblError.ForeColor = System.Drawing.Color.Black;
lblError.Visible = true;
}
else
{
lblError.Text = "A problem has occured. Please try again.";
lblError.ForeColor = System.Drawing.Color.Red;
lblError.Visible = true;
}
fullcounter++;
}
}
if (fullcounter > 0)
{
gvSearchResults.Rebind();
}
else
{
lblError.Text = "Please select at least one item to delete.";
lblError.ForeColor = System.Drawing.Color.Red;
lblError.Visible = true;
}
}
protected void btnAddItems_Click(object sender, EventArgs e)
{
Common.ReadingsDetailDBHandler rddb = new Common.ReadingsDetailDBHandler();
int counter = 0;
int jobCardHeaderID = 0;
string additionalParms = "";
//check if hidden field has value, if not you need to first create the header record
if (hidJobCardID.Value == "")
{
jobCardHeaderID = rddb.InsertJobCardHeader(0);
hidJobCardID.Value = jobCardHeaderID.ToString();
additionalParms = "&create=y";
}
else
{
jobCardHeaderID = Convert.ToInt32(hidJobCardID.Value);
}
//loop through gridview to find all marked for repairs
foreach (GridDataItem row in gvAddingItems.Items)
{
if (row.ItemType == GridItemType.Item)
{
CheckBox chkRow = (row.Cells[1].FindControl("chkMarkRepairs") as CheckBox);
if (chkRow.Checked)
{
//update mrd table with repairs
int mrdID = Convert.ToInt32(row.Cells[0].Text);
bool updated = rddb.UpdateMarkRepairs(mrdID, jobCardHeaderID);
//insert job card route
counter = counter + 1;
}
}
}
gvSearchResults.Rebind();
AddItem.Attributes["style"] = "display: none";
Response.Redirect("ViewWorkOrders.aspx?new=y&JobCardHeaderID=" + jobCardHeaderID.ToString() + additionalParms);
}