public static ReturnObject DoExport() { masters_company page_object = new masters_company(); ReturnObject return_object = new ReturnObject(); DBConnection db_connection = new DBConnection(); DataTable company_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; try { query = "select TOP " + export_limit + " * from CompanyMaster"; company_data = db_connection.ReturnDataTable(query); if (company_data.Rows.Count > 0) { file_name = page_object.CreateExport(company_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 GetCompanyData(int page_number) { masters_company page_object = new masters_company(); string employee_id, query, company_code = string.Empty; DBConnection db_connection = new DBConnection(); DataTable company_data = new DataTable(); ReturnObject return_object = new ReturnObject(); int start_row = (page_number - 1) * 30; int number_of_rows = page_number * 30 + 1; try { employee_id = HttpContext.Current.Session["employee_id"].ToString(); // if employee is logged in then showing only that employee company data ( done for royal group client first then implemnted in standard as well ) if (employee_id != "") { query = "select emp_company from employeemaster where emp_code='" + employee_id + "'"; company_code = db_connection.ExecuteQuery_WithReturnValueString(query); query = "select * FROM (select *, ROW_NUMBER() OVER (ORDER BY CompanyCode) as row FROM CompanyMaster where companycode = '" + company_code + "' "; // a where row > " + start_row + " and row < " + number_of_rows; } else { query = "select * FROM (select *, ROW_NUMBER() OVER (ORDER BY CompanyCode) as row FROM CompanyMaster"; } query += " ) a where row > " + start_row + " and row < " + number_of_rows; company_data = db_connection.ReturnDataTable(query); company_data = page_object.SetColumnNames(company_data); 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 performing this operation. Please try again. If the error persists, please contact Support."; throw; } return(return_object); }
public static ReturnObject EditCompany(string current, string previous) { masters_company page_object = new masters_company(); ReturnObject return_object = new ReturnObject(); string previous_company_name = string.Empty, company_name = string.Empty, company_code = string.Empty, address = string.Empty, phone = string.Empty, fax = string.Empty, email = string.Empty, pin = string.Empty, url = string.Empty, message = string.Empty; int count = 0; try { JObject current_data = JObject.Parse(current); company_name = current_data["company_name"].ToString(); company_code = current_data["company_code"].ToString(); address = current_data["company_address"].ToString(); phone = current_data["phone_number"].ToString(); fax = current_data["fax_number"].ToString(); email = current_data["email_address"].ToString(); pin = current_data["pin_code"].ToString(); url = current_data["website"].ToString(); JObject previous_data = JObject.Parse(previous); previous_company_name = previous_data["company_name"].ToString(); if (previous_company_name != company_name) { count = page_object.CheckCompanyName(company_name); if (count > 0) { return_object.status = "error"; return_object.return_data = "Company Name has been taken. Please try again with a different Name."; return(return_object); } } page_object.UpdateDatabase(company_code, company_name, address, phone, fax, email, pin, url, "U"); return_object.status = "success"; return_object.return_data = "Company edited successfully!"; } catch (Exception ex) { Logger.LogException(ex, page, "EDIT_COMPANY"); return_object.status = "error"; return_object.return_data = "An error occurred while editing Company details. Please try again. If the error persists, please contact Support."; throw; } finally { page_object.Dispose(); } return(return_object); }
public static ReturnObject DeleteCompany(string current) { masters_company page_object = new masters_company(); DBConnection db_connection = new DBConnection(); ReturnObject return_object = new ReturnObject(); int employee_count = 0; int branch_count = 0; int department_count = 0; int designation_count = 0; int employee_category_count = 0; int holiday_list_count = 0; int holiday_group_count = 0; string query = string.Empty; string company_code = string.Empty; string company_name = string.Empty; string address = string.Empty; string phone = string.Empty; string fax = string.Empty; string email = string.Empty; string pin = string.Empty; string url = string.Empty; try { JObject current_data = JObject.Parse(current); company_name = current_data["company_name"].ToString(); company_code = current_data["company_code"].ToString(); address = current_data["company_address"].ToString(); phone = current_data["phone_number"].ToString(); fax = current_data["fax_number"].ToString(); email = current_data["email_address"].ToString(); pin = current_data["pin_code"].ToString(); url = current_data["website"].ToString(); query = "select count (*) from EmployeeMaster where Emp_Company='" + company_code + "'"; employee_count = db_connection.GetRecordCount(query); if (employee_count > 0) { return_object.status = "error"; return_object.return_data = "Employees have been mapped to this Company. Please delete or reassign the employees."; return(return_object); } query = "select count (*) from DeptMaster where CompanyCode='" + company_code + "'"; department_count = db_connection.GetRecordCount(query); if (department_count > 0) { return_object.status = "error"; return_object.return_data = "Departments have been mapped to this Company. Please delete or reassign the departments."; return(return_object); } query = "select count (*) from BranchMaster where CompanyCode='" + company_code + "'"; branch_count = db_connection.GetRecordCount(query); if (branch_count > 0) { return_object.status = "error"; return_object.return_data = "Branches have been mapped to this Company. Please delete or reassign the branches."; return(return_object); } query = "select count (*) from DesigMaster where CompanyCode='" + company_code + "'"; designation_count = db_connection.GetRecordCount(query); if (designation_count > 0) { return_object.status = "error"; return_object.return_data = "Designations have been mapped to this Company. Please delete or reassign the designations."; return(return_object); } query = "select count (*) from EmployeeCategoryMaster where CompanyCode='" + company_code + "'"; employee_category_count = db_connection.GetRecordCount(query); if (employee_category_count > 0) { return_object.status = "error"; return_object.return_data = "Employee Categories have been mapped to this Company. Please delete or reassign the categories."; return(return_object); } query = "select count (*) from HolidayMaster where CompanyCode = '" + company_code + "' "; holiday_list_count = db_connection.GetRecordCount(query); if (holiday_list_count > 0) { return_object.status = "error"; return_object.return_data = "Holidays have been mapped to this Company. Please delete or reassign the categories."; return(return_object); } query = "select count (*) from HolidayGroup where CompanyCode = '" + company_code + "' "; holiday_group_count = db_connection.GetRecordCount(query); if (holiday_group_count > 0) { return_object.status = "error"; return_object.return_data = "Holiday Groups have been mapped to this Company. Please delete or reassign the categories."; return(return_object); } //TODO: Add query to delete Shift Settings record page_object.UpdateDatabase(company_code, company_name, address, phone, fax, email, pin, url, "D"); query = "delete from Shift where CompanyCode='" + company_code + "'"; db_connection.ExecuteQuery_WithOutReturnValue(query); query = "delete from ShiftEmployee where EmpCompanyCode='" + company_code + "'"; db_connection.ExecuteQuery_WithOutReturnValue(query); query = "delete from LeaveMaster where CompanyCode='" + company_code + "'"; db_connection.ExecuteQuery_WithOutReturnValue(query); return_object.status = "success"; return_object.return_data = "Company deleted successfully!"; } catch (Exception ex) { Logger.LogException(ex, page, "DELETE_COMPANY"); return_object.status = "error"; return_object.return_data = "An error occurred while performing this operation. Please try again. If the error persists, please contact Support."; throw; } finally { page_object.Dispose(); } return(return_object); }
public static ReturnObject AddCompany(string current) { masters_company page_object = new masters_company(); ReturnObject return_object = new ReturnObject(); string company_name = string.Empty; string company_code = string.Empty; string address = string.Empty; string phone = string.Empty; string fax = string.Empty; string email = string.Empty; string pin = string.Empty; string url = string.Empty; string message = string.Empty; int count = 0; try { JObject current_data = JObject.Parse(current); company_name = current_data["company_name"].ToString(); company_code = current_data["company_code"].ToString(); address = current_data["company_address"].ToString(); phone = current_data["phone_number"].ToString(); fax = current_data["fax_number"].ToString(); email = current_data["email_address"].ToString(); pin = current_data["pin_code"].ToString(); url = current_data["website"].ToString(); count = page_object.CheckCompanyCode(company_code); if (count > 0) { return_object.status = "error"; return_object.return_data = "Company Code has been taken. Please try again with a different Code."; return(return_object); } count = page_object.CheckCompanyName(company_name); if (count > 0) { return_object.status = "error"; return_object.return_data = "Company Name has been taken. Please try again with a different Name."; return(return_object); } page_object.UpdateDatabase(company_code, company_name, address, phone, fax, email, pin, url, "I"); // creating default row for Shift Setting page_object.CreateShiftSetting(company_code); return_object.status = "success"; return_object.return_data = "Company added successfully!"; } catch (Exception ex) { Logger.LogException(ex, page, "ADD_COMPANY"); return_object.status = "error"; return_object.return_data = "An error occurred while adding a new Company. Please try again. If the error persists, please contact Support."; throw; } finally { page_object.Dispose(); } return(return_object); }