/// <summary> /// To Update details of LeaveApproval in tbl_LeaveApproval table /// Created By : Nirmal, 11-02-2016 /// Modified By : /// </summary> public ApplicationResult LeaveApproval_Update_ForReject(LeaveApprovalBo objLeaveApprovalBo) { try { pSqlParameter = new SqlParameter[4]; pSqlParameter[0] = new SqlParameter("@LeaveApprovalID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objLeaveApprovalBo.LeaveApprovalID; pSqlParameter[1] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objLeaveApprovalBo.LastModifiedBy; pSqlParameter[2] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objLeaveApprovalBo.LastModifiedDate; pSqlParameter[3] = new SqlParameter("@NAReason", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objLeaveApprovalBo.NAReason; sSql = "usp_tbl_LeaveApproval_Update_ForReject"; 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 { objLeaveApprovalBo = 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 Insert details of LeaveApproval in tbl_LeaveApproval table /// Created By : Nirmal, 11-02-2016 /// Modified By : /// </summary> public ApplicationResult LeaveApproval_Insert(LeaveApprovalBo objLeaveApprovalBo) { try { pSqlParameter = new SqlParameter[8]; pSqlParameter[0] = new SqlParameter("@LeaveApplyID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objLeaveApprovalBo.LeaveApplyID; pSqlParameter[1] = new SqlParameter("@ApplyDate", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objLeaveApprovalBo.ApplyDate; pSqlParameter[2] = new SqlParameter("@LeaveID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objLeaveApprovalBo.LeaveID; pSqlParameter[3] = new SqlParameter("@IsHalfDay", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objLeaveApprovalBo.IsHalfDay; pSqlParameter[4] = new SqlParameter("@CreatedBy", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objLeaveApprovalBo.CreatedBy; pSqlParameter[5] = new SqlParameter("@CreatedDate", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objLeaveApprovalBo.CreatedDate; pSqlParameter[6] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objLeaveApprovalBo.LastModifiedBy; pSqlParameter[7] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objLeaveApprovalBo.LastModifiedDate; sSql = "usp_tbl_LeaveApproval_Insert"; int dtResult = DatabaseTransaction.ExecuteNonQuery(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 { objLeaveApprovalBo = null; } }