/// <summary>
/// To Update details of LeaveApply in tbl_LeaveApply table
/// Created By : Nirmal, 11-02-2016
/// Modified By :
/// </summary>
public ApplicationResult LeaveApply_Update_ForApproval(LeaveApplyBo objLeaveApplyBo)
{
try
{
pSqlParameter = new SqlParameter[3];
pSqlParameter[0] = new SqlParameter("@LeaveApplylID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objLeaveApplyBo.LeaveApplylID;
pSqlParameter[1] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objLeaveApplyBo.LastModifiedBy;
pSqlParameter[2] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objLeaveApplyBo.LastModifiedDate;
sSql = "usp_tbl_LeaveApply_Update_ForApproval";
int iResult = DatabaseTransaction.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objLeaveApplyBo = null;
}
}
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();
}
}
/// <summary>
/// To Update details of LeaveApply in tbl_LeaveApply table
/// Created By : Nirmal, 11-02-2016
/// Modified By :
/// </summary>
public ApplicationResult LeaveApply_Update(LeaveApplyBo objLeaveApplyBo)
{
try
{
pSqlParameter = new SqlParameter[13];
pSqlParameter[0] = new SqlParameter("@LeaveApplylID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objLeaveApplyBo.LeaveApplylID;
pSqlParameter[1] = new SqlParameter("@EmployeeMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objLeaveApplyBo.EmployeeMID;
pSqlParameter[2] = new SqlParameter("@FromDate", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objLeaveApplyBo.FromDate;
pSqlParameter[3] = new SqlParameter("@ToDate", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objLeaveApplyBo.ToDate;
pSqlParameter[4] = new SqlParameter("@Reason", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objLeaveApplyBo.Reason;
pSqlParameter[5] = new SqlParameter("@ApprovedBy", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objLeaveApplyBo.ApprovedBy;
pSqlParameter[6] = new SqlParameter("@ApprovedDate", SqlDbType.VarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objLeaveApplyBo.ApprovedDate;
pSqlParameter[7] = new SqlParameter("@TotalDays", SqlDbType.Float);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objLeaveApplyBo.TotalDays;
pSqlParameter[8] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objLeaveApplyBo.IsDeleted;
pSqlParameter[9] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objLeaveApplyBo.LastModifiedBy;
pSqlParameter[10] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objLeaveApplyBo.LastModifiedDate;
sSql = "usp_tbl_LeaveApply_Update";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objLeaveApplyBo = null;
}
}
/// <summary>
/// To Insert details of LeaveApply in tbl_LeaveApply table
/// Created By : Nirmal, 11-02-2016
/// Modified By :
/// </summary>
public ApplicationResult LeaveApply_Insert(LeaveApplyBo objLeaveApplyBo)
{
try
{
pSqlParameter = new SqlParameter[9];
pSqlParameter[0] = new SqlParameter("@EmployeeMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objLeaveApplyBo.EmployeeMID;
pSqlParameter[1] = new SqlParameter("@FromDate", SqlDbType.VarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objLeaveApplyBo.FromDate;
pSqlParameter[2] = new SqlParameter("@ToDate", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objLeaveApplyBo.ToDate;
pSqlParameter[3] = new SqlParameter("@Reason", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objLeaveApplyBo.Reason;
pSqlParameter[4] = new SqlParameter("@TotalDays", SqlDbType.Float);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objLeaveApplyBo.TotalDays;
pSqlParameter[5] = new SqlParameter("@CreatedBy", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objLeaveApplyBo.CreatedBy;
pSqlParameter[6] = new SqlParameter("@CreatedDate", SqlDbType.VarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objLeaveApplyBo.CreatedDate;
pSqlParameter[7] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objLeaveApplyBo.LastModifiedBy;
pSqlParameter[8] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objLeaveApplyBo.LastModifiedDate;
sSql = "usp_tbl_LeaveApply_Insert";
DataTable dtResult = new DataTable();
dtResult = DatabaseTransaction.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter);
ApplicationResult objResults = new ApplicationResult(dtResult);
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
//int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
//if (iResult > 0)
//{
// ApplicationResult objResults = new ApplicationResult();
// objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
// return objResults;
//}
//else
//{
// ApplicationResult objResults = new ApplicationResult();
// objResults.status = ApplicationResult.CommonStatusType.FAILURE;
// return objResults;
//}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objLeaveApplyBo = null;
}
}
