public static List <HolidayOfficewise> GetHolidayOfficewiseByOfficeIDandCalenderYear(int CalenderYear, int OfficeID, string searchText = "a", bool showDeleted = false) { try { DataTable HolidayOfficewiseRows = HolidayOfficewiseDataAccess.GetInstance.GetHolidayOfficewiseByOfficeIDandCalenderYear(CalenderYear, OfficeID, searchText, showDeleted); List <HolidayOfficewise> _HolidayOfficewiseList = new List <HolidayOfficewise>(); foreach (DataRow dr in HolidayOfficewiseRows.Rows) { HolidayOfficewise _HolidayOfficewise = new HolidayOfficewise(); _HolidayOfficewise.HolidayOfficewiseID = int.Parse(dr["HolidaysOfficewiseID"].ToString()); _HolidayOfficewise.HolidayID = int.Parse(dr["HolidayID"].ToString()); _HolidayOfficewise.DateOfOccasion = DateTime.Parse(dr["DateOfOccasion"].ToString()); _HolidayOfficewise.WeekDayOfOccasion = _HolidayOfficewise.DateOfOccasion.DayOfWeek.ToString(); _HolidayOfficewise.Occasion = dr["Occasion"].ToString(); _HolidayOfficewise.Office.OfficeID = int.Parse(dr["OfficeID"].ToString()); _HolidayOfficewise.IsActive = Boolean.Parse(dr["IsActive"].ToString()); _HolidayOfficewise.IsDeleted = Boolean.Parse(dr["IsDeleted"].ToString()); _HolidayOfficewiseList.Add(_HolidayOfficewise); } return(_HolidayOfficewiseList); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public int UpdateHolidayOfficewise(HolidayOfficewise _HolidayOfficewise) { try { int ReturnValue = 0; SqlCommand SqlCmd = new SqlCommand(); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; SqlCmd.Parameters.Add(GetParameter("HolidaysOfficewiseID", SqlDbType.Int, _HolidayOfficewise.HolidayOfficewiseID)); SqlCmd.Parameters.Add(GetParameter("@HolidayID", SqlDbType.Int, _HolidayOfficewise.HoliDay.HolidayID)); SqlCmd.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID)); SqlCmd.Parameters.Add(GetParameter("@IsActive", SqlDbType.Bit, (_HolidayOfficewise.IsActive == true?1:0))); SqlCmd.Parameters.Add(GetParameter("@IsDeleted", SqlDbType.Bit, (_HolidayOfficewise.IsActive == true ? 0 : 1))); SqlCmd.Parameters.Add(GetParameter("@DateModified", SqlDbType.DateTime, DateTime.Now)); SqlCmd.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); SqlCmd.CommandText = "pHRM_HolidaysOfficewise_Update"; ExecuteStoredProcedure(SqlCmd); ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString()); return(ReturnValue); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public int InsertHolidayOfficewise(HolidayOfficewise _HolidayOfficewise) { try { int ReturnValue = 0; SqlCommand SqlCmd = new SqlCommand(); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; SqlCmd.Parameters.Add(GetParameter("@HolidayID", SqlDbType.Int, _HolidayOfficewise.HolidayID)); SqlCmd.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID)); SqlCmd.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); SqlCmd.CommandText = "pHRM_HolidaysOfficewise_Insert"; ExecuteStoredProcedure(SqlCmd); ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString()); return(ReturnValue); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public static int UpdateHolidayOfficewise(HolidayOfficewise _HolidayOfficewise) { try { return(HolidayOfficewiseDataAccess.GetInstance.UpdateHolidayOfficewise(_HolidayOfficewise)); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public int InsertHolidayOfficewise(HolidayOfficewise _HolidayOfficewise) { try { return(HolidayOfficewiseIntegration.InsertHolidayOfficewise(_HolidayOfficewise)); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
protected void btn_Apply_Click(object sender, EventArgs e) { int result = (int)MicroEnums.DataOperationResult.Failure; HolidayOfficewise ObjHoli = new HolidayOfficewise(); List <HolidayOfficewise> thisHolidayOfficewiseList = new List <HolidayOfficewise>(); foreach (GridViewRow therow in gview_HolidaySelect.Rows) { HolidayOfficewise thisHolidayOfficewise = new HolidayOfficewise(); CheckBox chkb = (CheckBox)therow.FindControl("chk_Add"); Label theOfficelabel = (Label)therow.FindControl("lbl_HolidayOfficeId"); if (int.Parse(theOfficelabel.Text) == 0) { if (chkb.Checked) { ObjHoli.HolidayID = int.Parse(therow.Cells[2].Text); result = HolidayOfficewiseManagement.GetInstance.InsertHolidayOfficewise(ObjHoli); lbl_TheMessage.Text = GetDataOperationResult(result, "Holiday", MicroEnums.DataOperation.AddNew); } } else if (int.Parse(theOfficelabel.Text) != 0) { ObjHoli.HolidayID = int.Parse(therow.Cells[2].Text); if (!chkb.Checked) { ObjHoli.IsActive = false; } else { ObjHoli.IsActive = true; } ObjHoli.HolidayOfficewiseID = int.Parse(theOfficelabel.Text); result = HolidayOfficewiseManagement.GetInstance.UpdateHolidayOfficewise(ObjHoli); lbl_TheMessage.Text = GetDataOperationResult(result, "Holiday", MicroEnums.DataOperation.Edit); } } if (!string.IsNullOrEmpty(lbl_TheMessage.Text)) { dialog_Message.Show(); } }