// GET api/Supplier/ID public IHttpActionResult GetSupplier(int id) { if (id == 0) { return(BadRequest()); } var supplier = _context.Suppliers.SingleOrDefault(s => s.ID == id); if (supplier == null) { return(NotFound()); } var suppSubCats = _context.SupplierSubCategories.Include(sc => sc.SubCategory).ToList().FindAll(ssc => ssc.SupplierID == id).Select(sc => sc.SubCategory); var suppPhone = _context.SupplierPhones.SingleOrDefault(ssc => ssc.SupplierID == id).Phone; var suppFax = _context.SupplierFaxes.SingleOrDefault(ssc => ssc.SupplierID == id).Fax; var supplierInfo = new SupplierTelFaxViewModel() { Supplier = supplier, subCategories = suppSubCats, SupplierFax = suppFax, SupplierPhone = suppPhone }; return(Ok(supplierInfo)); }
public IHttpActionResult GetInfo(Login login) { var loginInDB = _context.Logins.SingleOrDefault(l => l.CompanyCode == login.CompanyCode); if (loginInDB == null) { return(BadRequest()); } if (login.Password != loginInDB.Password) { return(BadRequest()); } var userInDB = _context.Suppliers.SingleOrDefault(u => u.CompanyCode == loginInDB.CompanyCode); var telInDB = _context.SupplierPhones.SingleOrDefault(t => t.SupplierID == userInDB.ID); var faxInDB = _context.SupplierFaxes.SingleOrDefault(f => f.SupplierID == userInDB.ID); var viewModel = new SupplierTelFaxViewModel() { Supplier = userInDB, SupplierFax = faxInDB.Fax, SupplierPhone = telInDB.Phone, subCategories = null }; return(Ok(viewModel)); }
public IHttpActionResult UpdateSupplier(SupplierTelFaxViewModel supplierTelFaxViewModel) { //if (!ModelState.IsValid) // return BadRequest(); var supplierInDB = _context.Suppliers.SingleOrDefault(s => s.ID == supplierTelFaxViewModel.Supplier.ID); if (supplierInDB == null) { return(NotFound()); } #region ManualMapper supplierInDB.CompanyName = supplierTelFaxViewModel.Supplier.CompanyName; supplierInDB.Address = supplierTelFaxViewModel.Supplier.Address; supplierInDB.CompanyCode = supplierTelFaxViewModel.Supplier.CompanyCode; supplierInDB.Email = supplierTelFaxViewModel.Supplier.Email; supplierInDB.LegalPaperwork = supplierTelFaxViewModel.Supplier.LegalPaperwork; supplierInDB.InfoPaperwork = supplierTelFaxViewModel.Supplier.InfoPaperwork; supplierInDB.ManagerName = supplierTelFaxViewModel.Supplier.ManagerName; supplierInDB.ManagerPhone = supplierTelFaxViewModel.Supplier.ManagerPhone; supplierInDB.Password = supplierTelFaxViewModel.Supplier.Password; supplierInDB.AddedDate = supplierTelFaxViewModel.Supplier.AddedDate; var phone = _context.SupplierPhones.SingleOrDefault(p => p.SupplierID == supplierInDB.ID); var fax = _context.SupplierFaxes.SingleOrDefault(f => f.SupplierID == supplierInDB.ID); if (phone == null) { phone.Supplier = supplierTelFaxViewModel.Supplier; phone.Phone = supplierTelFaxViewModel.SupplierPhone; } else { phone.Phone = supplierTelFaxViewModel.SupplierPhone; } if (fax == null) { fax.Supplier = supplierTelFaxViewModel.Supplier; fax.Fax = supplierTelFaxViewModel.SupplierFax; } else { fax.Fax = supplierTelFaxViewModel.SupplierFax; } #endregion _context.SaveChanges(); return(Ok(supplierInDB)); }
public IHttpActionResult Confirmed(NewSupplier newSupplier) { SupplierController controller = new SupplierController(); var supplier = new Supplier() { CompanyName = newSupplier.CompanyName, AddedDate = DateTime.Now, Address = newSupplier.Address, Email = newSupplier.Email, ManagerName = newSupplier.ManagerName, ManagerPhone = newSupplier.ManagerPhone, InfoPaperwork = newSupplier.InfoPaperwork, LegalPaperwork = newSupplier.LegalPaperwork, Password = newSupplier.Password, CompanyCode = newSupplier.CompanyCode }; var login = new Login() { CompanyCode = newSupplier.CompanyCode, Password = newSupplier.Password }; _context.Logins.Add(login); var viewModel = new SupplierTelFaxViewModel() { Supplier = supplier, SupplierPhone = newSupplier.Phone, SupplierFax = newSupplier.Fax, subCategories = _context.SubCategories.ToList().FindAll(ssc => ssc.ID == newSupplier.SubCategoryID) }; var deletedSupplier = _context.NewSuppliers.SingleOrDefault(ds => ds.ID == newSupplier.ID); _context.NewSuppliers.Remove(deletedSupplier); _context.SaveChanges(); return(controller.CreateSupplier(viewModel)); }
public IHttpActionResult CreateSupplier(SupplierTelFaxViewModel supplierTelFaxViewModel) { var subCats = new List <int>(); foreach (var sc in supplierTelFaxViewModel.subCategories) { subCats.Add(sc.ID); } //if (!ModelState.IsValid) // return BadRequest(); if (subCats.Count == 0) { return(BadRequest()); } var supplier = new Supplier(supplierTelFaxViewModel.Supplier); supplier.Susspended = "NO"; _context.Suppliers.Add(supplier); var supplierPhone = new SupplierPhones() { Phone = supplierTelFaxViewModel.SupplierPhone, SupplierID = supplier.ID, Supplier = supplier }; _context.SupplierPhones.Add(supplierPhone); var supplierFax = new SupplierFaxes() { Fax = supplierTelFaxViewModel.SupplierFax, SupplierID = supplier.ID, Supplier = supplier }; _context.SupplierFaxes.Add(supplierFax); var login = new Login() { //Susspended = "NO", CompanyCode = supplier.CompanyCode, Password = supplier.Password }; //login.Susspended = "NO"; var listOfSubCats = supplierTelFaxViewModel.subCategories; var subCatSupp = new SubCategory(); foreach (var subCat in listOfSubCats) { subCatSupp = subCat; subCatSupp.ID = subCat.ID; _context.SupplierSubCategories.Add(new SupplierSubCategories() { SubCategoryID = subCat.ID, SupplierID = supplier.ID }); } var listOfPublicTenders = new List <PublicTender>(); var publicTendersInDB = _context.PublicTenders.ToList(); for (var i = 0; i < publicTendersInDB.Count; i++) { if (publicTendersInDB[i].SubCategoryID == subCatSupp.ID) { listOfPublicTenders.Add(publicTendersInDB[i]); } } _context.SaveChanges(); for (var i = 0; i < listOfPublicTenders.Count; i++) { _context.SupplierPublicTenders.Add( new SupplierPublicTender { Date = DateTime.Now, SupplierID = supplier.ID, Supplier = supplier, PublicTenderID = listOfPublicTenders[i].ID, PublicTender = listOfPublicTenders[i] }); _context.SaveChanges(); } //_context.Logins.Add(login); return(Created("", supplier)); }
public IHttpActionResult post(SupplierTelFaxViewModel supplierTelFaxViewModel) { var subCats = new List <int>(); foreach (var sc in supplierTelFaxViewModel.subCategories) { subCats.Add(sc.ID); } //if (!ModelState.IsValid) // return BadRequest(); if (subCats.Count == 0) { return(BadRequest()); } var supplier = new Supplier(supplierTelFaxViewModel.Supplier); _context.Suppliers.Add(supplier); _context.SaveChanges(); var supplierPhone = new SupplierPhones() { Phone = supplierTelFaxViewModel.SupplierPhone, SupplierID = supplier.ID }; var supplierFax = new SupplierFaxes() { Fax = supplierTelFaxViewModel.SupplierFax, SupplierID = supplier.ID }; var login = new Login() { CompanyCode = supplier.CompanyCode, Password = supplier.Password }; _context.Logins.Add(login); _context.SupplierPhones.Add(supplierPhone); _context.SaveChanges(); _context.SupplierFaxes.Add(supplierFax); _context.SaveChanges(); var listOfSubCats = supplierTelFaxViewModel.subCategories; foreach (var subCat in listOfSubCats) { _context.SupplierSubCategories.Add(new SupplierSubCategories() { SubCategoryID = subCat.ID, SupplierID = supplier.ID }); } _context.SaveChanges(); return(Created("", supplier)); }