public BlockInDetail Add(BlockInDetail data)
{
var pk = new BlockInDetailPK {BlockId = 1};
var maxId = BlockInDetailDAO.SelectSpecificType(null, Projections.Max("BlockInDetailPK.BlockDetailId"));
pk.BlockDetailId = maxId == null ? "1" : (Int64.Parse(maxId.ToString()) + 1).ToString();
data.BlockInDetailPK = pk;
var maxProduct = ProductDAO.SelectSpecificType(null, Projections.Max("ProductId"));
Int64 maxProductId = 1;
if (maxProduct != null)
{
maxProductId = (Int64)maxProduct + 1;
}
var maxStockInId = StockInDAO.SelectSpecificType(null, Projections.Max("StockInId"));
if (maxStockInId == null)
{
maxStockInId = (long) 1;
}
else
{
maxStockInId = (long)maxStockInId + 1;
}
var stockIn = new StockIn {StockInDate = data.ImportDate};
data.StockInId = (long)maxStockInId;
BlockInDetailDAO.Add(data);
StockInDAO.Add(stockIn);
foreach (Product product in data.Products)
{
// TODO product.ProductId = maxProductId++;
product.BlockInDetail = data;
ProductDAO.Add(product);
var stockInDetail = new StockInDetail
{
Product = product,
ProductId = product.ProductId,
StockIn = stockIn,
Quantity = product.Quantity,
Price = product.Price,
StockInType = (Int64)StockInDetail.StockInStatus.IMPORTED,
StockInDetailPK =
new StockInDetailPK
{StockInId = stockIn.StockInId, ProductId = product.ProductId}
};
StockInDetailDAO.Add(stockInDetail);
}
return data;
}
private void GoodsInput_Load(object sender, EventArgs e)
{
if (supplierList == null)
{
supplierList = SupplierLogic.FindAll(null);
cbbSupplier.DisplayMember = "SupplierName";
cbbSupplier.DataSource = supplierList;
}
if (sizeList == null)
{
sizeList = SizeLogic.FindAll(null);
}
if (colorList == null)
{
colorList = ColorLogic.FindAll(null);
}
if (typeList == null)
{
typeList = TypeLogic.FindAll(null);
}
if (BlockInDetail != null)
{
txtBlockId.Text = BlockInDetail.BlockInDetailPK.BlockDetailId + "";
txtDexcription.Text = BlockInDetail.DetailValue;
for (int i = 0; i < supplierList.Count; i++ )
{
if (((Supplier)supplierList[i]).SupplierId == BlockInDetail.SupplierId)
{
cbbSupplier.SelectedItem = supplierList[i];
break;
}
}
dtpImportDate.Value = BlockInDetail.BlockIn.ImportDate;
PopulateDataGrid();
}
else
{
BlockInDetail = new BlockInDetail();
}
}
public void Update(BlockInDetail data)
{
// Update block
BlockInDetailDAO.Update(data);
// Update Stock In
StockIn stockIn = null;
if (data.StockInId != 0)
{
stockIn = StockInDAO.FindById(data.StockInId);
if (stockIn != null)
{
stockIn.StockInDate = data.ImportDate;
StockInDAO.Update(stockIn);
}
}
// Get the max id of product
var maxProduct = ProductDAO.SelectSpecificType(null, Projections.Max("ProductId"));
Int64 maxProductId = 1;
if (maxProduct != null)
{
maxProductId = ((Int64)maxProduct) + 1;
}
foreach (Product product in data.Products)
{
// Add new Product
if (string.IsNullOrEmpty(product.ProductId))
{
// TODO product.ProductId = maxProductId++;
ProductDAO.Add(product);
if (stockIn != null)
{
var stockInDetail = new StockInDetail
{
Product = product,
ProductId = product.ProductId,
StockIn = stockIn,
Quantity = product.Quantity,
Price = product.Price,
StockInDetailPK =
new StockInDetailPK { StockInId = stockIn.StockInId, ProductId = product.ProductId }
};
StockInDetailDAO.Add(stockInDetail);
}
}
// Update Product
else {
ProductDAO.Update(product);
if (stockIn != null)
{
var stockInDetail = new StockInDetail
{
Product = product,
ProductId = product.ProductId,
StockIn = stockIn,
Quantity = product.Quantity,
Price = product.Price,
StockInDetailPK =
new StockInDetailPK { StockInId = stockIn.StockInId, ProductId = product.ProductId }
};
StockInDetailDAO.Update(stockInDetail);
}
}
}
}
public void Delete(BlockInDetail data)
{
BlockInDetailDAO.Delete(data);
}
/// <summary>
/// Delete BlockInDetail from database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public void Delete(BlockInDetail data)
{
HibernateTemplate.Delete(data);
}
/// <summary>
/// Add BlockInDetail to database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public BlockInDetail Add(BlockInDetail data)
{
HibernateTemplate.Save(data);
return data;
}
/// <summary>
/// Update BlockInDetail to database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public void Update(BlockInDetail data)
{
HibernateTemplate.Update(data);
}
private object[] AddBlockToDataGrid(BlockInDetail blockInDetail)
{
var obj = new object[6];
obj[0] = blockInDetail.BlockInDetailPK.BlockDetailId;
obj[1] = blockInDetail.ImportDate.ToString("dd/MM/yyyy HH:mm:ss");
obj[2] = blockInDetail.DetailValue;
Int64 sumOfProduct = 0;
Int64 sumOfPrice = 0;
foreach (Product product in blockInDetail.Products)
{
sumOfProduct += product.Quantity;
sumOfPrice += (product.Quantity * product.Price);
}
obj[3] = sumOfProduct;
obj[4] = sumOfPrice;
if (blockInDetail.DelFlg == 1)
{
obj[5] = "Đã xóa";
}
return obj;
}
