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