/*public PageHeaderCaption PageHeader
* {
* set
* {
* switch (value)
* {
* case PageHeaderCaption.Household:
* lblPageHeader.Text = Session["PROJECT_CODE"].ToString() + " - Socio-Economic - Household Details";
* break;
* }
* }
* }*/
/// <summary>
/// Clear sessions
/// redirect to login page
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lnkLogout_Click(object sender, EventArgs e)
{
if (Session["UnlockStatus"] != null && Session["USER_ID"] != null)
{
SharedAuthorizationBO objbo1 = new SharedAuthorizationBO();
objbo1.TRACKERHEADERID = Convert.ToInt32(Session["UnlockStatus"].ToString());
objbo1.LockStatus = "N";
objbo1.UpdateBy = Convert.ToInt32(Session["USER_ID"]);
(new SharedApprovalsBLL()).UPdateLockStatus(objbo1);
}
Session.Clear();
if (Session["USER_ID"] != null)
{
if (Cache["PRIV_" + Session["USER_ID"]] != null)
{
Cache.Remove("PRIV_" + Session["USER_ID"]);
}
Session["USER_ID"] = null;
}
Session["userName"] = null;
Session["PROJECT_ID"] = null;
Response.Redirect("~/Login.aspx");
}
/// <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;
SharedAuthorizationBLL objtempBLL = new SharedAuthorizationBLL();
SharedAuthorizationBO objtemp = objtempBLL.GetSharedAuthorizationsByID(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 Get Lock Status
/// </summary>
/// <param name="WorkflowdefinationID"></param>
/// <returns></returns>
public SharedAuthorizationBO GetLockStatus(int TRACKERHEADERID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_LOCKSTATUS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("TRACKERHEADERID_", TRACKERHEADERID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
SharedAuthorizationBO objBo = null;
objBo = new SharedAuthorizationBO();
while (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("LOCKEDSTATUS")))
{
objBo.LockStatus = dr.GetString(dr.GetOrdinal("LOCKEDSTATUS"));
}
if (!dr.IsDBNull(dr.GetOrdinal("LOCKEDBY")))
{
objBo.LockedBy = dr.GetString(dr.GetOrdinal("LOCKEDBY"));
}
}
dr.Close();
return(objBo);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["HeaderID"] != null)
{
SharedAuthorizationBO objbo1 = new SharedAuthorizationBO();
objbo1.TRACKERHEADERID = Convert.ToInt32(Request.QueryString["HeaderID"]);
objbo1.LockStatus = "N";
objbo1.UpdateBy = Convert.ToInt32(Session["USER_ID"]);
(new SharedApprovalsBLL()).UPdateLockStatus(objbo1);
ScriptManager.RegisterStartupScript(this, this.GetType(), "CloseLock", "window.close();", true);
}
}
/// <summary>
/// To UPdate Lock Status
/// </summary>
/// <param name="objApprovalCDPABUG"></param>
/// <returns></returns>
public void UPdateLockStatus(SharedAuthorizationBO objBo)
{
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_TRN_UPD_LOCKSTATUS", myConnection);
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("TRACKERHEADERID_", objBo.TRACKERHEADERID);
myCommand.Parameters.Add("LOCKEDSTATUS_", objBo.LockStatus);
myCommand.Parameters.Add("LOCKEDBY_", objBo.UpdateBy);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
/// <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["SharedUser"] = e.CommandArgument;
SharedAuthorizationBLL objtempBLL = new SharedAuthorizationBLL();
SharedAuthorizationBO objtemp = objtempBLL.GetSharedAuthorizationsByID(Convert.ToInt32(ViewState["SharedUser"].ToString()));
ddlAssignTo.ClearSelection();
ddlAssignTo.SelectedValue = objtemp.AssignedToId.ToString();
ddlModuleDropDownList.ClearSelection();
ddlModuleDropDownList.SelectedValue = objtemp.ModuleId.ToString();
getWorkfolwitemByModuleID();
ddlWorkflowItemDropDownList.ClearSelection();
ddlWorkflowItemDropDownList.SelectedValue = objtemp.WorkFlowId.ToString();
txtRemarks.Text = objtemp.Remarks.ToString();
btnSave.Text = "Update";
btnClear.Text = "Cancel";
}
else if (e.CommandName == "DeleteRow")
{
SharedAuthorizationBLL objtempBLL = new SharedAuthorizationBLL();
objtempBLL.DeleteSharedAuthorizationsByID(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="oSharedAuthorizationBO"></param>
private void SendMailForUser(string Status, int UID, SharedAuthorizationBO oSharedAuthorizationBO)
{
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 Shared authorized persion for all the approvals belogns to " + Session["PROJECT_CODE"].ToString() + " project.";
mailMessage.Body = "Dear Sir <br/><br/> " + Session["userName"].ToString() + " assign you as a Shared 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/> Authoriser Name : " + oSharedAuthorizationBO.AuthoriserName + "<br/>" +
"<br/> Assigned To: " + oSharedAuthorizationBO.AssignedTo + "<br/><br/>" +
"<br/> Remarks : " + oSharedAuthorizationBO.Remarks + "<br/><br/>" +
"Thanks and Regards <br/> WIS - UETCL Team";
}
else
{
mailMessage.Subject = Session["userName"].ToString() + " is available now. Your Shared 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 Shared 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/> Authoriser Name : " + oSharedAuthorizationBO.AuthoriserName + "<br/>" +
"<br/> Assigned To: : " + oSharedAuthorizationBO.AssignedTo + "<br/><br/>" +
"<br/> Remarks : " + oSharedAuthorizationBO.Remarks + "<br/><br/>" +
"Thanks and Regards <br/> WIS - UETCL Team";
}
mailMessage.IsBodyHtml = true;
smtp.Send(mailMessage);
}
/// <summary>
/// To Add Temporary Authorization
/// </summary>
/// <param name="pSharedAuth"></param>
/// <returns></returns>
public string AddSharedAuthorization(SharedAuthorizationBO pSharedAuth)
{
string result = "";
using (cnn = new OracleConnection(AppConfiguration.ConnectionString))
{
using (cmd = new OracleCommand("USP_TRN_INS_SHARED_WORKFLOW", cnn))
{
cmd.Connection = cnn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("WrkFlw_SharedId_", pSharedAuth.WorkFlowSharedId);
cmd.Parameters.Add("ModuleId_", pSharedAuth.ModuleId);
cmd.Parameters.Add("WorkFlowId_", pSharedAuth.WorkFlowId);
cmd.Parameters.Add("ProjectId_", pSharedAuth.ProjectId);
cmd.Parameters.Add("AuthoriserId_", pSharedAuth.AuthoriserId);
cmd.Parameters.Add("Remarks_", pSharedAuth.Remarks);
cmd.Parameters.Add("AssignedTo_", pSharedAuth.AssignedToId);
cmd.Parameters.Add("UserId_", pSharedAuth.CreatedBy);
// cmd.Parameters.Add("CREATEDBY_", pSharedAuth.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>
/// To Add Shared Authorization
/// </summary>
/// <param name="objAuth"></param>
/// <returns></returns>
public string AddSharedAuthorization(SharedAuthorizationBO pSharedAuth)
{
return((new SharedAuthorizationDAL()).AddSharedAuthorization(pSharedAuth));
}
/// <summary>
/// To Get Temp Authorizations By User
/// </summary>
/// <param name="userID"></param>
/// <param name="ProjectID"></param>
/// <returns></returns>
public SharedAuthorizationList GetSharedAuthorizationsByUser(int AuthorisedId, int ProjectID)
{
SharedAuthorizationBO pSharedAuth = null;
SharedAuthorizationList SharedAuthList = null;
using (cnn = new OracleConnection(AppConfiguration.ConnectionString))
{
using (cmd = new OracleCommand("USP_TRN_GET_SHARED_WORKFLOW", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("AuthoriserId_", AuthorisedId);
cmd.Parameters.Add("PROJECTID_", ProjectID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
SharedAuthList = new SharedAuthorizationList();
try
{
cmd.Connection.Open();
using (OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
pSharedAuth = new SharedAuthorizationBO();
if (!dr.IsDBNull(dr.GetOrdinal("WRKFLW_SHAREDID")))
{
pSharedAuth.WorkFlowSharedId = dr.GetInt32(dr.GetOrdinal("WRKFLW_SHAREDID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("modulename")))
{
pSharedAuth.ModuleName = dr.GetString(dr.GetOrdinal("modulename"));
}
if (!dr.IsDBNull(dr.GetOrdinal("WORKFLOWCODE")))
{
pSharedAuth.WorkFlow = dr.GetString(dr.GetOrdinal("WORKFLOWCODE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PROJECTID")))
{
pSharedAuth.ProjectId = dr.GetInt32(dr.GetOrdinal("PROJECTID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AssignedTo")))
{
pSharedAuth.AssignedTo = dr.GetString(dr.GetOrdinal("AssignedTo"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Authoriser")))
{
pSharedAuth.AuthoriserName = dr.GetString(dr.GetOrdinal("Authoriser"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AssignedTo")))
{
pSharedAuth.AssignedTo = dr.GetString(dr.GetOrdinal("AssignedTo"));
}
if (!dr.IsDBNull(dr.GetOrdinal("REMARKS")))
{
pSharedAuth.Remarks = dr.GetString(dr.GetOrdinal("REMARKS"));
}
//if (!dr.IsDBNull(dr.GetOrdinal("isdeleted")))
// pSharedAuth.Isdeleted = dr.GetString(dr.GetOrdinal("isdeleted"));
SharedAuthList.Add(pSharedAuth);
}
dr.Close();
}
}
catch (Exception ex)
{
throw ex;
}
}
}
pSharedAuth = null;
return(SharedAuthList);
}
/// <summary>
/// To Get Temp Authorizations By ID
/// </summary>
/// <param name="APPROVALTEMPAUTHORISERID"></param>
/// <returns></returns>
public SharedAuthorizationBO GetSharedAuthorizationsByID(int WorkFlowSharedId)//,int ProjectId)
{
SharedAuthorizationBO pSharedAuth = null;
// TemporaryAuthorizationList AuthList = null;
using (cnn = new OracleConnection(AppConfiguration.ConnectionString))
{
using (cmd = new OracleCommand("USP_TRN_GET_SHARED_WRKFLW_BYID", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("WRKFLW_SHAREDID_", WorkFlowSharedId);
// cmd.Parameters.Add("projectid_", WorkFlowSharedId);
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())
{
pSharedAuth = new SharedAuthorizationBO();
//if (!dr.IsDBNull(dr.GetOrdinal("WRKFLW_SHAREDID")))
// pSharedAuth.WorkFlowSharedId = dr.GetInt32(dr.GetOrdinal("WRKFLW_SHAREDID"));
//if (!dr.IsDBNull(dr.GetOrdinal("MODULEID")))
// pSharedAuth.ModuleId = dr.GetInt32(dr.GetOrdinal("MODULEID"));
//if (!dr.IsDBNull(dr.GetOrdinal("WORKFLOWID")))
// pSharedAuth.WorkFlowId = dr.GetInt32(dr.GetOrdinal("WORKFLOWID"));
//if (!dr.IsDBNull(dr.GetOrdinal("PROJECTID")))
// pSharedAuth.ProjectId = dr.GetInt32(dr.GetOrdinal("PROJECTID"));
//if (!dr.IsDBNull(dr.GetOrdinal("AssignedTo")))
// pSharedAuth.AssignedTo = dr.GetString(dr.GetOrdinal("AssignedTo"));
//if (!dr.IsDBNull(dr.GetOrdinal("AUTHORISERID")))
// pSharedAuth.AuthoriserId = dr.GetInt32(dr.GetOrdinal("AUTHORISERID"));
//if (!dr.IsDBNull(dr.GetOrdinal("ASSIGNTOID")))
// pSharedAuth.AssignedToId = dr.GetInt32(dr.GetOrdinal("ASSIGNTOID"));
//if (!dr.IsDBNull(dr.GetOrdinal("REMARKS")))
// pSharedAuth.Remarks = dr.GetString(dr.GetOrdinal("REMARKS"));
if (!dr.IsDBNull(dr.GetOrdinal("WRKFLW_SHAREDID")))
{
pSharedAuth.WorkFlowSharedId = dr.GetInt32(dr.GetOrdinal("WRKFLW_SHAREDID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("modulename")))
{
pSharedAuth.ModuleName = dr.GetString(dr.GetOrdinal("modulename"));
}
if (!dr.IsDBNull(dr.GetOrdinal("WORKFLOWCODE")))
{
pSharedAuth.WorkFlow = dr.GetString(dr.GetOrdinal("WORKFLOWCODE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MODULEID")))
{
pSharedAuth.ModuleId = dr.GetInt32(dr.GetOrdinal("MODULEID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("WORKFLOWID")))
{
pSharedAuth.WorkFlowId = dr.GetInt32(dr.GetOrdinal("WORKFLOWID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PROJECTID")))
{
pSharedAuth.ProjectId = dr.GetInt32(dr.GetOrdinal("PROJECTID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("assigntoid")))
{
pSharedAuth.AssignedToId = dr.GetInt32(dr.GetOrdinal("assigntoid"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AssignedTo")))
{
pSharedAuth.AssignedTo = dr.GetString(dr.GetOrdinal("AssignedTo"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AUTHORISERID")))
{
pSharedAuth.AuthoriserId = dr.GetInt32(dr.GetOrdinal("AUTHORISERID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Authoriser")))
{
pSharedAuth.AuthoriserName = dr.GetString(dr.GetOrdinal("Authoriser"));
}
//if (!dr.IsDBNull(dr.GetOrdinal("ASSIGNTOID")))
// pSharedAuth.AssignedToId = dr.GetInt32(dr.GetOrdinal("ASSIGNTOID"));
if (!dr.IsDBNull(dr.GetOrdinal("REMARKS")))
{
pSharedAuth.Remarks = dr.GetString(dr.GetOrdinal("REMARKS"));
}
//AuthList.Add(pSharedAuth);
}
dr.Close();
}
}
catch (Exception ex)
{
throw ex;
}
}
}
return(pSharedAuth);
}
/// <summary>
/// To UPdate Lock Status
/// </summary>
/// <param name="objApprovalCDPABUG"></param>
/// <returns></returns>
public void UPdateLockStatus(SharedAuthorizationBO objBo)
{
SharedApprovalsDAL objMyTaskDAL = new SharedApprovalsDAL();
objMyTaskDAL.UPdateLockStatus(objBo);
}
/// <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;
oSharedAuthorizationBLL = new SharedAuthorizationBLL();
oSharedAuthorizationBO = new SharedAuthorizationBO();
try
{
if (ViewState["SharedUser"] != null)
{
oSharedAuthorizationBO.WorkFlowSharedId = Convert.ToInt32(Convert.ToInt32(ViewState["SharedUser"].ToString()));
}
oSharedAuthorizationBO.AssignedToId = Convert.ToInt32(ddlAssignTo.SelectedValue);
oSharedAuthorizationBO.AuthoriserId = Convert.ToInt32(Session["USER_ID"]);
oSharedAuthorizationBO.ModuleId = Convert.ToInt32(ddlModuleDropDownList.Text);
oSharedAuthorizationBO.WorkFlowId = Convert.ToInt32(ddlWorkflowItemDropDownList.Text);
oSharedAuthorizationBO.Remarks = txtRemarks.Text.Trim();
if (oSharedAuthorizationBO.Remarks.Length > 500)
{
oSharedAuthorizationBO.Remarks = oSharedAuthorizationBO.Remarks.Substring(0, 499);
}
oSharedAuthorizationBO.ProjectId = Convert.ToInt32(Session["PROJECT_ID"]);
oSharedAuthorizationBO.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
// oSharedAuthorizationBO.AuthoriserId = Convert.ToInt32(ViewState["SharedUser"]);
//if (ViewState["SharedUser"] != null && Convert.ToInt32(ViewState["SharedUser"].ToString()) == 0)
//{
// result = oSharedAuthorizationBLL.AddSharedAuthorization(oSharedAuthorizationBO);
//}
//else
result = oSharedAuthorizationBLL.AddSharedAuthorization(oSharedAuthorizationBO);
if (string.IsNullOrEmpty(result) || result == "" || result == "null")
{
if (Convert.ToInt32(ViewState["SharedUser"]) == 0)
{
result = "Shared Authorization added successfully";
SendMailForUser("INS", Convert.ToInt32(ddlAssignTo.SelectedValue), oSharedAuthorizationBO);
}
else if (result == "Shared Authorization already exists in the system.")
{
result = "Shared Authorization already exists";
}
else
{
result = "Shared Authorization Updated successfully";
SendMailForUser("INS", Convert.ToInt32(ddlAssignTo.SelectedValue), oSharedAuthorizationBO);
}
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();
}
