public ActionResult Create(//[Bind(Include = "SettingsId,CompanyId,BankInterest,BankCharges")]
sdtoSettings Settings)
{
if (ModelState.IsValid)
{
Settings.CreatedOn = DateTime.Now;
db.GeneralSettings.Add(Settings);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(Settings);
}
// GET: Settings/Edit/5
public ActionResult EditOnCreate(sdtoSettings sdtoSettings)
{
if (sdtoSettings == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
if (sdtoSettings == null)
{
return HttpNotFound();
}
return View(sdtoSettings);
}
public ActionResult Edit(//[Bind(Include = "SettingsId,CompanyId,BankInterest,BankCharges,CreatedBy,CreatedOn,ModifiedBy,ModifiedOn")]
sdtoSettings Settings)
{
if (ModelState.IsValid)
{
Settings.CreatedOn = DateTime.Now;
Settings.ModifiedOn = DateTime.Now;
if (Settings.InterestAccountId == 0)
Settings.InterestAccountId = null;
db.Entry(Settings).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index", "Home");
}
ViewBag.CompanyList = new SelectList(db.Companies, "CompanyId", "CompanyName");
var assetSchedule = db.Schedules.Where(x => x.ShortName == "AS").FirstOrDefault();
var SelectListAsset = db.Schedules.Where(x => x.BaseScheduleId == assetSchedule.ScheduleId || x.ScheduleId == assetSchedule.ScheduleId).ToList();
ViewBag.AssetScheduleList = new SelectList(SelectListAsset, "ScheduleId", "ScheduleName", 0);
var liabilitySchedule = db.Schedules.Where(x => x.ShortName == "LY").FirstOrDefault();
var SelectListLiability = db.Schedules.Where(x => x.BaseScheduleId == liabilitySchedule.ScheduleId || x.ScheduleId == liabilitySchedule.ScheduleId).ToList();
ViewBag.LiabilityScheduleList = new SelectList(SelectListLiability, "ScheduleId", "ScheduleName", 0);
var expenditureSchedule = db.Schedules.Where(x => x.ShortName == "EX").FirstOrDefault();
var SelectListExpenditure = db.Schedules.Where(x => x.BaseScheduleId == expenditureSchedule.ScheduleId || x.ScheduleId == expenditureSchedule.ScheduleId).ToList();
ViewBag.ExpenditureScheduleList = new SelectList(SelectListExpenditure, "ScheduleId", "ScheduleName", 0);
var incomeSchedule = db.Schedules.Where(x => x.ShortName == "IC").FirstOrDefault();
var SelectListIncome = db.Schedules.Where(x => x.BaseScheduleId == incomeSchedule.ScheduleId || x.ScheduleId == incomeSchedule.ScheduleId).ToList();
ViewBag.IncomeScheduleList = new SelectList(SelectListIncome, "ScheduleId", "ScheduleName", 0);
var AccountList = db.AccountBooks.Where(x => x.IsDeleted == false).ToList();
AccountList.Insert(0, new sdtoAccountBook() { AccountBookId = 0, BookName = "Select an Account" });
ViewBag.AccountList = new SelectList(AccountList, "AccountBookId", "BookName", 0);
var scheduleList = db.Schedules.ToList();
scheduleList.Insert(0, new Data.Models.Accounts.Schedules.sdtoSchedule() { ScheduleId = 0, ScheduleName = "Select a Schedule" });
ViewBag.ScheduleList = new SelectList(scheduleList, "ScheduleId", "ScheduleName", 0);
var bookList = db.AccountBooks.ToList();
bookList.Insert(0, new Data.Models.Accounts.sdtoAccountBook { AccountBookId = 0, BookName = "Select a Book" });
ViewBag.BookList = new SelectList(bookList, "AccountBookId", "BookName", 0);
var cashBookType = db.AccountBookTypes.Where(x => x.UniqueName.Equals("CASH", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
var cashBookList = db.AccountBooks.Where(x => x.AccountBookTypeId == cashBookType.AccountBookTypeId).ToList();
cashBookList.Insert(0, new Data.Models.Accounts.sdtoAccountBook { AccountBookId = 0, BookName = "Select a Book" });
ViewBag.CashBookList = new SelectList(cashBookList, "AccountBookId", "BookName", 0);
var bankBookType = db.AccountBookTypes.Where(x => x.UniqueName.Equals("BANK", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
var bankBookList = db.AccountBooks.Where(x => x.AccountBookTypeId == bankBookType.AccountBookTypeId).ToList();
bankBookList.Insert(0, new Data.Models.Accounts.sdtoAccountBook { AccountBookId = 0, BookName = "Select a Book" });
ViewBag.BankBookList = new SelectList(bankBookList, "AccountBookId", "BookName", 0);
var journalBookType = db.AccountBookTypes.Where(x => x.UniqueName.Equals("journal", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
var journalBookList = db.AccountBooks.Where(x => x.AccountBookTypeId == journalBookType.AccountBookTypeId).ToList();
journalBookList.Insert(0, new Data.Models.Accounts.sdtoAccountBook { AccountBookId = 0, BookName = "Select a Book" });
ViewBag.JournalBookList = new SelectList(journalBookList, "AccountBookId", "BookName", 0);
var otherAccType = db.AccountTypes.Where(x => x.UniqueName.Equals("Other", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
var otherAccountHeads = db.AccountHeads.Where(x => x.AccountTypeId == otherAccType.AccountTypeId).ToList();
otherAccountHeads.Insert(0, new Data.Models.Accounts.sdtoAccountHead { AccountHeadId = 0, AccountName = "Select a Acount" });
ViewBag.OtherAccountHeads = new SelectList(otherAccountHeads, "AccountHeadId", "AccountName", 0);
return View(Settings);
}