/// <summary>
/// Initial mapping entity model to view model.
/// </summary>
/// <param name="vendorFilter">The vendor filter entity model data.</param>
/// <returns></returns>
private VendorFilterViewModel InitialVendorFilterViewModel(VendorFilter vendorFilter)
{
var result = new VendorFilterViewModel();
var emp = _unitOfWork.GetRepository <Hremployee>().GetCache(x => x.Aduser == vendorFilter.AssignTo).FirstOrDefault();
var company = _unitOfWork.GetRepository <Hrcompany>().GetCache(x => x.SapcomCode == vendorFilter.CompanyCode).FirstOrDefault();
var period = _unitOfWork.GetRepository <PeriodItem>().GetCache(x => x.Id == vendorFilter.PeriodItemId).FirstOrDefault();
var purOrg = _unitOfWork.GetRepository <PurchaseOrg>().GetCache(x => x.PurchaseOrg1 == vendorFilter.PurchasingOrg).FirstOrDefault();
var vendor = _unitOfWork.GetRepository <Data.Pocos.Vendor>().GetCache(x => x.VendorNo == vendorFilter.VendorNo).FirstOrDefault();
var valueHelpList = _unitOfWork.GetRepository <ValueHelp>().GetCache(x => x.ValueType == ConstantValue.ValueTypeVendorSendingStatus);
var weightingKeyList = _unitOfWork.GetRepository <ValueHelp>().GetCache(x => x.ValueType == ConstantValue.ValueTypeWeightingKey);
return(new VendorFilterViewModel
{
Id = vendorFilter.Id,
AssignTo = vendorFilter.AssignTo,
AssignToName = string.Format(ConstantValue.EmpTemplate, emp?.FirstnameTh, emp?.LastnameTh),
CompanyCode = vendorFilter.CompanyCode,
CompanyName = company?.LongText,
IsSending = vendorFilter.IsSending ?? false,
SendingStatus = vendorFilter.IsSending.HasValue && vendorFilter.IsSending.Value ? valueHelpList.FirstOrDefault(x => x.ValueKey == ConstantValue.VendorSending)?.ValueText :
valueHelpList.FirstOrDefault(x => x.ValueKey == ConstantValue.VendorWaiting)?.ValueText,
PeriodItemId = vendorFilter.PeriodItemId,
PeriodItemName = period?.PeriodName,
PurchasingOrg = vendorFilter.PurchasingOrg,
PurchasingName = purOrg?.PurchaseName,
SendEvaluationDate = vendorFilter.SendingEvaDate,
VendorNo = vendorFilter.VendorNo,
VendorName = vendor?.VendorName,
WeightingKey = vendorFilter.WeightingKey,
WeightingKeyName = weightingKeyList.FirstOrDefault(x => x.ValueKey == vendorFilter.WeightingKey)?.ValueText
});
}
public List <Vendor> GetVendors(VendorFilter filter)
{
using var context = Context();
var vendors = context.Vendor.Where(u => u.OrganisationId == filter.OrganisationId &&
(string.IsNullOrEmpty(filter.SearchText) || u.DisplayName.Contains(filter.SearchText) ||
u.LegalName.Contains(filter.SearchText)))
.OrderBy(u => u.DisplayName)
.Skip((filter.Page - 1) * filter.PageSize)
.Take(filter.PageSize)
.Select(u => new Vendor
{
BusinessRegistrationNumber = u.BusinessRegistrationNumber,
DisplayName = u.DisplayName,
LegalName = u.LegalName,
TaxNumber = u.TaxNumber,
Id = u.Id,
ContactId = u.ContactId,
Contact = new Contact
{
Id = u.ContactId,
Address = u.Contact.Address,
ContactName = u.Contact.ContactName,
Email = u.Contact.Email,
PhoneNumber = u.Contact.PhoneNumber,
Website = u.Contact.Website
}
}).ToList();
return(vendors);
}
public void GetTotalPage(VendorFilter filter)
{
using var context = Context();
filter.TotalRow = context.Vendor.Where(u => u.OrganisationId == filter.OrganisationId &&
(string.IsNullOrEmpty(filter.SearchText) || u.DisplayName.Contains(filter.SearchText) ||
u.LegalName.Contains(filter.SearchText))).Count();
}
private void PopulateVendors()
{
VendorFilter.DataSource = HccApp.ContactServices.Vendors.FindAll();
VendorFilter.DataTextField = "DisplayName";
VendorFilter.DataValueField = "Bvin";
VendorFilter.DataBind();
VendorFilter.Items.Insert(0, new ListItem("- Any Vendor -", string.Empty));
}
protected void Page_Init(object sender, EventArgs e)
{
//INITIALIZE VARIABLES
_CategoryId = AbleCommerce.Code.PageHelper.GetCategoryId();
_Category = CategoryDataSource.Load(_CategoryId);
_ProductId = AlwaysConvert.ToInt(Request.QueryString["ProductId"]);
_Product = ProductDataSource.Load(_ProductId);
if (_Product == null)
{
Response.Redirect(AbleCommerce.Code.NavigationHelper.GetAdminUrl("Catalog/Browse.aspx?CategoryId=" + _CategoryId.ToString()));
}
_KitComponentId = AlwaysConvert.ToInt(Request.QueryString["KitComponentId"]);
_KitComponent = KitComponentDataSource.Load(_KitComponentId);
if (_KitComponent == null)
{
Response.Redirect("EditKit.aspx?CategoryId=" + _CategoryId.ToString() + "&ProductId=" + _ProductId.ToString());
}
CancelLink.NavigateUrl += "?CategoryId=" + _CategoryId.ToString() + "&ProductId=" + _ProductId.ToString();
Caption.Text = string.Format(Caption.Text, _KitComponent.Name);
InstructionText.Text = string.Format(InstructionText.Text, _KitComponent.Name, _Product.Name);
int categoryCount = CategoryDataSource.CountAll();
StoreSettingsManager settings = AbleContext.Current.Store.Settings;
_DisplayCategorySearch = settings.CategorySearchDisplayLimit > 0 && categoryCount >= settings.CategorySearchDisplayLimit;
// INITIALIZE DROP DOWN LISTS
if (!_DisplayCategorySearch)
{
InitializeCategoryTree();
}
else
{
// DISPLAY AUTO COMPLETE FOR CATEGORY SEARCH OPTION
string js = PageHelper.GetAutoCompleteScript(Page.ResolveClientUrl("~/CategorySuggest.ashx"), CategoryAutoComplete, HiddenSelectedCategoryId, "Key", "Value");
ScriptManager.RegisterStartupScript(PageAjax, this.GetType(), "CATEGORY_SUGGEST", js, true);
CategoryAutoComplete.Visible = true;
CategoryFilter.Visible = false;
}
ManufacturerFilter.DataSource = ManufacturerDataSource.LoadAll("Name");
ManufacturerFilter.DataBind();
VendorFilter.DataSource = VendorDataSource.LoadAll("Name");
VendorFilter.DataBind();
// LOAD CUSTOM VIEWSTATE VARIABLES
LoadCustomViewState();
if (_SelectedProducts.Count > 0)
{
// REBIND THE REPEATER
BindSelectedProducts(_SelectedProducts);
}
AbleCommerce.Code.PageHelper.SetDefaultButton(NameFilter, SearchButton.ClientID);
AbleCommerce.Code.PageHelper.SetDefaultButton(SkuFilter, SearchButton.ClientID);
}
public PagedResultDto <VendorDto> GetVendors(VendorFilter input)
{
var query = vendorRepository.GetAll().Where(x => !x.IsDelete);
// filter by code
if (input.Code != null)
{
query = query.Where(x => x.Code.ToLower().Contains(input.Code.ToLower()));
}
// filter by name
if (input.Name != null)
{
query = query.Where(x => x.Name.ToLower().Contains(input.Name.ToLower()));
}
// filter by typeID
if (input.TypeID != 0)
{
query = query.Where(x => x.TypeID == input.TypeID);
}
// filter by isActive
if (input.IsActive != null)
{
if (input.IsActive.Equals("True"))
{
query = query.Where(x => x.IsActive == true);
}
else if (input.IsActive.Equals("False"))
{
query = query.Where(x => x.IsActive == false);
}
}
var totalCount = query.Count();
// sorting
if (!string.IsNullOrWhiteSpace(input.Sorting))
{
query = query.OrderBy(input.Sorting);
}
// paging
var items = query.PageBy(input).ToList();
// result
return(new PagedResultDto <VendorDto>(
totalCount,
items.Select(item => ObjectMapper.Map <VendorDto>(item)).ToList()));
}
private void toolBtnFindOrderNumber_Click(object sender, EventArgs e)
{
List <Vendors> vendorList = new List <Vendors>(vendorBindingSource.DataSource as BindingList <Vendors>);
VendorFilter vendorFilter = new VendorFilter(Convert.ToInt32(toolTxtFindOrderNumber.Text));
//Predicate<Vendors> filterByOrderID = new Predicate<Vendors>(orderFilter.MatchesOrderID);
Predicate <Vendors> filterByOrderID = new Predicate <Vendors>(vendorFilter.BeginsWithOrderID);
Vendors vendor = vendorList.Find(filterByOrderID);
if (vendor == null)
{
MessageBox.Show("No matching Vendor found", "Not Found", MessageBoxButtons.OK);
}
else
{
int index = vendorBindingSource.IndexOf(vendor);
vendorBindingSource.Position = index;
}
}
public PagedResultDto <VendorDto> GetVendorsByFilter(VendorFilter vendorFilter)
{
return(vendorAppService.GetVendors(vendorFilter));
}
public IActionResult GetTotalPage([FromBody] VendorFilter filter)
{
filter.OrganisationId = vendorService.OrganisationId;
vendorService.GetTotalPage(filter);
return(Ok(filter));
}
public IActionResult GetVendors([FromBody] VendorFilter filter)
{
filter.OrganisationId = vendorService.OrganisationId;
return(Ok(vendorService.GetVendors(filter)));
}
public CustomAdapterView(Activity context, ICursor cursor, DBHelper dbb) : base(context, cursor)
{
this.context = context;
this.cursor = cursor;
Filter = new VendorFilter(this, dbb);
}
