public VendorViewModel saveVendor(VendorViewModel vendorViewModel)
{
VendorDTO vendorDTO = new VendorDTO();
var vendorMapper = new ecvMapper <VendorModel, VendorDTO>();
vendorDTO = vendorMapper.CreateMappedObject(vendorViewModel.vendorModel);
var _vendorServiceStatus = _vendorService.SaveVendor(vendorDTO);
if (_vendorServiceStatus.operationStatus == OperationStatus.Error)
{
vendorViewModel.operationStatus = OperationStatus.Error;
if (!string.IsNullOrEmpty(_vendorServiceStatus.OperationMessage))
{
vendorViewModel.OperationMessage = _vendorServiceStatus.OperationMessage;
}
vendorViewModel.ecvRuleViolation = _vendorServiceStatus.ecvRuleViolation;
}
else
{
vendorViewModel.operationStatus = OperationStatus.Success;
if (!string.IsNullOrEmpty(_vendorServiceStatus.OperationMessage))
{
vendorViewModel.OperationMessage = _vendorServiceStatus.OperationMessage;
}
vendorViewModel.ecvRuleViolation = _vendorServiceStatus.ecvRuleViolation;
}
return(vendorViewModel);
}
public async Task <IActionResult> UpdateVendor(int id, VendorDTO VendorDTO)
{
if (id != VendorDTO.ID)
{
return(m_HttpController.BadRequest());
}
m_Context.Entry(VendorDTO).State = EntityState.Modified;
try
{
await m_Context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VendorExists(id))
{
return(m_HttpController.NotFound());
}
else
{
throw;
}
}
return(m_HttpController.NoContent());
}
public void AddVendor(VendorDTO vendor)
{
_dbcontext.Vendors.Create(new Vendor {
Name = vendor.Name, Address = vendor.Address
});
_dbcontext.SaveChanges();
}
public IHttpActionResult Create([FromBody] VendorDTO vendor)
{
ThrowIfUserHasNoRole(createRole);
if (vendor == null)
{
throw new KairosException("Missing model parameter");
}
if (vendor.Vendor_PK != 0)
{
throw new KairosException("Post method is not allowed because the requested primary key is must be '0' (zero) .");
}
using (var vendorCreateHandler = new VendorCreateHandler(Db, ActiveUser, new VendorValidator(), new VendorFactory(Db, ActiveUser), new VendorQuery(Db), AccessControl))
{
using (var transaction = new TransactionScope())
{
var saveResult = vendorCreateHandler.Save(vendorDTO: vendor, dateStamp: DateTime.Now);
transaction.Complete();
if (saveResult.Success)
{
return(Ok(new SuccessResponse(saveResult.Model, saveResult.Message)));
}
return(Ok(new ErrorResponse(ServiceStatusCode.ValidationError, saveResult.ValidationResult, saveResult.Message)));
}
}
}
public async Task <IActionResult> PutVendor([FromRoute] Guid id, [FromBody] VendorDTO vendor)
{
if (id != vendor.Id)
{
return(BadRequest());
}
_context.Entry(_mapper.Map <Vendor>(vendor)).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VendorExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <VendorDTO> FindBy(string medication, string location)
{
var vendors = await _context.Vendors
.Include(v => v.RxPrices)
.Select(v => new Vendor
{
Id = v.Id,
Name = v.Name,
Url = v.Url,
RxPrices = v.RxPrices
.Where(rp => rp.Name.ToLower().Contains(medication.ToLower()))
.Where(rp => rp.Location.ToLower().Contains(location.ToLower()))
.OrderBy(rp => rp.Name)
.ToList()
})
.ToListAsync();
var vendorDTO = new VendorDTO
{
Method = $"Find Vendors By: {medication}, {location}",
Count = vendors.Count(),
Vendors = vendors
};
return(vendorDTO);
}
public List <VendorDTO> GetAllVendors()
{
SqlConnection dbCon = GetSqlConnection();
DataTable dt = new DataTable("Vendors");
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand selectCommand = new SqlCommand();
selectCommand.Connection = dbCon;
selectCommand.CommandText = "SELECT VendorName FROM Vendors";
da.SelectCommand = selectCommand;
da.Fill(dt);
List <VendorDTO> vendorsList = new List <VendorDTO>();
foreach (DataRow row in dt.Rows)
{
VendorDTO currentVendor = new VendorDTO()
{
VendorName = row["VendorName"].ToString(),
};
vendorsList.Add(currentVendor);
}
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// productsList.Add(new ProductDTO());
// //productsList[i] = new ProductDTO();
// productsList[i].ProductName = dt.Rows[i].ItemArray[1].ToString();
// productsList[i].ProductPrice = (int)dt.Rows[i].ItemArray[2];
// productsList[i].VendorName = dt.Rows[i].ItemArray[3].ToString();
// //productsList.Add(productsList[i]);
//}
return(vendorsList);
}
public async Task <IActionResult> Post([FromBody] VendorDTO model)
{
VendorModel vendor = new DTOMapper <VendorDTO, VendorModel>().Serialize(model);
var response = await _vendorService.AddVendor(vendor);
return(Ok(response));
}
public async Task <IActionResult> PostVendor([FromBody] VendorDTO vendor)
{
_context.Vendors.Add(_mapper.Map <Vendor>(vendor));
await _context.SaveChangesAsync();
return(CreatedAtAction("GetVendor", new { id = vendor.Id }, vendor));
}
public async Task <IHttpActionResult> PostBusDetail(VendorDTO vendorDetail)
{
var model = _mapper.Map <Vendor>(vendorDetail);
_unitOfWork.Vendor.Add(model);
await _unitOfWork.Complete();
return(Ok(vendorDetail));
}
public void SetVendor(ProductDTO product, VendorDTO vendor)
{
Product dproduct = _dbcontext.Products.GetByKey(product.GTIN);
dproduct.VendorId = vendor.Id;
_dbcontext.Products.Update(dproduct);
_dbcontext.SaveChanges();
}
public async Task <IActionResult> PutVendorDetail(VendorDTO vendorDetail)
{
var model = _mapper.Map <Vendor>(vendorDetail);
_unitOfWork.Vendor.Update(model);
await _unitOfWork.Complete();
return(Ok(vendorDetail));
}
public void RemoveVendor(VendorDTO vendor)
{
Vendor dVendor = _dbcontext.Vendors.GetByKey(vendor.Id);
if (dVendor != null)
{
_dbcontext.Vendors.Delete(dVendor);
}
_dbcontext.SaveChanges();
}
public async Task <ActionResult <VendorDTO> > Add(VendorDTO vendorDTO)
{
if (!ModelState.IsValid)
{
return(CustomResponse(ModelState));
}
var vendor = _mapper.Map <Vendor>(vendorDTO);
await _vendorService.Add(vendor);
return(CustomResponse(vendorDTO));
}
private VendorEntryModel GetCreateStateModel()
{
VendorEntryFormData formData = new VendorEntryFormData();
List <Control> formControls = CreateFormControls(0);
VendorDTO vendorDTO = new VendorDTO();
return(new VendorEntryModel()
{
FormData = formData,
FormControls = formControls,
Model = vendorDTO,
});
}
private void VendorListView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
VendorDTO item = (sender as ListView).SelectedValue as VendorDTO;
//populate the edit fields
this.VendorEmail.Text = item.VendorEmail;
this.VendorName.Text = item.VendorName;
this.VendorPhone.Text = item.VendorPhone;
this.Address1.Text = item.StreetAddress;
this.Address2.Text = item.UnitAptSuite;
this.City.Text = item.City;
this.State.Text = item.State;
this.Zip.Text = item.ZipCode;
}
public VendorGet Post(VendorPost post)
{
var vendorDTO = new VendorDTO(post);
m_Context.Vendors.Add(vendorDTO);
m_Context.SaveChanges();
if (vendorDTO == null)
{
return(null);
}
return(new VendorGet(m_Context, vendorDTO));
}
public void RemoveVendor(VendorDTO vendor)
{
var validationErrors = new List <System.ComponentModel.DataAnnotations.ValidationResult>();
var validationContext = new System.ComponentModel.DataAnnotations.ValidationContext(vendor);
if (!System.ComponentModel.DataAnnotations.Validator.TryValidateObject(vendor, validationContext, validationErrors, true))
{
throw new ArgumentException($"Wrong input data: {string.Join(", ", validationErrors)}");
}
UnitOfWork.Vendors.Delete(new Vendor {
Id = vendor.Id, Name = vendor.Name, Address = vendor.Address
});
UnitOfWork.SaveChanges();
}
public async Task <VendorDTO> GetAll()
{
var vendors = await _context.Vendors
.Include(v => v.RxPrices)
.ToListAsync();
var vendorDTO = new VendorDTO
{
Method = $"Get All Vendors",
Count = vendors.Count(),
Vendors = vendors
};
return(vendorDTO);
}
public async Task <ActionResult <VendorDTO> > Update(Guid id, [FromBody] VendorDTO vendorDTO)
{
if (id != vendorDTO.Id)
{
NotifyError("Id from Query is different from the body.");
return(CustomResponse(vendorDTO));
}
if (!ModelState.IsValid)
{
return(CustomResponse(ModelState));
}
var vendor = _mapper.Map <Vendor>(vendorDTO);
await _vendorService.Update(vendor);
return(CustomResponse(vendorDTO));
}
private VendorEntryModel GetUpdateStateModel(int vendorPK)
{
VendorEntryFormData formData = new VendorEntryFormData();
List <Control> formControls = CreateFormControls(vendorPK);
VendorDTO vendorDTO = vendorQuery.GetByPrimaryKey(vendorPK);
if (vendorDTO == null)
{
throw new KairosException($"Record with primary key '{vendorDTO.Vendor_PK}' is not found.");
}
return(new VendorEntryModel()
{
FormData = formData,
FormControls = formControls,
Model = vendorDTO,
});
}
public void AddPersonSelection(PersonDTO person)
{
list3.Clear();
VendorDTO v = new VendorDTO();
v.City = person.city;
v.State = person.state;
v.StreetAddress = person.street_address;
v.UnitAptSuite = person.unit_apt_suite;
v.VendorEmail = person.email;
v.VendorName = person.CustomerName;
v.VendorPhone = person.phone_primary;
v.ZipCode = person.zipcode;
list3.Add(v);
VendorListView.ItemsSource = list3;
}
public async Task <ActionResult <VendorOut> > AddNewVendor([FromForm] VendorIn vendorIn)
{
try
{
VendorDTO vendorDTO = new VendorDTO(vendorIn);
m_Context.Vendors.Add(vendorDTO);
await m_Context.SaveChangesAsync();
vendorDTO = m_HttpController.CreatedAtAction("GetProduct", new { id = vendorDTO.ID }, vendorDTO).Value as VendorDTO;
await m_HttpController.PutVendor(vendorDTO.ID, vendorDTO);
return(new VendorOut(m_Context, vendorDTO));
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
throw;
}
}
public VendorDTO GetVendorById(int vendorId)
{
var _vendor = _unitOfWork.vendorRepository.Get(vendorId);
VendorDTO _vendorDTO;
if (_vendor == null)
{
_vendorDTO = null;
}
else
{
_vendorDTO = new VendorDTO();
var vendorMapper = new ecvMapper <Vendor, VendorDTO>();
_vendorDTO = vendorMapper.CreateMappedObject(_vendor);
}
return(_vendorDTO);
}
public async Task <VendorDTO> GetVendorById(int id)
{
var data = await _repository.GetVendorById(id);
var listDTO = data.Tags.Select(x => new TagDTO
{
Name = x.Name,
Value = x.Value
}).ToList();
VendorDTO vendorDTO = new VendorDTO
{
Name = data.Name,
Title = data.Title,
Date = data.Date,
Tags = listDTO
};
return(vendorDTO);
}
public override void Fill(IDbConnection connection, int count = 100)
{
CreateTable(connection);
Random random = new Random();
string InsertionString = GenerateInsertionString();
for (int i = 0; i < count; ++i)
{
VendorDTO vendor = new VendorDTO();
vendor.CompanyName = "CompanyName" + (i + 1);
vendor.Email = "Email" + (i + 1);
vendor.MobileNumber = "MNo" + (i + 1);
vendor.Address = "Address" + (i + 1);
vendor.City = "City" + (i + 1);
vendor.State = "State" + (i + 1);
connection.Execute(InsertionString, vendor);
}
}
public VendorDTO GetVendorsById(int id)
{
var vendor = _repository.GetVendorById(id);
var tags = vendor.Tags.Select(x => new TagDTO
{
Name = x.Name,
Value = x.Value
}).ToList();
var vendorMapDto = new VendorDTO()
{
Name = vendor.Name,
Title = vendor.Title,
Date = vendor.Date,
Tags = tags
};
return(vendorMapDto);
}
private void VendorListView_ItemSelected(object sender, SelectedItemChangedEventArgs e)
{
ListView lv = sender as ListView;
if (lv != null)
{
VendorDTO item = lv.SelectedItem as VendorDTO;
if (item != null)
{
Name.Text = item.VendorName;
Phone.Text = item.VendorPhone;
Email.Text = item.VendorEmail;
Address.Text = item.StreetAddress;
Address2.Text = item.UnitAptSuite;
City.Text = item.City;
State.SelectedItem = item.State;
Zip.Text = item.ZipCode;
}
}
}
public List <VendorAddressDTO> Resolve(Vendor source, VendorDTO destination, List <VendorAddressDTO> destMember, ResolutionContext context)
{
var list = new List <VendorAddressDTO>();
if (source.PrimaryAddress != null)
{
var vendorAddressDTO = new VendorAddressDTO()
{
Id = source.PrimaryAddress.Id,
VendorAddressType = new NameIdDto()
{
Id = 1, Name = "Main"
},
Address1 = source.PrimaryAddress.Address1,
Address2 = source.PrimaryAddress.Address2,
Address3 = source.PrimaryAddress.Address3,
City = source.PrimaryAddress.City,
StateName = source.PrimaryAddress.State,
PostalCode = source.PrimaryAddress.PostalCode,
Longitude = source.PrimaryAddress.Longitude,
Latitude = source.PrimaryAddress.Latitude,
AdditionalAddressInfo = source.PrimaryAddress.AdditionalAddressInfo,
Type = "Main",
// TODO: Figure a way to look-up the Id value
State = new NameIdDto()
{
Id = 0, Name = source.PrimaryAddress.State
},
Country = new NameIdDto()
{
Id = 0, Name = source.PrimaryAddress.Country
}
};
list.Add(vendorAddressDTO);
}
return(list);
}
public async Task AddRatingAndTicketCountToVendorAsync(VendorDTO vendorDTO)
{
vendorDTO.TicketCount = await _vendorRepository.GetVendorTicketCountAsync(vendorDTO.VendorId);
vendorDTO.VendorRating = await _vendorRepository.GetVendorRatingAsync(vendorDTO.VendorId);
}
