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