public static ReturnObject GetUserData(int page_number, bool is_filter, string filters) { user_account page_object = new user_account(); DBConnection db_connection = new DBConnection(); ReturnObject return_object = new ReturnObject(); DataTable user_data = new DataTable(); string query = string.Empty, user_id = string.Empty; int access_level = 0, start_row = (page_number - 1) * 30, number_of_rows = page_number * 30 + 1; try { user_id = HttpContext.Current.Session["username"].ToString(); if (user_id != "admin") { user_id = HttpContext.Current.Session["employee_id"].ToString(); } access_level = Convert.ToInt32(HttpContext.Current.Session["access_level"]); query = page_object.GetBaseQuery(); switch (access_level) { case 0: query += " and L.UserName!='admin' and L.Password!='admin' "; break; default: query += " and E.Emp_Code in (select distinct(Emp_Code) from EmployeeMaster where managerId='" + user_id + "' and Emp_Status=1) "; break; } query = page_object.GetFilterQuery(query, filters); query += " ) a where row > " + start_row + " and row < " + number_of_rows; user_data = db_connection.ReturnDataTable(query); return_object.status = "success"; return_object.return_data = JsonConvert.SerializeObject(user_data, Formatting.Indented); } catch (Exception ex) { Logger.LogException(ex, page, "GET_USER_DATA"); return_object.status = "error"; return_object.return_data = "An error occurred while loading User data. Please refresh the page and try again. If the error persists, please contact Support."; throw; } finally { page_object.Dispose(); } return(return_object); }
public static ReturnObject UpdateUser(string current, string previous_user_id) { user_account page_object = new user_account(); DBConnection db_connection = new DBConnection(); ReturnObject return_object = new ReturnObject(); JObject current_data = new JObject(); string employee_id = string.Empty, user_name = string.Empty, password = string.Empty, confirm_password = string.Empty, query = string.Empty; int user_access_level = 0, count = 0; try { // Parsing data from JSON current_data = JObject.Parse(current); // Storing data for later use. employee_id = current_data["employee_code"].ToString(); user_name = current_data["username"].ToString(); password = current_data["password"].ToString(); confirm_password = current_data["confirm_password"].ToString(); user_access_level = Convert.ToInt32(current_data["access_level"]); // Query for setting user access level query = "update EmployeeMaster set "; switch (user_access_level) { case 0: query += " ismanager = 0, IsHr = 0 "; break; case 1: query += " ismanager = 1, IsHr = 0 "; break; case 2: query += " ismanager = 0, IsHr = 0 "; break; case 3: query += " ismanager = 0, IsHr = 1 "; break; } query += " where emp_code='" + employee_id + "' "; db_connection.ExecuteQuery_WithOutReturnValue(query); if (previous_user_id != user_name) { query = "select count(*) from login where UserName = '******' and status = 1"; count = db_connection.ExecuteQuery_WithReturnValueInteger(query); if (count > 0) { return_object.status = "error"; return_object.return_data = "User name has been taken. Please try again with a different user name."; } else { page_object.InsertUpdate("U", employee_id, user_name, password, user_access_level, 1); return_object.status = "success"; return_object.return_data = "Changes saved successfully!"; } } else { page_object.InsertUpdate("U", employee_id, user_name, password, user_access_level, 1); return_object.status = "success"; return_object.return_data = "Changes saved successfully!"; } } catch (Exception ex) { Logger.LogException(ex, page, "UPDATE_USER"); return_object.status = "error"; return_object.return_data = "An error occurred while updating user details. Please try again. If the error persists, please contact Support."; throw; } finally { page_object.Dispose(); } return(return_object); }