Пример #1
0
 public int EmailCounter(string email)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         return(dbConnection.User.Where(e => e.Email == email).Count());
     }
 }
Пример #2
0
 public int UserCounter(string username)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         return(dbConnection.User.Where(u => u.Username == username).Count());
     }
 }
 public IEnumerable <ActivityModel> GetActivityByCustomerId(int id)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var customerId = dbConnection.Activity.Where(a => a.CustomerId == id).ToList();
         return(customerId.Select(c => new ActivityModel(c)).ToList());
     }
 }
 public ActivityModel GetActivityById(int id)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var activity = dbConnection.Activity.Where(a => a.Id == id).FirstOrDefault();
         return(activity == null ? null : new ActivityModel(activity));
     }
 }
 public void InsertActivity(Activity activity)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         dbConnection.Activity.Add(activity);
         dbConnection.SaveChanges();
     }
 }
Пример #6
0
 public int EmailCounter(string email)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var emailCount = dbConnection.User.Where(u => u.Email == email).Count();
         return(emailCount);
     }
 }
 public ActivityModel GetLastActivity(int id)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var lastActivity = dbConnection.Activity.Where(a => a.CustomerId == id).ToList();
         return(lastActivity.LastOrDefault().ToModel());
     }
 }
Пример #8
0
 public void Insert(User user)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         dbConnection.User.Add(user);
         dbConnection.SaveChanges();
     }
 }
 public IEnumerable <CustomerModel> GetAll()
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var customers = dbConnection.Customer.ToList();
         return(customers.Select(c => new CustomerModel(c)).ToList());
     }
 }
 public int PhoneCounter(string phone)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var phoneCount = dbConnection.Customer.Where(c => c.Phone == Convert.ToInt32(phone)).Count();
         return(phoneCount);
     }
 }
Пример #11
0
 public IEnumerable <UserModel> GetAll()
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var users = dbConnection.User.ToList();
         return(users.Select(u => new UserModel(u)).ToList());
     }
 }
 public void Insert(Customer customer)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         dbConnection.Customer.Add(customer);
         dbConnection.SaveChanges();
     }
 }
Пример #13
0
 public UserModel GetById(int id)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var user = dbConnection.User.Where(u => u.Id == id).FirstOrDefault();
         return(user == null ? null : new UserModel(user));
     }
 }
Пример #14
0
 public int GetUserIdByLogin(string username, string password)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var user = dbConnection.User.Where(u => u.Username == username && u.Password == password).ToList().LastOrDefault();
         return(user?.Id ?? 0);
     }
 }
 public IEnumerable <ActivityModel> GetActivitiesByCustomerId(int customerId)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var activities = dbConnection.Activity.Where(a => a.CustomerId == customerId).ToList();
         return(activities.Select(a => new ActivityModel(a)).ToList());
     }
 }
 public IEnumerable <CustomerModel> GetCustomersByPage(int count, int pageNo)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var skipCount = count * (pageNo - 1);
         var customers = dbConnection.Customer.Skip(skipCount).Take(count).ToList();
         return(customers.Select(a => new CustomerModel(a)).ToList());
     }
 }
 public ActivityModel GetActivityById(int id)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         //var user = dbConnection.Users.Where(u => u.Id == id).FirstOrDefault();
         var activity = dbConnection.Activity.Find(id);
         return(new ActivityModel(activity));
     }
 }
 public CustomerModel GetById(int id)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         //var user = dbConnection.Users.Where(u => u.Id == id).FirstOrDefault();
         var customer = dbConnection.Customer.Find(id);
         return(new CustomerModel(customer));
     }
 }
Пример #19
0
 public IEnumerable <UserModel> GetUsersByPage(int count, int pageNo)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         var skipCount = count * (pageNo - 1);
         var users     = dbConnection.User.Skip(skipCount).Take(count).ToList();
         return(users.Select(u => new UserModel(u)).ToList());
     }
 }
        public IEnumerable <CustomerModel> GetCustomersByPageNumber(int pageNumber)
        {
            var skipCount = (pageNumber - 1) * 5;

            using (SQLiteDBContext dbConnection = this.OpenConnection())
            {
                var customers = dbConnection.Customer.Skip(skipCount).Take(5).ToList();
                return(customers.Select(c => new CustomerModel(c)).ToList());
            }
        }
Пример #21
0
 public void Log(LogType logType, string message)
 {
     using (SQLiteDBContext dbConnection = this.OpenConnection())
     {
         Log newLog = new Log();
         newLog.Type      = logType;
         newLog.Message   = message;
         newLog.Timestamp = DateTime.UtcNow.Ticks;
         dbConnection.Log.Add(newLog);
         dbConnection.SaveChanges();
     }
 }
        public ActivityModel GetCustomerLastActivity(int id)
        {
            using (SQLiteDBContext dbConnection = this.OpenConnection())
            {
                var tempCustomerCount = dbConnection.Activity.Where(c => c.CustomerId == id).Count();

                if (tempCustomerCount == 0)
                {
                    return(null);
                }

                var activity = dbConnection.Activity.Where(a => a.CustomerId == id).LastOrDefault();
                return(activity == null ? null : new ActivityModel(activity));
            }
        }
Пример #23
0
        public void Log(LogType type, string message)
        {
            using (SQLiteDBContext dbConnection = this.OpenConnection())
            {
                Log tempLog = null;

                tempLog.Message   = message;
                tempLog.Type      = type;
                tempLog.Timestamp = DateTime.UtcNow.Ticks;

                dbConnection.Log.Add(tempLog);
                dbConnection.SaveChanges();

                //dbConnection.Execute("INSERT INTO Log (Type, Message, Timestamp) VALUES(@Type, @Message, @Timestamp)", new { Type = type, Message = message, Timestamp = DateTime.UtcNow.Ticks });
            }
        }