// 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));
}
