public IHttpActionResult CreateCategory(Category category) { //if (!ModelState.IsValid) // return BadRequest(); _context.Categories.Add(category); _context.SaveChanges(); return(Created(Request.RequestUri, category)); }
public IHttpActionResult SusspendSupplier(Login login) { var loginInDB = _context.Logins.SingleOrDefault(l => l.CompanyCode == login.CompanyCode); if (loginInDB == null) { return(NotFound()); } var supplierInDB = _context.Suppliers.SingleOrDefault(s => s.CompanyCode == login.CompanyCode); if (loginInDB.Susspended == "YES") { loginInDB.Susspended = "NO"; supplierInDB.Susspended = "NO"; } else { loginInDB.Susspended = "YES"; supplierInDB.Susspended = "YES"; } _context.SaveChanges(); return(Ok(loginInDB)); }
public IHttpActionResult ConfirmPayment(SupplierPublicTender supplierPublicTender) { // var supplierTenderInDB = _context.SupplierPublicTenders // .ToList().FindAll(s => s.SupplierID == supplierPublicTender.SupplierID); var supplierTenderInDB = _context.SupplierPublicTenders .FirstOrDefault(s => s.PublicTenderID == supplierPublicTender.PublicTenderID && s.SupplierID == supplierPublicTender.SupplierID); if (supplierTenderInDB != null) { if (supplierTenderInDB.Paid == "YES") { supplierTenderInDB.Paid = "NO"; _context.SaveChanges(); } else { supplierTenderInDB.Paid = "YES"; _context.SaveChanges(); } return(Ok(supplierTenderInDB)); } //for(var i = 0; i < supplierTenderInDB.Count; i++) //{ // if(supplierTenderInDB[i].PublicTenderID == supplierPublicTender.PublicTenderID) // { // if (supplierTenderInDB[i].Paid == "YES") // { // supplierTenderInDB[i].Paid = "NO"; // } // else // { // supplierTenderInDB[i].Paid = "YES"; // } // return Ok(); // } //} return(NotFound()); }
public IHttpActionResult UpdateTender(int id, PrivateTender tender) { if (!ModelState.IsValid) { return(BadRequest()); } var tenderInDB = _context.PrivateTenders.SingleOrDefault(t => t.ID == id); if (tenderInDB == null) { return(NotFound()); } tenderInDB.SupplierID = tender.SupplierID; _context.SaveChanges(); return(Ok(tenderInDB)); }
public IHttpActionResult DeleteNewSupplier(int id) { if (!ModelState.IsValid) { return(BadRequest()); } var newSupplierInDB = _context.NewSuppliers.SingleOrDefault(ns => ns.ID == id); if (newSupplierInDB == null) { return(NotFound()); } _context.NewSuppliers.Remove(newSupplierInDB); _context.SaveChanges(); return(Ok()); }
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)); }