Example #1
0
        public async Task <int> Save(PhoneTypeDTO _Dto, Guid Id, int EntityState)
        {
            PhoneTypeMaster _phoneTypeMaster = new PhoneTypeMaster();

            if (_Dto != null)
            {
                _phoneTypeMaster.Id            = Id;
                _phoneTypeMaster.PhoneType     = _Dto.PhoneType;
                _phoneTypeMaster.Description   = _Dto.Description;
                _phoneTypeMaster.ActivatedDate = DateTime.Now;
                _phoneTypeMaster.StatusCode    = EMPConstants.Active;
            }

            if (_Dto.Id != null)
            {
                _phoneTypeMaster.CreatedBy       = _Dto.UserId;
                _phoneTypeMaster.CreatedDate     = DateTime.Now;
                _phoneTypeMaster.LastUpdatedBy   = _Dto.UserId;
                _phoneTypeMaster.LastUpdatedDate = DateTime.Now;
            }
            else
            {
                _phoneTypeMaster.LastUpdatedBy   = _Dto.UserId;
                _phoneTypeMaster.LastUpdatedDate = DateTime.Now;
            }

            if (EntityState == (int)System.Data.Entity.EntityState.Modified)
            {
                var ExistPhone = db.PhoneTypeMasters.Where(o => o.Id != Id && o.PhoneType == _Dto.PhoneType).Any();
                if (ExistPhone)
                {
                    return(-1);
                }

                db.Entry(_phoneTypeMaster).State = System.Data.Entity.EntityState.Modified;
            }
            else
            {
                var ExistPhone = db.PhoneTypeMasters.Where(o => o.PhoneType == _Dto.PhoneType).Any();
                if (ExistPhone)
                {
                    return(-1);
                }
                db.PhoneTypeMasters.Add(_phoneTypeMaster);
            }

            try
            {
                await db.SaveChangesAsync();

                return(1);
            }

            catch (DbUpdateConcurrencyException)
            {
                return(0);
            }
        }
Example #2
0
        public async Task <Guid> SaveStatus(PhoneTypeDTO _Dto, Guid Id, int EntityState)
        {
            PhoneTypeMaster PhoneType = new PhoneTypeMaster();

            PhoneType = await db.PhoneTypeMasters.Where(o => o.Id == Id).FirstOrDefaultAsync();

            PhoneType.ActivatedDate = DateTime.Now;

            if (PhoneType.StatusCode == EMPConstants.InActive)
            {
                PhoneType.StatusCode = EMPConstants.Active;
            }
            else if (PhoneType.StatusCode == EMPConstants.Active)
            {
                PhoneType.StatusCode = EMPConstants.InActive;
            }

            if (EntityState == (int)System.Data.Entity.EntityState.Modified)
            {
                PhoneType.LastUpdatedDate = DateTime.Now;
                PhoneType.LastUpdatedBy   = _Dto.UserId;
                db.Entry(PhoneType).State = System.Data.Entity.EntityState.Modified;
            }

            try
            {
                await db.SaveChangesAsync();

                db.Dispose();
                return(PhoneType.Id);
            }

            catch (DbUpdateConcurrencyException)
            {
                if (!IsExists(PhoneType.Id))
                {
                    return(Guid.Empty);
                }
                else
                {
                    throw;
                }
            }
        }