public void EditUser(User user) { var entry = _databaseModel.Entry(user); if (entry.State == EntityState.Detached) { var set = _databaseModel.Set<User>(); var attachedEntity = set.Find(user.UserId); // You need to have access to key if (attachedEntity != null) { var attachedEntry = _databaseModel.Entry(attachedEntity); attachedEntry.CurrentValues.SetValues(user); } else { entry.State = EntityState.Modified; // This should attach entity } } _databaseModel.SaveChanges(); }
public List<Transaction> GetTransactions(User customer, Company company, DateTime beginningDate, DateTime endingDate) { var transactions = _databaseModel.Transactions .Where(t => (beginningDate <= t.CreatetedAt) && (t.CreatetedAt <= endingDate)) .OrderByDescending(t => t.CreatetedAt); if (customer != null) { var filteredTransactions = transactions.Where(t => t.UserId.Equals(customer.UserId)); return filteredTransactions.ToList(); } if (company != null) { // var storesList = _databaseModel.Stores.Where(s => s.CompanyId.Equals(company.CompanyId)); // var filteredTransactions = transactions.Join(storesList, t => t.StoreId, s => s.StoreId, // (o, id) => o); var filteredTransactions = transactions.Where(t => t.CompanyId.Equals(company.CompanyId)); return filteredTransactions.ToList(); } return transactions.ToList(); }
public void AddUser(User user) { _databaseModel.Users.Add(user); _databaseModel.SaveChanges(); }
public bool UpdateUser(User user) { _databaseModel.Entry(user).State = EntityState.Modified; //_databaseModel.SaveChanges(); return true; }
public List<Transaction> GetTransactions(User customer, DateTime beginningDate, DateTime endingDate) { return _transactionsRepository.GetTransactions(customer, null, beginningDate, endingDate); }
private void EditUser(User user) { user.UpdatedAt = DateTime.Now; _usersRepository.EditUser(user); }
public void Save(User user, int updatedBy) { if (user.UserId == 0) { AddUser(user); } else { EditUser(user); } }
private void AddUser(User user) { user.CreatetedAt = DateTime.Now; user.UpdatedAt = DateTime.Now; user.Password = BCrypt.Net.BCrypt.HashPassword(user.GeneratedCode, BCrypt.Net.BCrypt.GenerateSalt((int) Constants.WorkFactor)); _usersRepository.AddUser(user); }
public JsonResult IsValidParentUser(User user) { //TODO: missing users table modification //check if the user... //1. exists if (user != null) { //2. is senior or master if (user.RelationshipType.RelationshipTypeId.Equals((int) RelationshipTypes.Senior) || user.RelationshipType.RelationshipTypeId.Equals((int) RelationshipTypes.Master)) { //3. has enoght space to add a new children return Json(true, JsonRequestBehavior.AllowGet); } } return Json(false, JsonRequestBehavior.AllowGet); }
private EditViewModel Map(User user) { var editViewModel = new EditViewModel { Address1 = user.Address1, Cashback = user.Cashback.ToString(CultureInfo.InvariantCulture), Cellphone = user.Cellphone, CompaniesList = _companiesManagement.GetCompaniesList(SecurityContext), Company = user.Company, DistrictId = user.District.DistrictId, Day = user.Dob != null ? user.Dob.Value.Day : 1, Month = user.Dob != null ? user.Dob.Value.Month : 1, Year = user.Dob != null ? user.Dob.Value.Year : 1970, //Dob = (DateTime) user.Dob, Email = user.Email, Enabled = user.Enabled, FirstName = user.FName, GeneratedCode = user.GeneratedCode, IdentificationNumber = user.CedNumber.ToString(CultureInfo.InvariantCulture), IdentificationType = new IdentificationType {IdentificationTypeId = (int) IdentificationTypes.CedNumber}, IdentificationTypesList = GetIdentificationTypesList(), LastName1 = user.LName1, LastName2 = user.LName2, Nationality = user.Nationality, PhoneNumber = user.PhoneNumber, RelationshipType = user.RelationshipType, RelationshipTypeList = _relationshipTypesManagement.GetRelationshipTypesList(), RolesList = _rolesManagement.GetRoles(SecurityContext), UserId = user.UserId, UserRol = user.UserRol, ParentUser = user.UserReference /*ParentIdentificationNumber = user.UserReference != null ? user.UserReference.CedNumber.ToString(CultureInfo.InvariantCulture) : Constants.SolucionesArUser.ToString(),*/ }; return editViewModel; }
private User Map(EditViewModel editViewModel) { var user = new User { Address1 = editViewModel.Address1 != null ? editViewModel.Address1.ToUpper() : string.Empty, Cashback = editViewModel.Cashback != null ? Convert.ToDouble(editViewModel.Cashback) : 0, CedNumber = Convert.ToInt32(editViewModel.IdentificationNumber.Replace("-", string.Empty)), Cellphone = editViewModel.Cellphone, CompanyId = editViewModel.Company.CompanyId, DistrictId = editViewModel.DistrictId, Dob = new DateTime(editViewModel.Year, editViewModel.Month, editViewModel.Day), Email = editViewModel.Email != null ? editViewModel.Email.ToUpper() : string.Empty, Enabled = editViewModel.Enabled, FName = editViewModel.FirstName.ToUpper(), GeneratedCode = GenerateUserCode(editViewModel.LastName1, editViewModel.LastName2, editViewModel.IdentificationNumber .ToString(CultureInfo.InvariantCulture)).ToUpper(), LName1 = editViewModel.LastName1.ToUpper(), LName2 = editViewModel.LastName2.ToUpper(), Nationality = editViewModel.Nationality.ToUpper(), IdentificationTypeId = editViewModel.IdentificationType.IdentificationTypeId, RolId = editViewModel.UserRol.RolId, PhoneNumber = editViewModel.PhoneNumber, RelationshipTypeId = editViewModel.RelationshipType.RelationshipTypeId, UserId = editViewModel.UserId, UserReferenceId = editViewModel.ParentUser.UserId /*UserReferenceId = !string.IsNullOrEmpty(editViewModel.ParentIdentificationNumber) ? _usersManagement.GetUserByIdentificationNumber( Convert.ToInt32( editViewModel.ParentIdentificationNumber.Replace("-", string.Empty))) .UserId : (int) Constants.SolucionesArUser,*/ }; //update the user password with the SAR generated code user.Password = BCrypt.Net.BCrypt.HashPassword( user.GeneratedCode, BCrypt.Net.BCrypt.GenerateSalt((int) Constants.WorkFactor)); return user; }
private bool IsValidPayment(double cashback, User userInformation) { if (cashback <= 0) { ModelState.AddModelError("Cashback", "El cashback debe ser mayor a 0 colones."); return false; } if (userInformation.Cashback <= cashback) { ModelState.AddModelError("Cashback", string.Format("El cashback a debitar debe ser menor al cashback actual ({0} colones).", userInformation.Cashback)); return false; } return true; }