}//edit // GET: Contractors/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Contractors contractordetail = db.Contractors.Find(id); if (contractordetail == null) { return(HttpNotFound()); } ContractorsViewModel view = new ContractorsViewModel(); view.Id_Contractor = contractordetail.Id_Contractor; view.CompanyName = contractordetail.CompanyName; view.ContactPerson = contractordetail.ContactPerson; view.PhoneNumber = contractordetail.PhoneNumber; view.EmailAddress = contractordetail.EmailAddress; view.VatId = contractordetail.VatId; view.HourlyRate = contractordetail.HourlyRate; view.CreatedAt = contractordetail.CreatedAt; view.LastModifiedAt = DateTime.Now; view.DeletedAt = DateTime.Now; view.Active = contractordetail.Active; return(View(view)); }
public ActionResult Create(ContractorsViewModel model) { MobileWorkDataEntities db = new MobileWorkDataEntities(); Contractors con = new Contractors(); con.CompanyName = model.CompanyName; con.ContactPerson = model.ContactPerson; con.PhoneNumber = model.PhoneNumber; con.EmailAddress = model.EmailAddress; con.VatId = model.VatId; con.HourlyRate = model.HourlyRate; con.CreatedAt = DateTime.Now; con.LastModifiedAt = DateTime.Now; con.DeletedAt = model.DeletedAt; con.Active = model.Active; db.Contractors.Add(con); try { db.SaveChanges(); } catch (Exception ex) { } return(RedirectToAction("Index")); }//create
}//details // GET: Contractors/Create public ActionResult Create() { MobileWorkDataEntities db = new MobileWorkDataEntities(); ContractorsViewModel model = new ContractorsViewModel(); return(View(model)); }//create
public ActionResult Edit(ContractorsViewModel model) { Contractors con = new Contractors(); con.CompanyName = model.CompanyName; con.ContactPerson = model.ContactPerson; con.PhoneNumber = model.PhoneNumber; con.EmailAddress = model.EmailAddress; con.VatId = model.VatId; con.HourlyRate = model.HourlyRate; con.CreatedAt = model.CreatedAt; con.LastModifiedAt = DateTime.Now; con.DeletedAt = model.DeletedAt; con.Active = model.Active; db.SaveChanges(); return(View("Index")); }//edit
// GET: Contractors public ActionResult Index() { List <ContractorsViewModel> model = new List <ContractorsViewModel>(); MobileWorkDataEntities entities = new MobileWorkDataEntities(); try { List <Contractors> contractors = entities.Contractors.OrderBy(Contractors => Contractors.CompanyName).ToList(); // muodostetaan näkymämalli tietokannan rivien pohjalta foreach (Contractors contractor in contractors) { ContractorsViewModel view = new ContractorsViewModel(); view.Id_Contractor = contractor.Id_Contractor; view.CompanyName = contractor.CompanyName; view.ContactPerson = contractor.ContactPerson; view.PhoneNumber = contractor.PhoneNumber; view.EmailAddress = contractor.EmailAddress; view.VatId = contractor.VatId; view.HourlyRate = contractor.HourlyRate; view.CreatedAt = contractor.CreatedAt; view.LastModifiedAt = contractor.LastModifiedAt; view.DeletedAt = contractor.DeletedAt; view.Active = contractor.Active; view.Id_PinCode = contractor.PinCodes.FirstOrDefault()?.Id_PinCode; view.PinCode = contractor.PinCodes.FirstOrDefault()?.PinCode; ViewBag.PinCode = new SelectList((from u in db.PinCodes select new { Id_PinCode = u.Id_PinCode, PinCode = u.PinCode }), "Id_PinCode", "PinCode", null); model.Add(view); } } finally { entities.Dispose(); } return(View(model)); }//Index
}//Index // GET: Contractors/Details/5 public ActionResult Details(int?id) { ContractorsViewModel model = new ContractorsViewModel(); MobileWorkDataEntities entities = new MobileWorkDataEntities(); try { Contractors contractordetail = entities.Contractors.Find(id); if (contractordetail == null) { return(HttpNotFound()); } // muodostetaan näkymämalli tietokannan rivien pohjalta ContractorsViewModel view = new ContractorsViewModel(); view.Id_Contractor = contractordetail.Id_Contractor; view.CompanyName = contractordetail.CompanyName; view.ContactPerson = contractordetail.ContactPerson; view.PhoneNumber = contractordetail.PhoneNumber; view.EmailAddress = contractordetail.EmailAddress; view.VatId = contractordetail.VatId; view.HourlyRate = contractordetail.HourlyRate; view.CreatedAt = contractordetail.CreatedAt; view.LastModifiedAt = contractordetail.LastModifiedAt; view.DeletedAt = contractordetail.DeletedAt; view.Active = contractordetail.Active; model = view; } finally { entities.Dispose(); } return(View(model)); }//details