/// <summary>
/// to check the grievance data Exit Or Not
/// to enable the change request button
/// </summary>
public void checkGrievanceApprovalExitOrNot()
{
#region Enable ChangeRequest Button
string ResultValue = string.Empty;
string message = string.Empty;
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteList objProjectRouteList = new ProjectRouteList();
objProjectRoute.WorkFlowApprover = UtilBO.WorkflowGrievances;
objProjectRoute.Project_Id = Convert.ToInt32(Session["PROJECT_ID"]);
objProjectRoute = objProjectRouteBLL.getWOrkFlowApprovalID(objProjectRoute);
if ((objProjectRoute) != null)
{
btnSave.Visible = true;
btnClear.Visible = true;
}
else
{
btnSave.Visible = false;
btnClear.Visible = false;
}
#endregion
}
/// <summary>
/// Update status
/// </summary>
protected void UpdateStatus()
{
ProjectRouteBO objApprovalHeaderSave = new ProjectRouteBO();
objApprovalHeaderSave.WorkFlowApproverID = Convert.ToInt32(WorkFlowApproverIDTextBox.Text.ToString());
objApprovalHeaderSave.StatusID = (StatusIDTextBox.Text.ToString());
objApprovalHeaderSave.CreatedBy = Convert.ToInt32(Request.QueryString["userID"]);
objApprovalHeaderSave.ApproverUserID = Convert.ToInt32(ApproverUserIdTextBox.Text.ToString());
objApprovalHeaderSave.WorkFlowDefinitionID = Convert.ToInt32(WorkFlowDefinitionIDTextBox.Text.ToString());
objApprovalHeaderSave.HHID = Convert.ToInt32(HHIDTextBox.Text.ToString());
objApprovalHeaderSave.PageCode = PageCodeTextBox.Text.ToString();
objApprovalHeaderSave.EmailSubject = EmailSubjectTextBox.Text.ToString();
objApprovalHeaderSave.EmailBody = EmailBodyTextBox.Text.ToString();
if (ViewState["BatchNo"] != null)
{
objApprovalHeaderSave.ElementID = Convert.ToInt32(ViewState["BatchNo"]);
}
else if (ViewState["GrievanceID"] != null)
{
objApprovalHeaderSave.ElementID = Convert.ToInt32(ViewState["GrievanceID"]);
}
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
string message = objProjectRouteBLL.AddApprovalTrackheader(objApprovalHeaderSave);
}
/// <summary>
/// To find route status after save
/// </summary>
/// <param name="ProjectId"></param>
public void findRouteStatusafterSave(int ProjectId)
{
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
objProjectRoute.Project_Id = ProjectId;
objProjectRoute = objProjectRouteBLL.findRouteStatusafterSave(objProjectRoute);
if ((objProjectRoute) != null)
{
txtFinalRoute.Enabled = false;
txtComments.Enabled = false;
txtapprovedby.Enabled = false;
txtapprovedDate.Enabled = false;
GetApproavlComments();
if (objProjectRoute.ApprovedstatusID == 3)
{
pnlApprovel.Visible = false;
//StatusLabel.Visible = true;
ApprovalMessage1.SetMessage = ApprovalMessage.MessageValue.RouteApprovalSent;
//StatusLabel.Text = "Route Approval is Pending";
btn_Save.Visible = false;
btn_Clear.Visible = false;
ApproverButton.Visible = false;
}
}
}
/// <summary>
/// to check the approver
/// </summary>
/// <returns></returns>
public bool CheckApprover()
{
string ResultValue = string.Empty;
string message = string.Empty;
//bool mailSent = false;
bool approverExists = false;
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteList objProjectRouteList = new ProjectRouteList();
objProjectRoute.WorkFlowApprover = UtilBO.WorkflowGrievances;
objProjectRoute.Project_Id = Convert.ToInt32(Session["PROJECT_ID"]);
objProjectRoute = objProjectRouteBLL.getWOrkFlowApprovalID(objProjectRoute);
if (objProjectRoute != null)
{
//(new NotificationBLL()).SendEmail(Convert.ToInt32(Session["PROJECT_ID"]), UtilBO.WorkflowGrievances);
////NotificationObj.SendEmail(objProjectRoute.EmailID, objProjectRoute.EmailSubject, objProjectRoute.EmailBody, objProjectRoute.ProjectCode, objProjectRoute.ProjectName);
////ResultValue = NotificationObj.SendSMS(objProjectRoute.CellNumber, objProjectRoute.SmsText, objProjectRoute.ProjectCode, objProjectRoute.ProjectName);
//string Description = descriptionTextBox.Text.ToString().Trim();
//int GrievanceID = Convert.ToInt32(ViewState["GRIEVANCEID"]);
//System.Text.StringBuilder sb = new System.Text.StringBuilder();
//sb.Append("Dear Sir,");
//sb.Append(System.Environment.NewLine);
//sb.Append(objProjectRoute.EmailBody); sb.Append(GrievanceID);
//sb.Append(System.Environment.NewLine);
//sb.Append(Description);
//sb.Append(System.Environment.NewLine);
//sb.Append("Project Code : " + objProjectRoute.ProjectCode);
//sb.Append(System.Environment.NewLine);
//sb.Append("Project Name : " + objProjectRoute.ProjectName);
//sb.Append(System.Environment.NewLine);
//sb.Append(" Thanks and Regards");
//sb.Append(System.Environment.NewLine);
//sb.Append("WIS - UETCL Team");
//string InputEmail = sb.ToString();
//ProjectRouteBO objApprovalHeaderSave = new ProjectRouteBO();
//objApprovalHeaderSave.WorkFlowApproverID = objProjectRoute.WorkFlowApproverID;
//objApprovalHeaderSave.StatusID = objProjectRoute.StatusID;
//objApprovalHeaderSave.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
//objApprovalHeaderSave.PageCode = UtilBO.WorkflowGrievances;
//objApprovalHeaderSave.HHID = Convert.ToInt32(Session["HH_ID"].ToString());
//objApprovalHeaderSave.ElementID = Convert.ToInt32(ViewState["GRIEVANCEID"]); //sending Grivanceid
//objApprovalHeaderSave.ApproverUserID = objProjectRoute.ApproverUserID;
//objApprovalHeaderSave.WorkFlowDefinitionID = objProjectRoute.WorkFlowDefinitionID;
//objApprovalHeaderSave.EmailSubject = objProjectRoute.EmailSubject;
//objApprovalHeaderSave.EmailBody = InputEmail;
//message = objProjectRouteBLL.AddApprovalTrackheader(objApprovalHeaderSave);
approverExists = true;
}
return(approverExists);
}
/// <summary>
/// To fetch ProjectRoutes and bind to list
/// </summary>
private void GetProjectRoutes()
{
ProjectRouteBLL ProjectRouteLogic = new ProjectRouteBLL();
ProjectRouteList ProjectRoutes = ProjectRouteLogic.GetProjectRoutebyId(Convert.ToInt32(projectID));
lstRoutes.DataSource = ProjectRoutes;
lstRoutes.DataBind();
pnlRoutes.Visible = true;
}
/// <summary>
/// Set the Route coordinates to Map
/// </summary>
private void GenerateMap()
{
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
ProjectRouteList ProjectRouteList = new ProjectRouteList();
objProjectRoute.Project_Id = Convert.ToInt32(projectID);;
bool checck = true;
ProjectRouteList = objProjectRouteBLL.getFinalRouteApprovalDetial(objProjectRoute);
for (int i = 0; i < ProjectRouteList.Count; i++)
{
if (ProjectRouteList[i].IsFinal == "TRUE")
{
checck = false;
RouteCoordinatesBLL objRouteCoordinatesBLL = new RouteCoordinatesBLL();
RouteCoordinatesList RouteCoordinates = objRouteCoordinatesBLL.GetRouteCoordinates(ProjectRouteList[i].Route_ID.ToString());
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (RouteCoordinatesBO objRouteCoord in RouteCoordinates)
{
sb.Append(string.Format("'{0},{1},{2}'", objRouteCoord.Latitude, objRouteCoord.Longitude, objRouteCoord.Routename));
sb.Append(";");
}
if (sb.Length > 0)
{
sb.Remove(sb.Length - 1, 1);
}
//Response.Write(sb.ToString());
System.Text.StringBuilder sb1 = new System.Text.StringBuilder();
sb1.Append(string.Format("'{0},{1},{2}'", "0.469104", "33.164163", "E"));
sb1.Append(";");
sb1.Append(string.Format("'{0},{1},{2}'", "0.469145", "33.164285", "B"));
sb1.Append(";");
sb1.Append(string.Format("'{0},{1},{2}'", "0.468865", "33.164583", "C"));
sb1.Append(";");
sb1.Append(string.Format("'{0},{1},{2}'", "0.468782", "33.164507", "D"));
sb1.Append(";");
sb1.Append(string.Format("'{0},{1},{2}'", "0.469104", "33.164163", "E"));
sb1.Append(";");
if (sb1.Length > 0)
{
sb1.Remove(sb1.Length - 1, 1);
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowMap", string.Format("initialize(\"{0}\")", sb.ToString()), true);
//string paramView = string.Format("initialize('{0}','{1}');", sb.ToString(), sb1.ToString());
//ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowMap", paramView, true);
}
}
lblMessage.Visible = checck;
}
/// <summary>
/// To load routes
/// </summary>
public void LoadRoutes()
{
ProjectRouteBLL oProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteList lstProjectRouteList = new ProjectRouteList();
try
{
int ProjectId = 0;
if (Request.QueryString.Count == 0)
{
if (Session["PROJECT_ID"] != null)
{
ProjectId = Convert.ToInt32(Session["PROJECT_ID"].ToString());
RouteEnabled(true);
}
}
else
{
ProjectId = Convert.ToInt32(Request.QueryString["ProjectID"].ToString());
RouteEnabled(false);
}
lstProjectRouteList = oProjectRouteBLL.GetProjectRoutebyId(ProjectId);
rptRoute.DataSource = lstProjectRouteList;
rptRoute.DataBind();
FindSum();
}
catch (Exception ex)
{
throw ex;
}
for (int i = 0; i < rptRoute.Items.Count; i++)
{
Panel p = (Panel)rptRoute.Items[i].FindControl("pnlspace");
if (p != null)
{
if (i == 0)
{
p.Visible = true;
}
else
{
p.Visible = false;
}
}
}
}
/// <summary>
/// To fetch FinalRouteApprovalDetial
/// </summary>
/// <param name="ProjectId"></param>
public void getFinalRouteApprovalDetial(int ProjectId)
{
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
ProjectRouteList ProjectRouteList = new ProjectRouteList();
objProjectRoute.Project_Id = ProjectId;
ProjectRouteList = objProjectRouteBLL.getFinalRouteApprovalDetial(objProjectRoute);
//ProjectRouteList = objProjectRouteBLL.getFinalRouteApprovalDetial(objProjectRoute);
if ((ProjectRouteList.Count) > 0)
{
for (int i = 0; i < ProjectRouteList.Count; i++)
{
if (ProjectRouteList[i].IsFinal == "TRUE")
{
if (ProjectRouteList[i].ApprovedstatusID == 1)
{
btn_Save.Visible = false;
btn_Clear.Visible = false;
btn_ImportExcel.Visible = false;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 1].Visible = false;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 2].Visible = false;
}
}
else
{
if (ProjectRouteList[i].ApprovedstatusID == 3)
{
btn_Save.Visible = false;
btn_Clear.Visible = false;
btn_ImportExcel.Visible = false;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 1].Visible = false;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 2].Visible = false;
}
if (ProjectRouteList[i].ApprovedstatusID == 2)
{
btn_Save.Visible = true;
btn_Clear.Visible = true;
btn_ImportExcel.Visible = true;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 1].Visible = true;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 2].Visible = true;
}
}
}
}
}
/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>e
private void BindGrid(bool addRow, bool deleteRow)
{
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int CheckProjectID = 0;
if (Request.QueryString["ProjectID"] != null)
{
CheckProjectID = Convert.ToInt32(Request.QueryString["ProjectID"]);
}
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
grdApprovalComments.DataSource = objProjectRouteBLL.GetApprovedComments(ProjectID);
grdApprovalComments.DataBind();
}
/// <summary>
/// To find Route Status after Save
/// </summary>
/// <param name="ProjectId"></param>
public void findRouteStatusafterSave(int ProjectId)
{
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
objProjectRoute.Project_Id = ProjectId;
objProjectRoute = objProjectRouteBLL.findRouteStatusafterSave(objProjectRoute);
if ((objProjectRoute) != null)
{
if (objProjectRoute.ApprovedstatusID == 3)
{
btnSave.Visible = false;
btnClear.Visible = false;
}
}
}
/// <summary>
/// to find Route Status after Save
/// </summary>
/// <param name="ProjectId"></param>
public void findRouteStatusafterSave(int ProjectId)
{
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
objProjectRoute.Project_Id = ProjectId;
objProjectRoute = objProjectRouteBLL.findRouteStatusafterSave(objProjectRoute);
if ((objProjectRoute) != null)
{
if (objProjectRoute.ApprovedstatusID == 3)
{
btn_Save.Visible = false;
btn_Clear.Visible = false;
btn_ImportExcel.Visible = false;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 1].Visible = false;
GrdRouteCoordinates.Columns[GrdRouteCoordinates.Columns.Count - 2].Visible = false;
}
}
}
/// <summary>
/// To fetch details and assign to textbox
/// </summary>
/// <param name="ProjectID"></param>
public void GetProjectRouteDetails(int ProjectID)
{
// int RouteCordinate = 0;
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteList objProjectRoute = objProjectRouteBLL.GetProjectRoutebyId(ProjectID);
if (objProjectRoute.Count > 0)
{
pnlRouteSelCriteria.Visible = true;
//ApproverButton.Visible = true;
for (int i = 0; i < objProjectRoute.Count; i++)
{
if (i == 0)
{
txtRoute1.Text = objProjectRoute[i].Route_Name;
txtRouteDetails1.Text = objProjectRoute[i].Route_Details;
ViewState["ROUTE_ID1"] = objProjectRoute[i].Route_ID;
lnkbtnone1.Visible = true;
RouteCoordinatesOne();
}
else if (i == 1)
{
txtRoute2.Text = objProjectRoute[i].Route_Name;
txtRouteDetails2.Text = objProjectRoute[i].Route_Details;
ViewState["ROUTE_ID2"] = objProjectRoute[i].Route_ID;
lnkbtnTwo.Visible = true;
RouteCoordinatesTwo();
}
else if (i == 2)
{
txtRoute3.Text = objProjectRoute[i].Route_Name;
txtRouteDetails3.Text = objProjectRoute[i].Route_Details;
ViewState["ROUTE_ID3"] = objProjectRoute[i].Route_ID;
lnkbtnthree.Visible = true;
RouteCoordinatesThree();
}
}
ProjectRouteList lstProjectRouteList = objProjectRouteBLL.GetProjectRoutebyId(ProjectID);
if (lstProjectRouteList.Count > 0)
{
//For Enabling/Disabling Approver Button
if (lstProjectRouteList[0].TotalRouteScore > 0)
{
ApproverButton.Visible = true;
}
else
{
ApproverButton.Visible = false;
}
}
//Enabling or Disabling Route Selection Panel based on Route Cordinate Value
if (ViewState["ROUTE_ID1"] != null)
{
if (RouteCordinates(ViewState["ROUTE_ID1"].ToString()) > 0)
{
//Enabling Route Selection Link Button
pnlRouteSelCriteria.Visible = true;
}
}
else if (ViewState["ROUTE_ID2"] != null)
{
if (RouteCordinates(ViewState["ROUTE_ID2"].ToString()) > 0)
{
pnlRouteSelCriteria.Visible = true;
}
}
else if (ViewState["ROUTE_ID3"] != null)
{
if (RouteCordinates(ViewState["ROUTE_ID3"].ToString()) > 0)
{
//Enabling Route Selection Link Button
pnlRouteSelCriteria.Visible = true;
}
}
else
{
//Disbling Route Selection Link Button
pnlRouteSelCriteria.Visible = false;
}
}
else
{
pnlRouteSelCriteria.Visible = false;
ApproverButton.Visible = false;
}
}
/// <summary>
/// To get final route approval detail
/// </summary>
/// <param name="ProjectId"></param>
public void getFinalRouteApprovalDetial(int ProjectId)
{
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
ProjectRouteList ProjectRouteList = new ProjectRouteList();
objProjectRoute.Project_Id = ProjectId;
ProjectRouteList = objProjectRouteBLL.getFinalRouteApprovalDetial(objProjectRoute);
//ProjectRouteList = objProjectRouteBLL.getFinalRouteApprovalDetial(objProjectRoute);
if ((ProjectRouteList.Count) > 0)
{
for (int i = 0; i < ProjectRouteList.Count; i++)
{
if (ProjectRouteList[i].IsFinal == "TRUE")
{
txtFinalRoute.Enabled = false;
txtComments.Enabled = false;
txtapprovedby.Enabled = false;
txtapprovedDate.Enabled = false;
GetApproavlComments();
if (ProjectRouteList[i].ApprovedstatusID == 1)
{
pnlApprovel.Visible = true;
txtFinalRoute.Text = ProjectRouteList[i].Route_Name.ToString();
txtComments.Text = ProjectRouteList[i].ApproverComment.ToString();
txtapprovedby.Text = ProjectRouteList[i].ApproverUserName.ToString();
txtapprovedDate.Text = ProjectRouteList[i].Approveddate.ToString();
btn_Save.Visible = false;
btn_Clear.Visible = false;
ApproverButton.Visible = false;
// lnkApprovalComments.Visible = false;
//StatusLabel.Visible = false;
//StatusLabel.Text = "";
ApprovalMessage1.SetMessage = ApprovalMessage.MessageValue.None;
}
}
else
{
if (ProjectRouteList[i].ApprovedstatusID == 3)
{
pnlApprovel.Visible = false;
//StatusLabel.Visible = true;
//StatusLabel.Text = "Route Approval is Pending";
ApprovalMessage1.SetMessage = ApprovalMessage.MessageValue.RouteApprovalSent;
btn_Save.Visible = false;
btn_Clear.Visible = false;
ApproverButton.Visible = false;
///lnkApprovalComments.Visible = true;
}
if (ProjectRouteList[i].ApprovedstatusID == 2)
{
pnlApprovel.Visible = false;
//StatusLabel.Visible = true;
//StatusLabel.Text = "Route Declined";
ApprovalMessage1.SetMessage = ApprovalMessage.MessageValue.RouteApprovalDeclined;
btn_Save.Visible = true;
btn_Clear.Visible = true;
ApproverButton.Visible = false;
//lnkApprovalComments.Visible = true;
}
}
}
}
else
{
pnlApprovel.Visible = false;
}
}
/// <summary>
/// To send route approval notification
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ApproverButton_Click(object sender, EventArgs e)
{
string ResultValue = string.Empty;
string message = string.Empty;
string WorkFlowCode = UtilBO.WorkflowRouteApproval;
string emailSubject = string.Empty;
string emailBody = string.Empty;
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteList objProjectRouteList = new ProjectRouteList();
objProjectRoute.WorkFlowApprover = UtilBO.WorkflowRouteApproval;
objProjectRoute.Project_Id = Convert.ToInt32(Session["PROJECT_ID"]);
objProjectRoute = objProjectRouteBLL.getWOrkFlowApprovalID(objProjectRoute);
if ((objProjectRoute) != null)
{
(new NotificationBLL()).SendEmail(Convert.ToInt32(Session["PROJECT_ID"]), UtilBO.WorkflowRouteApproval);
#region for sending SMS
WIS_ConfigBO WIS_ConfigBO = new WIS_ConfigBO();
WIS_ConfigBLL WIS_ConfigBLL = new WIS_ConfigBLL();
WIS_ConfigBO = WIS_ConfigBLL.GetConfigSMSsending();
if (WIS_ConfigBO != null)
{
if (WIS_ConfigBO.MobileStatus == "Y")
{
string Result = string.Empty;
string SendsmsTest = objProjectRoute.SmsText + objProjectRoute.ProjectCode + objProjectRoute.ProjectName;
NotificationBO SMSNotificationBO = new NotificationBO();
NotificationBLL SMSNotificationBLL = new NotificationBLL();
SMSNotificationBO.ProviderMobileNo = WIS_ConfigBO.MobileNumber;
SMSNotificationBO.ProviderPasword = WIS_ConfigBO.MobilePassword;
SMSNotificationBO.ProviderURL = WIS_ConfigBO.SiteUrl;
SMSNotificationBO.CellNumber = objProjectRoute.CellNumber;
SMSNotificationBO.SmsText = SendsmsTest;
Result = SMSNotificationBLL.SENDSMS(SMSNotificationBO);
}
}
#endregion
//NotificationObj.SendEmail(objProjectRoute.EmailID, objProjectRoute.EmailSubject, objProjectRoute.EmailBody, objProjectRoute.ProjectCode, objProjectRoute.ProjectName);
//ResultValue = NotificationObj.SendSMS(objProjectRoute.CellNumber, objProjectRoute.SmsText, objProjectRoute.ProjectCode, objProjectRoute.ProjectName);
ProjectRouteBO objApprovalHeaderSave = new ProjectRouteBO();
objApprovalHeaderSave.WorkFlowApproverID = objProjectRoute.WorkFlowApproverID;
objApprovalHeaderSave.StatusID = objProjectRoute.StatusID;
objApprovalHeaderSave.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
objApprovalHeaderSave.PageCode = "RTA";
objApprovalHeaderSave.ApproverUserID = objProjectRoute.ApproverUserID;
objApprovalHeaderSave.WorkFlowDefinitionID = objProjectRoute.WorkFlowDefinitionID;
#region email formate
switch (WorkFlowCode)
{
case "RTA":
emailSubject = string.Format("{0} {1}", objProjectRoute.EmailSubject, objProjectRoute.ProjectName);
//emailBody = emailBody.Replace("@@PROJECTNAME", objProjectRoute.EmailBody);
emailBody = objProjectRoute.EmailBody.Replace("@@PROJECTNAME", objProjectRoute.ProjectName);
break;
default:
emailSubject = objProjectRoute.EmailSubject;
break;
}
string approverName = objProjectRoute.ApproverUserName;
StringBuilder sb = new StringBuilder();
sb.Append("Dear " + approverName + ",");
sb.Append("<br/><br/>");
sb.Append(emailBody);
sb.Append("<br/><br/>");
sb.Append("Thanks and Regards,");
sb.Append("<br/>");
sb.Append("WIS - UETCL Team");
#endregion
objApprovalHeaderSave.EmailSubject = emailSubject;
objApprovalHeaderSave.EmailBody = sb.ToString();
message = objProjectRouteBLL.AddApprovalTrackheader(objApprovalHeaderSave);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Route Approval Notification has been sent";
}
if (message != "")
{
int ProjectId = Convert.ToInt32(Session["PROJECT_ID"]);
findRouteStatusafterSave(ProjectId);
getFinalRouteApprovalDetial(ProjectId);
GetApproavlComments();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
ApproverButton.Visible = false;
}
}
else
{
message = "Route Approver is not defined";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
findRouteStatusafterSave(Convert.ToInt32(Session["PROJECT_ID"]));
}
/// <summary>
/// To save details to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Save_Click(object sender, EventArgs e)
{
if (txtRoute1.Text != "")
{
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
objProjectRoute.Route_ID = Convert.ToInt32(ViewState["ROUTE_ID1"]);
objProjectRoute.Project_Id = Convert.ToInt32(Session["PROJECT_ID"]);
objProjectRoute.Route_Name = txtRoute1.Text;
objProjectRoute.Route_Details = txtRouteDetails1.Text.Trim();
if (objProjectRoute.Route_Details.Length > 1000)
{
objProjectRoute.Route_Details = objProjectRoute.Route_Details.Substring(0, 999);
}
objProjectRoute.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ViewState["ROUTE_ID1"] = objProjectRouteBLL.AddProjectRoutes(objProjectRoute);
if (Convert.ToInt32(ViewState["ROUTE_ID1"]) != 0)
{
lnkbtnone1.Visible = true;
RouteCoordinatesOne();
}
}
if (txtRoute2.Text != "")
{
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
objProjectRoute.Route_ID = Convert.ToInt32(ViewState["ROUTE_ID2"]);
objProjectRoute.Project_Id = Convert.ToInt32(Session["PROJECT_ID"]);
objProjectRoute.Route_Name = txtRoute2.Text;
objProjectRoute.Route_Details = txtRouteDetails2.Text.Trim();
if (objProjectRoute.Route_Details.Length > 1000)
{
objProjectRoute.Route_Details = objProjectRoute.Route_Details.Substring(0, 999);
}
objProjectRoute.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
//objProjectRouteBLL.AddProjectRoutes(objProjectRoute);
ViewState["ROUTE_ID2"] = objProjectRouteBLL.AddProjectRoutes(objProjectRoute);
if (Convert.ToInt32(ViewState["ROUTE_ID2"]) != 0)
{
lnkbtnTwo.Visible = true;
RouteCoordinatesTwo();
}
}
if (txtRoute3.Text != "")
{
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
objProjectRoute.Route_ID = Convert.ToInt32(ViewState["ROUTE_ID3"]);
objProjectRoute.Project_Id = Convert.ToInt32(Session["PROJECT_ID"]);
objProjectRoute.Route_Name = txtRoute3.Text;
objProjectRoute.Route_Details = txtRouteDetails3.Text.Trim();
if (objProjectRoute.Route_Details.Length > 1000)
{
objProjectRoute.Route_Details = objProjectRoute.Route_Details.Substring(0, 999);
}
objProjectRoute.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
// objProjectRouteBLL.AddProjectRoutes(objProjectRoute);
ViewState["ROUTE_ID3"] = objProjectRouteBLL.AddProjectRoutes(objProjectRoute);
if (Convert.ToInt32(ViewState["ROUTE_ID3"]) != 0)
{
lnkbtnthree.Visible = true;
RouteCoordinatesThree();
}
}
GetProjectRouteDetails(Convert.ToInt32(Session["PROJECT_ID"]));
findRouteStatusafterSave(Convert.ToInt32(Session["PROJECT_ID"]));
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data saved successfully');", true);
// ClearDetails();
}
