public async Task <ActionResult> DeleteConfirmed(Guid id)
        {
            SalesYearMaster salesYearMaster = await db.SalesYearMasters.FindAsync(id);

            db.SalesYearMasters.Remove(salesYearMaster);
            await db.SaveChangesAsync();

            return(RedirectToAction("Index"));
        }
        public async Task <ActionResult> Edit([Bind(Include = "Id,SalesYear,ApplicableFromDate,ApplicableToDate,Description,CreatedBy,CreatedDate,LastUpdatedDate,LastUpdatedBy,StatusCodeId")] SalesYearMaster salesYearMaster)
        {
            if (ModelState.IsValid)
            {
                db.Entry(salesYearMaster).State = EntityState.Modified;
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            //ViewBag.StatusCodeId = new SelectList(db.StatusCodeMasters, "Id", "StatusCodes", salesYearMaster.StatusCodeId);
            return(View(salesYearMaster));
        }
        // GET: SalesYearMasters/Details/5
        public async Task <ActionResult> Details(Guid?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            SalesYearMaster salesYearMaster = await db.SalesYearMasters.FindAsync(id);

            if (salesYearMaster == null)
            {
                return(HttpNotFound());
            }
            return(View(salesYearMaster));
        }
        // GET: SalesYearMasters/Edit/5
        public async Task <ActionResult> Edit(Guid?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            SalesYearMaster salesYearMaster = await db.SalesYearMasters.FindAsync(id);

            if (salesYearMaster == null)
            {
                return(HttpNotFound());
            }
            //ViewBag.StatusCodeId = new SelectList(db.StatusCodeMasters, "Id", "StatusCodes", salesYearMaster.StatusCodeId);
            return(View(salesYearMaster));
        }
Example #5
0
        public async Task <Guid> SaveStatus(SalesYearDTO _Dto, Guid Id, int EntityState)
        {
            SalesYearMaster _SalesYearMaster = new SalesYearMaster();

            _SalesYearMaster = await db.SalesYearMasters.Where(o => o.Id == Id).FirstOrDefaultAsync();

            if (_SalesYearMaster.StatusCode == EMPConstants.InActive)
            {
                _SalesYearMaster.StatusCode = EMPConstants.Active;
                //_SalesYearMaster.DeActivatedDate = null;
                //_SalesYearMaster.ActivatedDate = DateTime.Now;
            }
            else if (_SalesYearMaster.StatusCode == EMPConstants.Active)
            {
                //_SalesYearMaster.StatusCode = EMPConstants.InActive;
                //_SalesYearMaster.DeActivatedDate = DateTime.Now;
            }

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

                db.Dispose();
                return(_SalesYearMaster.Id);
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!IsExists(_SalesYearMaster.Id))
                {
                    return(Guid.Empty);
                }
                else
                {
                    throw;
                }
            }
        }
Example #6
0
        /// <summary>
        /// this method is used for Save & Update Sales Year Details
        /// </summary>
        /// <param name="_Dto"></param>
        /// <param name="Id"></param>
        /// <param name="EntityState"></param>
        /// <returns></returns>
        public Guid Save(SalesYearDTO _Dto, Guid Id, int EntityState)
        {
            SalesYearMaster _SalesYearMaster = new SalesYearMaster();

            if (_Dto != null)
            {
                if (_Dto.Id == Guid.Empty)
                {
                    var salesYearcheck = db.SalesYearMasters.Where(a => a.SalesYear == _Dto.SalesYear).Any();
                    if (salesYearcheck)
                    {
                        return(Guid.Empty);
                    }
                }

                _SalesYearMaster.Id        = Id;
                _SalesYearMaster.SalesYear = _Dto.SalesYear;

                _SalesYearMaster.Description = _Dto.Description;
                _SalesYearMaster.DateType    = _Dto.DateType;
                //if (_SalesYearMaster.DateType == true)
                if (System.DateTime.Now.Year < _SalesYearMaster.SalesYear)
                {
                    _SalesYearMaster.ApplicableFromDate = _Dto.ApplicableFromDate.Value.AddDays(1);
                    _SalesYearMaster.ApplicableToDate   = null;
                }
                else
                {
                    _SalesYearMaster.ApplicableToDate = DateTime.Now;// _Dto.ApplicableFromDate;
                }
                _SalesYearMaster.StatusCode = EMPConstants.Active;
            }

            if (EntityState == (int)System.Data.Entity.EntityState.Modified)
            {
                _SalesYearMaster.LastUpdatedDate = DateTime.Now;
                _SalesYearMaster.LastUpdatedBy   = _Dto.UserId;
                db.Entry(_SalesYearMaster).State = System.Data.Entity.EntityState.Modified;
            }
            else
            {
                bool iretbal = UpdatePreviousYearData(_SalesYearMaster.SalesYear ?? 0);
                if (iretbal)
                {
                    _SalesYearMaster.CreatedBy       = _Dto.UserId;
                    _SalesYearMaster.CreatedDate     = DateTime.Now;
                    _SalesYearMaster.LastUpdatedDate = DateTime.Now;
                    _SalesYearMaster.LastUpdatedBy   = _Dto.UserId;
                    db.SalesYearMasters.Add(_SalesYearMaster);
                }
                else
                {
                    return(Guid.Empty);
                }
            }

            try
            {
                db.SaveChanges();
                db.Dispose();

                SaveBankAssociatedDetail(Id, _Dto.BankInfoList, _Dto.UserId ?? Guid.Empty);
                //bool result = _DataMigrationService.SetArchiveData();
                return(_SalesYearMaster.Id);
            }

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