/// <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));
}