protected void gvLeaveApprove_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
LeaveApplyBl objLeaveApplyBl = new LeaveApplyBl();
if (e.CommandName.ToString() == "Delete1")
{
var objResult = objLeaveApplyBl.LeaveApply_Delete(Convert.ToInt32(e.CommandArgument), Convert.ToInt32(Session[ApplicationSession.USERID]), DateTime.UtcNow.AddHours(5.5).ToString());
if (objResult != null)
{
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
BindApplyLeave();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Leave has been successfully cancelled');</script>");
}
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void btnGo_OnClick(object sender, EventArgs e)
{
if (ddlStatus.SelectedValue.ToString() == "-1")
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Select Status.');</script>");
}
else
{
ApplicationResult objResult = new ApplicationResult();
LeaveApplyBl objLeaveApplyBl = new LeaveApplyBl();
objResult = objLeaveApplyBl.LeaveApply_Select_ForPrincipal(Convert.ToInt32(ddlStatus.SelectedValue), Convert.ToInt32(Session[ApplicationSession.USERID]));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
gvLeaveApprove.DataSource = objResult.resultDT;
gvLeaveApprove.DataBind();
PanelVisibility(2);
}
else
{
PanelVisibility(3);
}
}
}
}
private void BindApplyLeave()
{
ApplicationResult objResult = new ApplicationResult();
LeaveApplyBl objLeaveApplyBl = new LeaveApplyBl();
objResult = objLeaveApplyBl.LeaveApply_Select(0, Convert.ToInt32(Session[ApplicationSession.USERID].ToString()));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
gvLeaveApprove.DataSource = objResult.resultDT;
gvLeaveApprove.DataBind();
divLeaveApprove.Visible = true;
}
else
{
divLeaveApprove.Visible = false;
}
}
}
protected void btnSave_OnClick(object sender, EventArgs e)
{
try
{
LeaveApplyBl objLeaveApplyBl = new LeaveApplyBl();
LeaveApplyBo objLeaveApplyBo = new LeaveApplyBo();
LeaveApprovalBo objLeaveApprovalBo = new LeaveApprovalBo();
LeaveApprovalBl objLeaveApprovalBl = new LeaveApprovalBl();
ApplicationResult objResult = new ApplicationResult();
double dbTotalDays = 0.0;
foreach (GridViewRow row in gvLeave.Rows)
{
if (((CheckBox)row.FindControl("cbHalfDay")).Checked)
{
dbTotalDays += 0.5;
}
else
{
dbTotalDays += 1;
}
}
objLeaveApplyBo.FromDate = txtFromDate.Text;
objLeaveApplyBo.ToDate = txtToDate.Text;
objLeaveApplyBo.Reason = txtReason.Text.Trim();
objLeaveApplyBo.EmployeeMID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveApplyBo.TotalDays = Convert.ToDouble(dbTotalDays);
objLeaveApplyBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveApplyBo.CreatedDate = DateTime.UtcNow.AddDays(5.5).ToString();
objLeaveApplyBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveApplyBo.LastModifiedDate = DateTime.UtcNow.AddDays(5.5).ToString();
DatabaseTransaction.OpenConnectionTransation();
int intLeaveApplyID = 0;
objResult = objLeaveApplyBl.LeaveApply_Insert(objLeaveApplyBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
//ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>");
//ClearAll();
if ((objResult.resultDT.Rows[0]["LeaveApplylID"].ToString()) != "")
{
intLeaveApplyID = Convert.ToInt32(objResult.resultDT.Rows[0]["LeaveApplylID"].ToString());
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You have already apply leave between this dates.');</script>");
return;
}
}
int a = 0;
int b = 0;
foreach (GridViewRow row in gvLeave.Rows)
{
a += 1;
objLeaveApprovalBo.LeaveApplyID = intLeaveApplyID;
objLeaveApprovalBo.ApplyDate = (((TextBox)row.FindControl("txtGridDates")).Text);
objLeaveApprovalBo.LeaveID = Convert.ToInt32((((DropDownList)row.FindControl("ddlLeaveType")).SelectedValue));
objLeaveApprovalBo.IsHalfDay = Convert.ToInt32((((CheckBox)row.FindControl("cbHalfDay")).Checked));
objLeaveApprovalBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveApprovalBo.CreatedDate = DateTime.UtcNow.AddDays(5.5).ToString();
objLeaveApprovalBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID]);
objLeaveApprovalBo.LastModifiedDate = DateTime.UtcNow.AddDays(5.5).ToString();
var objResultApproval = objLeaveApprovalBl.LeaveApproval_Insert(objLeaveApprovalBo);
if (objResultApproval != null)
{
if (objResultApproval.status == ApplicationResult.CommonStatusType.SUCCESS)
{
b += 1;
}
}
}
if (a == b)
{
DatabaseTransaction.CommitTransation();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>");
ClearAll();
PanelVisibilityMode(1);
divLeaveApprove.Visible = true;
divDate.Visible = false;
BindApplyLeave();
}
}
catch (Exception ex)
{
DatabaseTransaction.RollbackTransation();
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
finally
{
DatabaseTransaction.connection.Close();
}
}
protected void btnSave_OnClick(object sender, EventArgs e)
{
try
{
LeaveApprovalBo objLeaveApprovalBo = new LeaveApprovalBo();
LeaveApprovalBl objLeaveApprovalBl = new LeaveApprovalBl();
LeaveApplyBl objLeaveApplyBl = new LeaveApplyBl();
LeaveApplyBo objLeaveApplyBo = new LeaveApplyBo();
ApplicationResult objResult = new ApplicationResult();
int a = 0;
int b = 0;
if (ViewState["Mode"].ToString() == "Approve")
{
objLeaveApplyBo.LeaveApplylID = Convert.ToInt32(ViewState["LeaveApplyID"].ToString());
objLeaveApplyBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID].ToString());
objLeaveApplyBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
DatabaseTransaction.OpenConnectionTransation();
objResult = objLeaveApplyBl.LeaveApply_Update_ForApproval(objLeaveApplyBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
}
foreach (GridViewRow row in gvLeave.Rows)
{
a += 1;
objLeaveApprovalBo.LeaveApprovalID =
Convert.ToInt32(((Label)row.FindControl("lblLeaveApprovalID")).Text);
objLeaveApprovalBo.NAReason = txtReason.Text;
objLeaveApprovalBo.LastModifiedBy =
Convert.ToInt32(Session[ApplicationSession.USERID].ToString());
objLeaveApprovalBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
if (((CheckBox)row.FindControl("cbApprove")).Checked)
{
objResult = objLeaveApprovalBl.LeaveApproval_Update_ForApproval(objLeaveApprovalBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
b += 1;
}
}
else
{
objResult = objLeaveApprovalBl.LeaveApproval_Update_ForReject(objLeaveApprovalBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
b += 1;
}
}
}
if (a == b)
{
DatabaseTransaction.transaction.Commit();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Leave application has been successfully approved or rejected.');</script>");
ClearAll();
PanelVisibility(1);
}
else
{
DatabaseTransaction.RollbackTransation();
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objLeaveApplyBo.LeaveApplylID = Convert.ToInt32(ViewState["LeaveApplyID"].ToString());
objLeaveApplyBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID].ToString());
objLeaveApplyBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
DatabaseTransaction.OpenConnectionTransation();
objResult = objLeaveApplyBl.LeaveApply_Update_ForApproval(objLeaveApplyBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
}
foreach (GridViewRow row in gvLeave.Rows)
{
a += 1;
objLeaveApprovalBo.LeaveApprovalID =
Convert.ToInt32(((Label)row.FindControl("lblLeaveApprovalID")).Text);
objLeaveApprovalBo.NAReason = txtReason.Text;
objLeaveApprovalBo.LastModifiedBy =
Convert.ToInt32(Session[ApplicationSession.USERID].ToString());
objLeaveApprovalBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
if (((CheckBox)row.FindControl("cbApprove")).Checked)
{
objResult = objLeaveApprovalBl.LeaveApproval_Update_ForApproval(objLeaveApprovalBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
b += 1;
}
}
else
{
objResult = objLeaveApprovalBl.LeaveApproval_Update_ForReject(objLeaveApprovalBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
b += 1;
}
}
}
if (a == b)
{
DatabaseTransaction.transaction.Commit();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Leave application has been successfully Updated.');</script>");
ClearAll();
PanelVisibility(1);
}
else
{
DatabaseTransaction.RollbackTransation();
}
}
}
catch (Exception ex)
{
DatabaseTransaction.RollbackTransation();
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
finally
{
DatabaseTransaction.connection.Close();
}
}
protected void gvRole_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
LeaveApplyBl objLeaveApplyBl = new LeaveApplyBl();
if (e.CommandName.ToString() == "Edit1")
{
if (ddlStatus.SelectedValue != "0")
{
ViewState["LeaveApplyID"] = e.CommandArgument.ToString();
objResult =
objLeaveApplyBl.LeaveApply_Select_ForApprove(Convert.ToInt32(e.CommandArgument.ToString()));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
DataTable dt = new DataTable();
dt.Rows.Clear();
dt.Columns.Add("NO");
for (var i = 1; i <= objResult.resultDT.Rows.Count; i++)
{
dt.Rows.Add(this.ToString());
}
gvLeave.DataSource = dt;
gvLeave.DataBind();
BindLeaveType();
for (var i = 0; i < gvLeave.Rows.Count; i++)
{
if (
objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_ISAPPROVED].ToString() ==
"1")
{
((CheckBox)(gvLeave.Rows[i].Cells[1].FindControl("cbApprove"))).Checked = true;
}
else if (objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_ISAPPROVED].ToString() ==
"2")
{
((CheckBox)(gvLeave.Rows[i].Cells[1].FindControl("cbApprove"))).Checked = false;
}
((Label)(gvLeave.Rows[i].Cells[0].FindControl("lblLeaveApprovalID"))).Text =
objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_LEAVEAPPROVALID]
.ToString();
((TextBox)(gvLeave.Rows[i].Cells[2].FindControl("txtGridDates"))).Text =
objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_APPLYDATE].ToString();
((DropDownList)(gvLeave.Rows[i].Cells[4].FindControl("ddlLeaveType")))
.SelectedValue =
objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_LEAVEID].ToString();
if (
objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_ISHALFDAY].ToString() ==
"1")
{
((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Checked = true;
}
else
{
((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Checked = false;
}
((TextBox)(gvLeave.Rows[i].Cells[2].FindControl("txtGridDates"))).Enabled = false;
((DropDownList)(gvLeave.Rows[i].Cells[4].FindControl("ddlLeaveType"))).Enabled =
false;
((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Enabled = false;
}
ViewState["Mode"] = "Edit";
PanelVisibility(4);
}
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('This leave has not approved yet,You can not edit.');</script>");
}
}
else if (e.CommandName.ToString() == "Approve1")
{
if (ddlStatus.SelectedValue.ToString() != "1")
{
#region Bind Leave Balance
GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer;
int rowIndex = gvr.RowIndex;
int empid = Convert.ToInt32(gvLeaveApprove.Rows[rowIndex].Cells[1].Text);
LeaveBl objLeaveBl = new LeaveBl();
objResult =
objLeaveBl.Leave_Select_ForBalance(empid);//Convert.ToInt32(Session[ApplicationSession.USERID].ToString()) + <%# Eval("EmployeeMID") %>
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
gvLeaveBalance.DataSource = objResult.resultDT;
gvLeaveBalance.DataBind();
}
}
#endregion
//objLeaveApprovalBo.EmployeeMID = Convert.ToInt32(e.CommandArgument.ToString());
ViewState["LeaveApplyID"] = e.CommandArgument.ToString();
objResult =
objLeaveApplyBl.LeaveApply_Select_ForApprove(Convert.ToInt32(e.CommandArgument.ToString()));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
DataTable dt = new DataTable();
dt.Rows.Clear();
dt.Columns.Add("NO");
for (var i = 1; i <= objResult.resultDT.Rows.Count; i++)
{
dt.Rows.Add(this.ToString());
}
gvLeave.DataSource = dt;
gvLeave.DataBind();
BindLeaveType();
for (var i = 0; i < gvLeave.Rows.Count; i++)
{
((Label)(gvLeave.Rows[i].Cells[0].FindControl("lblLeaveApprovalID"))).Text =
objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_LEAVEAPPROVALID]
.ToString();
((TextBox)(gvLeave.Rows[i].Cells[2].FindControl("txtGridDates"))).Text =
objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_APPLYDATE].ToString();
((DropDownList)(gvLeave.Rows[i].Cells[4].FindControl("ddlLeaveType")))
.SelectedValue =
objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_LEAVEID].ToString();
if (
objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_ISHALFDAY].ToString() ==
"1")
{
((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Checked = true;
}
else
{
((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Checked = false;
}
((TextBox)(gvLeave.Rows[i].Cells[2].FindControl("txtGridDates"))).Enabled = false;
((DropDownList)(gvLeave.Rows[i].Cells[4].FindControl("ddlLeaveType"))).Enabled =
false;
((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Enabled = false;
}
ViewState["Mode"] = "Approve";
PanelVisibility(4);
}
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('This Leave has already approved.');</script>");
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
