public ActionResult Edit(ViewModels.CompanyEditViewModel viewModel) { if (!ModelState.IsValid) { return(View(viewModel)); } using (var entities = new SPOInvoiceEntities()) { var model = entities.Company.FirstOrDefault(c => c.id == viewModel.id); model.InvoiceAddress = viewModel.InvoiceAddress; model.InvoiceDefaultPaymentTermsDays = viewModel.InvoiceDefaultPaymentTermsDays; model.InvoiceEmail = viewModel.InvoiceEmail; model.InvoiceName = viewModel.InvoiceName; model.InvoicePostAddress = viewModel.InvoicePostAddress; model.InvoicePostNo = viewModel.InvoicePostNo; model.name = viewModel.name; model.OrgNo = viewModel.OrgNo; model.Founded = viewModel.Founded; var changeLog = new Models.ChangeLog(); changeLog.datum = DateTime.Now; changeLog.description = "Company with id " + viewModel.id + " was edited"; entities.ChangeLog.Add(changeLog); entities.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Delete(int id) { using (var entities = new SPOInvoiceEntities()) { var obj = entities.Company.FirstOrDefault(x => x.id == id); entities.Company.RemoveRange(new[] { obj }); entities.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Create(ViewModels.CompanyEditViewModel viewModel) { if (!ModelState.IsValid) { return(View(viewModel)); } using (var entities = new SPOInvoiceEntities()) { var model = new Models.Company(); model.InvoiceAddress = viewModel.InvoiceAddress; model.InvoiceDefaultPaymentTermsDays = viewModel.InvoiceDefaultPaymentTermsDays; model.InvoiceEmail = viewModel.InvoiceEmail; model.InvoiceName = viewModel.InvoiceName; model.InvoicePostAddress = viewModel.InvoicePostAddress; model.InvoicePostNo = viewModel.InvoicePostNo; model.name = viewModel.name; model.OrgNo = viewModel.OrgNo; model.Founded = viewModel.Founded; entities.Company.Add(model); // EF FIXAR RELATIONER!!! //GENOM PROPERTY //var invoice = new Models.Invoice(); //invoice.Datum = DateTime.Now; //invoice.InvoiceAddress = model.InvoiceAddress; //invoice.Company = model; //entities.Invoice.Add(invoice); var changeLog = new Models.ChangeLog(); changeLog.datum = DateTime.Now; changeLog.description = "A new Company was created"; entities.ChangeLog.Add(changeLog); entities.SaveChanges(); return(RedirectToAction("Index")); } }
// GET: Company public ActionResult Index() { var viewModel = new ViewModels.CompanyListViewModel(); using (var entities = new SPOInvoiceEntities()) { foreach (var dbCompany in entities.Company) { viewModel.Companies.Add(new ViewModels.CompanyListViewModel.CompanyViewModel { Id = dbCompany.id, Name = dbCompany.name, OrgNo = dbCompany.OrgNo } ); } } return(View(viewModel)); }
protected ViewModels.CompanyEditViewModel GetCompanyFromDatabaseAndConvertToViewModel(int id) { using (var entities = new SPOInvoiceEntities()) { var model = entities.Company.FirstOrDefault(c => c.id == id); var viewModel = new ViewModels.CompanyEditViewModel(); viewModel.id = model.id; viewModel.InvoiceAddress = model.InvoiceAddress; viewModel.InvoiceDefaultPaymentTermsDays = model.InvoiceDefaultPaymentTermsDays.HasValue ? model.InvoiceDefaultPaymentTermsDays.Value : 30; viewModel.InvoiceEmail = model.InvoiceEmail; viewModel.InvoiceName = model.InvoiceName; viewModel.InvoicePostAddress = model.InvoicePostAddress; viewModel.InvoicePostNo = model.InvoicePostNo; viewModel.name = model.name; viewModel.OrgNo = model.OrgNo; viewModel.Founded = model.Founded.HasValue ? model.Founded.Value : DateTime.Now; return(viewModel); } }