public void Update(StockIn data)
{
string dateStr = data.StockInDate.ToString("yyMMdd");
var criteria = new ObjectCriteria();
criteria.AddGreaterCriteria("ProductId", dateStr + "000000");
var maxId = ProductDAO.SelectSpecificType(criteria, Projections.Max("ProductId"));
var productId = (maxId == null)
? Int64.Parse(dateStr + "000001")
: (Int64.Parse(maxId.ToString()) + 1);
maxId = StockDAO.SelectSpecificType(null, Projections.Max("StockId"));
var stockId = maxId == null ? 1 : Int64.Parse(maxId.ToString()) + 1;
data.UpdateDate = DateTime.Now;
data.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
int delFlg = 0;
foreach (StockInDetail stockInDetail in data.StockInDetails)
{
// add product
Product product = stockInDetail.Product;
if (string.IsNullOrEmpty(product.ProductId))
{
product.ProductId = string.Format("{0:000000000000}", productId++);
product.CreateDate = DateTime.Now;
product.UpdateDate = DateTime.Now;
product.Quantity = stockInDetail.Quantity;
product.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
product.CreateId = ClientInfo.getInstance().LoggedUser.Name;
ProductDAO.Add(product);
// add dept stock in
var detailPK = new StockInDetailPK { ProductId = product.ProductId, StockInId = data.StockInId };
stockInDetail.StockInDetailPK = detailPK;
stockInDetail.CreateDate = DateTime.Now;
stockInDetail.UpdateDate = DateTime.Now;
stockInDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
stockInDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
stockInDetail.ProductMaster = product.ProductMaster;
StockInDetailDAO.Add(stockInDetail);
// dept stock
var departmentStock = new Stock
{
StockId = stockId++,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Product = product,
ProductMaster = product.ProductMaster,
Quantity = stockInDetail.Quantity,
GoodQuantity = stockInDetail.Quantity
};
departmentStock.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
departmentStock.CreateId = ClientInfo.getInstance().LoggedUser.Name;
StockDAO.Add(departmentStock);
var pricePk = new DepartmentPricePK { DepartmentId = 0, ProductMasterId = product.ProductMaster.ProductMasterId };
var price = DepartmentPriceDAO.FindById(pricePk);
if (price == null)
{
price = new DepartmentPrice { DepartmentPricePK = pricePk, Price = stockInDetail.SellPrice, UpdateDate = DateTime.Now, CreateDate = DateTime.Now };
price.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
price.CreateId = ClientInfo.getInstance().LoggedUser.Name;
DepartmentPriceDAO.Add(price);
}
}
else
{
var temProduct = ProductDAO.FindById(product.ProductId);
if (stockInDetail.DelFlg == 0)
{
temProduct.Quantity = product.Quantity;
temProduct.Price = product.Price;
}
else
{
temProduct.DelFlg = 1;
delFlg++;
}
temProduct.UpdateDate = DateTime.Now;
product.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
ProductDAO.Update(temProduct);
// update dept stock in
var detailPK = new StockInDetailPK { ProductId = product.ProductId, StockInId = data.StockInId };
stockInDetail.StockInDetailPK = detailPK;
stockInDetail.UpdateDate = DateTime.Now;
stockInDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
StockInDetailDAO.Update(stockInDetail);
// update stock
criteria = new ObjectCriteria();
criteria.AddEqCriteria("Product.ProductId", product.ProductId);
criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
IList departmentStockList = StockDAO.FindAll(criteria);
if (departmentStockList.Count > 0)
{
Stock stock = (Stock) departmentStockList[0];
stock.UpdateDate = DateTime.Now;
if (stockInDetail.DelFlg == 0)
{
stock.GoodQuantity = stock.GoodQuantity -
(stockInDetail.OldQuantity - stockInDetail.Quantity);
stock.Quantity = stock.ErrorQuantity + stock.GoodQuantity + stock.DamageQuantity +
stock.UnconfirmQuantity + stock.LostQuantity;
}
else
{
stock.DelFlg = 1;
}
stock.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
stock.CreateId = ClientInfo.getInstance().LoggedUser.Name;
StockDAO.Update(stock);
}
var pricePk = new DepartmentPricePK { DepartmentId = 0, ProductMasterId = product.ProductMaster.ProductMasterId };
var price = DepartmentPriceDAO.FindById(pricePk);
if (price == null)
{
price = new DepartmentPrice { DepartmentPricePK = pricePk, Price = stockInDetail.SellPrice, UpdateDate = DateTime.Now, CreateDate = DateTime.Now };
price.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
price.CreateId = ClientInfo.getInstance().LoggedUser.Name;
DepartmentPriceDAO.Add(price);
}
}
}
if (delFlg == data.StockInDetails.Count)
{
data.DelFlg = 1;
}
StockInDAO.Update(data);
}
public StockIn Add(StockIn data)
{
string dateStr = data.StockInDate.ToString("yyMMdd");
var criteria = new ObjectCriteria();
criteria.AddGreaterCriteria("StockInId", dateStr + "00000");
var maxId = StockInDAO.SelectSpecificType(criteria, Projections.Max("StockInId"));
var stockInId = maxId == null ? dateStr + "00001" : string.Format("{0:00000000000}", (Int64.Parse(maxId.ToString()) + 1));
data.StockInId = stockInId;
criteria = new ObjectCriteria();
criteria.AddGreaterCriteria("ProductId", dateStr + "000000");
maxId = ProductDAO.SelectSpecificType(criteria, Projections.Max("ProductId"));
var productId = (maxId == null)
? Int64.Parse(dateStr + "000001")
: (Int64.Parse(maxId.ToString()) + 1);
maxId = StockDAO.SelectSpecificType(null, Projections.Max("StockId"));
var stockId = maxId == null ? 1 : Int64.Parse(maxId.ToString()) + 1;
data.CreateDate = DateTime.Now;
data.UpdateDate = DateTime.Now;
data.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
data.CreateId = ClientInfo.getInstance().LoggedUser.Name;
StockInDAO.Add(data);
foreach (StockInDetail stockInDetail in data.StockInDetails)
{
// add product
Product product = stockInDetail.Product;
if (string.IsNullOrEmpty(product.ProductId))
{
product.ProductId = string.Format("{0:000000000000}", productId++);
product.CreateDate = DateTime.Now;
product.UpdateDate = DateTime.Now;
product.Quantity = stockInDetail.Quantity;
product.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
product.CreateId = ClientInfo.getInstance().LoggedUser.Name;
ProductDAO.Add(product);
criteria = new ObjectCriteria();
criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
criteria.AddEqCriteria("ProductMaster.ProductMasterId", product.ProductMaster.ProductMasterId);
// var sum = StockDAO.SelectSpecificType(criteria, Projections.Sum("Quantity"));
// add dept stock in
var detailPK = new StockInDetailPK { ProductId = product.ProductId, StockInId = stockInId};
stockInDetail.StockInDetailPK = detailPK;
stockInDetail.CreateDate = DateTime.Now;
stockInDetail.UpdateDate = DateTime.Now;
stockInDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
stockInDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
stockInDetail.ProductMaster = product.ProductMaster;
// stockInDetail.CurrentStockQuantity = (sum == null) ? 0 : Int64.Parse(sum.ToString());
StockInDetailDAO.Add(stockInDetail);
// dept stock
var stock = new Stock
{
StockId = stockId++,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Product = product,
Quantity = stockInDetail.Quantity,
GoodQuantity = stockInDetail.Quantity,
ProductMaster = product.ProductMaster
};
stock.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
stock.CreateId = ClientInfo.getInstance().LoggedUser.Name;
StockDAO.Add(stock);
var pricePk = new DepartmentPricePK { DepartmentId = 0, ProductMasterId = product.ProductMaster.ProductMasterId };
var price = DepartmentPriceDAO.FindById(pricePk);
if (price == null)
{
price = new DepartmentPrice { DepartmentPricePK = pricePk, Price = stockInDetail.SellPrice, UpdateDate = DateTime.Now, CreateDate = DateTime.Now };
price.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
price.CreateId = ClientInfo.getInstance().LoggedUser.Name;
DepartmentPriceDAO.Add(price);
}
else
{
price.Price = stockInDetail.SellPrice;
price.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
price.UpdateDate = DateTime.Now;
DepartmentPriceDAO.Update(price);
}
}
}
return data;
}
private int GetIndexFromList(Stock stock, StockCollection collection)
{
for(int i=0;i<collection.Count;i++)
{
if(collection[i].Product.ProductId.Equals(stock.Product.ProductId))
{
return i;
}
}
return -1;
}
private bool HasInStockList(Stock stock, StockCollection list, out int stockDefIndex)
{
int count = -1;
foreach (Stock stockDefect in list)
{
if(stockDefect.Product.ProductId.Equals(stock.Product.ProductId))
{
stockDefIndex = count;
return true;
}
count += 1;
}
stockDefIndex = count;
return false;
}
private StockOutDetail GetFromStockOutList(Stock stock, StockOutDetailCollection list)
{
foreach (StockOutDetail detail in list)
{
if(detail.Product.ProductId == stock.Product.ProductId)
{
return detail;
}
}
return null;
}
private Stock GetFromStockList(Stock stock, StockCollection collection)
{
foreach (Stock stockChecked in collection)
{
if (stockChecked.Product.ProductId.Equals(stock.Product.ProductId))
{
return stockChecked;
}
}
return null;
}
public StockIn Add(StockIn data)
{
string dateStr = data.StockInDate.ToString("yyMMdd");
var criteria = new ObjectCriteria();
criteria.AddGreaterCriteria("StockInId", dateStr + "00000");
var maxId = StockInDAO.SelectSpecificType(criteria, Projections.Max("StockInId"));
var stockInId = maxId == null ? dateStr + "00001" : string.Format("{0:00000000000}", (Int64.Parse(maxId.ToString()) + 1));
data.StockInId = stockInId;
/*criteria = new ObjectCriteria();
criteria.AddGreaterCriteria("ProductId", dateStr + "000000");
maxId = ProductDAO.SelectSpecificType(criteria, Projections.Max("ProductId"));
var productId = (maxId == null)
? Int64.Parse(dateStr + "000001")
: (Int64.Parse(maxId.ToString()) + 1);*/
maxId = StockDAO.SelectSpecificType(null, Projections.Max("StockId"));
var stockId = maxId == null ? 1 : Int64.Parse(maxId.ToString()) + 1;
data.CreateDate = DateTime.Now;
data.UpdateDate = DateTime.Now;
data.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
data.CreateId = ClientInfo.getInstance().LoggedUser.Name;
StockInDAO.Add(data);
IDictionary<string, string> maxPrdIdList = new Dictionary<string, string>();
foreach (StockInDetail stockInDetail in data.StockInDetails)
{
// add product
Product product = stockInDetail.Product;
if (string.IsNullOrEmpty(product.ProductId))
{
// find master ID
string masterId = product.ProductMaster.ProductMasterId;
masterId = masterId.Substring(6);
// search in product table to get latest number
string nextPrdId = GetProductIdFromList(maxPrdIdList,masterId);
if (nextPrdId == null)
{
string shortDate = StringUtility.ConvertDateToFourChar(DateTime.Now);
ObjectCriteria prdCrit = new ObjectCriteria();
prdCrit.AddLikeCriteria("ProductId", masterId + shortDate + "%");
var maxIPrdId = ProductDAO.SelectSpecificType(prdCrit, Projections.Max("ProductId"));
string productId = (maxIPrdId == null)
? masterId + shortDate + "01"
: IncreaseMaxProductId(maxIPrdId.ToString());
nextPrdId = productId;
maxPrdIdList[masterId] = nextPrdId;
}
product.ProductId = nextPrdId;
// increase product id and grant to the dictionary
nextPrdId = IncreaseMaxProductId(nextPrdId);
maxPrdIdList[masterId] = nextPrdId;
product.CreateDate = DateTime.Now;
product.UpdateDate = DateTime.Now;
product.Quantity = stockInDetail.Quantity;
product.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
product.CreateId = ClientInfo.getInstance().LoggedUser.Name;
ProductDAO.Add(product);
criteria = new ObjectCriteria();
criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
criteria.AddEqCriteria("ProductMaster.ProductMasterId", product.ProductMaster.ProductMasterId);
// var sum = StockDAO.SelectSpecificType(criteria, Projections.Sum("Quantity"));
// add dept stock in
var detailPK = new StockInDetailPK { ProductId = product.ProductId, StockInId = stockInId};
stockInDetail.StockInDetailPK = detailPK;
stockInDetail.CreateDate = DateTime.Now;
stockInDetail.UpdateDate = DateTime.Now;
stockInDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
stockInDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
stockInDetail.ProductMaster = product.ProductMaster;
// stockInDetail.CurrentStockQuantity = (sum == null) ? 0 : Int64.Parse(sum.ToString());
StockInDetailDAO.Add(stockInDetail);
// if do not needs to confirm then update stock.
if (data.ConfirmFlg != 1)
{
// add stock
var stock = new Stock
{
StockId = stockId++,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Product = product,
Quantity = stockInDetail.Quantity,
GoodQuantity = stockInDetail.Quantity,
ProductMaster = product.ProductMaster
};
stock.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
stock.CreateId = ClientInfo.getInstance().LoggedUser.Name;
StockDAO.Add(stock);
}
var pricePk = new DepartmentPricePK { DepartmentId = 0, ProductMasterId = product.ProductMaster.ProductMasterId };
var price = DepartmentPriceDAO.FindById(pricePk);
if (price == null)
{
price = new DepartmentPrice
{
DepartmentPricePK = pricePk,
Price = stockInDetail.SellPrice,
WholeSalePrice = stockInDetail.WholeSalePrice,
UpdateDate = DateTime.Now,
CreateDate = DateTime.Now
};
if(stockInDetail.DepartmentPrice!=null)
{
price.WholeSalePrice = stockInDetail.DepartmentPrice.WholeSalePrice;
}
price.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
price.CreateId = ClientInfo.getInstance().LoggedUser.Name;
DepartmentPriceDAO.Add(price);
}
else
{
// don't need to update price
//price.Price = stockInDetail.SellPrice;
price.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
price.UpdateDate = DateTime.Now;
//DepartmentPriceDAO.Update(price);
}
}
}
return data;
}
/// <summary>
/// Delete Stock from database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public void Delete(Stock data)
{
HibernateTemplate.Delete(data);
}
public void Delete(Stock data)
{
StockDAO.Delete(data);
}
public void UpdateDetail(StockIn data)
{
string dateStr = data.StockInDate.ToString("yyMMdd");
var criteria = new ObjectCriteria();
criteria.AddGreaterCriteria("ProductId", dateStr + "000000");
//var maxId = ProductDAO.SelectSpecificType(criteria, Projections.Max("ProductId"));
/*var productId = (maxId == null)
? Int64.Parse(dateStr + "000001")
: (Int64.Parse(maxId.ToString()) + 1);*/
var maxId = StockDAO.SelectSpecificType(null, Projections.Max("StockId"));
var stockId = maxId == null ? 1 : Int64.Parse(maxId.ToString()) + 1;
data.UpdateDate = DateTime.Now;
data.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
int delFlg = 0;
IDictionary<string, string> maxPrdIdList = new Dictionary<string, string>();
foreach (StockInDetail stockInDetail in data.StockInDetails)
{
// add product
Product product = stockInDetail.Product;
if (string.IsNullOrEmpty(product.ProductId))
{
//product.ProductId = string.Format("{0:000000000000}", productId++);
// find master ID
string masterId = product.ProductMaster.ProductMasterId;
masterId = masterId.Substring(6);
// search in product table to get latest number
string nextPrdId = GetProductIdFromList(maxPrdIdList, masterId);
if (nextPrdId == null)
{
string shortDate = StringUtility.ConvertDateToFourChar(DateTime.Now);
ObjectCriteria prdCrit = new ObjectCriteria();
prdCrit.AddLikeCriteria("ProductId", masterId + shortDate + "%");
var maxIPrdId = ProductDAO.SelectSpecificType(prdCrit, Projections.Max("ProductId"));
string productId = (maxIPrdId == null)
? masterId + shortDate + "01"
: IncreaseMaxProductId(maxIPrdId.ToString());
nextPrdId = productId;
maxPrdIdList[masterId] = nextPrdId;
}
product.ProductId = nextPrdId;
// increase product id and grant to the dictionary
nextPrdId = IncreaseMaxProductId(nextPrdId);
maxPrdIdList[masterId] = nextPrdId;
product.CreateDate = DateTime.Now;
product.UpdateDate = DateTime.Now;
product.Quantity = stockInDetail.Quantity;
product.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
product.CreateId = ClientInfo.getInstance().LoggedUser.Name;
ProductDAO.Add(product);
// add dept stock in
var detailPK = new StockInDetailPK { ProductId = product.ProductId, StockInId = data.StockInId };
stockInDetail.StockInDetailPK = detailPK;
stockInDetail.CreateDate = DateTime.Now;
stockInDetail.UpdateDate = DateTime.Now;
stockInDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
stockInDetail.CreateId = ClientInfo.getInstance().LoggedUser.Name;
stockInDetail.ProductMaster = product.ProductMaster;
StockInDetailDAO.Add(stockInDetail);
if (!ClientSetting.ImportConfirmation)
{
// dept stock
var stock = new Stock
{
StockId = stockId++,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Product = product,
ProductMaster = product.ProductMaster,
Quantity = stockInDetail.Quantity,
GoodQuantity = stockInDetail.Quantity
};
stock.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
stock.CreateId = ClientInfo.getInstance().LoggedUser.Name;
StockDAO.Add(stock);
}
var pricePk = new DepartmentPricePK { DepartmentId = 0, ProductMasterId = product.ProductMaster.ProductMasterId };
var price = DepartmentPriceDAO.FindById(pricePk);
if (price == null)
{
price = new DepartmentPrice { DepartmentPricePK = pricePk, Price = stockInDetail.SellPrice, UpdateDate = DateTime.Now, CreateDate = DateTime.Now };
price.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
price.CreateId = ClientInfo.getInstance().LoggedUser.Name;
DepartmentPriceDAO.Add(price);
}
}
else
{
var temProduct = ProductDAO.FindById(product.ProductId);
if (stockInDetail.DelFlg == 0)
{
temProduct.Quantity = product.Quantity;
temProduct.Price = product.Price;
}
else
{
temProduct.DelFlg = 1;
delFlg++;
}
temProduct.UpdateDate = DateTime.Now;
product.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
ProductDAO.Update(temProduct);
// update dept stock in
var detailPK = new StockInDetailPK { ProductId = product.ProductId, StockInId = data.StockInId };
stockInDetail.StockInDetailPK = detailPK;
stockInDetail.UpdateDate = DateTime.Now;
stockInDetail.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
StockInDetailDAO.Update(stockInDetail);
// if do not need to confirm then update stock
if (data.ConfirmFlg != 1)
{
// update stock
criteria = new ObjectCriteria();
criteria.AddEqCriteria("Product.ProductId", product.ProductId);
criteria.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO);
IList stockList = StockDAO.FindAll(criteria);
if (stockList.Count > 0)
{
Stock stock = (Stock)stockList[0];
stock.UpdateDate = DateTime.Now;
if (stockInDetail.DelFlg == 0)
{
stock.GoodQuantity = stock.GoodQuantity -
(stockInDetail.OldQuantity - stockInDetail.Quantity);
stock.Quantity = stock.ErrorQuantity + stock.GoodQuantity + stock.DamageQuantity +
stock.UnconfirmQuantity + stock.LostQuantity;
}
else
{
stock.DelFlg = 1;
}
stock.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
stock.CreateId = ClientInfo.getInstance().LoggedUser.Name;
StockDAO.Update(stock);
}
else
{
// in case confirmation so stock in has been confirmed to update
if (ClientSetting.ImportConfirmation)
{
// dept stock
var stock = new Stock
{
StockId = stockId++,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
Product = product,
ProductMaster = product.ProductMaster,
Quantity = stockInDetail.Quantity,
GoodQuantity = stockInDetail.Quantity
};
stock.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
stock.CreateId = ClientInfo.getInstance().LoggedUser.Name;
StockDAO.Add(stock);
}
}
}
var pricePk = new DepartmentPricePK { DepartmentId = 0, ProductMasterId = product.ProductMaster.ProductMasterId };
var price = DepartmentPriceDAO.FindById(pricePk);
if (price == null)
{
price = new DepartmentPrice { DepartmentPricePK = pricePk, Price = stockInDetail.SellPrice, UpdateDate = DateTime.Now, CreateDate = DateTime.Now };
price.UpdateId = ClientInfo.getInstance().LoggedUser.Name;
price.CreateId = ClientInfo.getInstance().LoggedUser.Name;
DepartmentPriceDAO.Add(price);
}
}
}
if (delFlg == data.StockInDetails.Count)
{
data.DelFlg = 1;
}
}
public Stock Add(Stock data)
{
StockDAO.Add(data);
return data;
}
public void Update(Stock data)
{
StockDAO.Update(data);
}
private static object[] AddBlockToDataGrid(Stock stock, int rowIndex)
{
var obj = new object[MAX_COLUMN];
obj[PRODUCT_MASTER_ID_POS] = stock.Product.ProductMaster.ProductMasterId;
obj[PRODUCT_MASTER_NAME_POS] = stock.Product.ProductMaster.ProductName;
obj[PRODUCT_QUANTITY_POS] = stock.Quantity;
obj[PRODUCT_SUM_POS] = 0;
obj[MAX_COLUMN - 1] = rowIndex;
return obj;
}
/// <summary>
/// Update Stock to database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public void Update(Stock data)
{
HibernateTemplate.Update(data);
}
private bool HasInList(Stock defect, StockOutDetailCollection list)
{
foreach (StockOutDetail detail in list)
{
if(detail.Product.ProductId == defect.Product.ProductId)
{
return true;
}
}
return false;
}
/// <summary>
/// Add Stock to database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public Stock Add(Stock data)
{
HibernateTemplate.Save(data);
return data;
}
private bool HasInStockList(Stock stock, StockCollection list, out int stockDefIndex)
{
int count = 0;
foreach (Stock stockDefect in list)
{
if(stockDefect.StockId == stock.StockId)
{
stockDefIndex = count;
return true;
}
count += 1;
}
stockDefIndex = count;
return false;
}
private void btnSave_Click(object sender, EventArgs e)
{
// validate data
if (!ValidateData())
{
return;
}
var createdStockList = new List<Stock>();
var createReturnProductList = new List<ReturnProduct>();
var stockInDetailList = new List<StockInDetail>();
for (int i = 0; i < dgvStockInDetail.RowCount; i++)
{
var index = NumberUtility.ParseInt(dgvStockInDetail[MAX_COLUMN - 1, i].Value);
var acceptQty = NumberUtility.ParseLong(dgvStockInDetail[ACCEPT_QUANTITY_POS, i].Value);
var returnQty = NumberUtility.ParseLong(dgvStockInDetail[RETURN_QUANTITY_POS, i].Value);
var stockInDetail = (StockInDetail)StockInDetailList[index];
// approve for product
if (acceptQty != 0)
{
Stock currentStock = null;
if (_currentEventArgs != null && _currentEventArgs.StockList != null)
{
foreach (Stock stock in _currentEventArgs.StockList)
{
if (stock.Product.ProductId == stockInDetail.Product.ProductId)
{
currentStock = stock;
currentStock.Quantity += acceptQty;
break;
}
}
if (currentStock == null)
{
currentStock = new Stock
{
Quantity = acceptQty,
Product = ((StockInDetail)StockInDetailList[index]).Product
};
}
createdStockList.Add(currentStock);
}
}
// return the product
if (returnQty != 0)
{
var returnProduct = new ReturnProduct
{
ProductId = ((StockInDetail)StockInDetailList[index]).Product.ProductId,
Quantity = returnQty
};
createReturnProductList.Add(returnProduct);
}
if (stockInDetail.Quantity == acceptQty + returnQty)
{
stockInDetail.StockInType = (long)StockInDetail.StockInStatus.COMPLETELY_STOCKED;
stockInDetailList.Add(stockInDetail);
}
}
if (createdStockList.Count > 0 || createReturnProductList.Count > 0)
{
var eventArgs = new StockCreateEventArgs { CreateStockList = createdStockList, CreateReturnProductList = createReturnProductList, UpdateStockInDetailList = stockInDetailList };
EventUtility.fireEvent(CreateStockEvent, this, eventArgs);
EventUtility.fireEvent(SearchStockInDetailEvent, this, _currentEventArgs);
StockInDetailList = _currentEventArgs.StockInDetailList;
PopulateDataGrid(_currentEventArgs);
}
}
private void AddStockToList(IList list, Stock stock1)
{
bool found = false;
foreach (Stock stock in list)
{
if(stock.Product.ProductId.Equals(stock1.Product.ProductId))
{
found = true;
break;
}
}
if(!found)
{
list.Add(stock1);
}
}
