Esempio n. 1
0
        /// <summary>
        /// Creates a phone number
        /// </summary>
        /// <param name="phoneModel"></param>
        /// <returns></returns>
        public int Create(PhoneModel phoneModel)
        {
            using (var scope = new TransactionScope())
            {
                var phone = new PhoneNumber()
                {
                    AreaCode       = phoneModel.AreaCode,
                    Created        = DateTime.Now,
                    CreatedBy      = phoneModel.CreatedBy,
                    LastModified   = DateTime.Now,
                    LastModifiedBy = phoneModel.LastModifiedBy,
                    Extension      = phoneModel.Extension,
                    Number         = phoneModel.PhoneNumber,
                    PhoneTypeId    = phoneModel.PhoneTypeId,
                    Archived       = phoneModel.Archived
                };

                var phoneCheck = _dbActions.PhoneNumberRepository.GetSingle(p => p.AreaCode == phoneModel.AreaCode &&
                                                                            p.Number == phoneModel.PhoneNumber &&
                                                                            p.Extension == phoneModel.Extension);
                if (phoneCheck == null)
                {
                    _dbActions.PhoneNumberRepository.Insert(phone);
                    _dbActions.Save();
                    scope.Complete();
                    return(phone.Id);
                }
                scope.Complete();
                return(-1);
            }
        }
Esempio n. 2
0
 /// <summary>
 /// Creates a user security
 /// </summary>
 /// <param name="userSecurityModel"></param>
 /// <returns></returns>
 public int Create(UserSecurityModel userSecurityModel)
 {
     using (var scope = new TransactionScope())
     {
         var userSecurity = new UserSecurity()
         {
             UserId         = userSecurityModel.Id,
             IpAddress      = userSecurityModel.IpAddress,
             LockedOut      = userSecurityModel.IsLockedOut,
             Password       = userSecurityModel.Password,
             Created        = userSecurityModel.Created,
             CreatedBy      = userSecurityModel.CreatedBy,
             LastModified   = userSecurityModel.LastModified,
             LastModifiedBy = userSecurityModel.LastModifiedBy,
         };
         var userCheck = _dbActions.UserSecurityRepository.GetSingle(p => p.UserId == userSecurityModel.UserId || p.IpAddress == userSecurityModel.IpAddress);
         if (userCheck == null)
         {
             _dbActions.UserSecurityRepository.Insert(userSecurity);
             _dbActions.Save();
             scope.Complete();
             return(userSecurity.Id);
         }
         scope.Complete();
         return(-1);
     }
 }
Esempio n. 3
0
 /// <summary>
 /// Creates a lookup type
 /// </summary>
 /// <param name="addressModel"></param>
 /// <returns></returns>
 public int Create(AddressModel addressModel)
 {
     using (var scope = new TransactionScope())
     {
         var address = new Address()
         {
             Address1       = addressModel.Address1,
             Address2       = addressModel.Address2,
             City           = addressModel.City,
             StateId        = addressModel.State.Id,
             Zip            = addressModel.Zip,
             AddressTypeId  = addressModel.AddressType.Id,
             Created        = addressModel.Created,
             CreatedBy      = addressModel.CreatedBy,
             LastModified   = addressModel.LastModified,
             LastModifiedBy = addressModel.LastModifiedBy,
             Archived       = addressModel.Archived
         };
         var addressCheck = _dbActions.AddressRepository.GetSingle(p => p.Address1 == addressModel.Address1 &&
                                                                   p.Address2 == addressModel.Address2 &&
                                                                   p.City == addressModel.City &&
                                                                   p.StateId == addressModel.StateId &&
                                                                   p.Zip == addressModel.Zip);
         if (addressCheck == null)
         {
             _dbActions.AddressRepository.Insert(address);
             _dbActions.Save();
             scope.Complete();
             return(address.Id);
         }
         scope.Complete();
         return(-1);
     }
 }
Esempio n. 4
0
        public bool UpdateLoginStatus(int userId, string jwToken, DateTime tokenExpiration)
        {
            try
            {
                var loginStatus = _dbActions.LoginStatusRepository.GetSingle(p => p.UserId == userId);

                if (loginStatus != null)
                {
                    using (var scope = new TransactionScope())
                    {
                        loginStatus.Id             = loginStatus.Id;
                        loginStatus.UserId         = userId;
                        loginStatus.JwToken        = jwToken;
                        loginStatus.TokenExpires   = tokenExpiration;
                        loginStatus.CreatedBy      = loginStatus.CreatedBy;
                        loginStatus.Created        = loginStatus.Created;
                        loginStatus.LastModified   = DateTime.Now;
                        loginStatus.LastModifiedBy = "SYSTEM";

                        _dbActions.LoginStatusRepository.Update(loginStatus);
                        _dbActions.Save();
                        scope.Complete();
                        return(true);
                    }
                }

                using (var scope = new TransactionScope())
                {
                    LoginStatus newLoginStatus = new LoginStatus
                    {
                        UserId         = userId,
                        JwToken        = jwToken,
                        TokenExpires   = tokenExpiration,
                        CreatedBy      = "SYSTEM",
                        Created        = DateTime.Now,
                        LastModified   = DateTime.Now,
                        LastModifiedBy = "SYSTEM"
                    };

                    _dbActions.LoginStatusRepository.Insert(newLoginStatus);
                    _dbActions.Save();
                    scope.Complete();
                    return(true);
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine(e.Message);
                throw;
            }
        }
Esempio n. 5
0
 /// <summary>
 /// Creates a state
 /// </summary>
 /// <param name="stateModel"></param>
 /// <returns></returns>
 public int Create(StateModel stateModel)
 {
     using (var scope = new TransactionScope())
     {
         var state = new StateLookup()
         {
             StateName         = stateModel.StateName,
             StateAbbreviation = stateModel.StateAbbreviation,
             Archived          = stateModel.Archived
         };
         _dbActions.StateRepository.Insert(state);
         _dbActions.Save();
         scope.Complete();
         return(state.Id);
     }
 }
Esempio n. 6
0
 /// <summary>
 /// Creates a address type
 /// </summary>
 /// <param name="addressTypeModel"></param>
 /// <returns></returns>
 public int Create(AddressTypeModel addressTypeModel)
 {
     using (var scope = new TransactionScope())
     {
         var addressType = new AddressTypeLookup()
         {
             AddressType = addressTypeModel.AddressType,
             Archived    = addressTypeModel.Archived
         };
         var addressTypeCheck = _dbActions.AddressTypeRepository.GetSingle(p => p.AddressType == addressTypeModel.AddressType);
         if (addressTypeCheck == null)
         {
             _dbActions.AddressTypeRepository.Insert(addressType);
             _dbActions.Save();
             scope.Complete();
             return(addressType.Id);
         }
         scope.Complete();
         return(-1);
     }
 }
Esempio n. 7
0
        /// <summary>
        /// Creates a user
        /// </summary>
        /// <param name="userRoleModel"></param>
        /// <returns></returns>
        public int Create(RoleModel userRoleModel)
        {
            using (var scope = new TransactionScope())
            {
                var userRole = new Role()
                {
                    RoleName       = userRoleModel.Name,
                    Description    = userRoleModel.Description,
                    Created        = userRoleModel.Created,
                    CreatedBy      = userRoleModel.CreatedBy,
                    LastModified   = userRoleModel.LastModified,
                    LastModifiedBy = userRoleModel.LastModifiedBy,
                    Archived       = userRoleModel.Archived,

                    //Users = userRoleModel.AssignedUsers.Select(p => new User()
                    //{
                    //    Id = p.Id,
                    //    UserName = p.UserName,
                    //    EmailAddress = p.EmailAddress,
                    //    Created = p.Created,
                    //    CreatedBy = p.CreatedBy,
                    //    LastModified = p.LastModified,
                    //    LastModifiedBy = p.LastModifiedBy,
                    //    Archived = p.Archived,
                    //}).ToList()
                };

                var userRoleCheck = _dbActions.UserRoleRepository.GetSingle(p => p.RoleName == userRoleModel.Name);
                if (userRoleCheck == null)
                {
                    _dbActions.UserRoleRepository.Insert(userRole);
                    _dbActions.Save();
                    scope.Complete();
                    return(userRole.Id);
                }
                scope.Complete();
                return(-1);
            }
        }
Esempio n. 8
0
        /// <summary>
        /// Creates a address type
        /// </summary>
        /// <param name="phoneTypeModel"></param>
        /// <returns></returns>
        public int Create(PhoneTypeModel phoneTypeModel)
        {
            using (var scope = new TransactionScope())
            {
                var phoneType = new PhoneTypeLookup()
                {
                    PhoneType = phoneTypeModel.PhoneType,
                    Archived  = phoneTypeModel.Archived
                };

                var phoneTypeCheck = _dbActions.PhoneTypeRepository.GetSingle(p => p.PhoneType == phoneTypeModel.PhoneType);
                if (phoneTypeCheck == null)
                {
                    _dbActions.PhoneTypeRepository.Insert(phoneType);
                    _dbActions.Save();
                    scope.Complete();
                    return(phoneType.Id);
                }
                scope.Complete();
                return(-1);
            }
        }
Esempio n. 9
0
 /// <summary>
 /// Creates a user
 /// </summary>
 /// <param name="userModel"></param>
 /// <returns></returns>
 public int Create(UserModel userModel)
 {
     using (var scope = new TransactionScope())
     {
         var user = new User()
         {
             UserName     = userModel.UserName,
             EmailAddress = userModel.EmailAddress,
             ContactId    = userModel.ContactId,
             Roles        = userModel.Roles.Select(p => new Role()
             {
                 Id             = p.Id,
                 RoleName       = p.Name,
                 Description    = p.Description,
                 CreatedBy      = p.CreatedBy,
                 Created        = p.Created,
                 LastModified   = p.LastModified,
                 LastModifiedBy = p.LastModifiedBy,
                 Archived       = p.Archived
             }).ToList(),
             Created        = userModel.Created,
             CreatedBy      = userModel.CreatedBy,
             LastModified   = userModel.LastModified,
             LastModifiedBy = userModel.LastModifiedBy,
             Archived       = userModel.Archived
         };
         var userCheck = _dbActions.UserRepository.GetSingle(p => p.UserName == userModel.UserName || p.EmailAddress == userModel.EmailAddress);
         if (userCheck == null)
         {
             _dbActions.UserRepository.Insert(user);
             _dbActions.Save();
             scope.Complete();
             return(user.Id);
         }
         scope.Complete();
         return(-1);
     }
 }
Esempio n. 10
0
        /// <summary>
        /// Creates a Customer
        /// </summary>
        /// <param name="customerModel"></param>
        /// <returns></returns>
        public int Create(CustomerModel customerModel)
        {
            using (var scope = new TransactionScope())
            {
                var customer = new Customer()
                {
                    AccountNumber = customerModel.AccountNumber,
                    AccountRepId  = customerModel.AccountRep.Id,
                    AccountRep    = new Contact()
                    {
                        Id             = customerModel.AccountRep.Id,
                        EmailAddress   = customerModel.AccountRep.EmailAddress,
                        FirstName      = customerModel.AccountRep.FirstName,
                        LastName       = customerModel.AccountRep.LastName,
                        Created        = customerModel.AccountRep.Created,
                        CreatedBy      = customerModel.AccountRep.CreatedBy,
                        LastModified   = customerModel.AccountRep.LastModified,
                        LastModifiedBy = customerModel.AccountRep.LastModifiedBy
                    },
                    IsParentInd = customerModel.IsParent,
                    ParentId    = customerModel.ParentId,
                    //Cannot insert parent through child!!!!!
                    Name          = customerModel.Name,
                    ShipToBillInd = customerModel.ShipToBill,
                    WebsiteUrl    = customerModel.WebsiteUrl,
                    Addresses     = customerModel.Addresses?.Select(p => new Address()
                    {
                        Id             = p.Id,
                        AddressTypeId  = p.AddressType.Id,
                        Address1       = p.Address1,
                        Address2       = p.Address2,
                        City           = p.City,
                        StateId        = p.State.Id,
                        Zip            = p.Zip,
                        Created        = p.Created,
                        CreatedBy      = p.CreatedBy,
                        LastModified   = p.LastModified,
                        LastModifiedBy = p.LastModifiedBy,
                        Archived       = p.Archived
                    }).ToList(),
                    PhoneNumbers = customerModel.PhoneNumbers?.Select(p => new PhoneNumber()
                    {
                        Id             = p.Id,
                        AreaCode       = p.AreaCode,
                        PhoneTypeId    = p.PhoneTypeId,
                        Number         = p.PhoneNumber,
                        Extension      = p.Extension,
                        Created        = p.Created,
                        CreatedBy      = p.CreatedBy,
                        LastModified   = p.LastModified,
                        LastModifiedBy = p.LastModifiedBy
                    }).ToList(),
                    Contacts = customerModel.Contacts.Select(p => new Contact()
                    {
                        Id             = p.Id,
                        EmailAddress   = p.EmailAddress,
                        FirstName      = p.FirstName,
                        LastName       = p.LastName,
                        Created        = p.Created,
                        CreatedBy      = p.CreatedBy,
                        LastModified   = p.LastModified,
                        LastModifiedBy = p.LastModifiedBy
                    }).ToList(),
                    Created        = DateTime.Now,
                    CreatedBy      = customerModel.CreatedBy,
                    LastModified   = DateTime.Now,
                    LastModifiedBy = customerModel.LastModifiedBy,
                    Archived       = customerModel.Archived
                };
                if (customer.Addresses != null)
                {
                    foreach (Address addr in customer.Addresses)
                    {
                        _dbActions.Context.Entry(addr).State = addr.Id == 0 ? EntityState.Added : EntityState.Unchanged;
                    }
                }


                if (customer.PhoneNumbers != null)
                {
                    foreach (PhoneNumber phone in customer.PhoneNumbers)
                    {
                        _dbActions.Context.Entry(phone).State = phone.Id == 0 ? EntityState.Added : EntityState.Unchanged;
                    }
                }

                var customerCheck = _dbActions.CustomerRepository.GetSingle(p => p.Name == customer.Name);
                if (customerCheck == null)
                {
                    _dbActions.CustomerRepository.Insert(customer);
                    _dbActions.Save();
                    scope.Complete();
                    return(customer.Id);
                }
                scope.Complete();
                return(-1);
            }
        }
Esempio n. 11
0
        /// <summary>
        /// Creates a contact
        /// </summary>
        /// <param name="contactModel"></param>
        /// <returns></returns>
        public int Create(ContactModel contactModel)
        {
            using (var scope = new TransactionScope())
            {
                var contact = new Contact()
                {
                    FirstName    = contactModel.FirstName,
                    LastName     = contactModel.LastName,
                    EmailAddress = contactModel.EmailAddress,
                    Addresses    = contactModel.Addresses?.Select(p => new Address()
                    {
                        Id             = p.Id,
                        AddressTypeId  = p.AddressType.Id,
                        Address1       = p.Address1,
                        Address2       = p.Address2,
                        City           = p.City,
                        StateId        = p.State.Id,
                        Zip            = p.Zip,
                        Created        = p.Created,
                        CreatedBy      = p.CreatedBy,
                        LastModified   = p.LastModified,
                        LastModifiedBy = p.LastModifiedBy,
                        Archived       = p.Archived
                    }).ToList(),
                    PhoneNumbers = contactModel.PhoneNumbers?.Select(p => new PhoneNumber()
                    {
                        Id             = p.Id,
                        AreaCode       = p.AreaCode,
                        PhoneTypeId    = p.PhoneTypeId,
                        Number         = p.PhoneNumber,
                        Extension      = p.Extension,
                        Created        = p.Created,
                        CreatedBy      = p.CreatedBy,
                        LastModified   = p.LastModified,
                        LastModifiedBy = p.LastModifiedBy
                    }).ToList(),
                    Created        = DateTime.Now,
                    CreatedBy      = contactModel.CreatedBy,
                    LastModified   = DateTime.Now,
                    LastModifiedBy = contactModel.LastModifiedBy,
                    Archived       = contactModel.Archived
                };
                if (contact.Addresses != null)
                {
                    foreach (Address addr in contact.Addresses)
                    {
                        _dbActions.Context.Entry(addr).State = addr.Id == 0 ? EntityState.Added : EntityState.Unchanged;
                    }
                }


                if (contact.PhoneNumbers != null)
                {
                    foreach (PhoneNumber phone in contact.PhoneNumbers)
                    {
                        _dbActions.Context.Entry(phone).State = phone.Id == 0 ? EntityState.Added : EntityState.Unchanged;
                    }
                }

                var contactCheck = _dbActions.ContactRepository.GetSingle(p => p.EmailAddress == contact.EmailAddress);
                if (contactCheck == null)
                {
                    _dbActions.ContactRepository.Insert(contact);
                    _dbActions.Save();
                    scope.Complete();
                    return(contact.Id);
                }
                scope.Complete();
                return(-1);
            }
        }