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();
}
}
