// GET: Providers/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CSales.Database.Models.Provider provider = this.db.Provider.Find(id); if (provider == null) { return(HttpNotFound()); } var prov = new DetailsProviderViewModel { Contact = provider.Contact, Id = provider.Id, IdBusinessName = provider.BusinessName.Id, IsActive = provider.IsActive, IsForeignProvider = provider.IsForeignProvider, Name = provider.Name, Telephones = this.db.TelephoneProvider.Where(t => t.IdPRV == provider.Id), Addresses = this.db.AddressProvider.Where(a => a.IdPRV == provider.Id), CitiesDistricts = this.db.CityProvider.Where(cd => cd.IdProv == provider.Id) }; return(View(prov)); }
public ActionResult Create(CreateProviderViewModel provider) { if (ModelState.IsValid) { var P = new CSales.Database.Models.Provider { Contact = provider.Contact, IsActive = provider.IsActive, Name = provider.Name, IsForeignProvider = provider.IsForeignProvider, }; this.db.Database.ExecuteSqlCommand(@"INSERT INTO PROVIDER(NAME, ISACTIVE, CONTACT, ISFOREIGNPROVIDER, BUSINESSNAME, CREATEDDATE) values ({0},{1},{2},{3},{4},{5})", provider.Name, provider.IsActive, provider.Contact, provider.IsForeignProvider, provider.IdBusinessName, DateTime.Now); var newProv = this.db.Provider.OrderByDescending(x => x.Id).FirstOrDefault(); for (int i = 0; i < provider.Addresses.Count(); i++) { this.db.Database.ExecuteSqlCommand(@"INSERT INTO APRV(ADDRESSNAME,DESCRIPTION,IDPRV) values ({0},{1},{2})", provider.Addresses.ElementAt(i), "Descripcion default", newProv.Id); } for (int i = 0; i < provider.Telephones.Count(); i++) { this.db.Database.ExecuteSqlCommand(@"INSERT INTO TELPROV(NUMBER,DESCRIPTION,IDPRV) values ({0},{1},{2})", provider.Telephones.ElementAt(i), "Descripcion default", newProv.Id); } var cCorriente = new CurrentAccountProvider { CreatedDate = DateTime.Now, IdProvider = newProv.Id, TotalDebt = 0 }; this.db.CurrentAcountProvider.Add(cCorriente); this.db.SaveChanges(); return(RedirectToAction("Index")); } this.ViewBag.IdBusinessName = new SelectList(db.BusinessName, "Id", "Name", provider.IdBusinessName); return(View(provider)); }