public static ReturnObject DeleteHolidayGroup(string current) { masters_holiday_group page_object = new masters_holiday_group(); DBConnection db_connection = new DBConnection(); ReturnObject return_object = new ReturnObject(); string company_code = string.Empty; string holiday_group_code = string.Empty; string holiday_group_name = string.Empty; string query = string.Empty; try { JObject current_data = JObject.Parse(current); holiday_group_code = current_data["holiday_group_code"].ToString(); company_code = current_data["company_code"].ToString(); query = "select count(*) from BranchMaster where HolidayCode='" + holiday_group_code + "'"; if (db_connection.RecordExist(query)) { return_object.status = "error"; return_object.return_data = "This Holiday Group has been mapped to a Branch. Please delete or reassign the Branch."; } else if (db_connection.GetRecordCount("select count(*) from HolidayMaster where holgrpcode = '" + holiday_group_code + "' ") > 0) { return_object.status = "error"; return_object.return_data = "Holidays have been assigned to this Holiday Group. Please delete or unassign the holidays and try again."; } else { page_object.UpdateDatabase("", "", company_code, holiday_group_code, "D", ""); return_object.status = "success"; return_object.return_data = "Holiday Group deleted successfully!"; } } catch (Exception ex) { Logger.LogException(ex, page, "DELETE_HOLIDAY_GROUP"); return_object.status = "error"; return_object.return_data = "An error occurred while deleting the Holiday Group. Please try again. If the error persists, please contact Support."; throw; } finally { page_object.Dispose(); } return(return_object); }
public static ReturnObject EditHolidayGroup(string current, string previous) { masters_holiday_group page_object = new masters_holiday_group(); DBConnection db_connection = new DBConnection(); ReturnObject return_object = new ReturnObject(); string query = string.Empty; string original_holiday_group_code = string.Empty; string original_holiday_group_name = string.Empty; string holiday_group_code = string.Empty; string holiday_group_name = string.Empty; string company_code = string.Empty; string max_days = string.Empty; int count = 0; try { JObject current_data = JObject.Parse(current); holiday_group_code = current_data["holiday_group_code"].ToString(); holiday_group_name = current_data["holiday_group_name"].ToString(); company_code = current_data["company_code"].ToString(); max_days = current_data["max_days"].ToString(); original_holiday_group_code = holiday_group_code; query = "select count(holname) As Count from HolidayMaster Where holgrpcode = '" + holiday_group_code + "' and holtype = 'Restricted' and holyear = year(getdate())"; count = db_connection.ExecuteQuery_WithReturnValueInteger(query); if (Convert.ToInt32(max_days) < count) { return_object.status = "error"; return_object.return_data = "Please check restricted Holiday count in the Holiday List"; } else { JObject previous_data = JObject.Parse(previous); original_holiday_group_name = previous_data["holiday_group_name"].ToString(); if (original_holiday_group_name != holiday_group_name) { count = page_object.CheckHolidayGroupName(holiday_group_name, company_code); if (count > 0) { return_object.status = "error"; return_object.return_data = "Holiday Group Name has been taken. Please try again with a different Name."; return(return_object); } } page_object.UpdateDatabase(holiday_group_code, holiday_group_name, company_code, original_holiday_group_code, "U", max_days); return_object.status = "success"; return_object.return_data = "Holiday Group edited successfully!"; } } catch (Exception ex) { Logger.LogException(ex, page, "EDIT_HOLIDAY_GROUP"); return_object.status = "error"; return_object.return_data = "An error occurred while editing Holiday Group details. Please try again. If the error persists, please contact Support."; throw; } finally { page_object.Dispose(); } return(return_object); }
public static ReturnObject AddHolidayGroup(string current) { masters_holiday_group page_object = new masters_holiday_group(); DBConnection db_connection = new DBConnection(); ReturnObject return_object = new ReturnObject(); string original_holiday_group_code = string.Empty; string holiday_group_code = string.Empty; string holiday_group_name = string.Empty; string company_code = string.Empty; string message = string.Empty; string max_days = string.Empty; int count = 0; try { JObject current_data = JObject.Parse(current); original_holiday_group_code = "hol"; holiday_group_code = current_data["holiday_group_code"].ToString(); holiday_group_name = current_data["holiday_group_name"].ToString(); company_code = current_data["company_code"].ToString(); max_days = current_data["max_days"].ToString(); count = page_object.CheckHolidayGroupCode(holiday_group_code); if (count > 0) { return_object.status = "error"; return_object.return_data = "Holiday Group Code has been taken. Please try again with a different Code."; return(return_object); } count = page_object.CheckHolidayGroupName(holiday_group_name, company_code); if (count > 0) { return_object.status = "error"; return_object.return_data = "Holiday Group Name has been taken. Please try again with a different Name."; return(return_object); } page_object.UpdateDatabase(holiday_group_code, holiday_group_name, company_code, "hol", "I", max_days); return_object.status = "success"; return_object.return_data = "Holiday Group added successfully!"; } catch (Exception ex) { Logger.LogException(ex, page, "ADD_HOLIDAY_GROUP"); return_object.status = "error"; return_object.return_data = "An error occurred while adding a new Holiday Group. Please try again. If the error persists, please contact Support."; throw; } finally { page_object.Dispose(); } return(return_object); }