/// <summary> /// To Delete details of LeaveTemplate for selected LeaveTemplateID from tbl_LeaveTemplate table /// Created By : Nirmal, 09-02-2016 /// Modified By : /// </summary> public ApplicationResult LeaveTemplate_Delete(LeaveTemplateBo objLeaveTemplateBo) { try { pSqlParameter = new SqlParameter[3]; pSqlParameter[0] = new SqlParameter("@LeaveID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objLeaveTemplateBo.LeaveID; pSqlParameter[1] = new SqlParameter("@EmployeeMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objLeaveTemplateBo.EmployeeMID; pSqlParameter[2] = new SqlParameter("@AcademicYear", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objLeaveTemplateBo.AcademicYear; strStoredProcName = "usp_tbl_LeaveTemplate_Delete"; int iResult = DatabaseTransaction.ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcName, 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; } }
protected void btnSave_Click(object sender, EventArgs e) { try { LeaveTemplateBo objLeaveTemplateBo = new LeaveTemplateBo(); LeaveTemplateBl objLeaveTemplateBl = new LeaveTemplateBl(); ApplicationResult objResult = new ApplicationResult(); int k = 0; int intCount = 0; DatabaseTransaction.OpenConnectionTransation(); foreach (GridViewRow row in gvLeave.Rows) { objLeaveTemplateBo.EmployeeMID = Convert.ToInt32(hfEmployeeID.Value); objLeaveTemplateBo.LeaveID = Convert.ToInt32(row.Cells[0].Text); objLeaveTemplateBo.Total = (((TextBox)row.FindControl("txtTotalLeaves")).Text); objLeaveTemplateBo.AcademicYear = ddlYear.Text; objLeaveTemplateBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]); objLeaveTemplateBo.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objLeaveTemplateBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID]); objLeaveTemplateBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); if (((CheckBox)row.FindControl("chkChild")).Checked) { intCount += 1; if (objLeaveTemplateBo.Total == "0") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Please Fill Total Leaves " + row.Cells[0].Text + ".');</script>"); break; } else { objResult = objLeaveTemplateBl.LeaveTemplate_Insert(objLeaveTemplateBo); if (objResult != null) { k += 1; } } } else { objResult = objLeaveTemplateBl.LeaveTemplate_Delete(objLeaveTemplateBo); } } if (k == intCount) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Leave Template Updated Successfully.');</script>"); DatabaseTransaction.CommitTransation(); ClearAll(); gvLeave.Visible = false; } else { DatabaseTransaction.RollbackTransation(); //DatabaseTransaction.connection.Close(); } } 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>"); } }
/// <summary> /// To Update details of LeaveTemplate in tbl_LeaveTemplate table /// Created By : Nirmal, 09-02-2016 /// Modified By : /// </summary> public ApplicationResult LeaveTemplate_Update(LeaveTemplateBo objLeaveTemplateBo) { try { pSqlParameter = new SqlParameter[9]; pSqlParameter[0] = new SqlParameter("@LeaveTemplateID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objLeaveTemplateBo.LeaveTemplateID; pSqlParameter[1] = new SqlParameter("@EmployeeMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objLeaveTemplateBo.EmployeeMID; pSqlParameter[2] = new SqlParameter("@LeaveID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objLeaveTemplateBo.LeaveID; pSqlParameter[3] = new SqlParameter("@Total", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objLeaveTemplateBo.Total; pSqlParameter[4] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objLeaveTemplateBo.IsDeleted; pSqlParameter[5] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objLeaveTemplateBo.LastModifiedBy; pSqlParameter[6] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objLeaveTemplateBo.LastModifiedDate; sSql = "usp_tbl_LeaveTemplate_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 { objLeaveTemplateBo = null; } }