public static ReturnObject DeleteEmployeeCategory(string current)
{
masters_employee_category page_object = new masters_employee_category();
DBConnection db_connection = new DBConnection();
Hashtable employee_category_hash_table = new Hashtable();
ReturnObject return_object = new ReturnObject();
string query = string.Empty;
string employee_category_code = string.Empty;
string company_code = string.Empty;
int count = 0;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
JObject current_data = JObject.Parse(current);
employee_category_code = current_data["employee_category_code"].ToString();
company_code = current_data["company_code"].ToString();
query = "select count(*) from employeemaster where emp_Employee_Category = '" + employee_category_code + "' and Emp_Status = '1' ";
count = db_connection.GetRecordCount(query);
if (count > 0)
{
return_object.status = "error";
return_object.return_data = "Employees have been assigned to this Employee Category. Please reassign the Employees and try again.";
}
else
{
employee_category_hash_table.Add("mode", "D");
employee_category_hash_table.Add("EmpCategoryCode", employee_category_code);
employee_category_hash_table.Add("CompanyCode", company_code);
db_connection.ExecuteStoredProcedureWithHashtable_WithoutReturn("ManipulateGradeMaster1", employee_category_hash_table);
return_object.status = "success";
return_object.return_data = "Employee Category deleted successfully!";
}
}
catch (Exception ex)
{
Logger.LogException(ex, page, "DELETE_EMPLOYEE_CATEGORY");
return_object.status = "error";
return_object.return_data = "An error occurred while deleting this Employee Category. Please try again. If the error persists, please contact Support.";
throw;
}
}
return(return_object);
}
public static ReturnObject GetCompanyData()
{
masters_employee_category page_object = new masters_employee_category();
DataTable company_data = new DataTable();
DBConnection db_connection = new DBConnection();
ReturnObject return_object = new ReturnObject();
string query = string.Empty, employee_id = string.Empty, company_code = string.Empty;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
employee_id = HttpContext.Current.Session["username"].ToString();
//load company list as per employee
if (employee_id != "admin")
{
query = "select emp_company from EmployeeMaster where Emp_Code='" + employee_id + "'";
company_code = db_connection.ExecuteQuery_WithReturnValueString(query);
query = "select CompanyCode as company_code, CompanyName as company_name from CompanyMaster where CompanyCode='" + company_code + "' order by CompanyName ";
}
else
{
query = "select CompanyCode as company_code, CompanyName as company_name from CompanyMaster";
}
company_data = db_connection.ReturnDataTable(query);
return_object.status = "success";
return_object.return_data = JsonConvert.SerializeObject(company_data, Formatting.Indented);
}
catch (Exception ex)
{
Logger.LogException(ex, page, "GET_COMPANY_DATA");
return_object.status = "error";
return_object.return_data = "An error occurred while loading Company Data. Please try again. If the error persists, please contact Support.";
throw;
}
}
return(return_object);
}
public static ReturnObject GetEmployeeCategoryData(int page_number, bool is_filter, string filters)
{
masters_employee_category page_object = new masters_employee_category();
DBConnection db_connection = new DBConnection();
DataTable employeeCategory_data_table = new DataTable();
ReturnObject return_object = new ReturnObject();
int start_row = (page_number - 1) * 30;
int number_of_record = page_number * 30 + 1;
string query = string.Empty;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
query = page_object.GetBaseQuery();
if (is_filter)
{
query = page_object.GetFilterQuery(filters, query);
}
query += " ) a where row > " + start_row + " and row < " + number_of_record;
employeeCategory_data_table = db_connection.ReturnDataTable(query);
return_object.status = "success";
return_object.return_data = JsonConvert.SerializeObject(employeeCategory_data_table, Formatting.Indented);
}
catch (Exception ex)
{
Logger.LogException(ex, page, "GET_EMPLOYEE_CATEGORY_DATA");
return_object.status = "error";
return_object.return_data = "An error occurred while loading Employee Category data. Please try again. If the error persists, please contact Support.";
throw;
}
}
return(return_object);
}
public static ReturnObject DoExport(string filters, bool is_filter)
{
masters_employee_category page_object = new masters_employee_category();
ReturnObject return_object = new ReturnObject();
DBConnection db_connection = new DBConnection();
DataTable branch_data = new DataTable();
DateTime now = DateTime.Now;
int export_limit = Convert.ToInt32(ConfigurationManager.AppSettings["EXPORT_LIMIT"]);
string[] column_names = new string[] { };
string
query = string.Empty, file_name = string.Empty;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
query = page_object.GetBaseQuery();
if (is_filter)
{
query += page_object.GetFilterQuery(filters, query);
}
query += " ) a where row > 0 and row < " + export_limit;
branch_data = db_connection.ReturnDataTable(query);
if (branch_data.Rows.Count > 0)
{
file_name = page_object.CreateExport(branch_data);
return_object.status = "success";
return_object.return_data = file_name;
}
else
{
return_object.status = "info";
return_object.return_data = "No data found with the selected filters. Please try again with different filters.";
}
}
catch (Exception ex)
{
Logger.LogException(ex, page, "GET_DATA_FOR_EXPORT");
return_object.status = "error";
return_object.return_data = "An error occurred while generating your report. Please try again. If the error persists, please contact Support.";
throw;
}
finally
{
page_object.Dispose();
}
}
return(return_object);
}
public static ReturnObject EditEmployeeCategory(string current, string previous)
{
masters_employee_category page_object = new masters_employee_category();
DBConnection db_connection = new DBConnection();
ReturnObject return_object = new ReturnObject();
string original_employee_category_name = string.Empty;
string employee_category_code = string.Empty;
string employee_category_name = string.Empty;
string company_code = string.Empty;
string total_hours = string.Empty;
int process = 0;
int count = 0;
if (HttpContext.Current.Session["username"] == null) // checking session expired or not
{
return_object = page_object.DoLogout();
}
else
{
try
{
JObject current_data = JObject.Parse(current);
employee_category_code = current_data["employee_category_code"].ToString();
employee_category_name = current_data["employee_category_name"].ToString();
company_code = current_data["company_code"].ToString();
total_hours = current_data["total_hours"].ToString();
process = Convert.ToInt32(current_data["process"]);
JObject previous_data = JObject.Parse(previous);
original_employee_category_name = previous_data["employee_category_name"].ToString();
if (original_employee_category_name != employee_category_name)
{
count = page_object.CheckEmployeeCategoryName(employee_category_name, company_code);
if (count > 0)
{
return_object.status = "error";
return_object.return_data = "Employee Category Name has been taken. Please try again with a different Name.";
return(return_object);
}
}
page_object.UpdateDatabase("U", employee_category_code, employee_category_name, company_code, total_hours, process);
return_object.status = "success";
return_object.return_data = "Employee Category edited successfully!";
}
catch (Exception ex)
{
Logger.LogException(ex, page, "EDIT_EMPLOYEE_CATEGORY");
return_object.status = "error";
return_object.return_data = "An error occurred while saving the Employee Category. Please try again. If the error persists, please contact Support.";
throw;
}
finally
{
page_object.Dispose();
}
}
return(return_object);
}
