Esempio n. 1
0
        private List <CataloglogUiPlus> MapListToUi(List <cataloglogui> model)
        {
            if (model == null)
            {
                return(null);
            }

            var mapper  = new MyAutoMapper <CataloglogUiPlus>();
            var modelUi = model.Select(x => mapper.Map(x)).ToList();

            foreach (var item in modelUi)
            {
                switch (item.TypeEnum)
                {
                case CatalogLogType.MNN:
                    item.AfterUi = item.After != null?GetMnnName(Int64.Parse(item.After)) : "";

                    item.BeforeUi = item.Before != null?GetMnnName(Int64.Parse(item.Before)) : "";

                    break;

                case CatalogLogType.PKU:
                    item.AfterUi  = UserFrendlyName(item.After);
                    item.BeforeUi = UserFrendlyName(item.Before);
                    break;

                default:
                    item.AfterUi  = item.After;
                    item.BeforeUi = item.Before;
                    break;
                }
            }

            return(modelUi);
        }
Esempio n. 2
0
        public Catalog GetCatalog(string name)
        {
            var dbCatalog = this.myDB.Catalogs.FirstOrDefault(x => x.Name == name);

            if (dbCatalog != null)
            {
                return(MyAutoMapper.FromDBCatalogToCatalog(dbCatalog));
            }

            return(default);
Esempio n. 3
0
        public ICollection <Catalog> GetAll()
        {
            var dbCollection = this.myDB.Catalogs;

            var result = new List <Catalog>();

            dbCollection.ToList().ForEach(x => result.Add(MyAutoMapper.FromDBCatalogToCatalog(x)));

            return(result);
        }
Esempio n. 4
0
        public ICollection <Models.Category> GetAll()
        {
            var dbCollection = this.myDB.Categories;

            var result = new List <Models.Category>();

            dbCollection.ToList().ForEach(x => result.Add(MyAutoMapper.FromDbCategoryToCategory(x)));

            return(result);
        }
Esempio n. 5
0
        public void addCatalog(Catalog catalog)
        {
            if (catalog == null)
            {
                throw new ArgumentNullException("Catalog can`t be null!");
            }

            var dbCatalog = MyAutoMapper.FromCatalogToDBCatalog(catalog);

            this.myDB.AddCatalog(dbCatalog);
        }
Esempio n. 6
0
        public void addCategory(Models.Category category)
        {
            if (category == null)
            {
                throw new ArgumentNullException("Category can`t be null!");
            }

            var dbCategory = MyAutoMapper.FromCategoryToDbCategory(category);

            this.myDB.AddCategory(dbCategory);
        }
        public List <T> Read <T>()
        {
            var connString = ConfigurationManager.ConnectionStrings["producerinterface"].ConnectionString;

            using (var conn = new MySqlConnection(connString)) {
                conn.Open();
                using (var command = GetCmd(conn)) {
                    using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection)) {
                        var mapper = new MyAutoMapper <T>();
                        return(mapper.Map(reader));
                    }
                }
            }
        }
        public ActionResult Signup(UserRenterViewModel model)
        {
            if (ModelState.IsValid)
            {
                var user   = MyAutoMapper.GetInstance().Map <User>(model);
                var renter = MyAutoMapper.GetInstance().Map <Renter>(model);
                try
                {
                    var check = CheckRoomIDIsAvailable(model.RoomID);
                    if (check == -1)
                    {
                        ModelState.AddModelError("RoomID", "This RoomID is not valid");
                        return(View(model));
                    }
                    else if (check == 0)
                    {
                        ModelState.AddModelError("RoomID", "This RoomID is not available");
                        return(View(model));
                    }
                    string userID = Utils.getRandomID(10);
                    user.ID = userID;
                    var roleRenterID = _db.Roles.Single(r => r.RoleName == "Renter").RoleID;
                    user.RoleID   = roleRenterID;
                    user.isActive = true;
                    user.Password = user.Password.ComputeSha256Hash();
                    _db.Users.Add(user);

                    renter.ID        = userID;
                    renter.StartDate = DateTime.Now;
                    renter.RoomID    = model.RoomID;
                    _db.Renters.Add(renter);

                    var room = _db.Rooms.Find(model.RoomID);
                    room.isAvailable = false;

                    _db.SaveChanges();
                }
                catch (Exception e)
                {
                    ModelState.AddModelError(string.Empty, e.Message);
                    return(View(model));
                }
                return(Login(user.Username, user.Password, true));
            }
            return(View(model));
        }