// // GET: /DailyJvDetail/Create public ActionResult Create() { EHMSEntities ent = new EHMSEntities(); if (ent.GL_Transaction.Where(x => x.TransactionDate.Year == DateTime.Now.Year && x.TransactionDate.Month == DateTime.Now.Month && x.TransactionDate.Day == DateTime.Now.Day).Any() == false) { int msg = 1; return(RedirectToAction("Index/" + msg)); } else if (ent.DailyJvDetails.Where(x => x.Date == DateTime.Today).Any()) { int msg = 2; return(RedirectToAction("Index/" + msg)); } DailyJvDetailModel model = new DailyJvDetailModel(); model.JvDetailList = new List <DailyJvDetailModel>(); model.Date = DateTime.Today; model.JvNo = ent.SetupVoucherNumbers.FirstOrDefault().VoucherNo.ToString(); model.HospitalDetail = new SetUpHospitalDetailModel(); var obj = ent.SetupHospitalDetails.FirstOrDefault(); AutoMapper.Mapper.Map(obj, model.HospitalDetail); var gtlist = (from gt in ent.GL_Transaction where (gt.TransactionDate.Year == model.Date.Year && gt.TransactionDate.Month == model.Date.Month && gt.TransactionDate.Day == model.Date.Day) group gt by gt.Narration1 into grouplist select new { headname = grouplist.Key, headtotal = grouplist.Sum(x => x.Amount) }).ToList(); foreach (var item in gtlist) { DailyJvDetailModel md = new DailyJvDetailModel(); md.AccountHead = item.headname; md.CrAmount = item.headtotal; model.JvDetailList.Add(md); } return(View(model)); }
public void Insert(DailyJvDetailModel model) { EHMSEntities ent = new EHMSEntities(); DailyJvDetail obj = new DailyJvDetail(); obj.JvNo = model.JvNo; obj.Narration = model.Narration; obj.Date = model.Date; obj.DrCr = "Dr"; obj.AccountHead = "Bank or Cash"; obj.DrAmount = model.DrAmount; obj.CrAmount = 0; obj.Status = true; obj.VerifiedBy = 1; obj.CreatedBy = 1; obj.CreatedDate = DateTime.Today; ent.DailyJvDetails.Add(obj); //ent.SaveChanges(); foreach (var item in model.JvDetailList) { obj = new DailyJvDetail(); obj.JvNo = model.JvNo; obj.Narration = model.Narration; obj.Date = model.Date; obj.DrCr = "Cr"; obj.AccountHead = item.AccountHead; obj.CrAmount = item.CrAmount; obj.DrAmount = 0; obj.Status = true; obj.VerifiedBy = 1; obj.CreatedBy = 1; obj.CreatedDate = DateTime.Today; ent.DailyJvDetails.Add(obj); } var objvn = ent.SetupVoucherNumbers.FirstOrDefault(); objvn.VoucherNo = objvn.VoucherNo + 1; ent.Entry(objvn).State = System.Data.EntityState.Modified; ent.SaveChanges(); }
public ActionResult Create(DailyJvDetailModel model) { try { // TODO: Add insert logic here pro.Insert(model); return(RedirectToAction("Index")); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } return(View()); } }