private static Request EmployeeHandler(Request req) { try { string response = "invalid id or password"; employees emp = JsonConvert.DeserializeObject <employees>(req.content); Request reply = new Request(); switch (req.purpose) { case Constants.Log_In: // get the name of the employee List <employees> emplist = DB1.GetEmployees(""); //check if the id and the password var result = from item in emplist where ((item.employee_id == emp.employee_id) && (item.password == emp.password)) select item; if (result.Count() > 0) { // get the employee emp = ((List <employees>)result.ToList()).First(); //response = emp.employee_name; //check if the employee is a foreman List <job_type> foremanjobtypelist = DB1.GetJobType("SELECT a.* FROM job_type a, job_description b WHERE (a.job_type_id = b.job_type_id) AND (b.employee_id = " + emp.employee_id + " ) AND (a.job_name = '" + Constants.Foreman + "')"); if (foremanjobtypelist.Count == 0) { // the person is a not a foreman foreman List <job_type> supervisorjobtypelist = DB1.GetJobType("SELECT a.* FROM job_type a, job_description b WHERE (a.job_type_id = b.job_type_id) AND (b.employee_id = " + emp.employee_id + " ) AND((a.job_name = '" + Constants.Supervisor + "'))"); } else { // the person is a foreman // get a list of all tasks that are related to him List <task> tasklist = DB1.GetTasks("SELECT a.* FROM tasks a WHERE a.employee_id = " + emp.employee_id); //return the tasks string taskstring = JsonConvert.SerializeObject(tasklist); // generate the request req = new Request(); req.category = Constants.Foreman; req.purpose = Constants.Log_In; Container c = new Container(); c._tasklist = tasklist; req.content = JsonConvert.SerializeObject(c); } } else { } break; } return(req); } catch { return(null); } }
// function to get a whole table from the database public Container GetWholeEntity() { try { // switch based on the option string CmdText = ""; Container c = new Container(); if (Connect()) { // get all clients { CmdText = "SELECT * FROM clients "; datareader = GetReader(CmdText); c._clientlist = new List<clients>(); while (datareader.Read()) { clients Client = new clients(); Client.client_id = Convert.ToInt32(datareader["client_id"]); Client.client_name = datareader["client_name"].ToString(); Client.email = datareader["email"].ToString(); Client.contact = datareader["contact"].ToString(); c._clientlist.Add(Client); } datareader.Close(); datareader = null; } // get all employees { CmdText = "SELECT * FROM employees "; datareader = GetReader(CmdText); c._employeeslist = new List<employees>(); while (datareader.Read()) { employees emp = new employees(); emp.employee_name = datareader["employee_name"].ToString(); emp.employee_contact_number = datareader["employee_contact_number"].ToString(); emp.employee_id = Convert.ToInt32(datareader["employee_id"].ToString()); c._employeeslist.Add(emp); } datareader.Close(); datareader = null; } //get all job types { CmdText = "SELECT * FROM job_type "; datareader = GetReader(CmdText); c._job_typelist = new List<job_type>(); while (datareader.Read()) { job_type job = new job_type(); job.job_name = datareader["job_name"].ToString(); job.job_type_id = Convert.ToInt32(datareader["job_type_id"].ToString()); job.unit_pay = Convert.ToInt32(datareader["unit_pay"].ToString()); c._job_typelist.Add(job); } datareader.Close(); datareader = null; } // get all projects { CmdText = "SELECT * FROM Projects "; datareader = GetReader(CmdText); c._projectlist = new List<projects>(); while (datareader.Read()) { projects proj = new projects(); proj.project_id = Convert.ToInt32(datareader["project_id"].ToString()); proj.project_name = datareader["project_name"].ToString(); proj.location = datareader["location"].ToString(); proj.description = datareader["description"].ToString(); proj.start_date = Convert.ToDateTime(datareader["start_date"].ToString()); proj.end_date = Convert.ToDateTime(datareader["end_Date"].ToString()); proj.status = datareader["status"].ToString(); proj.client_id = Convert.ToInt32(datareader["client_id"].ToString()); c._projectlist.Add(proj); } datareader.Close(); datareader = null; } // get all stock material names { CmdText = "SELECT * FROM stock_materials"; datareader = GetReader(CmdText); c._stock_materialslist = new List<stock_materials>(); while (datareader.Read()) { stock_materials stock = new stock_materials(); stock.stock_id = Convert.ToInt32(datareader["stock_id"]); stock.material_id = Convert.ToInt32(datareader["material_id"]); stock.quanitity = Convert.ToInt32(datareader["quantity"]); c._stock_materialslist.Add(stock); } datareader.Close(); datareader = null; } // get all material names { CmdText = "SELECT * FROM materials"; datareader = GetReader(CmdText); c._materialslist = new List<materials>(); while (datareader.Read()) { materials mat = new materials(); mat.material_id = Convert.ToInt16(datareader["material_id"]); mat.material_name = datareader["material_name"].ToString(); mat.measuring_unit = datareader["measuring_unit"].ToString(); c._materialslist.Add(mat); } datareader.Close(); datareader = null; } //get all tasks { CmdText = "SELECT * FROM tasks"; datareader = GetReader(CmdText); c._tasklist = new List<task>(); while (datareader.Read()) { task t = new task(); t.task_id = Convert.ToInt32(datareader["task_id"].ToString()); t.task_name = datareader["task_name"].ToString(); t.start_date = Convert.ToDateTime(datareader["start_date"].ToString()); t.end_date = Convert.ToDateTime(datareader["end_date"].ToString()); t.budget = Convert.ToInt32(datareader["budget"].ToString()); t.status = datareader["status"].ToString(); t.employee_id = Convert.ToInt32(datareader["employee_id"]); t.project_id = Convert.ToInt32(datareader["project_id"].ToString()); c._tasklist.Add(t); } datareader.Close(); datareader = null; } return c; } else { return null; } } catch { return null; } }
public List<employees> GetEmployees(string CmdText) { try { if (CmdText == "") { CmdText = "SELECT * FROM employees "; } // get all employees Connect(); datareader = GetReader(CmdText); List<employees> employeeslist = new List<employees>(); while (datareader.Read()) { employees emp = new employees(); emp.employee_name = datareader["employee_name"].ToString(); emp.employee_contact_number = datareader["employee_contact_number"].ToString(); emp.employee_id = Convert.ToInt32(datareader["employee_id"].ToString()); emp.password = datareader["password"].ToString(); employeeslist.Add(emp); } datareader.Close(); datareader = null; return employeeslist; } catch { return null; } }
public bool UpdateEmployee(employees e) { try { string CmdText = "UPDATE employees set employee_name = @employee_name , employee_contact_number = @employee_contact_number where employee_id = " + e.employee_id; cmd = new MySqlCommand(CmdText, this.conn); cmd.Parameters.AddWithValue("@employee_name", e.employee_name); cmd.Parameters.AddWithValue("@employee_Contact_number", e.employee_contact_number); cmd.ExecuteNonQuery(); return true; } catch { return false; } }