public static List<Operation> GetMachines() { Database db = new Database("SELECT * FROM [machines]"); List<Dictionary<string,object>> dataList = db.Fetch(); if(dataList != null) { List<Operation> result = new List<Operation> { }; foreach(Dictionary<string, object> item in dataList) { int id = (int)item["id"]; int duration = (int)item["duration"]; int number = (int)item["amount"]; string name = (string)item["name"]; result.Add(new Operation(id, name, duration, number)); } if(result.Count != 0) { return result; } else { return null; } } else { return null; } }
public static List<Item> GetItems() { try { Database db = new Database("SELECT * FROM [items]"); List<Dictionary<string, object>> datalist = db.Fetch(); if (datalist != null) { List<Item> items = new List<Item> { }; foreach (Dictionary<string, object> data in datalist) { int id = (int)data["id"]; int num = (int)data["inStock"]; string name = (string)data["name"]; items.Add(new Item(id, name, num)); } return items; } else { return null; } } catch(Exception exc) { Log.Record(exc); return null; } }
public static List<Order> GetWorkLine() { Database db = new Database("SELECT * FROM [viewWorkLine]"); List<Dictionary<string, object>> data = db.Fetch(); if (data != null) { List<Order> orders = new List<Order> { }; foreach (Dictionary<string, object> item in data) { int id = (int)item["id"]; int cid = (int)item["customerId"]; DateTime oDate = (DateTime)item["orderDate"]; DateTime eDate = (DateTime)item["expectDate"]; DateTime? dDate = item["deliverDate"] as DateTime?; orders.Add(new Order(id, cid, oDate, eDate, dDate)); } return orders; } else { return null; } }
public static List<Employee> GetEmployees() { try { Database db = new Database("SELECT * FROM [employees] ORDER BY [firstname] ASC"); List<Dictionary<string, object>> datalist = db.Fetch(); if(datalist != null) { List<Employee> workers = new List<Employee> { }; foreach (Dictionary<string, object> item in datalist) { // Initiate Employee informations int id = (int)item["id"]; string firstname = (string)item["firstname"]; string lastname = (string)item["lastname"]; string user = (string)item["username"]; Employee worker = new Employee(id, firstname, lastname, user); // Load task for each Employee Dictionary<string, object> param = new Dictionary<string, object> { }; param.Add("id", id); List<Dictionary<string, object>> block = new Database("getTask", param).FetchProcedure(); // Checking if Employee have any task if (block != null) { foreach (Dictionary<string, object> jobdata in block) { int mid = (int)jobdata["machineId"]; int eid = (int)jobdata["employeeId"]; DateTime aDate = (DateTime)jobdata["activeDate"]; DateTime dDate = (DateTime)jobdata["deadline"]; bool jid = (bool)jobdata["completed"]; worker.Joblist.Add(new Job(mid, eid, aDate, dDate, jid)); } } // Add Employee to list workers.Add(worker); } return workers; } else { return null; } } catch (Exception exc) { Log.Record(exc); return null; } }