public void RefreshGridViewUsers()
{
User entity = new User();
SearchParam searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
this.BindingDataToForm(entity, searchParam, 0);
bindingNavigatorUser.BindingSource.PositionChanged += new EventHandler(BindingSource_PositionChanged);
}
private void FrmUserStatus_Load(object sender, EventArgs e)
{
//
ContructGridViewColumn();
//Get all user
searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
//
searchEntity = new UserStatus();
//
SearchResult<UserStatus> searchResult = userStatusManager.GetUserStatusListByParam(searchEntity, searchParam);
//Binding list userrole to gridview
IList2DataTable(searchResult.SearchList, dataSetUserStatus.Tables["UserStatus"]);
//Binding list to navigator
listPages = new List<Int32>();
BindingDataToBindingNagivator(searchResult.SearchSize, 0);
//
isAdd = true;
}
private void btnReloadAll_Click(object sender, EventArgs e)
{
//Get all user
searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
//
searchEntity = new UserRole();
//
SearchResult<UserRole> searchResult = userRoleManager.GetUserRoleListByParam(searchEntity, searchParam);
//Binding list userrole to gridview
IList2DataTable(searchResult.SearchList, dataSetUserRole.Tables["UserRole"]);
//Binding list to navigator
listPages = new List<Int32>();
BindingDataToBindingNagivator(searchResult.SearchSize, 0);
}
public void AdvanceSearchProduct(Product searchEntity)
{
//Default param
searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
//
this.searchEntity = searchEntity;
//
SearchResult<Product> searchResult = productManager.GetProductListByAdvanceParam(searchEntity, searchParam);
currentListProduct = searchResult.SearchList;
//Binding list userrole to gridview
IList2DataTable(searchResult.SearchList, dataSetProduct.Tables["Product"]);
//Binding list to navigator
listPages = new List<Int32>();
BindingDataToBindingNagivator(searchResult.SearchSize, 0);
}
private void BindingDataToFormProductName(ProductName entity, SearchParam searchParam, int position)
{
SearchResult<ProductName> searchResult = productNameManager.GetProductNameListByParam(entity, searchParam);
if (searchResult != null)
{
DataTable dataTableProductName = new DataTable("ProductName");
dataTableProductName.Columns.Add("ProductNameId", typeof(Int32));
dataTableProductName.Columns.Add("ProdName", typeof(string));
dataTableProductName.Columns.Add("CategoryId", typeof(int));
dataTableProductName.Columns.Add("CategoryName", typeof(string));
dataTableProductName.Columns.Add("ManId", typeof(int));
dataTableProductName.Columns.Add("ManName", typeof(string));
foreach (ProductName objProduct in searchResult.SearchList)
{
DataRow rowTemp = dataTableProductName.NewRow();
rowTemp["ProductNameId"] = objProduct.ID;
rowTemp["ProdName"] = objProduct.ProdName;
rowTemp["CategoryId"] = objProduct.CategoryId;
if (objProduct.CategoryIdLookup != null)
{
rowTemp["CategoryName"] = objProduct.CategoryIdLookup.CategoryName;
}
else
{
Category temp = categoryManager.GetById(objProduct.CategoryId, false);
if (temp != null)
{
rowTemp["CategoryName"] = temp.CategoryName;
}
else
{
rowTemp["CategoryName"] = string.Empty;
}
}
rowTemp["ManId"] = objProduct.ManId;
if (objProduct.ManIdLookup != null)
{
rowTemp["ManName"] = objProduct.ManIdLookup.ManName;
}
else
{
Manufacturer temp = manufacturerManager.GetById(objProduct.ManId, false);
if (temp != null)
{
rowTemp["ManName"] = temp.ManName;
}
else
{
rowTemp["ManName"] = string.Empty;
}
}
dataTableProductName.Rows.Add(rowTemp);
}
dataSetProductName = new DataSet();
dataSetProductName.Tables.Add(dataTableProductName);
gvTenSanPham.DataSource = dataSetProductName;
gvTenSanPham.DataSource = dataSetProductName;
gvTenSanPham.DataMember = "ProductName";
gvTenSanPham.Columns["ProductNameId"].HeaderText = "Mã tên sản phẩm";
gvTenSanPham.Columns["ProdName"].HeaderText = "Tên sản phẩm";
gvTenSanPham.Columns["CategoryId"].Visible = false;
gvTenSanPham.Columns["CategoryName"].HeaderText = "Loại sản phẩm";
gvTenSanPham.Columns["ManId"].Visible = false;
gvTenSanPham.Columns["ManName"].HeaderText = "Nhà sản xuất";
currentListProductName = searchResult.SearchList;
logger.Debug("searchList size = " + searchResult.SearchList.Count);
List<Int32> listPages = new List<Int32>();
int totalPage = 0;
if (searchResult.SearchSize % DEFAULT_LIMIT > 0)
{
totalPage = (int)searchResult.SearchSize / DEFAULT_LIMIT + 1;
}
else
{
totalPage = (int)searchResult.SearchSize / DEFAULT_LIMIT;
}
logger.Debug("searchSize = " + searchResult.SearchSize);
logger.Debug("totalPage = " + totalPage);
for (int i = 0; i < totalPage; i++)
{
listPages.Add(i);
}
bindingNavigatorProductName.BindingSource = new BindingSource(listPages, "");
bindingNavigatorProductName.BindingSource.Position = position;
bindingNavigatorProductName.BindingSource.PositionChanged += new EventHandler(BindingSource_PositionChangedProductName);
toolStripLblTotal.Text = "Tổng số tên sản phẩm: " + searchResult.SearchSize;
}
}
private void BindingDataToForm(Product entity, SearchParam searchParam, int position)
{
SearchResult<Product> searchResult = productManager.GetProductListByParam(entity, searchParam);
if (searchResult != null)
{
DataTable dataTableProduct = new DataTable("Product");
dataTableProduct.Columns.Add("ProductId", typeof(Int64));
dataTableProduct.Columns.Add("MfgDate", typeof(string));
dataTableProduct.Columns.Add("ExpDate", typeof(string));
dataTableProduct.Columns.Add("ProductNameId", typeof(int));
dataTableProduct.Columns.Add("ProdName", typeof(string));
dataTableProduct.Columns.Add("PurchasePrice", typeof(string));
dataTableProduct.Columns.Add("SalePrice", typeof(string));
dataTableProduct.Columns.Add("Discount", typeof(string));
dataTableProduct.Columns.Add("StatusId", typeof(int));
dataTableProduct.Columns.Add("Status", typeof(string));
dataTableProduct.Columns.Add("BillPurchaseId", typeof(int));
dataTableProduct.Columns.Add("BillSaleId", typeof(int));
dataTableProduct.Columns.Add("UnitId", typeof(int));
dataTableProduct.Columns.Add("Unit", typeof(string));
dataTableProduct.Columns.Add("Description", typeof(string));
foreach (Product objProduct in searchResult.SearchList)
{
DataRow rowTemp = dataTableProduct.NewRow();
rowTemp["ProductId"] = objProduct.ID;
rowTemp["MfgDate"] = objProduct.MfgDate.Value.ToString("dd/MM/yyyy");
rowTemp["ExpDate"] = objProduct.ExpDate.Value.ToString("dd/MM/yyyy");
rowTemp["ProductNameId"] = objProduct.ProductNameIdLookup.ID;
rowTemp["ProdName"] = objProduct.ProductNameIdLookup.ProdName;
rowTemp["PurchasePrice"] = objProduct.PurchasePrice;
rowTemp["SalePrice"] = objProduct.SalePrice;
rowTemp["Discount"] = objProduct.Discount;
rowTemp["StatusId"] = objProduct.ProductStatusIdLookup.ID;
rowTemp["Status"] = objProduct.ProductStatusIdLookup.StatusName;
rowTemp["BillPurchaseId"] = objProduct.BillPurchaseId;
if (objProduct.BillSaleId != null) rowTemp["BillSaleId"] = objProduct.BillSaleId;
rowTemp["UnitId"] = objProduct.UnitIdLookup.ID;
rowTemp["Unit"] = objProduct.UnitIdLookup.UnitName;
rowTemp["Description"] = objProduct.Description;
dataTableProduct.Rows.Add(rowTemp);
}
dataSetProduct = new DataSet();
dataSetProduct.Tables.Add(dataTableProduct);
gvSanPhamDanhMuc.DataSource = dataSetProduct;
gvSanPhamDanhMuc.DataSource = dataSetProduct;
gvSanPhamDanhMuc.DataMember = "Product";
gvSanPhamDanhMuc.Columns["ProductId"].HeaderText = "Mã sản phẩm";
gvSanPhamDanhMuc.Columns["MfgDate"].HeaderText = "Ngày sản xuất";
gvSanPhamDanhMuc.Columns["ExpDate"].HeaderText = "Ngày hết hạn";
gvSanPhamDanhMuc.Columns["ProductNameId"].Visible = false;
gvSanPhamDanhMuc.Columns["ProdName"].HeaderText = "Tên sản phẩm";
gvSanPhamDanhMuc.Columns["PurchasePrice"].HeaderText = "Giá mua";
gvSanPhamDanhMuc.Columns["SalePrice"].HeaderText = "Giá bán";
gvSanPhamDanhMuc.Columns["Discount"].HeaderText = "Giảm giá";
gvSanPhamDanhMuc.Columns["StatusId"].Visible = false;
gvSanPhamDanhMuc.Columns["Status"].HeaderText = "Trạng thái";
gvSanPhamDanhMuc.Columns["BillPurchaseId"].HeaderText = "Mã mua";
gvSanPhamDanhMuc.Columns["BillSaleId"].HeaderText = "Mã bán";
gvSanPhamDanhMuc.Columns["UnitId"].Visible = false;
gvSanPhamDanhMuc.Columns["Unit"].HeaderText = "Đơn vị";
gvSanPhamDanhMuc.Columns["Description"].HeaderText = "Mô tả";
currentListProduct = searchResult.SearchList;
logger.Debug("searchList size = " + searchResult.SearchList.Count);
List<Int32> listPages = new List<Int32>();
int totalPage = 0;
if (searchResult.SearchSize % DEFAULT_LIMIT > 0)
{
totalPage = (int)searchResult.SearchSize / DEFAULT_LIMIT + 1;
}
else
{
totalPage = (int)searchResult.SearchSize / DEFAULT_LIMIT;
}
logger.Debug("searchSize = " + searchResult.SearchSize);
logger.Debug("totalPage = " + totalPage);
for (int i = 0; i < totalPage; i++)
{
listPages.Add(i);
}
bindingNavigatorProduct.BindingSource = new BindingSource(listPages, "");
bindingNavigatorProduct.BindingSource.Position = position;
bindingNavigatorProduct.BindingSource.PositionChanged += new EventHandler(BindingSource_PositionChanged);
toolStripLblTotal.Text = "Tổng số sản phẩm: " + searchResult.SearchSize;
}
}
private void RefreshGridViewProductName(ProductName searchEntity)
{
//Get all user
searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
//
this.searchEntityProductName = searchEntity;
//
SearchResult<ProductName> searchResult = productNameManager.GetProductNameListByParam(searchEntity, searchParam);
currentListProductName = searchResult.SearchList;
//Binding list userrole to gridview
IList2DataTableProductName(searchResult.SearchList, dataSetProductName.Tables["ProductName"]);
//Binding list to navigator
listPagesProductName = new List<Int32>();
BindingDataToBindingNagivatorProductName(searchResult.SearchSize, 0);
}
private void btnReloadAll_Click(object sender, EventArgs e)
{
//Get all user
searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
searchEntity = new User();
SearchResult<User> searchResult = userManager.GetUserListByParam(searchEntity, searchParam);
currentListUser = searchResult.SearchList;
//Binding list user to gridview
IList2DataTable(currentListUser, dataSetUser.Tables["User"]);
//
listPages = new List<Int32>();
BindingDataToBindingNagivator(searchResult.SearchSize, 0);
}
/*
private string DieuKienTimKiem()
{
string dk = "";
if (chkTatCaTimKiemQuanLy.Checked)
dk = " where SanPham.MaSanPham like '%" + textBoxSearch.Text + "%' or SanPham.TenSanPham like N'%" + textBoxSearch.Text + "%' or LoaiSanPham.LoaiSanPham like N'%" + textBoxSearch.Text + "%' or DonVi.DonVi like N'%" + textBoxSearch.Text + "%' or QuocGia.QuocGia like N'%" + textBoxSearch.Text + "%' or NhaSanXuat.TenNhaSanXuat like N'%" + textBoxSearch.Text + "%' or NhaCungCap.NhaCungCap like N'%" + textBoxSearch.Text + "%' or SanPham.MoTa like N'%" + textBoxSearch.Text + "%'";
else
{
if (chkMaSanPhamTimKiemQuanLy.Checked)
dk += " or SanPham.MaSanPham like '%" + textBoxSearch.Text+"%'";
if (chkTenSanPhamTimKiemQuanLy.Checked)
dk += " or SanPham.TenSanPham like N'%" + textBoxSearch.Text+"%'";
if (chkLoaiSanPhamTimKiemQuanLy.Checked)
dk += " or LoaiSanPham.LoaiSanPham like N'%" + textBoxSearch.Text+"%'";
if (chkDonViTimKiemQuanLy.Checked)
dk += " or DonVi.DonVi like N'%" + textBoxSearch.Text + "%'";
if (chkNguonGocTimKiemQuanLy.Checked)
dk += " or QuocGia.QuocGia like N'%"+ textBoxSearch.Text+"%'";
if (chkNhaSanXuatTimKiemQuanLy.Checked)
dk += "or NhaSanXuat.TenNhaSanXuat like N'%" + textBoxSearch.Text + "%'";
if (chkNhaCungCapTimKiemQuanLy.Checked)
dk += " or NhaCungCap.NhaCungCap like N'%" + textBoxSearch.Text + "%'";
if (chkMoTaTimKiemQuanLy.Checked)
dk += " or SanPham.MoTa like N'%" + textBoxSearch.Text+"%'";
if (dk.Trim().Length > 0)
dk = " where "+dk.Substring(4);
}
return dk;
}
*/
private void frmDanhMucSanPham_Load(object sender, EventArgs e)
{
this.Location = new Point((this.MdiParent.ClientSize.Width-this.Width)/2,(this.MdiParent.ClientSize.Height-this.Height)/2-50);
try
{
//Create column of gridview
ContructGridViewColumn();
//Get all product
searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
searchParamProductName = new SearchParam();
searchParamProductName.Start = DEFAULT_START;
searchParamProductName.Limit = DEFAULT_LIMIT;
searchParamProductName.SortBy = DEFAULT_SORT_BY;
searchParamProductName.SortDir = DEFAULT_SORT_DIR;
searchEntity = new Product();
searchEntityProductName = new ProductName();
SearchResult<Product> searchResult = productManager.GetProductListByParam(searchEntity, searchParam);
SearchResult<ProductName> searchResultProductName = productNameManager.GetProductNameListByParam(searchEntityProductName, searchParamProductName);
currentListProduct = searchResult.SearchList;
currentListProductName = searchResultProductName.SearchList;
//Binding list product to gridview
IList2DataTable(currentListProduct, dataSetProduct.Tables["Product"]);
IList2DataTableProductName(currentListProductName, dataSetProductName.Tables["ProductName"]);
listPages = new List<Int32>();
listPagesProductName = new List<Int32>();
BindingDataToBindingNagivator(searchResult.SearchSize, 0);
BindingDataToBindingNagivatorProductName(searchResultProductName.SearchSize, 0);
//Binding value for combobox
//comboBoxTenSanPham.DataSource = productNameManager.GetAll();
//comboBoxTenSanPham.DisplayMember = "ProdName";
//comboBoxTenSanPham.ValueMember = "ID";
comboBoxLoaiSanPham.DataSource = categoryManager.GetAll();
comboBoxLoaiSanPham.DisplayMember = "CategoryName";
comboBoxLoaiSanPham.ValueMember = "ID";
comboBoxNhasx.DataSource = manufacturerManager.GetAll();
comboBoxNhasx.DisplayMember = "ManName";
comboBoxNhasx.ValueMember = "ID";
cboTenSanPham.DataSource = productNameManager.GetAll();
cboTenSanPham.DisplayMember = "ProdName";
cboTenSanPham.ValueMember = "ID";
cboLoaiSanPham.DataSource = categoryManager.GetAll();
cboLoaiSanPham.DisplayMember = "CategoryName";
cboLoaiSanPham.ValueMember = "ID";
cboNguonGoc.DataSource = countryManager.GetAll();
cboNguonGoc.DisplayMember = "CountryName";
cboNguonGoc.ValueMember = "ID";
cboNhaSanXuat.DataSource = manufacturerManager.GetAll();
cboNhaSanXuat.DisplayMember = "ManName";
cboNhaSanXuat.ValueMember = "ID";
cboDonVi.DataSource = unitManager.GetAll();
cboDonVi.DisplayMember = "UnitName";
cboDonVi.ValueMember = "ID";
cboTrangThai.DataSource = productStatusManager.GetAll();
cboTrangThai.DisplayMember = "StatusName";
cboTrangThai.ValueMember = "ID";
ResetFormProductName();
SetFormProductNameReadOnly(true);
SetFormProductReadOnly(true);
//int khoa = Int32.Parse(cboTenSanPham.SelectedValue.ToString());
//ProductName productName = productNameManager.GetById(khoa, true);
//cboLoaiSanPham.SelectedValue = productName.CategoryIdLookup.ID;
//cboNhaSanXuat.SelectedValue = productName.ManIdLookup.ID;
//Manufacturer man = manufacturerManager.GetById(productName.ManIdLookup.ID, true);
//cboNguonGoc.SelectedValue = man.CountryIdLookup.ID;
//xoaTrang();
//Display all column in gridview
DisplayAll();
//BindingProductToForm(0);
//updateProductId = (Int64)gvSanPhamDanhMuc.Rows[0].Cells["ProductId"].Value;
//BindingProductNameToForm(0);
//updateProductNameId = (Int32)gvTenSanPham.Rows[0].Cells["ProductNameId"].Value;
}
catch (Exception ex)
{
logger.Debug(ex.Message);
logger.Debug(ex.StackTrace);
MessageBox.Show(ex.StackTrace);
}
}
private void RefreshGridView(Provider searchEntity)
{
//Get all user
searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
//
this.searchEntity = searchEntity;
//
SearchResult<Provider> searchResult = manufacturerManager.GetProviderListByParam(searchEntity, searchParam);
currentListProvider = searchResult.SearchList;
//Binding list userrole to gridview
IList2DataTable(searchResult.SearchList, dataSetProvider.Tables["Provider"]);
//Binding list to navigator
listPages = new List<Int32>();
BindingDataToBindingNagivator(searchResult.SearchSize, 0);
}
private void MoveItem(int position)
{
SearchParam searchParam = new SearchParam();
searchParam.Start = bindingNavigatorProvider.BindingSource.Position * DEFAULT_LIMIT;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
//this.BindingDataToForm(searchEntity, searchParam, position);
SearchResult<Provider> searchResult = manufacturerManager.GetProviderListByParam(searchEntity, searchParam);
currentListProvider = searchResult.SearchList;
//Binding list userrole to gridview
IList2DataTable(searchResult.SearchList, dataSetProvider.Tables["Provider"]);
//
BindingDataToBindingNagivator(searchResult.SearchSize, position);
}
private void FrmProvider_Load(object sender, EventArgs e)
{
//
ContructGridViewColumn();
//Get all user
searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
//
searchEntity = new Provider();
//
SearchResult<Provider> searchResult = manufacturerManager.GetProviderListByParam(searchEntity, searchParam);
currentListProvider = searchResult.SearchList;
//Binding list userrole to gridview
IList2DataTable(searchResult.SearchList, dataSetProvider.Tables["Provider"]);
//Binding list to navigator
listPages = new List<Int32>();
BindingDataToBindingNagivator(searchResult.SearchSize, 0);
//Binding data to cbbCountry
cbbCountry.DataSource = countryManager.GetAll();
cbbCountry.ValueMember = "ID";
cbbCountry.DisplayMember = "CountryName";
//
isAdd = true;
}
private void FrmUser_Load(object sender, EventArgs e)
{
try
{
//Create column of gridview
ContructGridViewColumn();
//Get all user
searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
searchEntity = new User();
SearchResult<User> searchResult = userManager.GetUserListByParam(searchEntity, searchParam);
currentListUser = searchResult.SearchList;
//Binding list user to gridview
IList2DataTable(currentListUser, dataSetUser.Tables["User"]);
//
listPages = new List<Int32>();
BindingDataToBindingNagivator(searchResult.SearchSize, 0);
//Binding value for combobox
cbbUserTitle.DataSource = userTitleManager.GetAll();
cbbUserTitle.DisplayMember = "UserTitleName";
cbbUserTitle.ValueMember = "ID";
cbbUserRole.DataSource = userRoleManager.GetAll();
cbbUserRole.DisplayMember = "UserRoleName";
cbbUserRole.ValueMember = "ID";
cbbUserStatus.DataSource = userStatusManager.GetAll();
cbbUserStatus.DisplayMember = "UserStatusName";
cbbUserStatus.ValueMember = "ID";
//Display all column in gridview
DisplayAll();
}
catch (Exception ex)
{
logger.Debug(ex.Message);
logger.Debug(ex.StackTrace);
MessageBox.Show(ex.Message);
}
}
private void MoveItem(int position)
{
SearchParam searchParam = new SearchParam();
searchParam.Start = bindingNavigatorUserStatus.BindingSource.Position * DEFAULT_LIMIT;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
//this.BindingDataToForm(searchEntity, searchParam, position);
SearchResult<UserStatus> searchResult = userStatusManager.GetUserStatusListByParam(searchEntity, searchParam);
//Binding list userrole to gridview
IList2DataTable(searchResult.SearchList, dataSetUserStatus.Tables["UserStatus"]);
//
BindingDataToBindingNagivator(searchResult.SearchSize, position);
}
private void MoveItemProductName(int position)
{
SearchParam searchParam = new SearchParam();
searchParam.Start = bindingNavigatorProductName.BindingSource.Position * DEFAULT_LIMIT;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
this.BindingDataToFormProductName(searchEntityProductName, searchParam, position);
}
private void RefreshGridView(UserStatus searchEntity)
{
//Get all user
searchParam = new SearchParam();
searchParam.Start = DEFAULT_START;
searchParam.Limit = DEFAULT_LIMIT;
searchParam.SortBy = DEFAULT_SORT_BY;
searchParam.SortDir = DEFAULT_SORT_DIR;
//
this.searchEntity = searchEntity;
//
SearchResult<UserStatus> searchResult = userStatusManager.GetUserStatusListByParam(searchEntity, searchParam);
//Binding list userrole to gridview
IList2DataTable(searchResult.SearchList, dataSetUserStatus.Tables["UserStatus"]);
//Binding list to navigator
listPages = new List<Int32>();
BindingDataToBindingNagivator(searchResult.SearchSize, 0);
}
private void BindingDataToForm(User entity, SearchParam searchParam, int position)
{
SearchResult<User> searchResult = userManager.GetUserListByParam(entity, searchParam);
if (searchResult != null)
{
DataTable dataTableUser = new DataTable("User");
dataTableUser.Columns.Add("UserId", typeof(int));
dataTableUser.Columns.Add("Username", typeof(string));
dataTableUser.Columns.Add("FullName", typeof(string));
dataTableUser.Columns.Add("Email", typeof(string));
dataTableUser.Columns.Add("Birthday", typeof(string));
dataTableUser.Columns.Add("IdCardNo", typeof(string));
dataTableUser.Columns.Add("SexId", typeof(byte));
dataTableUser.Columns.Add("Sex", typeof(string));
dataTableUser.Columns.Add("TelNo", typeof(string));
dataTableUser.Columns.Add("Address", typeof(string));
dataTableUser.Columns.Add("UserTitleId", typeof(int));
dataTableUser.Columns.Add("UserTitle", typeof(string));
dataTableUser.Columns.Add("UserRoleId", typeof(int));
dataTableUser.Columns.Add("UserRole", typeof(string));
dataTableUser.Columns.Add("UserStatusId", typeof(int));
dataTableUser.Columns.Add("UserStatus", typeof(string));
foreach(User objUser in searchResult.SearchList)
{
DataRow rowTemp = dataTableUser.NewRow();
rowTemp["UserId"] = objUser.ID;
rowTemp["Username"] = objUser.Username;
rowTemp["FullName"] = objUser.FullName;
rowTemp["Email"] = objUser.Email;
rowTemp["Birthday"] = objUser.Birthday.Value.ToString("dd/MM/yyyy");
rowTemp["IdCardNo"] = objUser.IdCardNo;
try
{
if (Int32.Parse(objUser.Sex.ToString()) == 0)
{
rowTemp["Sex"] = "Nữ";
rowTemp["SexId"] = 0;
}
else {
rowTemp["Sex"] = "Nam";
rowTemp["SexId"] = 1;
}
}
catch (Exception ex) {
rowTemp["Sex"] = "Nam";
}
rowTemp["TelNo"] = objUser.TelNo;
rowTemp["Address"] = objUser.Address;
rowTemp["UserTitleId"] = objUser.UserTitleId;
if (objUser.UserTitleIdLookup != null)
{
rowTemp["UserTitle"] = objUser.UserTitleIdLookup.UserTitleName;
}
else
{
if (objUser.UserTitleId.HasValue)
{
UserTitle temp = userTitleManager.GetById(objUser.UserTitleId.Value, false);
rowTemp["UserTitle"] = temp.UserTitleName;
}
else
{
rowTemp["UserTitle"] = string.Empty;
}
}
rowTemp["UserRoleId"] = objUser.UserRoleId;
if (objUser.UserRoleIdLookup != null)
{
rowTemp["UserRole"] = objUser.UserRoleIdLookup.UserRoleName;
}
else
{
if (objUser.UserRoleId != 0)
{
UserRole temp = userRoleManager.GetById(objUser.UserRoleId, false);
rowTemp["UserRole"] = temp.UserRoleName;
}
else
{
rowTemp["UserRole"] = string.Empty;
}
}
rowTemp["UserStatusId"] = objUser.UserStatusId;
if (objUser.UserStatusIdLookup != null)
{
rowTemp["UserStatus"] = objUser.UserStatusIdLookup.UserStatusName;
}
else
{
UserStatus temp = userStatusManager.GetById(objUser.UserStatusId, false);
if (temp != null)
{
rowTemp["UserStatus"] = temp.UserStatusName;
}
else
{
rowTemp["UserStatus"] = string.Empty;
}
}
dataTableUser.Rows.Add(rowTemp);
}
dataSetUser = new DataSet();
dataSetUser.Tables.Add(dataTableUser);
gvUser.DataSource = dataSetUser;
gvUser.DataMember = "User";
gvUser.Columns["UserId"].HeaderText = "Mã người dùng";
gvUser.Columns["Username"].HeaderText = "Tên đăng nhập";
gvUser.Columns["FullName"].HeaderText = "Họ và tên";
gvUser.Columns["Email"].HeaderText = "Email";
gvUser.Columns["Birthday"].HeaderText = "Ngày sinh";
gvUser.Columns["IdCardNo"].HeaderText = "Số CMT/Passport";
gvUser.Columns["Sex"].HeaderText = "Giới tính";
gvUser.Columns["TelNo"].HeaderText = "Điện thoại";
gvUser.Columns["Address"].HeaderText = "Địa chỉ";
gvUser.Columns["UserTitleId"].Visible = false;
gvUser.Columns["UserTitle"].HeaderText = "Chức vụ";
gvUser.Columns["UserRoleId"].Visible = false;
gvUser.Columns["UserRole"].HeaderText = "Nhóm người dùng";
gvUser.Columns["UserStatusId"].Visible = false;
gvUser.Columns["UserStatus"].HeaderText = "Trạng thái";
//
currentListUser = searchResult.SearchList;
//
logger.Debug("searchList size = " + searchResult.SearchList.Count);
List<Int32> listPages = new List<Int32>();
int totalPage = 0;
if (searchResult.SearchSize % DEFAULT_LIMIT > 0)
{
totalPage = (int)searchResult.SearchSize / DEFAULT_LIMIT + 1;
}
else
{
totalPage = (int)searchResult.SearchSize / DEFAULT_LIMIT;
}
logger.Debug("searchSize = " + searchResult.SearchSize);
logger.Debug("totalPage = " + totalPage);
for (int i = 0; i < totalPage; i++)
{
listPages.Add(i);
}
bindingNavigatorUser.BindingSource = new BindingSource(listPages, "");
bindingNavigatorUser.BindingSource.Position = position;
bindingNavigatorUser.BindingSource.PositionChanged += new EventHandler(BindingSource_PositionChanged);
//Set total of number user in bindingNavigator
toolStripLblTotal.Text = "Tổng số người dùng: " + searchResult.SearchSize;
}
}