public SaleListViewModel GetCurrentSaleList()
{
SaleListViewModel currentSaleList = null;
var sales = salesDBDao.GetOnGoingSaleList();
if (sales.Rows.Count == 0)
{
currentSaleList = new SaleListViewModel()
{
SheetID = Guid.NewGuid(),
Change = 0,
PayValue = 0,
SaleValue = 0,
DiscValue = 0,
//TO DO: update to login user
CashierID = "Tester",
ShopID = "A001"
};
salesDBDao.NewSaleList(
currentSaleList.SheetID.ToString(),
currentSaleList.CashierID,
currentSaleList.ShopID,
currentSaleList.PayValue,
currentSaleList.SaleValue,
currentSaleList.DiscValue);
}
else
{
currentSaleList = SaleListDTConverter.GetModel(sales).First();
}
return(currentSaleList);
}
public JsonResult GetSale()
{
SaleService os = new SaleService();
SaleListViewModel result = os.GetAllSale();
var datas = new { result.data };
return(Json(datas, JsonRequestBehavior.AllowGet));
}
public SaleListViewModel GetAllSale()
{
SaleListViewModel result = new SaleListViewModel();
result.data = new List <SaleViewModel>();
DBModel context = new DBModel();
DbRepository <Sale> repo = new DbRepository <Sale>(context);
foreach (var item in repo.GetAll().OrderBy((x) => x.Sale_Product))
{
SaleViewModel s = new SaleViewModel()
{
Sale_ID = item.Sale_ID,
Sale_Product = item.Sale_Product,
Sale_UnPrice = item.Sale_UnPrice,
Sale_FristDate = item.Sale_FristDate,
Sale_LastDate = item.Sale_LastDate
};
result.data.Add(s);
}
return(result);
}
public static List <SaleListViewModel> GetModel(DataTable dtData)
{
var items = new List <SaleListViewModel>();
foreach (DataRow row in dtData.Rows)
{
Guid sheetid;
Guid.TryParse(Convert.ToString(row["SheetID"]), out sheetid);
var item = new SaleListViewModel
{
SheetID = sheetid,
CashierID = Convert.ToString(row["CashierID"]),
PayValue = Convert.ToDecimal(row["PayValue"]),
SaleValue = Convert.ToDecimal(row["SaleValue"]),
DiscValue = Convert.ToDecimal(row["DiscValue"]),
Change = Convert.ToDecimal(row["PayValue"]) - (Convert.ToDecimal(row["SaleValue"]) - Convert.ToDecimal(row["DiscValue"]))
};
items.Add(item);
}
return(items);
}
public SaleListItemViewModel AddGoods(int goodsID, SaleListViewModel saleList, ObservableCollection <SaleListItemViewModel> salelistItems)
{
var goods = localDBDao.GetGoods(goodsID);
int newSeqID = 1;
if (salelistItems.Count > 0)
{
newSeqID = salelistItems.Max(x => x.SeqID) + 1;
}
var newItem = new SaleListItemViewModel
{
SheetID = saleList.SheetID,
SeqID = newSeqID,
GoodsID = goodsID,
GoodsName = goods.Rows[0]["shortname"].ToString(),
BarcodeID = goods.Rows[0]["barcodeid"].ToString(),
Quantity = 1,
SalePrice = Convert.ToDecimal(goods.Rows[0]["Price"]),
SaleValue = Convert.ToDecimal(goods.Rows[0]["Price"]) * 1,
Cost = Convert.ToDecimal(goods.Rows[0]["cost"])
};
salelistItems.Add(newItem);
this.UpdateSalesData(saleList, salelistItems);
salesDBDao.AddSaleListItem(newItem.SheetID.ToString(),
newItem.SeqID,
newItem.GoodsID,
newItem.GoodsName,
newItem.BarcodeID,
newItem.Quantity,
newItem.Cost,
newItem.SalePrice,
newItem.SaleValue,
newItem.DiscValue);
return(newItem);
}
public void DeleteSalelistItems(string sheetID, List <SaleListItemViewModel> deleteItems, SaleListViewModel saleList, ObservableCollection <SaleListItemViewModel> salelistItems)
{
List <int> seqs = new List <int>();
foreach (var deleteItem in deleteItems)
{
seqs.Add(deleteItem.SeqID);
salelistItems.Remove(deleteItem);
}
this.salesDBDao.DeleteSalelistItems(sheetID, seqs);
this.UpdateSalesData(saleList, salelistItems);
}
public void CalcTotalValue(SaleListViewModel saleList, ObservableCollection <SaleListItemViewModel> salelistItems)
{
//TO DO: Process sales promotion
saleList.SaleValue = salelistItems.Sum(x => x.SaleValue);
saleList.DiscValue = salelistItems.Sum(x => x.DiscValue);
}
public void UpdateSalesData(SaleListViewModel saleList, ObservableCollection <SaleListItemViewModel> salelistItems)
{
this.CalcTotalValue(saleList, salelistItems);
saleList.Change = saleList.PayValue - saleList.SaleValue + saleList.DiscValue;
this.salesDBDao.UpdateSaleList(saleList.SheetID.ToString(), saleList.PayValue, saleList.SaleValue, saleList.DiscValue);
}
