/// <summary> /// To Add Temporary Authorization /// </summary> /// <param name="objAuth"></param> /// <returns></returns> public string AddTemporaryAuthorization(TemporaryAuthorizationBO objAuth) { string result = ""; using (cnn = new OracleConnection(AppConfiguration.ConnectionString)) { using (cmd = new OracleCommand("USP_INS_APPROVALTEMPAUTHORISER", cnn)) { cmd.Connection = cnn; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("APPROVALTEMPAUTHORISERID_", objAuth.Approvaltempauthoriserid); cmd.Parameters.Add("AUTHORISERID_", objAuth.Authoriserid); cmd.Parameters.Add("ASSIGNTOID_", objAuth.Assigntoid); cmd.Parameters.Add("FROMDATE_", objAuth.Fromdate); cmd.Parameters.Add("TODATE_", objAuth.Todate); cmd.Parameters.Add("REMARKS_", objAuth.Remarks); cmd.Parameters.Add("PROJECTID_", objAuth.ProjectID); cmd.Parameters.Add("CREATEDBY_", objAuth.Createdby); cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; cnn.Open(); cmd.ExecuteNonQuery(); if (cmd.Parameters["errorMessage_"].Value != null) { result = cmd.Parameters["errorMessage_"].Value.ToString(); } else { result = string.Empty; } } } return(result); }
/// <summary> /// Update Database Make data as Obsoluted /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void IsObsolete_CheckedChanged(Object sender, EventArgs e) { string message = string.Empty; try { CheckBox chk = (CheckBox)sender; GridViewRow gr = (GridViewRow)chk.Parent.Parent; string APPROVALTEMPAUTHORISERID = ((Literal)gr.FindControl("litLineTypeID")).Text; TemporaryAuthorizationBLL objtempBLL = new TemporaryAuthorizationBLL(); TemporaryAuthorizationBO objtemp = objtempBLL.GetTempAuthorizationsByID(Convert.ToInt32(APPROVALTEMPAUTHORISERID)); objtempBLL.ObsoleteTempAuthorizationsByID(Convert.ToInt32(APPROVALTEMPAUTHORISERID), Convert.ToString(chk.Checked)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Updated successfully"; } string status = ""; if (!chk.Checked) { status = "INS"; } SendMailForUser(status, Convert.ToInt32(objtemp.AssignedTo), objtemp); ClearDetails(); Bindgrid(); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// To save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string result = string.Empty; string AlertMessage = string.Empty; objTemporaryAuthorizationBLL = new TemporaryAuthorizationBLL(); objTemporaryAuthorizationBO = new TemporaryAuthorizationBO(); try { objTemporaryAuthorizationBO.Assigntoid = Convert.ToInt32(ddlAssignTo.SelectedValue); objTemporaryAuthorizationBO.Authoriserid = Convert.ToInt32(Session["USER_ID"]); objTemporaryAuthorizationBO.Fromdate = Convert.ToDateTime(dptxtFrom.Text); objTemporaryAuthorizationBO.Todate = Convert.ToDateTime(dptxtTo.Text); objTemporaryAuthorizationBO.Remarks = txtRemarks.Text.Trim(); if (objTemporaryAuthorizationBO.Remarks.Length > 500) { objTemporaryAuthorizationBO.Remarks = objTemporaryAuthorizationBO.Remarks.Substring(0, 499); } objTemporaryAuthorizationBO.ProjectID = Convert.ToInt32(Session["PROJECT_ID"]); objTemporaryAuthorizationBO.Createdby = Convert.ToInt32(Session["USER_ID"]); objTemporaryAuthorizationBO.Approvaltempauthoriserid = Convert.ToInt32(ViewState["TEMPAUTHID"]); result = objTemporaryAuthorizationBLL.AddTemporaryAuthorization(objTemporaryAuthorizationBO); SendMailForUser("INS", Convert.ToInt32(ddlAssignTo.SelectedValue), objTemporaryAuthorizationBO); if (string.IsNullOrEmpty(result) || result == "" || result == "null") { if (Convert.ToInt32(ViewState["TEMPAUTHID"]) == 0) { result = "Temporary Authorization added successfully"; } else if (result == "Temp Authorization already exists in the system.") { result = "Temporary Authorization already exists"; } else { result = "Temporary Authorization Updated successfully"; } AlertMessage = "alert('" + result + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); } else { AlertMessage = "alert('" + result + "');"; } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); ClearDetails(); } catch (Exception ex) { AlertMessage = "alert('" + ex + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); } Bindgrid(); }
/// <summary> /// Set edit mode for edit comand /// Delete data from the database for delete comand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdTempAuth_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; try { if (e.CommandName == "EditRow") { ViewState["TEMPAUTHID"] = e.CommandArgument; TemporaryAuthorizationBLL objtempBLL = new TemporaryAuthorizationBLL(); TemporaryAuthorizationBO objtemp = objtempBLL.GetTempAuthorizationsByID(Convert.ToInt32(ViewState["TEMPAUTHID"])); ddlAssignTo.ClearSelection(); if (ddlAssignTo.Items.FindByValue(objtemp.AssignedTo) != null) { ddlAssignTo.Items.FindByValue(objtemp.AssignedTo).Selected = true; } dptxtFrom.Text = Convert.ToDateTime(objtemp.Fromdate).ToString(UtilBO.DateFormat); dptxtTo.Text = Convert.ToDateTime(objtemp.Todate).ToString(UtilBO.DateFormat); txtRemarks.Text = objtemp.Remarks; btnSave.Text = "Update"; btnClear.Text = "Cancel"; } else if (e.CommandName == "DeleteRow") { TemporaryAuthorizationBLL objtempBLL = new TemporaryAuthorizationBLL(); objtempBLL.DeleteTempAuthorizationsByID(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } ClearDetails(); Bindgrid(); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// To generate mail to the user /// </summary> /// <param name="Status"></param> /// <param name="UID"></param> /// <param name="objTemporaryAuthorizationBO"></param> private void SendMailForUser(string Status, int UID, TemporaryAuthorizationBO objTemporaryAuthorizationBO) { UserBLL objUserBLL = new UserBLL(); UserBO objUser = new UserBO(); objUser = objUserBLL.GetUserById(UID); ProjectBLL objProjectBLL = new ProjectBLL(); ProjectBO objProject = objProjectBLL.GetProjectByProjectID(Convert.ToInt32(Session["PROJECT_ID"])); string fileName = string.Empty; //NotificationObj.SendChangeRequestEmail(EmailToTextBox.Text, EmailSubjectTextBox.Text, EmailBodyTextBox.Text); MailMessage mailMessage = new MailMessage(); SmtpClient smtp = new SmtpClient(); mailMessage.To.Add(objUser.EmailID.Trim()); mailMessage.From = new MailAddress(ConfigurationManager.AppSettings.Get("FromMailAddress")); if (Status == "INS") { mailMessage.Subject = Session["userName"].ToString() + " assign you as a Temporary authorized person for all the approvals belogns to " + Session["PROJECT_CODE"].ToString() + " project."; mailMessage.Body = "Dear Sir <br/><br/> " + Session["userName"].ToString() + " assign you as a Temporary authorized person for all the approvals belogns to " + Session["PROJECT_CODE"].ToString() + " project. <br/><br/> ProjectCode : " + Session["PROJECT_CODE"].ToString() + "<br/> ProjectName : " + objProject.ProjectName + "<br/>" + "<br/> From Date : " + objTemporaryAuthorizationBO.Fromdate.ToString(UtilBO.DateFormat) + "<br/>" + "<br/> To Date : " + objTemporaryAuthorizationBO.Todate.ToString(UtilBO.DateFormat) + "<br/><br/>" + "<br/> Remarks : " + objTemporaryAuthorizationBO.Remarks + "<br/><br/>" + "Thanks and Regards <br/> WIS - UETCL Team"; } else { mailMessage.Subject = Session["userName"].ToString() + " is available now. Your Temporary authorization for all the approvals belogns to " + Session["PROJECT_CODE"].ToString() + " project was canceled."; mailMessage.Body = "Dear Sir <br/><br/> " + Session["userName"].ToString() + " is available now. Your Temporary authorization for all the approvals belogns to " + Session["PROJECT_CODE"].ToString() + " project was canceled. <br/><br/> ProjectCode : " + Session["PROJECT_CODE"].ToString() + "<br/> ProjectName : " + objProject.ProjectName + "<br/>" + "<br/> From Date : " + objTemporaryAuthorizationBO.Fromdate.ToString(UtilBO.DateFormat) + "<br/>" + "<br/> To Date : " + objTemporaryAuthorizationBO.Todate.ToString(UtilBO.DateFormat) + "<br/><br/>" + "<br/> Remarks : " + objTemporaryAuthorizationBO.Remarks + "<br/><br/>" + "Thanks and Regards <br/> WIS - UETCL Team"; } mailMessage.IsBodyHtml = true; smtp.Send(mailMessage); }
/// <summary> /// To Get Temp Authorizations By User /// </summary> /// <param name="userID"></param> /// <param name="ProjectID"></param> /// <returns></returns> public TemporaryAuthorizationList GetTempAuthorizationsByUser(int userID, int ProjectID) { TemporaryAuthorizationBO objAuth = null; TemporaryAuthorizationList AuthList = null; using (cnn = new OracleConnection(AppConfiguration.ConnectionString)) { using (cmd = new OracleCommand("USP_TRN_GET_TEMPAUTHBYUSERID", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CREATEDBY_", userID); cmd.Parameters.Add("PROJECTID_", ProjectID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; AuthList = new TemporaryAuthorizationList(); try { cmd.Connection.Open(); using (OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { while (dr.Read()) { objAuth = new TemporaryAuthorizationBO(); if (!dr.IsDBNull(dr.GetOrdinal("APPROVALTEMPAUTHORISERID"))) { objAuth.Approvaltempauthoriserid = dr.GetInt32(dr.GetOrdinal("APPROVALTEMPAUTHORISERID")); } if (!dr.IsDBNull(dr.GetOrdinal("AuthoriserName"))) { objAuth.AuthoriserName = dr.GetString(dr.GetOrdinal("AuthoriserName")); } if (!dr.IsDBNull(dr.GetOrdinal("AssignedTo"))) { objAuth.AssignedTo = dr.GetString(dr.GetOrdinal("AssignedTo")); } if (!dr.IsDBNull(dr.GetOrdinal("fromdate"))) { objAuth.Fromdate = dr.GetDateTime(dr.GetOrdinal("fromdate")); } if (!dr.IsDBNull(dr.GetOrdinal("todate"))) { objAuth.Todate = dr.GetDateTime(dr.GetOrdinal("todate")); } if (!dr.IsDBNull(dr.GetOrdinal("remarks"))) { objAuth.Remarks = dr.GetString(dr.GetOrdinal("remarks")); } if (!dr.IsDBNull(dr.GetOrdinal("isdeleted"))) { objAuth.Isdeleted = dr.GetString(dr.GetOrdinal("isdeleted")); } AuthList.Add(objAuth); } dr.Close(); } } catch (Exception ex) { throw ex; } } } objAuth = null; return(AuthList); }
/// <summary> /// To Add Temporary Authorization /// </summary> /// <param name="objAuth"></param> /// <returns></returns> public string AddTemporaryAuthorization(TemporaryAuthorizationBO objAuth) { return((new TemporaryAuthorizationDAL()).AddTemporaryAuthorization(objAuth)); }