private void button4_Click(object sender, EventArgs e)
{
if (Product == null) {
Product = new Product();
}
if (Product.ProductMaster == null)
{
Product.ProductMaster = new ProductMaster();
}
Product.ProductMaster.ProductName = txtProductName.Text;
this.Close();
}
private object[] AddProductToDataGrid(Product product, int rowIndex)
{
var obj = new object[MAX_COLUMNS];
obj[PRODUCT_PRICE_POS] = product.Price;
obj[PRODUCT_QUANTITY_POS] = product.Quantity;
if (product.ProductMaster != null)
{
obj[PRODUCT_ID_POS] = product.ProductMaster.ProductMasterId;
obj[PRODUCT_NAME_POS] = product.ProductMaster.ProductName;
obj[PRODUCT_TYPE_POS] = product.ProductMaster.ProductType.TypeName;
obj[PRODUCT_SIZE_POS] = product.ProductMaster.ProductSize.SizeName;
obj[PRODUCT_COLOR_POS] = product.ProductMaster.ProductColor.ColorName;
}
obj[MAX_COLUMNS - 1] = rowIndex;
return obj;
}
private void btnAdd_Click(object sender, EventArgs e)
{
PurchaseOrderDetail orderDetail = pODList.AddNew();
orderDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
orderDetail.CreateDate = DateTime.Now;
orderDetail.UpdateDate = DateTime.Now;
orderDetail.UpdateId = orderDetail.CreateId;
orderDetail.DelFlg = 0;
orderDetail.DepartmentId = CurrentDepartment.Get().DepartmentId;
orderDetail.Quantity = 1;
if (GoodsSaleController.PurchaseOrder == null)
{
PurchaseOrder order = new PurchaseOrder();
GoodsSaleController.PurchaseOrder = order;
}
orderDetail.PurchaseOrder = GoodsSaleController.PurchaseOrder;
PurchaseOrderDetailPK purchaseOrderDetailPK = new PurchaseOrderDetailPK();
purchaseOrderDetailPK.DepartmentId = CurrentDepartment.Get().DepartmentId;
orderDetail.PurchaseOrderDetailPK = purchaseOrderDetailPK;
// new product to test
ProductMaster productMaster = new ProductMaster();
orderDetail.ProductMaster = productMaster;
Product product = new Product();
product.ProductMaster = orderDetail.ProductMaster;
orderDetail.Product = product;
GoodsSaleController.PurchaseOrder.PurchaseOrderDetails =
ObjectConverter.ConvertToNonGenericList<PurchaseOrderDetail>(pODList);
bdsBill.EndEdit();
//bdsBill.EndEdit();
}
public long FindConfirmingQuantity(Product product)
{
return (long)HibernateTemplate.Execute(
delegate(ISession session)
{
IList list = null;
try
{
string queryString =
" SELECT SUM(sodet.Quantity) FROM StockOutDetail sodet,StockOut so " +
" WHERE sodet.StockOut.StockoutId = so.StockoutId AND so.ConfirmFlg = 1 AND so.DelFlg = 0 " +
" AND sodet.DelFlg = 0 and sodet.Product.ProductId = :stockOutId GROUP BY sodet.Product.ProductId";
IQuery iQuery = session.CreateQuery(queryString);
iQuery.SetParameter("stockOutId", product.ProductId);
list = iQuery.List();
if (list == null || list.Count != 1)
return (long)0;
return (long)list[0];
}
catch (Exception e)
{
Console.Out.WriteLine(e.Message);
return 0;
}
}
);
}
public long FindConfirmingQuantity(Product product)
{
return StockOutDetailDAO.FindConfirmingQuantity(product);
}
private bool ExistInList(IList list, Product product)
{
foreach (Product product1 in list)
{
if(product1.ProductId.Equals(product.ProductId))
{
return true;
}
}
return false;
}
private void dgvProduct_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0)
{
var productMasterForm = GlobalUtility.GetFormObject<ProductMasterSearchOrCreateForm>(FormConstants.PRODUCT_MASTER_SEARCH_OR_CREATE_FORM);
productMasterForm.ShowDialog();
if (productMasterForm.SelectedProductMaster != null)
{
// check if the product master already existed
foreach (Product product in BlockInDetail.Products)
{
if (product.ProductMaster != null && product.ProductMaster.ProductMasterId == productMasterForm.SelectedProductMaster.ProductMasterId)
{
return;
}
}
if (e.RowIndex < BlockInDetail.Products.Count)
{
var product = (Product)BlockInDetail.Products[e.RowIndex];
product.ProductMaster = productMasterForm.SelectedProductMaster;
ModifyDataGrid(product, e.RowIndex);
//BindDataToProducts();
//PopulateDataGrid();
}
else
{
var product = new Product
{
ProductMaster = productMasterForm.SelectedProductMaster
};
BlockInDetail.Products.Add(product);
ModifyDataGrid(product, e.RowIndex);
//BindDataToProducts();
//PopulateDataGrid();
}
}
}
}
/// <summary>
/// Delete Product from database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public void Delete(Product data)
{
HibernateTemplate.Delete(data);
}
/// <summary>
/// Add Product to database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public Product Add(Product data)
{
HibernateTemplate.Save(data);
return data;
}
public void Update(Product data)
{
ProductDAO.Update(data);
}
private void ModifyDataGrid(Product product, int rowIndex)
{
dgvProduct[PRODUCT_PRICE_POS + 1, rowIndex].Value = product.Price;
dgvProduct[PRODUCT_QUANTITY_POS + 1, rowIndex].Value = product.Quantity;
if (product.ProductMaster != null)
{
dgvProduct[PRODUCT_ID_POS + 1, rowIndex].Value = product.ProductMaster.ProductMasterId;
dgvProduct[PRODUCT_NAME_POS + 1, rowIndex].Value = product.ProductMaster.ProductName;
if (product.ProductMaster.ProductType != null)
{
dgvProduct[PRODUCT_TYPE_POS + 1, rowIndex].Value = product.ProductMaster.ProductType.TypeName;
}
if (product.ProductMaster.ProductSize != null)
{
dgvProduct[PRODUCT_SIZE_POS + 1, rowIndex].Value = product.ProductMaster.ProductSize.SizeName;
}
if (product.ProductMaster.ProductColor != null)
{
dgvProduct[PRODUCT_COLOR_POS + 1, rowIndex].Value = product.ProductMaster.ProductColor.ColorName;
}
if (product.ProductMaster.Country != null)
{
dgvProduct[PRODUCT_COUNTRY_POS + 1, rowIndex].Value = product.ProductMaster.Country.CountryName;
}
if (product.ProductMaster.Manufacturer != null)
{
dgvProduct[PRODUCT_SUPPLIER_POS + 1, rowIndex].Value = product.ProductMaster.Manufacturer.ManufacturerName;
}
}
else
{
dgvProduct[PRODUCT_ID_POS + 1, rowIndex].Value = "";
dgvProduct[PRODUCT_NAME_POS + 1, rowIndex].Value = "";
dgvProduct[PRODUCT_TYPE_POS + 1, rowIndex].Value = "";
dgvProduct[PRODUCT_SIZE_POS + 1, rowIndex].Value = "";
dgvProduct[PRODUCT_COLOR_POS + 1, rowIndex].Value = "";
dgvProduct[PRODUCT_COUNTRY_POS + 1, rowIndex].Value = "";
dgvProduct[PRODUCT_SUPPLIER_POS + 1, rowIndex].Value = "";
}
}
/// <summary>
/// Update Product to database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public void Update(Product data)
{
HibernateTemplate.Update(data);
}
private void dgvProduct_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0 && e.RowIndex >= 0 && e.RowIndex < DepartmentStockInDetailList.Count)
{
/* if (CurrentDepartmentStockIn != null)
{
string productId = dgvProduct[PRODUCT_ID_POS + 1, e.RowIndex].Value.ToString();
foreach (DepartmentStockInDetail d in DepartmentStockInDetailList)
{
if (d.Product.ProductMaster != null
&& d.Product.ProductMaster.ProductMasterId != null
&& d.Product.ProductMaster.ProductMasterId.Equals(productId))
{
return;
}
}
}
*/
var productMasterForm = GlobalUtility.GetFormObject<ProductMasterSearchOrCreateForm>(FormConstants.PRODUCT_MASTER_SEARCH_OR_CREATE_FORM);
productMasterForm.ShowDialog();
ProductMaster productMaster = productMasterForm.SelectedProductMaster;
if (productMaster != null)
{
// check if the product master already existed
foreach (DepartmentStockInDetail stockInDetail in DepartmentStockInDetailList)
{
if (stockInDetail.Product != null && stockInDetail.Product.ProductMaster != null && stockInDetail.Product.ProductMaster.ProductMasterId == productMaster.ProductMasterId)
{
return;
}
}
if (e.RowIndex < DepartmentStockInDetailList.Count)
{
var stockInDetail = (DepartmentStockInDetail)DepartmentStockInDetailList[e.RowIndex];
if (stockInDetail.Product == null)
{
stockInDetail.Product = new Product();
}
stockInDetail.Product.ProductMaster = productMaster;
ModifyDataGrid(stockInDetail.Product, e.RowIndex);
}
else
{
var product = new Product
{
ProductMaster = productMaster
};
DepartmentStockInDetailList.Add(new DepartmentStockInDetail { Product = product });
ModifyDataGrid(product, e.RowIndex);
}
}
}
}
private Stock GetStockOfProduct(Product product, IList stockList)
{
foreach (Stock stock in stockList)
{
if(stock.Product.ProductId == product.ProductId)
{
return stock;
}
}
return null;
}
public void Delete(Product data)
{
ProductDAO.Delete(data);
}
public Product Add(Product data)
{
ProductDAO.Add(data);
return data;
}
private void CreateNewBlankPurchaseOrderDetail(BindingSource bill)
{
PurchaseOrderDetail orderDetail = (PurchaseOrderDetail)bill.AddNew();
orderDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
orderDetail.CreateDate = DateTime.Now;
orderDetail.UpdateDate = DateTime.Now;
orderDetail.UpdateId = orderDetail.CreateId;
orderDetail.DelFlg = 0;
orderDetail.DepartmentId = CurrentDepartment.Get().DepartmentId;
orderDetail.Quantity = 1;
PurchaseOrderDetailPK purchaseOrderDetailPK = new PurchaseOrderDetailPK();
purchaseOrderDetailPK.DepartmentId = CurrentDepartment.Get().DepartmentId;
orderDetail.PurchaseOrderDetailPK = purchaseOrderDetailPK;
// new product to test
ProductMaster productMaster = new ProductMaster();
orderDetail.ProductMaster = productMaster;
Product product = new Product();
product.ProductMaster = orderDetail.ProductMaster;
orderDetail.Product = product;
bill.EndEdit();
}
