public ActionResult PaymentPeriod() { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var paymentPeriodQuery = (from p in _dbContext.T_PaymentPeriod select p).FirstOrDefault(); if (paymentPeriodQuery == null) { paymentPeriodQuery = new JneCommSitesDataLayer.T_PaymentPeriod(); paymentPeriodQuery.dStartCutOffDate = DateTime.Now; } return(View(paymentPeriodQuery)); }
public ActionResult PaymentPeriod(JneCommSitesDataLayer.T_PaymentPeriod model) { JneCommSitesDataLayer.JneCommSitesDataBaseEntities _dbContext = new JneCommSitesDataLayer.JneCommSitesDataBaseEntities(); var paymentPeriodQuery = (from p in _dbContext.T_PaymentPeriod select p).FirstOrDefault(); if (paymentPeriodQuery != null) { paymentPeriodQuery.dStartCutOffDate = model.dStartCutOffDate; } else { JneCommSitesDataLayer.T_PaymentPeriod newPaymentPeriod = new JneCommSitesDataLayer.T_PaymentPeriod(); newPaymentPeriod.dStartCutOffDate = DateTime.Now; newPaymentPeriod.siDaysForPaymentPeriod = 15; _dbContext.T_PaymentPeriod.Add(newPaymentPeriod); } _dbContext.SaveChanges(); return(View(paymentPeriodQuery)); }