public void LoadCustomer(int Flag)
{
try
{
if (Flag == 1)//Using BSS DB to show reports
{
dt = objBSS.GetComplainDetailByComplainID(Convert.ToInt32(Session["ComplainID"].ToString()));
if (dt.Rows.Count > 0)
{
lbl_CusName.InnerHtml = dt.Rows[0]["CircuitName"].ToString();
lbl_TicNum.InnerHtml = dt.Rows[0]["TicketNo"].ToString();
lbl_ComRec.InnerHtml = Convert.ToString(dt.Rows[0]["ComplaintReceivedDate"]);
lbl_LUT.InnerHtml = Convert.ToString(dt.Rows[0]["LastUpdatedDate"]);
lbl_CS.InnerHtml = dt.Rows[0]["ComplainStatus"].ToString();
lbl_AD.InnerHtml = dt.Rows[0]["AssignDepartment"].ToString();
lbl_CN.InnerHtml = dt.Rows[0]["CallerName"] + "/" + dt.Rows[0]["CallerNumber"];
lbl_LR.InnerHtml = dt.Rows[0]["Remarks"].ToString();
}
}
}
catch (Exception ex)
{
// Interaction.MsgBox(ex.Message(), MsgBoxStyle.Information, "BSS Administrator");
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GVTeam.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chkRow") as CheckBox);
if (chkRow.Checked)
{
string ComplaintID = row.Cells[1].Text;
string TicketNo = row.Cells[2].Text;
DropDownList ddl = (DropDownList)GVTeam.Rows[row.RowIndex].FindControl("DropDownList1");
string TeamID = ddl.SelectedValue.ToString();
string TeamName = ddl.SelectedItem.ToString();
DropDownList dd2 = (DropDownList)GVTeam.Rows[row.RowIndex].FindControl("DropDownList2");
string PriorityID = dd2.SelectedValue.ToString();
int DeptID = Convert.ToInt32(Session["DepartmentID"]);
int userid = Convert.ToInt32(Session["UserID"]);
string Remarks = "Assigning Complain: " + TicketNo + " To " + TeamName + " with " + PriorityID + " priority by " + Session["Name"] + " of " + DeptID;
int AssignedDeptID = 0;
//string Remarks = "test";
dynamic dt_GetAssignedDeptId = objBSS.GetComplainDetailByComplainID(Convert.ToInt32(ComplaintID));
if (dt_GetAssignedDeptId.Rows.Count > 0)
{
AssignedDeptID = Convert.ToInt32(dt_GetAssignedDeptId.Rows[0]["AssignedDeptID"]);
}
//objBSS.AssignedComplainsToTeam(ComplaintID, TeamID, PriorityID, Remarks, DeptID, Session["Name"].ToString(), userid);
//objBSS.AssignedComplainsToTeam(Convert.ToInt32(ComplaintID), Convert.ToInt32(TeamID), Convert.ToInt32(PriorityID), Remarks, DeptID.ToString(), Session["Name"].ToString(), userid);
//objBSS.AssignedComplainsToTeam(Convert.ToInt32(ComplaintID), Convert.ToInt32(TeamID), Convert.ToInt32(PriorityID), Remarks, "1", Session["Name"].ToString(), userid);
if (!(TeamID.Equals("-1") || PriorityID.Equals("-1")))
{
objBSS.AssignedComplainsToTeam(Convert.ToInt32(ComplaintID), Convert.ToInt32(TeamID), Convert.ToInt32(PriorityID), Remarks, AssignedDeptID, Session["Name"].ToString(), userid);
}
else
{
lblStatus.Text = "Please select Team and Priority";
lblStatus.Visible = true;
}
//string country = (row.Cells[2].FindControl("lblCountry") as Label).Text;
}
}
}
Response.Redirect("~\\ComplainManagement\\OMTeamEscalation.aspx");
}
public void GetComplainDetails(int ComplainID)
{
try
{
dynamic dt = objBSS.GetComplainDetailByComplainID(ComplainID);
if (dt.Rows.Count > 0)
{
//tbTicketNo.Text = dt.Rows(0)("TicketNo");
tbComplainTicketNo.Text = dt.Rows[0]["TicketNo"];
tbComplainLoggedBy.Text = dt.Rows[0]["LoggedBy"];
ComplainStatusID = dt.Rows[0]["ComplaintStatusID"];
TicketTypeID = dt.Rows[0]["TicketTypeID"];
tbRemarks.Text = dt.Rows[0]["Remarks"];
int SignUpId = dt.Rows[0]["SignUpID"];
if (TicketTypeID == 6)
{
cbCheckAll.Enabled = false;
}
//if (ComplainStatusID == 5 | ComplainStatusID == 1)
if (ComplainStatusID.Equals(5))
{
btnUpdate.Visible = false;
}
//else
//{
// btnUpdate.Visible = true;
//}
tbComplainStatus.Text = dt.Rows[0]["ComplainStatus"];
cmbAssignedtoDepartment.SelectedValue = Convert.ToString(dt.Rows[0]["AssignedDeptID"]);
tbComplaintReceivedDT.Text = Convert.ToString(dt.Rows[0]["ComplaintReceivedDate"]);
AppDomain.CurrentDomain.SetData("LastUpdatedDate", Convert.ToDateTime(dt.Rows[0]["LastUpdatedDate"]));
}
}
catch (Exception ex)
{
throw ex;
}
}
public void GetComplainDetails(int ComplainID)
{
try
{
dynamic dt = objBSS.GetComplainDetailByComplainID(ComplainID);
if (dt.Rows.Count > 0)
{
//tbTicketNo.Text = dt.Rows(0)("TicketNo");
tbComplainTicketNo.Text = dt.Rows[0]["TicketNo"];
tbComplainLoggedBy.Text = dt.Rows[0]["LoggedBy"];
ComplainStatusID = dt.Rows[0]["ComplaintStatusID"];
TicketTypeID = dt.Rows[0]["TicketTypeID"];
tbRemarks.Text = dt.Rows[0]["Remarks"];
int SignUpId = dt.Rows[0]["SignUpID"];
dtSolving.SelectedDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
if ((TicketTypeID.Equals(6)) & (Convert.ToInt32(Session["DepartmentID"]).Equals(1) || Convert.ToInt32(Session["DepartmentID"]).Equals(58) || Convert.ToInt32(Session["DepartmentID"]).Equals(59) || Convert.ToInt32(Session["DepartmentID"]).Equals(60)))
{
DataTable dt_DeplDet = objBSS.GetCircuitDeploymentDetatils(SignUpId);
if (dt_DeplDet.Rows.Count > 0)
{
txtJoinName.Text = dt_DeplDet.Rows[0]["JoinName"].ToString();
txtTubeNameFromCustomer.Text = dt_DeplDet.Rows[0]["TubeNameFromCustomer"].ToString();
txtCoreColorFromCustomer.Text = dt_DeplDet.Rows[0]["CoreColorFromCustomer"].ToString();
txtTubeNameFromNode.Text = dt_DeplDet.Rows[0]["TubeNameFromNode"].ToString();
txtCoreColorFromNode.Text = dt_DeplDet.Rows[0]["CoreColorFromNode"].ToString();
txtCutDistance.Text = dt_DeplDet.Rows[0]["CutDistance"].ToString();
}
pnlFiberDetails.Visible = true;
}
else
{
pnlFiberDetails.Visible = false;
}
if (TicketTypeID == 6)
{
cbCheckAll.Enabled = false;
}
//if (ComplainStatusID == 5 | ComplainStatusID == 1)
if (ComplainStatusID.Equals(5) || ComplainStatusID.Equals(1))
{
btnUpdate.Visible = false;
}
//else
//{
// btnUpdate.Visible = true;
//}
tbComplainStatus.Text = dt.Rows[0]["ComplainStatus"];
cmbAssignedDepartment.SelectedValue = "61";
objBL.LoadProblemDignosedAt(cmbProblemDiagnosedat, Convert.ToInt32(cmbAssignedDepartment.SelectedValue));
objBL.LoadReasonOutage(cmbReasonofOutage, 0, 0, Convert.ToInt32(cmbAssignedDepartment.SelectedValue), 1, Convert.ToInt32(Session["UserID"]));
tbComplaintReceivedDT.Text = Convert.ToString(dt.Rows[0]["ComplaintReceivedDate"]);
AppDomain.CurrentDomain.SetData("LastUpdatedDate", Convert.ToDateTime(dt.Rows[0]["LastUpdatedDate"]));
tbRemarks.Text = dt.Rows[0]["Remarks"];
//ComplainStatusID = 1;
if (ComplainStatusID.Equals(1) || ComplainStatusID.Equals(5))
{
//tbPersonSolvingComplain.Text = dt.Rows[0]["PersonSolving"];
dtSolving.SelectedDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 5, 30, 0);
cmbProblemDiagnosedat.SelectedValue = Convert.ToString(dt.Rows[0]["ProblemDignoseEndID"]);
cmbReasonofOutage.SelectedValue = Convert.ToString(dt.Rows[0]["ReasonOutageID"]);
if (dt.Rows[0]["FCR"] == "True")
{
rbFCRYes.Checked = true;
}
else
{
rbFCRNo.Checked = true;
}
tbCauses.Text = dt.Rows[0]["Dignose_Causes"];
tbRootCauseAnalysis.Text = dt.Rows[0]["Dignose_RootCauseAnalysis"];
tbPreventiveMeasures.Text = dt.Rows[0]["Dignose_PreventativeMeasureTake"];
cmbLastMileInfra.SelectedValue = Convert.ToString(dt.Rows[0]["LastMileInfraID"]);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
click = "Complain Forward";
UserID = Convert.ToInt32(Session["UserID"]);
RoleID = Convert.ToInt32(Session["RoleID"]);
DeptID = Convert.ToInt32(Session["DepartmentID"]);
EngineerName = Session["Name"].ToString();
complaintID = (Convert.ToInt32(Session["ComplainID"]));
//pnlComplainInProcessForm.Visible = true;
dynamic dt = objBSS.GetComplainDetailByComplainID(Convert.ToInt32(Session["ComplainID"]));
if (Convert.ToInt32(Session["DepartmentID"]).Equals(1) || Convert.ToInt32(Session["DepartmentID"]).Equals(3))
{
tbIPResponses.ReadOnly = false;
PnlRequestType.Visible = true;
//lblRequest.Visible = true;
//RadioRequestTypeNE.Visible = true;
}
else
{
tbIPResponses.ReadOnly = true;
PnlRequestType.Visible = false;
//lblRequest.Visible = false;
}
LoadMyCombos(click);
if (dt.Rows.Count > 0)
{
ViewState["Pic1"] = dt.Rows[0]["Picture1"].ToString();
ViewState["Pic2"] = dt.Rows[0]["Picture2"].ToString();
if (dt.Rows.Count < 2)
{
cbCheckAll.Enabled = false;
}
objBL.LoadComplainStatus(cmbComplainStatus, "Follow");
objBL.loadAssignedDepartment(cmbAssignedDepartment, "Follow");
tbLoggedBy0.Text = Session["Name"].ToString();
if (Convert.ToString(dt.Rows[0]["ETTR"]) != "")
{
RadDateTimePicker1.SelectedDate = (DateTime)dt.Rows[0]["ETTR"]; //(DateTime)Session["ETTR"];
}
if (Convert.ToString(dt.Rows[0]["ETA"]) != "")
{
RadDateTimePicker3.SelectedDate = (DateTime)dt.Rows[0]["ETA"]; //(DateTime)Session["ETA"];
}
tbInternalRemarks.Text = dt.Rows[0]["Remarks"]; //Session["Remarks"].ToString();
this.tbComplainTicketNo.Text = dt.Rows[0]["TicketNo"];
tbComplainLoggedBy.Text = dt.Rows[0]["LoggedBy"];
ComplainStatusID = dt.Rows[0]["ComplaintStatusID"];
tbComplaintReceivedDT.Text = Convert.ToString(dt.Rows[0]["ComplaintReceivedDate"]);
tbComplainStatus.Text = dt.Rows[0]["ComplainStatus"];
cmbAssignedDepartment.Text = dt.Rows[0]["AssignDepartment"];
cmbAssignedDepartment.SelectedValue = Convert.ToString(dt.Rows[0]["AssignedDeptID"]);
cmbComplainStatus.Text = dt.Rows[0]["ComplainStatus"];
cmbComplainStatus.SelectedValue = Convert.ToString(dt.Rows[0]["ComplaintStatusID"]);
tbLoggedBy0.ReadOnly = true;
TicketTypeID = Convert.ToInt32(dt.Rows[0]["TicketTypeID"]);
if (TicketTypeID == 6)
{
cbCheckAll.Enabled = false;
}
if (ComplainStatusID.Equals(1) || ComplainStatusID.Equals(5))
{
btnUpdate.Visible = false;
}
if (ComplainStatusID.Equals("6"))
{
cmbAssignedDepartment.Enabled = false;
}
tbInternalRemarks.Text = dt.Rows[0]["Remarks"];
if (Convert.ToString(dt.Rows[0]["LastUpdatedDate"]) != "")
{
AppDomain.CurrentDomain.SetData("LastUpdatedDate", Convert.ToDateTime(dt.Rows[0]["LastUpdatedDate"]));
}
if (dt.Rows[0]["ComplaintStatusID"] == 4)
{
EngineerName = Session["Name"].ToString();
tbComplainLoggedBy.Text = dt.Rows[0]["PersonGivenETA"];
RadDateTimePicker3.SelectedDate = dt.Rows[0]["ETA"];
RadDateTimePicker1.SelectedDate = dt.Rows[0]["ETTR"];
tbIPResponses.Text = dt.Rows[0]["QueryResponse"];
if (dt.Rows[0]["RequestTypeAtNE"] == "Support Request")
{
SupportRequest.Checked = true;
}
else if (dt.Rows[0]["RequestTypeAtNE"] == "Service Request")
{
ServiceRequest.Checked = true;
}
}
loadGridView(click);
}
else
{
ViewState["Pic1"] = "";
ViewState["Pic2"] = "";
}
}
}
catch (Exception ex)
{
throw ex;
}
}
