public void Vendor_Repository_Get_ALL()
{
//Act
var result = _objRepo.GetAll().ToList();
//Assert
Assert.IsNotNull(result);
_listCount = result.Count;
Assert.IsTrue(_listCount >= 0);
}
protected void grdVendorList_RowCommand(object sender, GridViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "VendorCmdDelete":
{
int VendorId = Convert.ToInt32(e.CommandArgument);
VendorRepository VenObj = new VendorRepository();
VenObj.Delete(VendorId);
List <VendorObject> VendorList = new List <VendorObject>();
VendorList = VenObj.GetAll();
grdVendorList.DataSource = VendorList;
grdVendorList.DataBind();
break;
}
default:
{
break;
}
}
}
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext)
{
List <ValidationResult> errors = new List <ValidationResult>();
CustomerRepository cdb = new CustomerRepository();
EmployeeRepository edb = new EmployeeRepository();
VendorRepository vdb = new VendorRepository();
//check if the same login id is available in employee, customer and vendor tables
if (cdb.GetAll().Where(x => x.LoginID == LoginID).FirstOrDefault() != null)
{
errors.Add(new ValidationResult($"User exists already.", new List <string> {
nameof(LoginID)
}));
}
if (edb.GetAll().Where(x => x.LoginID == LoginID).FirstOrDefault() != null)
{
errors.Add(new ValidationResult($"User exists already.", new List <string> {
nameof(LoginID)
}));
}
if (vdb.GetAll().Where(x => x.LoginID == LoginID).FirstOrDefault() != null)
{
errors.Add(new ValidationResult($"User exists already.", new List <string> {
nameof(LoginID)
}));
}
return(errors);
}
public ActionResult VendorList()
{
if (CheckAccess())
{
return(View(vendorrepo.GetAll()));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
VendorRepository VenObj = new VendorRepository();
List <VendorObject> VendorList = new List <VendorObject>();
VendorList = VenObj.GetAll();
grdVendorList.DataSource = VendorList;
grdVendorList.DataBind();
}
}
public IHttpActionResult GetVendors()
{
var vendorFromDB = vendorDB.GetAll();
if (vendorFromDB.Count != 0)
{
return(Ok(vendorFromDB));
}
else
{
return(StatusCode(HttpStatusCode.NotFound));
}
}
public IEnumerable <VendorViewModel> GetAllVendorsByBusinessAdmin(string BusinessAdminId)
{
using (var db = new VendorRepository())
{
return(db.GetAll().Select(model => new VendorViewModel
{
vendorId = model.vendorId,
VendorEmail = model.VendorEmail,
RegistrationDate = model.RegistrationDate,
TelephoneNumber = model.TelephoneNumber,
VendorPostalAddress = model.VendorPostalAddress,
VendorRegNo = model.VendorRegNo,
VendorName = model.VendorName,
}).Where(x => x.BusAdminId.Equals(BusinessAdminId)));
}
}
public IHttpActionResult PostProduct(Product product)
{
if (ModelState.IsValid)
{
LoginRepository loginRepository = new LoginRepository();
VendorRepository vendorRepository = new VendorRepository();
var loginFromDB = loginRepository.GetUserByUsername(Thread.CurrentPrincipal.Identity.Name.ToString());
var vendorFromDB = vendorRepository.GetAll().Where(x => x.LoginID == loginFromDB.ID).FirstOrDefault();
var checkProductFromDB = productDB.GetAll().Where(x => x.Name == product.Name && x.VendorID == vendorFromDB.ID).ToList();
if (checkProductFromDB.Count == 0)
{
product.VendorID = vendorFromDB.ID;
productDB.Insert(product);
var productFromDB = productDB.Get(product.ID);
var result = productFromDB.AddLinks(
new HyperMedia
{
Rel = "Get one product by ID",
Href = Url.Link("GetProductByID", new { id = productFromDB.ID }),
Method = "GET"
}
);
string uri = Url.Link("GetProductByID", new { id = productFromDB.ID });
return(Created(uri, result));
}
else
{
return(BadRequest("Product Exist"));
}
}
else
{
return(BadRequest(ModelState));
}
}
public IHttpActionResult DeleteRejectVendor(int id)
{
UserRepository userRepository = new UserRepository();
userRepository.Delete(id);
VendorRepository vendorRepository = new VendorRepository();
Vendor vendor = vendorRepository.GetAll().Where(v => v.UserId == id).FirstOrDefault();
if (vendor == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
vendorRepository.Delete(vendor.VendorId);
return(StatusCode(HttpStatusCode.NoContent));
}
}
public VendorViewModel GetById(int VendorId)
{
using (var db = new VendorRepository())
{
var vendordbRes = db.GetAll().ToList().Find(d => (d.vendorId.Equals(VendorId)));
var vendorview = new VendorViewModel();
{
vendorview.vendorId = vendordbRes.vendorId;
vendorview.VendorEmail = vendordbRes.VendorEmail;
vendorview.RegistrationDate = vendordbRes.RegistrationDate;
vendorview.TelephoneNumber = vendordbRes.TelephoneNumber;
vendorview.VendorPostalAddress = vendordbRes.VendorPostalAddress;
vendorview.VendorRegNo = vendordbRes.VendorRegNo;
vendorview.VendorName = vendordbRes.VendorName;
}
return(vendorview);
}
}
public HttpResponseMessage GetDrivers()
{
List <Data.vendor> vendor = repo.GetAll().ToList();
List <VendorBO> vendorList = new List <VendorBO>();
if (vendor.Count > 0)
{
foreach (var driv in vendor)
{
VendorBO vendorBO = new VendorBO();
vendorBO.vendid = driv.vendid;
vendorBO.vendkey = driv.vendkey;
vendorBO.vendname = driv.vendname;
vendorBO.status = driv.status;
vendorBO.statusdate = driv.statusdate;
var address = new AddressRepository().GetbyId(driv.addrkey);
if (address != null)
{
vendorBO.Address = new AddressBO()
{
AddrKey = address.addrkey,
Address1 = address.address1,
Address2 = address.address2,
City = address.city,
State = address.state,
Zip = address.zipcode,
Email = address.email,
Phone = address.phone,
Fax = address.fax
};
}
vendorList.Add(vendorBO);
}
return(Request.CreateResponse(HttpStatusCode.OK, vendorList, Configuration.Formatters.JsonFormatter));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Not found", Configuration.Formatters.JsonFormatter));
}
}
public ICollection <Vendor> GetAll()
{
return(_vendorRepository.GetAll());
}
public List <Vendor> GetAll()
{
return(_vendorRepository.GetAll());
}
public IEnumerable <AddressBO> GetAddressesByType(int addressType)
{
DeliveryOrderDL dl = new DeliveryOrderDL();
var list = EnumExtensions.GetEnumValues <AddressType>();
List <AddressBO> returnList = new List <AddressBO>();
var specifiedType = list.FirstOrDefault(a => a.Value == addressType);
AddressType addType;
Enum.TryParse(specifiedType.Name, out addType);
switch (addType)
{
case AddressType.Customer:
{
var CustomerRepository = new CustomerRepository();
var allcustomers = CustomerRepository.GetAll();
foreach (var customer in allcustomers)
{
var addressBO = dl.GetAddress(customer.addrkey);
addressBO.AddrKey = customer.addrkey;
addressBO.Name = customer.custname;
returnList.Add(addressBO);
}
}
break;
case AddressType.Company:
{
var DL = new CompanyDL();
var companies = DL.GetCompanies();
foreach (var company in companies)
{
var addressBO = DL.GetAddress(company.addrkey);
addressBO.AddrKey = company.addrkey;
addressBO.Name = company.compname;
returnList.Add(addressBO);
}
}
break;
case AddressType.ShippingPort:
{
var shippingRepo = new ShippingPortRepository();
var allPorts = shippingRepo.GetAll();
foreach (var port in allPorts)
{
var addressBO = dl.GetAddress(port.addrkey);
addressBO.AddrKey = port.addrkey;
addressBO.Name = port.shippingportid;
returnList.Add(addressBO);
}
}
break;
case AddressType.Terminal:
{
var shippingRepo = new TerminalRepository();
var allPorts = shippingRepo.GetAll();
foreach (var port in allPorts)
{
var addressBO = dl.GetAddress(port.addrkey);
addressBO.AddrKey = port.portkey;
returnList.Add(addressBO);
}
}
break;
case AddressType.Warehouse:
{
var shippingRepo = new WarehouseRepository();
var allPorts = shippingRepo.GetAll();
foreach (var port in allPorts)
{
var addressBO = dl.GetAddress(port.addrkey);
addressBO.AddrKey = port.warehousekey;
addressBO.Name = port.warehouseid;
returnList.Add(addressBO);
}
}
break;
case AddressType.Vendor:
{
var repo = new VendorRepository();
var allPorts = repo.GetAll();
foreach (var port in allPorts)
{
var addressBO = dl.GetAddress(port.addrkey);
addressBO.AddrKey = port.vendkey;
addressBO.Name = port.vendname;
returnList.Add(addressBO);
}
}
break;
}
return(returnList);
}
