private Employee GetFromDbByName(string name) { var emp = new Employee(); emp.Name = name; SQLiteCommand command = DBFunctions.GetInstance().GetCommand("Select ID,Name,Phone,Address,RoleId From Employees Where (Name) = (?)"); command.Parameters.AddWithValue("Name", emp.Name); using (SQLiteDataReader reader = DBFunctions.GetInstance().GetReader(command)) { if (reader.Read()) { emp.Id = (Int64)reader[0]; emp.Name = reader[1].ToString(); emp.Phone = reader[2].ToString(); emp.Address = reader[3].ToString(); emp.Role = RoleCache.GetInstance().GetRoleById((Int64)reader[4]); } else { emp = null; } reader.Close(); } return(emp); }
private EmployeeCache() { lock (dummy) { if (Employees == null) { Employees = new List <Employee>(); } Employees?.Clear(); Employee emp; DBFunctions.GetInstance().OpenConnection(); using (SQLiteDataReader reader = DBFunctions.GetInstance().GetReader("Select Id, Name, Phone, Address, RoleId from Employees")) { while (reader.Read()) { emp = new Employee(); emp.Id = (Int64)reader[0]; emp.Name = reader[1].ToString(); emp.Phone = reader[2].ToString(); emp.Address = reader[3].ToString(); emp.Role = new EmployeeRole { Id = (Int64)reader[4] }; Employees.Add(emp); } reader.Close(); } foreach (var employee in Employees) { employee.Role = RoleCache.GetInstance().GetRoleById(employee.Role.Id); } } }
public static RoleCache GetInstance() { if (instance == null) { instance = new RoleCache(); } return(instance); }
public void Clear() { if (Roles != null) { Roles.Clear(); } instance = null; }