public void LoadCustomers()
{
List <TblCustomerDTO> listCustomers = customerModel.getCustomers();
if (listCustomers != null)
{
}
DataTable dtCustomer = ConvertCustom.ListToDataTable <TblCustomerDTO>(listCustomers);
bsCustomer = new BindingSource()
{
DataSource = dtCustomer
};
//binding data to data grid view
form.getBnCustomer().BindingSource = bsCustomer;
form.getDgvCustomer().DataSource = bsCustomer;
//hide unnecessary column
form.getDgvCustomer().Columns["phone"].Visible = false;
form.getDgvCustomer().Columns["address"].Visible = false;
form.getDgvCustomer().Columns["point"].Visible = false;
//clear and add new data binding
clearDataBindingTextCustomer();
bindingDataTextCustomer();
}
public void getAllProduct()
{
try
{
List <TblProductsDTO> listProducts = productModel.getProducts();
DataTable dataTable = ConvertCustom.ListToDataTable(listProducts);
bindingSourceProduct = new BindingSource()
{
DataSource = dataTable
};
form.GetBindingNavigatorProduct().BindingSource = bindingSourceProduct;
form.GetDataGridViewProduct().DataSource = bindingSourceProduct;
form.GetDataGridViewProduct().Columns["idProduct"].Visible = false;
form.GetDataGridViewProduct().Columns["idCategory"].Visible = false;
form.GetDataGridViewProduct().Columns["status"].Visible = false;
form.GetComboBoxTable().DataSource = bindingSourceCategory;
form.GetComboBoxTable().DisplayMember = "name";
form.GetComboBoxTable().ValueMember = "idCategory";
clearDataBindingTextProduct();
bindingDataTextProduct();
}
catch (Exception e)
{
MessageBox.Show(MessageUtil.ERROR + " Get All Product" + e.Message);
}
}
public void LoadProducts()
{
listProducts = productModel.getProductsToSale();
DataTable dtProduct = ConvertCustom.ListToDataTable <TblProductsDTO>(listProducts);
bsProduct = new BindingSource()
{
DataSource = dtProduct
};
//binding data to data grid view
form.getBnProduct().BindingSource = bsProduct;
form.getDgvProduct().DataSource = bsProduct;
//hide unessesary column
form.getDgvProduct().Columns["idProduct"].Visible = false;
form.getDgvProduct().Columns["status"].Visible = false;
form.getDgvProduct().Columns["idCategory"].Visible = false;
form.getDgvProduct().Columns["categoryName"].Visible = false;
List <TblCategoryDTO> listCategory = categoryModel.getAll();
foreach (var category in listCategory)
{
form.getCmbCategory().Items.Add(category.name);
}
foreach (DataGridViewColumn column in form.getDgvProduct().Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
public void SearchRevenues(DateTime date)
{
float total = orderModel.LoadTotal(date);
List <RevenuesDTO> listDetail = orderModel.LoadOrderDetail(date);
if (listDetail != null)
{
DataTable dtOrderDetail = ConvertCustom.ListToDataTable <RevenuesDTO>(listDetail);
bsOrderdetail = new BindingSource()
{
DataSource = dtOrderDetail
};
//binding data to data grid view
form.getBnOrderDetail().BindingSource = bsOrderdetail;
form.getDgvOrderDetail().DataSource = bsOrderdetail;
form.gettotal().Text = total.ToString();
//hide unnecessary column
form.getDgvOrderDetail().Columns["Customer"].Visible = false;
form.getDgvOrderDetail().Columns["Salesman"].Visible = false;
form.getDgvOrderDetail().Columns["total"].Visible = false;
//clear and add new data binding
clearDataBindingTextOrderdetail();
bindingDataTextOrderdetail();
}
}
public void loadEmp()
{
try
{
List <TblEmployeesDTO> listEmp = model.getAll();
DataTable dataTable = ConvertCustom.ListToDataTable(listEmp);
bsEmp = new BindingSource()
{
DataSource = dataTable
};
bindingSource();
}
catch (Exception e)
{
MessageBox.Show(MessageUtil.ERROR + " Get All Employee");
}
}
public void LoadEmpByRole(frmManager_v2 form)
{
try
{
string role = form.getRole();
List <TblEmployeesDTO> list = model.LoadEmpByRole(role);
DataTable dataTable = ConvertCustom.ListToDataTable(list);
bsEmp = new BindingSource()
{
DataSource = dataTable
};
bindingSource();
}
catch (Exception e)
{
MessageBox.Show(MessageUtil.ERROR + " Load Employee By Role");
}
}
public void getAllCategory()
{
try
{
List <TblCategoryDTO> categoryDTOs = categoryModel.getAll();
DataTable dataTable = ConvertCustom.ListToDataTable(categoryDTOs);
bindingSourceCategory = new BindingSource()
{
DataSource = dataTable
};
form.GetDataGridViewCategory().DataSource = bindingSourceCategory;
form.GetDataGridViewCategory().Columns["idCategory"].Visible = false;
form.GetBindingNavigatorCategory().BindingSource = bindingSourceCategory;
clearDataBindingTextCategory();
bindingDataTextCategory();
}
catch (Exception e)
{
MessageBox.Show(MessageUtil.ERROR + " Get All Category");
}
}
public void LoadProductsOrder()
{
if (listProductOrder == null)
{
form.getDgvItemOfOrder().DataSource = null;
form.getDgvItemOfOrder().Rows.Clear();
return;
}
DataTable dtProduct = ConvertCustom.ListToDataTable <CartItemDTO>(listProductOrder);
//binding data to data grid view
form.getDgvItemOfOrder().DataSource = dtProduct;
form.getDgvItemOfOrder().Columns["idProduct"].Visible = false;
foreach (DataGridViewColumn column in form.getDgvItemOfOrder().Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
