public RawItemMasterViewModel()
{
TableDropDown tdd = new TableDropDown();
PrimaryVendorList = tdd.SetPrimaryVendorList();
StoreList = tdd.SetStoreDropDown();
LocationList = tdd.SetLocationDropDown();
VendorList = tdd.SetVendorList();
UnitOfMeasureList = tdd.SetUnitOfMeasureList();
MaterialsGroupList = tdd.SetMaterialsGroupList();
GroupList = tdd.SetGroupList();
RawItemMasterList = new List <RawItem>();
MenuItemList = new List <MenuItem>();
VendorsSelectedList = new List <bool>(VendorList.Count());
PreviousVendorsSelectedList = new List <bool>();
VendorCPR = new List <string>(VendorList.Count());
VendorPUN = new List <string>(VendorList.Count());
VendorSCM = new List <string>(VendorList.Count());
int i = 0;
foreach (var v in VendorList)
{
VendorsSelectedList.Add(v.Cb);
PreviousVendorsSelectedList.Add(v.Cb);
VendorCPR.Add("");
VendorPUN.Add("");
VendorSCM.Add("");
i++;
}
}
private static void LoadVendorsList(FilterExpression expression, VendorList sageVendors)
{
var modifier = LoadModifiers.Create();
modifier.Filters = expression;
sageVendors.Load(modifier);
}
private void AddMaterialCommand(object model)
{
ErrorMessage = "";
var material = model as Material;
if (material.BillAmount <= 0 ||
material.Quantity <= 0 ||
string.IsNullOrWhiteSpace(material.BillNumber) ||
SelectedVendor.VendorId == 0 ||
material.SelectedMaterialType.MaterialTypeId == 0 ||
material.SelectedUnit.UnitId == 0)
{
ErrorMessage = "*Please check the entry. Some field's Values are missing.";
return;
}
material.SelectedVendor = Vendors.Single(x => x.VendorId == SelectedVendor.VendorId);
material.SiteId = SiteId;
material.CreatedDate = DateTime.Now;
_repositoryManager.AddMaterial(material);
Materials = new ObservableCollection <Material>(_repositoryManager.GetMaterialBySiteId(SiteId));
MaterialToAdd = new Material();
MaterialToAdd.SelectedUnit = Units.First();
SelectedVendor = VendorList.First();
MaterialToAdd.SelectedMaterialType = MaterialTypes.First();
OnPropertyChanged(nameof(MaterialToAdd));
OnPropertyChanged(nameof(SelectedVendor));
}
public async Task <VendorList> GetVendors()
{
var result = new VendorList();
if (_workContext.CurrentCustomer.CustomerRoles.Any(x => x.Name == "Vendors"))
{
result.IsVendor = true;
}
else
{
result.IsVendor = false;
}
var products = _repo.Collection.AsQueryable().Where(x => x.VendorId != null).AsEnumerable().GroupBy(x => x.VendorId, x => x).ToDictionary(x => x.Key)
.Select(z => new VendorModel
{
IsAdminApproveNeeded = z.Value.FirstOrDefault().IsAdminApproveNeeded,
Name = _vendorRepository.GetById(z.Key).Name,
Products = z.Value.Select(y => new ProductModel {
IsAdminApproved = y.IsAdminApproved,
IsAdminApproveNeeded = y.IsAdminApproveNeeded,
Description = y.FullDescription,
Name = y.Name,
Id = y.Id
}).ToList(),
_id = z.Key
}).ToList();
result.List = products;
result.IsNewVendorsAdminApproveNeeded = _settings.IsNewVendorsAdminApproveNeeded;
if (result.IsVendor)
{
result.List.RemoveAll(x => x._id != _workContext.CurrentVendor.Id);
}
return(result);
}
private void BindLine()
{
if (dataGridView.SelectedRows.Count > 0)
{
var id = (int)dataGridView.SelectedRows[0].Cells[0].Value;
_vendor = VendorList.GetVendor(id);
vendorBindingSource.DataSource = _vendor;
}
}
private void UpdateVendor()
{
VendorList vl = new VendorList();
foreach (IPMacPair imp in hosts)
{
string[] mac = imp.MAC.Split('-');
imp.Vendor = vl.FindVendorByMac(string.Join("", mac, 0, 3));
}
}
// GET: Vendor
public ActionResult VendorHome()
{
var vendors = _vendorService.SelectAll();
var models = new VendorList
{
VendorViewModels = GetVendors(vendors)
};
return(View(models));
}
void prepareVendorList()
{
string sqlstr = "select '' as vendor_id, '' as vendor_name ";
sqlstr += " union( ";
sqlstr += " select vendor_id, vendor_name from vendor) ";
sqlstr += " order by vendor_id ";
VendorList.DataSource = mydb.GetDataTable(sqlstr);
VendorList.DataBind();
}
private void GetData(int userID)
{
using var db = new AppDbContext();
var data = db.Vendors.ToList();
foreach (var vendor in data.Where(vendor => vendor.UserID == userID))
{
VendorList.Add(vendor);
}
}
private void DataGridBinding_Load(object sender, System.EventArgs e)
{
// Bind ComboBox list datasources first
statesBindingSource.EnumToDataSource(typeof(States));
colState.DataSource = statesBindingSource;
colState.DisplayMember = "Description";
colState.ValueMember = "Key";
vendorListBindingSource.DataSource = VendorList.GetVendorList();
}
private void DeleteVendorCommand(object model)
{
var vendor = model as Vendor;
if (OnMessageBoxEvent("Do you want to delete this entry?"))
{
_repositoryManager.DeleteVendor(vendor);
_vendors.Remove(vendor);
VendorList.Remove(VendorList.Single(x => x.VendorId == vendor.VendorId));
}
}
public VendorList GetListOfVendors()
{
var vendorList = new VendorList
{
Vendors = _vendorRepo.GetAll()
.OrderBy(v => v.VendorName)
.ToList()
};
return(vendorList);
}
private void BindVendors()
{
IList <Vendor> vendors = VendorDataSource.LoadAll("Name");
int index = vendors.IndexOf(_VendorId);
if (index > -1)
{
vendors.RemoveAt(index);
}
VendorList.DataSource = vendors;
VendorList.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// Get Vendor list from Session
VendorList sList = VendorList.GetVendors();
// Add new Vendor to list
sList.AddVendor(txtVendorName.Text, txtVendorStreet.Text, txtVendorCity.Text, txtVendorState.Text, txtVendorZip.Text, txtCounty.Text, txtVendorMedia.Text, txtEmail.Text);
lblOutput.Visible = true;
}
}
public void refreshVendors()
{
this.VendorList.Rows.Clear();
List <object>[] rs;
string[] columns = { "strVendCode", "strVendName" };
rs = dbConnect.Select("Select * from tblVendor where boolVendIsDel = false;", columns);
for (int i = 0; i < rs[0].Count; i++)
{
this.VendorList.Rows.Add(rs[0].ElementAt(i).ToString(), rs[1].ElementAt(i).ToString());
}
//clear selection
VendorList.ClearSelection();
}
private void AddVendorCommand(object model)
{
var vendor = model as Vendor;
if (string.IsNullOrWhiteSpace(vendor.VendorName) || string.IsNullOrWhiteSpace(vendor.Address))
{
return;
}
vendor.CreatedDate = DateTime.Now;
_repositoryManager.AddVendor(vendor);
var list = _repositoryManager.GetVendorBySiteId(SiteId);
Vendors = new ObservableCollection <Vendor>(list);
VendorToAdd = new Vendor();
VendorList = ProcessVendors(list);
SelectedVendor = VendorList.First();
OnPropertyChanged(nameof(SelectedVendor));
}
protected void Page_Load(object sender, EventArgs e)
{
// Add headers
DataTable dt = new DataTable();
dt.Columns.Add("Business Name");
dt.Columns.Add("Address");
dt.Columns.Add("City");
dt.Columns.Add("State");
dt.Columns.Add("County");
dt.Columns.Add("Zip");
dt.Columns.Add("Media");
dt.Columns.Add("Email");
// Add each bean data as a data table entry
VendorList sList = VendorList.GetVendors();
for (int i = 0; i < sList.Count; i++)
{
dt.Rows.Add(sList[i].VendorName, sList[i].VendorStreet, sList[i].VendorCity, sList[i].VendorState, sList[i].VendorZip, sList[i].County, sList[i].VendorMedia, sList[i].Email);
}
}
private void DeleteButtonClick(object sender)
{
var vendor = sender as Vendor;
using (var db = new AppDbContext())
{
var vendorFromDB = db.Vendors.SingleOrDefault(x => x.ID == vendor.ID);
db.Remove(vendorFromDB);
var user = db.Users.SingleOrDefault(x => x.ID == _user.ID);
user.VendorsCount--;
var reviewList = db.Reviews.ToList();
foreach (var review in reviewList.Where(x => x.VendorID == vendor.ID))
{
db.Remove(review);
}
db.SaveChanges();
}
var itemToRemove = VendorList.Single(d => d.ID == vendor.ID);
VendorList.Remove(itemToRemove);
}
private void DataGridBinding_Load(object sender, System.EventArgs e)
{
vendorListBindingSource.DataSource = VendorList.GetVendorList();
}
public MainForm()
{
InitializeComponent();
VendorList.GetVendorList();
}
private void createNewTab(eTabType type)
{
switch (type)
{
case eTabType.MAIN_TAB:
break;
case eTabType.CUSTOMER_TAB:
{
//Hieu
//Edit
var newTab = isExitTabPage("Danh sách khách hàng");
if (newTab == null)
{
newTab = new TabPage("Danh sách khách hàng");
var customerList = new CustomerList();
customerList.Dock = DockStyle.Fill;
newTab.Controls.Add(customerList);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
case eTabType.VENDOR_TAB:
{
var newTab = isExitTabPage("Danh sách nhà cung cấp");
if (newTab == null)
{
newTab = new TabPage("Danh sách nhà cung cấp");
var vendorList = new VendorList();
vendorList.Dock = DockStyle.Fill;
newTab.Controls.Add(vendorList);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
case eTabType.ORDER_TAB:
{
var customerOrder = new CreateCustomerOrderForm();
var result = customerOrder.ShowDialog();
if (result == DialogResult.OK)
{
var newTab = isExitTabPage("Giao dịch");
if (newTab == null)
{
newTab = new TabPage("Giao dịch");
newTab.AutoScroll = true;
var order = new OrderDetailForm(customerOrder.OrderId);
order.Dock = DockStyle.Top;
newTab.Controls.Add(order);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
}
else if (result == DialogResult.Retry)
{
createNewTab(eTabType.CUSTOMER_TAB);
}
break;
}
case eTabType.CUSTOMER_ORDER_LIST_TAB:
{
var selectForm = new SelectOrderForm();
var result = selectForm.ShowDialog();
if (result == DialogResult.OK)
{
var text = "Đơn hàng " + selectForm.OrderKey;
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var order = new CustomerOrderDetail(selectForm.OrderId);
order.Dock = DockStyle.Fill;
newTab.Controls.Add(order);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
}
break;
}
case eTabType.STORE_TAB:
{
var text = "Danh sách kho hàng";
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var store = new InventoryList();
store.Dock = DockStyle.Fill;
newTab.Controls.Add(store);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
case eTabType.PRODUCT_TAB:
{
var text = "Danh sách mặt hàng";
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var product = new ProductList();
product.Dock = DockStyle.Fill;
newTab.Controls.Add(product);
this.newProductMenuItem.Click += product.showDialogAddProduct; //7ung
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
case eTabType.STAFF_TAB:
{
var text = "Danh sách nhân viên";
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var staff = new StaffList();
staff.Dock = DockStyle.Fill;
newTab.Controls.Add(staff);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
case eTabType.INOUT_INVENTORY:
{
var text = "Quản lý đơn hàng nhập xuất kho";
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var store = new InOutInventoryList();
store.Dock = DockStyle.Fill;
newTab.Controls.Add(store);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
case eTabType.INVENTORY_LIST:
{
var text = "Quản lý kho hàng";
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var store = new InventoryList();
store.Dock = DockStyle.Fill;
newTab.Controls.Add(store);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
case eTabType.VENDOR_ORDER_TAB:
{
var vendorOrder = new CreateVendorOrderForm();
var result = vendorOrder.ShowDialog();
if (result == DialogResult.OK)
{
var text = "Giao dịch đơn hàng " + vendorOrder.DocumentKey;
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var order = new VendorOrderDetailForm(vendorOrder.OrderId);
order.Dock = DockStyle.Top;
newTab.Controls.Add(order);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
}
else if (result == DialogResult.Retry)
{
createNewTab(eTabType.VENDOR_TAB);
}
break;
}
case eTabType.VENDOR_ORDER_LIST_TAB:
{
var selectForm = new SelectVendorOrderForm();
var result = selectForm.ShowDialog();
if (result == DialogResult.OK)
{
var text = "Đơn hàng " + selectForm.DocumentKey;
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var order = new VendorOrderDetail(selectForm.OrderId);
order.DocumentKey = selectForm.DocumentKey;
order.Dock = DockStyle.Fill;
newTab.Controls.Add(order);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
}
break;
}
case eTabType.REVENUE_REPORT_TAB:
{
var text = "Báo cáo doanh thu";
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var report = new RevenueReport();
report.Dock = DockStyle.Fill;
newTab.Controls.Add(report);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
case eTabType.CUSTOMER_REPORT_TAB:
{
var text = "Báo cáo tình hình khách hàng";
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var report = new CustomerReport();
report.Dock = DockStyle.Top;
newTab.Controls.Add(report);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
case eTabType.CREATE_BUSINESS_REPORT_TAB:
{
var dialogCreate = new CreateReportForm();
var r = dialogCreate.ShowDialog();
if (r == DialogResult.OK)
{
var text = "Báo cáo chi phí bán hàng";
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var report = new CreateBusinessFee(dialogCreate.DocumentId, true);
report.Dock = DockStyle.Top;
newTab.Controls.Add(report);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
}
break;
}
case eTabType.VIEW_BUSINESS_REPORT_TAB:
{
var text = "Xem cáo chi phí bán hàng";
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var report = new ViewBusinessFee();
report.Dock = DockStyle.Top;
newTab.Controls.Add(report);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
case eTabType.INVENTORY_REPORT_TAB:
{
var text = "Báo cáo tồn kho";
var newTab = isExitTabPage(text);
if (newTab == null)
{
newTab = new TabPage(text);
newTab.AutoScroll = true;
var report = new InventoryReport();
report.Dock = DockStyle.Fill;
newTab.Controls.Add(report);
tabControl.TabPages.Add(newTab);
}
tabControl.SelectedTab = newTab;
break;
}
default:
break;
}
}
private void LoadSearchFilter()
{
ProductFilter criteria = Session["ProductSearchFilter"] as ProductFilter;
if (criteria != null)
{
Name.Text = criteria.Name;
SearchDescriptions.Checked = criteria.SearchDescriptions;
Sku.Text = criteria.Sku;
ListItem selectedItem = null;
if (!_DisplayCategorySearch)
{
CategoriesList.DataBind();
selectedItem = CategoriesList.Items.FindByValue(criteria.CategoryId.ToString());
if (selectedItem != null)
{
CategoriesList.SelectedIndex = CategoriesList.Items.IndexOf(selectedItem);
}
}
else
{
Category selectedCategory = CategoryDataSource.Load(criteria.CategoryId);
if (selectedCategory != null)
{
CategoryAutoComplete.Text = selectedCategory.Name;
}
HiddenSelectedCategoryId.Value = criteria.CategoryId.ToString();
}
ManufacturerList.DataBind();
selectedItem = ManufacturerList.Items.FindByValue(criteria.ManufacturerId.ToString());
if (selectedItem != null)
{
ManufacturerList.SelectedIndex = ManufacturerList.Items.IndexOf(selectedItem);
}
VendorList.DataBind();
selectedItem = VendorList.Items.FindByValue(criteria.VendorId.ToString());
if (selectedItem != null)
{
VendorList.SelectedIndex = VendorList.Items.IndexOf(selectedItem);
}
ProductGroups.DataBind();
selectedItem = ProductGroups.Items.FindByValue(criteria.GroupId.ToString());
if (selectedItem != null)
{
ProductGroups.SelectedIndex = ProductGroups.Items.IndexOf(selectedItem);
}
OnlyFeatured.Checked = criteria.Featured == BitFieldState.True;
FromPrice.Text = criteria.FromPrice.ToString();
ToPrice.Text = criteria.ToPrice.ToString();
OnlyDigitalGoods.Checked = criteria.DigitalGoodsOnly;
OnlyGiftCertificates.Checked = criteria.GiftCertificatesOnly;
OnlyKits.Checked = criteria.KitsOnly;
OnlySubscriptions.Checked = criteria.SubscriptionsOnly;
ShowProductThumbnails.Checked = criteria.IncludeThumbnails;
}
}
private void DataGridBinding_Load(object sender, System.EventArgs e)
{
vendorListBindingSource.DataSource = VendorList.GetVendorList();
dataGridView.Rows[0].Selected = true;
}
