//After Save Approval Data Check the status of approval /// <summary> /// To find Route Status after Save /// </summary> /// <param name="objProjectRoute"></param> /// <returns></returns> public ProjectRouteBO findRouteStatusafterSave(ProjectRouteBO objProjectRoute) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_APPAFTERSAVEROUTE"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("ProjectedId_", objProjectRoute.Project_Id); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ProjectRouteBO objProjectApprovedRoute = null; ProjectRouteList ProjectRoute = new ProjectRouteList(); while (dr.Read()) { objProjectApprovedRoute = new ProjectRouteBO(); if (!dr.IsDBNull(dr.GetOrdinal("STATUSID"))) { objProjectApprovedRoute.ApprovedstatusID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("STATUSID"))); } } dr.Close(); return(objProjectApprovedRoute); }
/// <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> /// 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 get Final Route Approval Detial /// </summary> /// <param name="objProjectRoute"></param> /// <returns></returns> public ProjectRouteList getFinalRouteApprovalDetial(ProjectRouteBO objProjectRoute) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GETAPPROVEDROUTE"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("ProjectIdIN_", objProjectRoute.Project_Id); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ProjectRouteBO objProjectApprovedRoute = null; ProjectRouteList ProjectRoute = new ProjectRouteList(); while (dr.Read()) { objProjectApprovedRoute = new ProjectRouteBO(); if (!dr.IsDBNull(dr.GetOrdinal("ROUTENAME"))) { objProjectApprovedRoute.Route_Name = dr.GetString(dr.GetOrdinal("ROUTENAME")); } if (!dr.IsDBNull(dr.GetOrdinal("ROUTEID"))) { objProjectApprovedRoute.Route_ID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ROUTEID"))); } if (!dr.IsDBNull(dr.GetOrdinal("USERNAME"))) { objProjectApprovedRoute.ApproverUserName = dr.GetString(dr.GetOrdinal("USERNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("APPROVEDDATE"))) { objProjectApprovedRoute.Approveddate = dr.GetDateTime(dr.GetOrdinal("APPROVEDDATE")).ToString(UtilBO.DateFormat); } ; if (!dr.IsDBNull(dr.GetOrdinal("COMMENTS"))) { objProjectApprovedRoute.ApproverComment = dr.GetString(dr.GetOrdinal("COMMENTS")); } if (!dr.IsDBNull(dr.GetOrdinal("STATUSID"))) { objProjectApprovedRoute.ApprovedstatusID = dr.GetInt32(dr.GetOrdinal("STATUSID")); } if (!dr.IsDBNull(dr.GetOrdinal("ISFINAL"))) { objProjectApprovedRoute.IsFinal = dr.GetString(dr.GetOrdinal("ISFINAL")); } ProjectRoute.Add(objProjectApprovedRoute); } dr.Close(); return(ProjectRoute); }
/// <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> /// To Get Approved Comments /// </summary> /// <param name="ProjectID"></param> /// <returns></returns> public ProjectRouteList GetApprovedComments(int ProjectID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_RTAAPPROVALCOMMENTS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("ProjectIdIN_", ProjectID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ProjectRouteBO objProjectBO = null; ProjectRouteList ProjectList = new ProjectRouteList(); while (dr.Read()) { objProjectBO = new ProjectRouteBO(); if (!dr.IsDBNull(dr.GetOrdinal("USERNAME"))) { objProjectBO.AppName = dr.GetString(dr.GetOrdinal("USERNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("STATUS"))) { objProjectBO.Status = dr.GetString(dr.GetOrdinal("STATUS")); } if (!dr.IsDBNull(dr.GetOrdinal("ACTIONTAKENDATE"))) { objProjectBO.ActioDate = dr.GetDateTime(dr.GetOrdinal("ACTIONTAKENDATE")).ToString(UtilBO.DateFormat); } if (!dr.IsDBNull(dr.GetOrdinal("APPROVERCOMMENTS"))) { objProjectBO.Comments = dr.GetString(dr.GetOrdinal("APPROVERCOMMENTS")); } if (!dr.IsDBNull(dr.GetOrdinal("ROLENAME"))) { objProjectBO.RoleName = dr.GetString(dr.GetOrdinal("ROLENAME")); } ProjectList.Add(objProjectBO); } dr.Close(); return(ProjectList); }
/// <summary> /// To Get Project Route by Id /// </summary> /// <param name="ProjectId"></param> /// <returns></returns> public ProjectRouteList GetProjectRoutebyId(int ProjectId) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GETPROJECTROUTEBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ProjectIdIN", ProjectId); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ProjectRouteBO objProjectRoute = null; ProjectRouteList ProjectRoute = new ProjectRouteList(); while (dr.Read()) { objProjectRoute = new ProjectRouteBO(); if (ColumnExists(dr, "RouteID") && !dr.IsDBNull(dr.GetOrdinal("RouteID"))) { objProjectRoute.Route_ID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("RouteID"))); } if (ColumnExists(dr, "routename") && !dr.IsDBNull(dr.GetOrdinal("routename"))) { objProjectRoute.Route_Name = dr.GetString(dr.GetOrdinal("routename")); } if (ColumnExists(dr, "routedetails") && !dr.IsDBNull(dr.GetOrdinal("routedetails"))) { objProjectRoute.Route_Details = dr.GetString(dr.GetOrdinal("routedetails")); } if (ColumnExists(dr, "totalroutescore") && !dr.IsDBNull(dr.GetOrdinal("totalroutescore"))) { objProjectRoute.TotalRouteScore = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("totalroutescore"))); } ProjectRoute.Add(objProjectRoute); } dr.Close(); return(ProjectRoute); }
/// <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 get WOrk Flow Approval ID /// </summary> /// <param name="objProjectRoute"></param> /// <returns></returns> public ProjectRouteBO getWOrkFlowApprovalID(ProjectRouteBO objProjectRoute) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_WORKFLOWAPPREID"; //string APPROVERLEVEL = "1"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("ProjectId_", objProjectRoute.Project_Id); cmd.Parameters.Add("WorkFlowApprover_", objProjectRoute.WorkFlowApprover); //cmd.Parameters.Add("APPROVERLEVEL_", APPROVERLEVEL); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ProjectRouteBO ProjectRouteBOobj = null; ProjectRouteList ProjectRouteList = new ProjectRouteList(); while (dr.Read()) { ProjectRouteBOobj = new ProjectRouteBO(); if (ColumnExists(dr, "CELLNUMBER") && !dr.IsDBNull(dr.GetOrdinal("CELLNUMBER"))) { ProjectRouteBOobj.CellNumber = (dr.GetString(dr.GetOrdinal("CELLNUMBER"))); } if (ColumnExists(dr, "EMAILID") && !dr.IsDBNull(dr.GetOrdinal("EMAILID"))) { ProjectRouteBOobj.EmailID = (dr.GetString(dr.GetOrdinal("EMAILID"))); } if (ColumnExists(dr, "WORKFLOWDEFINITIONID") && !dr.IsDBNull(dr.GetOrdinal("WORKFLOWDEFINITIONID"))) { ProjectRouteBOobj.WorkFlowDefinitionID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("WORKFLOWDEFINITIONID"))); } if (ColumnExists(dr, "WORKFLOWAPPROVERID") && !dr.IsDBNull(dr.GetOrdinal("WORKFLOWAPPROVERID"))) { ProjectRouteBOobj.WorkFlowApproverID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("WORKFLOWAPPROVERID"))); } if (ColumnExists(dr, "APPROVERUSERID") && !dr.IsDBNull(dr.GetOrdinal("APPROVERUSERID"))) { ProjectRouteBOobj.ApproverUserID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("APPROVERUSERID"))); } if (ColumnExists(dr, "APPROVERUSERNAME") && !dr.IsDBNull(dr.GetOrdinal("APPROVERUSERNAME"))) { ProjectRouteBOobj.ApproverUserName = (dr.GetString(dr.GetOrdinal("APPROVERUSERNAME"))); } if (ColumnExists(dr, "PROJECTCODE") && !dr.IsDBNull(dr.GetOrdinal("PROJECTCODE"))) { ProjectRouteBOobj.ProjectCode = (dr.GetString(dr.GetOrdinal("PROJECTCODE"))); } if (ColumnExists(dr, "PROJECTNAME") && !dr.IsDBNull(dr.GetOrdinal("PROJECTNAME"))) { ProjectRouteBOobj.ProjectName = (dr.GetString(dr.GetOrdinal("PROJECTNAME"))); } if (ColumnExists(dr, "EMAILSUBJECT") && !dr.IsDBNull(dr.GetOrdinal("EMAILSUBJECT"))) { ProjectRouteBOobj.EmailSubject = (dr.GetString(dr.GetOrdinal("EMAILSUBJECT"))); } if (ColumnExists(dr, "EMAILBODY") && !dr.IsDBNull(dr.GetOrdinal("EMAILBODY"))) { ProjectRouteBOobj.EmailBody = (dr.GetString(dr.GetOrdinal("EMAILBODY"))); } if (ColumnExists(dr, "SMSTEXT") && !dr.IsDBNull(dr.GetOrdinal("SMSTEXT"))) { ProjectRouteBOobj.SmsText = (dr.GetString(dr.GetOrdinal("SMSTEXT"))); } } dr.Close(); return(ProjectRouteBOobj); }