Exemple #1
0
        public ResultStatus Edit(TOURIS_TM_SUB_CATEGORY subCategory)
        {
            try
            {
                TOURIS_TM_SUB_CATEGORY subCategoryNew = _ctx.TOURIS_TM_SUB_CATEGORY.Find(subCategory.ID);
                subCategoryNew.CATEGORY_ID              = subCategory.CATEGORY_ID;
                subCategoryNew.VILLAGE_ID               = subCategory.VILLAGE_ID;
                subCategoryNew.ADDRESS                  = subCategory.ADDRESS;
                subCategoryNew.SUB_CATEGORY_NAME        = subCategory.SUB_CATEGORY_NAME;
                subCategoryNew.SUB_CATEGORY_DESCRIPTION = subCategory.SUB_CATEGORY_DESCRIPTION;
                subCategoryNew.START_TIME               = subCategory.START_TIME;
                subCategoryNew.END_TIME                 = subCategory.END_TIME;
                subCategoryNew.PHOTO_PATH               = subCategory.PHOTO_PATH;
                subCategoryNew.LAST_MODIFIED_TIME       = subCategory.LAST_MODIFIED_TIME;
                subCategoryNew.LAST_MODIFIED_BY         = subCategory.LAST_MODIFIED_BY;
                _ctx.Entry(subCategoryNew).State        = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
        public static void AuditEntities(this DbCtx db, IPrincipal principal)
        {
            try
            {
                var modifiedEntries = db.ChangeTracker.Entries()
                                      .Where(x => x.Entity is IHasAudit <string, DateTime?> && (x.State == EntityState.Added || x.State == EntityState.Modified));
                var username = principal != null ? principal.Identity.Name : "anonymous";
                var now      = DateTime.UtcNow;
                foreach (var entry in modifiedEntries)
                {
                    var entity = (IHasAudit <string, DateTime?>)entry.Entity;

                    if (entry.State == EntityState.Added)
                    {
                        entity.CreatedAt = now;
                        entity.Creator   = username;
                    }
                    else
                    {
                        db.Entry(entity).Property(x => x.CreatedAt).IsModified = false;
                        db.Entry(entity).Property(x => x.Creator).IsModified   = false;
                    }

                    entity.ModifiedAt = now;
                    entity.Modifier   = username;
                }
            }
            catch (Exception ex)
            {
            }
        }
Exemple #3
0
        private async Task <List <SeasonEachConfViewModel> > GetParticipationViewModelsForEachConference()
        {
            List <Season> seasons = await _context.Seasons.ToListAsync();

            List <SeasonEachConfViewModel> seasonEachConfViewModels = new List <SeasonEachConfViewModel>();

            foreach (Season season in seasons)
            {
                List <Participation> participations = await _context.Participations.Where(p => p.Season.Equals(season)).ToListAsync();

                List <PartEachConfViewModel> partEachConfViewModels = new List <PartEachConfViewModel>();

                foreach (Participation part in participations)
                {
                    await _context.Entry(part).Reference(p => p.User).LoadAsync();

                    partEachConfViewModels.Add(new PartEachConfViewModel
                    {
                        Id       = part.Id,
                        User     = part.User.Degree + " " + part.User.FirstName + " " + part.User.LastName,
                        ConfPart = part.ConferenceParticipation.GetValueOrDefault(),
                        PaperPub = part.PaperPublication.GetValueOrDefault()
                    });
                }

                seasonEachConfViewModels.Add(new SeasonEachConfViewModel
                {
                    Season         = season.Name + " " + season.EditionNumber,
                    Participations = partEachConfViewModels
                });
            }

            return(seasonEachConfViewModels);
        }
        public ResultStatus Edit(TOURIS_TM_SOSMED sosmed)
        {
            try
            {
                TOURIS_TM_SOSMED sosmedNew = _ctx.TOURIS_TM_SOSMED.Find(sosmed.ID);
                sosmedNew.TYPE               = sosmed.TYPE;
                sosmedNew.NAME               = sosmed.NAME;
                sosmedNew.DESCRIPTION        = sosmed.DESCRIPTION;
                sosmedNew.ICON               = sosmed.ICON;
                sosmedNew.URL                = sosmed.URL;
                sosmedNew.DATA_EMBED         = sosmed.DATA_EMBED;
                sosmedNew.HEIGHT             = sosmed.HEIGHT;
                sosmedNew.WIDTH              = sosmed.WIDTH;
                sosmedNew.DATA_WIDGET_ID     = sosmed.DATA_WIDGET_ID;
                sosmedNew.LAST_MODIFIED_TIME = sosmed.LAST_MODIFIED_TIME;
                sosmedNew.LAST_MODIFIED_BY   = sosmed.LAST_MODIFIED_BY;
                _ctx.Entry(sosmedNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #5
0
        /// <summary>
        /// 设备的归还
        /// </summary>
        /// <param name="equipmentId"></param>
        /// <returns>
        /// 0 : 指定Id的设备不存在
        /// 1 : 操作成功
        /// -1 : 指定设备未被领用
        /// </returns>
        public int ReturnEquipment(int equipmentId, string adminAccount)
        {
            var equipment = DbCtx.Equipments
                            .FirstOrDefault(e => e.Id == equipmentId);

            if (equipment == null)
            {
                return(0);
            }
            if (equipment.User == null)
            {
                return(-1);
            }
            DbCtx.Histories.Add(new History()
            {
                ReturnDate     = DateTime.Now,
                EquipmentTitle = equipment.Title,
                UserName       = equipment.User.Name,
                AdminAccount   = adminAccount
            });                    //添加归还记录

            equipment.User = null; //删除当前领用用户
            DbCtx.Entry(equipment).State = EntityState.Modified;
            DbCtx.SaveChanges();
            return(1);
        }
Exemple #6
0
 public ActionResult Edit([Bind(Include = "RecenzieId,Titlu,Descriere,Nota,NumeUtilizator")] Recenzie recenzie)
 {
     if (ModelState.IsValid)
     {
         db.Entry(recenzie).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(recenzie));
 }
Exemple #7
0
 public ActionResult Edit([Bind(Include = "IDRecenzie,Titlu,Nota,IDFilm")] Recenzie recenzie)
 {
     if (ModelState.IsValid)
     {
         db.Entry(recenzie).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(recenzie));
 }
        public void Update(ContactModel dBcontact, ContactModel contact)
        {
            Contact dBentity = Contact.formModel(dBcontact);
            Contact entity   = Contact.formModel(contact);

            _ctx.Entry(dBentity).CurrentValues.SetValues(entity);
            _ctx.Entry(dBentity.Address).CurrentValues.SetValues(entity.Address);

            // Delete Contracts
            foreach (var child in dBentity.Contracts.ToList())
            {
                if (!entity.Contracts.Any(c => c.ContactId == child.ContactId && c.EntrepriseId == child.EntrepriseId))
                {
                    _ctx.Contract.Remove(child);
                }
            }

            //update or insert
            foreach (var child in entity.Contracts)
            {
                var existingChild = dBentity.Contracts
                                    .Where(c => c.ContactId == child.ContactId && c.EntrepriseId == child.EntrepriseId)
                                    .SingleOrDefault();

                if (existingChild != null)
                {
                    // Update child
                    _ctx.Entry(existingChild).CurrentValues.SetValues(child);
                }
                else
                {
                    // Insert child
                    var newChild = new Contract
                    {
                        ContractType = child.ContractType,
                        TVA          = child.TVA,
                        EntrepriseId = child.EntrepriseId
                    };
                    dBentity.Contracts.Add(newChild);
                }
            }
            _ctx.SaveChanges();
        }
 public ActionResult Edit([Bind(Include = "Id,CurrentlyBooked,CurrentCustomerId,RoomSize,PricePerNight")] Room room)
 {
     if (ModelState.IsValid)
     {
         db.Entry(room).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(room));
 }
 public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,Salary")] Employee employee)
 {
     if (ModelState.IsValid)
     {
         db.Entry(employee).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(employee));
 }
 public ActionResult Edit([Bind(Include = "Id,RoomId,StartDate,EndDate,CustomerId")] Reservation reservation)
 {
     if (ModelState.IsValid)
     {
         db.Entry(reservation).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.RoomId = new SelectList(db.Rooms, "Id", "Id", reservation.RoomId);
     return(View(reservation));
 }
Exemple #12
0
        public ResultStatus Delete(int id, string modifiedBy, DateTime modifiedTime)
        {
            try
            {
                GEMA_TM_USER user = _ctx.GEMA_TM_USER.Find(id);
                user.LAST_MODIFIED_TIME = modifiedTime;
                user.LAST_MODIFIED_BY   = modifiedBy;
                user.ROW_STATUS         = eStat.fg.NotActive;

                _ctx.Entry(user).State = EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #13
0
        public ResultStatus Edit(TOURIS_TM_ROLE role)
        {
            try
            {
                TOURIS_TM_ROLE roleNew = _ctx.TOURIS_TM_ROLE.Find(role.ID);
                roleNew.ROLE_NAME          = role.ROLE_NAME;
                roleNew.ROLE_DESCRIPTION   = role.ROLE_DESCRIPTION;
                roleNew.LAST_MODIFIED_TIME = role.LAST_MODIFIED_TIME;
                roleNew.LAST_MODIFIED_BY   = role.LAST_MODIFIED_BY;
                _ctx.Entry(roleNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #14
0
 public ActionResult Edit([Bind(Include = "Id,Title,RoomId,EmployeeId")] Job job)
 {
     if (ModelState.IsValid)
     {
         db.Entry(job).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.EmployeeId = new SelectList(db.Employees, "Id", "FirstName", job.EmployeeId);
     ViewBag.RoomId     = new SelectList(db.Rooms, "Id", "Id", job.RoomId);
     return(View(job));
 }
Exemple #15
0
        public ResultStatus Edit(TOURIS_TM_MENU menu)
        {
            try
            {
                TOURIS_TM_MENU menuNew = _ctx.TOURIS_TM_MENU.Find(menu.ID);
                menuNew.MENU_NAME          = menu.MENU_NAME;
                menuNew.MENU_DESCRIPTION   = menu.MENU_DESCRIPTION;
                menuNew.MENU_PARENT_ID     = menu.MENU_PARENT_ID;
                menuNew.LAST_MODIFIED_TIME = menu.LAST_MODIFIED_TIME;
                menuNew.LAST_MODIFIED_BY   = menu.LAST_MODIFIED_BY;
                _ctx.Entry(menuNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #16
0
        public ResultStatus Edit(TOURIS_TM_COUNTRY country)
        {
            try
            {
                TOURIS_TM_COUNTRY countryNew = _ctx.TOURIS_TM_COUNTRY.Find(country.ID);
                countryNew.COUNTRY_CODE        = country.COUNTRY_CODE;
                countryNew.COUNTRY_NAME        = country.COUNTRY_NAME;
                countryNew.COUNTRY_DESCRIPTION = country.COUNTRY_DESCRIPTION;
                countryNew.LAST_MODIFIED_TIME  = country.LAST_MODIFIED_TIME;
                countryNew.LAST_MODIFIED_BY    = country.LAST_MODIFIED_BY;
                _ctx.Entry(countryNew).State   = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #17
0
        public ResultStatus Edit(TOURIS_TM_VILLAGE village)
        {
            try
            {
                TOURIS_TM_VILLAGE villageNew = _ctx.TOURIS_TM_VILLAGE.Find(village.ID);
                villageNew.DISTRICT_ID         = village.DISTRICT_ID;
                villageNew.VILLAGE_CODE        = village.VILLAGE_CODE;
                villageNew.VILLAGE_NAME        = village.VILLAGE_NAME;
                villageNew.VILLAGE_DESCRIPTION = village.VILLAGE_DESCRIPTION;
                villageNew.LAST_MODIFIED_TIME  = village.LAST_MODIFIED_TIME;
                villageNew.LAST_MODIFIED_BY    = village.LAST_MODIFIED_BY;
                _ctx.Entry(villageNew).State   = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #18
0
        public ResultStatus Edit(TOURIS_TM_DISTRICT district)
        {
            try
            {
                TOURIS_TM_DISTRICT districtNew = _ctx.TOURIS_TM_DISTRICT.Find(district.ID);
                districtNew.CITY_ID              = district.CITY_ID;
                districtNew.DISTRICT_CODE        = district.DISTRICT_CODE;
                districtNew.DISTRICT_NAME        = district.DISTRICT_NAME;
                districtNew.DISTRICT_DESCRIPTION = district.DISTRICT_DESCRIPTION;
                districtNew.LAST_MODIFIED_TIME   = district.LAST_MODIFIED_TIME;
                districtNew.LAST_MODIFIED_BY     = district.LAST_MODIFIED_BY;
                _ctx.Entry(districtNew).State    = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
        public ResultStatus Edit(TOURIS_TM_CONTACT_US contactUs)
        {
            try
            {
                TOURIS_TM_CONTACT_US contactUsNew = _ctx.TOURIS_TM_CONTACT_US.Find(contactUs.ID);
                contactUsNew.NAME_SENDER        = contactUs.NAME_SENDER;
                contactUsNew.EMAIL_SENDER       = contactUs.EMAIL_SENDER;
                contactUsNew.PHONE_SENDER       = contactUs.EMAIL_SENDER;
                contactUsNew.DESCRIPTION        = contactUs.DESCRIPTION;
                contactUsNew.LAST_MODIFIED_TIME = contactUs.LAST_MODIFIED_TIME;
                contactUsNew.LAST_MODIFIED_BY   = contactUs.LAST_MODIFIED_BY;
                _ctx.Entry(contactUsNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #20
0
        public ResultStatus Edit(TOURIS_TM_SUB_CATEGORY_PHOTO subCategoryPhoto)
        {
            try
            {
                TOURIS_TM_SUB_CATEGORY_PHOTO subCategoryPhotoNew = _ctx.TOURIS_TM_SUB_CATEGORY_PHOTO.Find(subCategoryPhoto.ID);
                subCategoryPhotoNew.SUB_CATEGORY_ID    = subCategoryPhoto.SUB_CATEGORY_ID;
                subCategoryPhotoNew.PHOTO_NAME         = subCategoryPhoto.PHOTO_NAME;
                subCategoryPhotoNew.PHOTO_DESCRIPTION  = subCategoryPhoto.PHOTO_DESCRIPTION;
                subCategoryPhotoNew.PHOTO_PATH         = subCategoryPhoto.PHOTO_PATH;
                subCategoryPhotoNew.LAST_MODIFIED_TIME = subCategoryPhoto.LAST_MODIFIED_TIME;
                subCategoryPhotoNew.LAST_MODIFIED_BY   = subCategoryPhoto.LAST_MODIFIED_BY;
                _ctx.Entry(subCategoryPhotoNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #21
0
        /// <summary>
        /// 删除一个设备
        /// </summary>
        /// <param name="Id">设备的Id</param>
        /// <returns>
        /// 0 : 对应Id的设备不存在
        /// 1 : 操作成功
        /// </returns>
        public int DeleteEquipment(int Id)
        {
            var equipment = DbCtx.Equipments
                            .FirstOrDefault(e => e.Id == Id);

            if (equipment == null) //此Id不存在
            {
                return(0);         //返回0
            }
            DbCtx.Entry(equipment).State = EntityState.Deleted;
            DbCtx.SaveChanges();
            return(1);
        }
        public ResultStatus Edit(GEMA_TM_SUB_CATEGORY subCategory)
        {
            try
            {
                GEMA_TM_SUB_CATEGORY subCategoryNew = _ctx.GEMA_TM_SUB_CATEGORY.Find(subCategory.ID);
                subCategoryNew.CATEGORY_ID        = subCategory.CATEGORY_ID;
                subCategoryNew.SUB_CATEGORY_NAME  = subCategory.SUB_CATEGORY_NAME;
                subCategoryNew.DESCRIPTION        = subCategory.DESCRIPTION;
                subCategoryNew.IMAGE_PATH         = subCategory.IMAGE_PATH;
                subCategoryNew.LAST_MODIFIED_TIME = subCategory.LAST_MODIFIED_TIME;
                subCategoryNew.LAST_MODIFIED_BY   = subCategory.LAST_MODIFIED_BY;
                _ctx.Entry(subCategoryNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
        public ResultStatus Edit(TOURIS_TM_PROVINCE province)
        {
            try
            {
                TOURIS_TM_PROVINCE provinceNew = _ctx.TOURIS_TM_PROVINCE.Find(province.ID);
                provinceNew.COUNTRY_ID           = province.COUNTRY_ID;
                provinceNew.PROVINCE_CODE        = province.PROVINCE_CODE;
                provinceNew.PROVINCE_NAME        = province.PROVINCE_NAME;
                provinceNew.PROVINCE_DESCRIPTION = province.PROVINCE_DESCRIPTION;
                provinceNew.LAST_MODIFIED_TIME   = province.LAST_MODIFIED_TIME;
                provinceNew.LAST_MODIFIED_BY     = province.LAST_MODIFIED_BY;
                _ctx.Entry(provinceNew).State    = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #24
0
        public ResultStatus Edit(GEMA_TR_BOOKING booking)
        {
            using (var transaction = _ctx.Database.BeginTransaction())
            {
                try
                {
                    GEMA_TR_BOOKING bookingNew = _ctx.GEMA_TR_BOOKING.Find(booking.ID);
                    if (booking.STATUS == (int)EnumList.BookingStatus.Submitted)
                    {
                        bookingNew.STATUS               = (int)EnumList.BookingStatus.Uploaded;
                        bookingNew.RECEIVE_PAYMENT_BY   = booking.LAST_MODIFIED_BY;
                        bookingNew.RECEIVE_PAYMENT_TIME = booking.LAST_MODIFIED_TIME;
                        bookingNew.PAYMENT_IMAGE_PATH   = booking.PAYMENT_IMAGE_PATH;
                    }
                    else if (booking.STATUS == (int)EnumList.BookingStatus.Uploaded)
                    {
                        bookingNew.STATUS = (int)EnumList.BookingStatus.Completed;
                        bookingNew.COMPLETE_PAYMENT_BY   = booking.LAST_MODIFIED_BY;
                        bookingNew.COMPLETE_PAYMENT_TIME = booking.LAST_MODIFIED_TIME;
                    }

                    bookingNew.LAST_MODIFIED_TIME = booking.LAST_MODIFIED_TIME;
                    bookingNew.LAST_MODIFIED_BY   = booking.LAST_MODIFIED_BY;
                    _ctx.Entry(bookingNew).State  = System.Data.Entity.EntityState.Modified;
                    _ctx.SaveChanges();
                    rs.SetSuccessStatus();

                    transaction.Commit();
                }
                catch (Exception ex)
                {
                    rs.SetErrorStatus(ex.Message);
                    transaction.Rollback();
                }
            }

            return(rs);
        }
Exemple #25
0
        public ResultStatus Edit(GEMA_TM_PRICEL_LIST priceList)
        {
            try
            {
                GEMA_TM_PRICEL_LIST priceListNew = _ctx.GEMA_TM_PRICEL_LIST.Find(priceList.ID);
                priceListNew.TYPE               = priceList.TYPE;
                priceListNew.DESCRIPTION        = priceList.DESCRIPTION;
                priceListNew.PRICE              = priceList.PRICE;
                priceListNew.IMAGE_BIT          = priceList.IMAGE_BIT;
                priceListNew.IMAGE_PATH         = priceList.IMAGE_PATH;
                priceListNew.LAST_MODIFIED_TIME = priceList.LAST_MODIFIED_TIME;
                priceListNew.LAST_MODIFIED_BY   = priceList.LAST_MODIFIED_BY;
                _ctx.Entry(priceListNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #26
0
        public ResultStatus Edit(GEMA_TM_SLIDESHOW slideshow)
        {
            try
            {
                GEMA_TM_SLIDESHOW slideshowNew = _ctx.GEMA_TM_SLIDESHOW.Find(slideshow.ID);
                slideshowNew.TITTLE = slideshow.TITTLE;
                slideshowNew.CONTENT_DESCRIPTION = slideshow.CONTENT_DESCRIPTION;
                slideshowNew.CLASS              = slideshow.CLASS;
                slideshowNew.PHOTO_PATH         = slideshow.PHOTO_PATH;
                slideshowNew.URL                = slideshow.URL;
                slideshowNew.LAST_MODIFIED_TIME = slideshow.LAST_MODIFIED_TIME;
                slideshowNew.LAST_MODIFIED_BY   = slideshow.LAST_MODIFIED_BY;
                _ctx.Entry(slideshowNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Exemple #27
0
        public ResultStatus Edit(GEMA_TM_CATEGORY category)
        {
            try
            {
                GEMA_TM_CATEGORY categoryNew = _ctx.GEMA_TM_CATEGORY.Find(category.ID);
                categoryNew.CATEGORY_NAME      = category.CATEGORY_NAME;
                categoryNew.DESCRIPTION        = category.DESCRIPTION;
                categoryNew.URL                = category.URL;
                categoryNew.CLASS              = category.CLASS;
                categoryNew.IMAGE_PATH         = category.IMAGE_PATH;
                categoryNew.LAST_MODIFIED_TIME = category.LAST_MODIFIED_TIME;
                categoryNew.LAST_MODIFIED_BY   = category.LAST_MODIFIED_BY;
                _ctx.Entry(categoryNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
        /// <summary>
        /// 删除一个设备类别
        /// </summary>
        /// <param name="Id"></param>
        /// <returns>
        /// -2 : 指定Id的设备小类下面有设备
        /// -1 : 指定Id的设备种类不存在
        /// 0 : 指定Id的设备大类下有小类
        /// 1 : 删除成功
        /// </returns>
        public int DeleteEquipmentType(int id)
        {
            var equipmentType = DbCtx.EquipmentTypes
                                .FirstOrDefault(et => et.Id == id);

            if (equipmentType == null)
            {
                return(-1);
            }
            if (equipmentType.Type == 0)
            {
                IList <EquipmentType> equipmentTypes = DbCtx.EquipmentTypes
                                                       .Where(et => et.BigEquipmentType.Id == equipmentType.Id)
                                                       .ToList(); //查找当前大类下面是否有小类
                if (equipmentTypes.Count != 0)
                {
                    return(0);
                }
            }
            else if (equipmentType.Type == 1)
            {
                IList <Equipment> equipments = DbCtx.Equipments
                                               .Where(e => e.EquipmentType.Id == equipmentType.Id)
                                               .ToList(); //查找当前小类下面是否有设备
                if (equipments.Count != 0)
                {
                    return(-2);
                }
            }
            else
            {
                throw new MyException("应该只有大类和小类,请检查数据库", 6);
            }
            DbCtx.Entry(equipmentType).State = EntityState.Deleted;
            DbCtx.SaveChanges();
            return(1);
        }
Exemple #29
0
        /// <summary>
        /// 领用某一设备
        /// </summary>
        /// <param name="userId">要领用设备的用户Id</param>
        /// <param name="equipmentId">被领用设备的Id</param>
        /// <returns>
        /// 1 : 操作成功
        /// 0 : 没有对应的user或者没有对应的设备
        /// -1 : 设备已经被占用
        /// -2 : 设备在维修或已经报废
        /// </returns>
        public int BorrowEquipment(int userId, int equipmentId)
        {
            var user = DbCtx.Users
                       .FirstOrDefault(u => u.Id == userId);           //得到用户
            var equipment = DbCtx.Equipments
                            .FirstOrDefault(e => e.Id == equipmentId); //得到设备

            if (user == null || equipment == null)
            {
                return(0);
            }
            if (equipment.User != null) //设备被占用
            {
                return(-1);
            }
            if (equipment.State != 0) //设备在维修或者报废
            {
                return(-2);
            }
            equipment.User = user; //修改用户为指定用户
            DbCtx.Entry(equipment).State = EntityState.Modified;
            DbCtx.SaveChanges();
            return(1);
        }
Exemple #30
0
 public void Update(T entity)
 {
     ctx.Entry(entity).State = EntityState.Modified;
     ctx.SaveChanges();
 }