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)); }
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; } } }
/// <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; } } }