public bool DeleteItemByKey(int key) { try { using (SpendingHelperDBEntities context = new SpendingHelperDBEntities()) { CLoginDataDto loginData = context.CLoginDatasDto.Where(l => l.PersonID == key).FirstOrDefault(); if (loginData == null) { log.Info("Can't delete loginData because it doesn't exist in database (personId = {0})", key); return(false); } context.CLoginDatasDto.Remove(loginData); context.SaveChanges(); } } catch (Exception ex) { log.Error(ex, "Some error occure while trying to delete loginData (PersonId = {1}). Message: {0}", ex.Message, key); return(false); } return(true); }
public bool UpdateItem(CLoginDataDto item) { try { using (SpendingHelperDBEntities context = new SpendingHelperDBEntities()) { CLoginDataDto loginData = context.CLoginDatasDto.Where(l => l.PersonID == item.PersonID).FirstOrDefault(); if (loginData == null) { log.Info("Can't update loginData because it doesn't exist in database (personId = {0})", item.PersonID); return(false); } loginData.email = item.email; loginData.Username = item.Username; loginData.PasswordHash = item.PasswordHash; context.SaveChanges(); } } catch (Exception ex) { log.Error(ex, "Some error occure while trying to update loginData (PersonId = {1}). Message: {0}", ex.Message, item.PersonID); return(false); } return(true); }
public CLoginDataDto FindLoginDataByUsername(string username) { try { SpendingHelperDBEntities connection = CSConnectionPool.GetConnection(); CLoginDataDto loginDto = connection.CLoginDatasDto.FirstOrDefault(l => l.Username.Equals(username)); return(loginDto); } catch (Exception ex) { log.Error(ex, "Some error occure while trying to FindLoginDataByUsername. Message: {0}", ex.Message); return(null); } }
public bool AddItem(CLoginDataDto item) { try { using (SpendingHelperDBEntities context = new SpendingHelperDBEntities()) { context.CLoginDatasDto.Add(item); context.SaveChanges(); } } catch (Exception ex) { log.Error(ex, "Some error occure while trying to add loginData into DB. Message: {0}", ex.Message); return(false); } return(true); }
public CLoginDataDto FindLoginDataByEmail(string email) { try { //SpendingHelperDBEntities context = CSConnectionPool.GetConnection(); using (SpendingHelperDBEntities context = new SpendingHelperDBEntities()) { CLoginDataDto loginDto = (from login in context.CLoginDatasDto where login.email.ToLower().Equals(email.ToLower()) select login).FirstOrDefault(); return(loginDto); } } catch (Exception ex) { log.Error(ex, "Some error occure while trying to FindLoginDataByEmail. Message: {0}", ex.Message); return(null); } }