public static void SaveInventoryDay(VehicleDataContext dc, string itemCode, DateTime actionTime, int quantity, int actionType, string dealerCode, string branchCode)
{
long actionDay = long.Parse(actionTime.ToString("yyyyMMdd"));
var inv = dc.SaleInventoryDays.SingleOrDefault(iv => iv.ItemCode == itemCode &&
iv.ActionDay == actionDay &&
iv.ActionType== actionType &&
iv.BranchCode == branchCode &&
iv.DealerCode == dealerCode);
if (inv == null)
{
inv = new SaleInventoryDay
{
ActionDay = actionDay,
ActionType = actionType,
BranchCode = branchCode,
DealerCode = dealerCode,
ItemCode = itemCode,
Quantity = 0,
};
dc.SaleInventoryDays.InsertOnSubmit(inv);
}
inv.Quantity += quantity;
}
/// <summary>
/// Save to inventory actions of day for each item code
/// If data for item in same day exist, quantity will be update
/// </summary>
/// <param name="ItemCode"></param>
/// <param name="ActionTime"></param>
/// <param name="Quantity"></param>
/// <param name="ActionType"></param>
/// <param name="DealerCode"></param>
/// <param name="BranchCode"></param>
/// <returns></returns>
public static SaleInventoryDay SaveInventoryDay(VehicleDataContext db, string ItemCode, DateTime ActionTime, int Quantity, int ActionType, string DealerCode, string BranchCode)
{
//var daoItem = DaoFactory.GetDao<VDMS.Core.Domain.Item, string>();
//var item = daoItem.GetById(ItemCode, false); //true -> false
//var daoInven = DaoFactory.GetDao<Inventoryday, long>();
long ActionDay = long.Parse(ActionTime.ToString("yyyyMMdd"));
//daoInven.SetCriteria(new ICriterion[] { Expression.Eq("Item", item), Expression.Eq("Actionday", ActionDay)
// , Expression.Eq("Actiontype", ActionType), Expression.Eq("Dealercode", DealerCode), Expression.Eq("Branchcode", BranchCode)});
//var list = daoInven.GetAll();
var ivd =
db.SaleInventoryDays.FirstOrDefault(
p =>
p.ItemCode == ItemCode && p.ActionDay == ActionDay && p.ActionType == ActionType &&
p.DealerCode == DealerCode && p.BranchCode == BranchCode);
if (ivd == null)
{
ivd = new SaleInventoryDay();
ivd.ItemCode = ItemCode;
ivd.ActionDay = ActionDay;
ivd.ActionType = ActionType;
ivd.DealerCode = DealerCode;
ivd.BranchCode = BranchCode;
ivd.Quantity = 0;
db.SaleInventoryDays.InsertOnSubmit(ivd);
}
ivd.Quantity += Quantity;
return ivd;
}
private void detach_SaleInventoryDays(SaleInventoryDay entity)
{
this.SendPropertyChanging("SaleInventoryDays");
entity.Item = null;
}
