public async Task <UnitPrices> GetUnitPriceBySizeId(int SizeId)
{
var model = new UnitPrices();
model.UnitPriceBySize = await unitPriceRepository.GetUnitPriceBySizeId(SizeId);
var size = await sizeRepository.Get(SizeId);
model.SizeName = size.SizeName;
return(model);
}
public List <UnitPrices> GetUnitPrice(string idProcduct, string text)
{
List <UnitPrices> listproduct = new List <UnitPrices>();
DataTable data = DataProvider.Instance.ExcuteQuery("EXEC GetUnitPrice @text , @idProduct ", new object[] { text, idProcduct });
foreach (DataRow item in data.Rows)
{
UnitPrices list = new UnitPrices(item);
listproduct.Add(list);
}
return(listproduct);
}
private void cbUnitName_SelectedIndexChanged(object sender, EventArgs e)
{
UnitPrices unit = Product_DAO.Instance.GetUnitPriceWhenCreateInvoice(Convert.ToInt32(cbUnitName.SelectedValue));
lbUnitPrice.Text = unit.Unitprice.ToString("C0", culture);
unitPrice = unit.Unitprice;
exchangeValue = unit.ExchangeValue;
tbQuantity.Text = "1";
UpdateItemWhenEdit();
UpdateTotalAmount();
}
public int TotalPriceCalculator(List <Product> productList)
{
var prods = productList;
var unitPrice = new UnitPrices();
var promotion = new PromotionList();
var promoFactor = new PromotionFactor();
int totalPrice = 0;
int currentPrice = 0;
int newCurrentPrice = 0;
int currentPriceForC = 0;
int currentPriceForD = 0;
foreach (Product prod in prods)
{
if (prod.ProductId == ProductEnum.A)
{
currentPrice = (prod.ProductQuantity / (promoFactor.Factors((int)prod.ProductId)))
* promotion.Promotionfor3A
+ (prod.ProductQuantity % 3) * unitPrice.UnitPriceforA;
}
else if (prod.ProductId == ProductEnum.B)
{
currentPrice = (prod.ProductQuantity / (promoFactor.Factors((int)prod.ProductId))) * promotion.Promotionfor2B
+ (prod.ProductQuantity % 2) * unitPrice.UnitPriceforB;
}
else if (prod.ProductId == ProductEnum.C)
{
currentPrice = prod.ProductQuantity * unitPrice.UnitPriceforC;
currentPriceForC = currentPrice;
}
else if (prod.ProductId == ProductEnum.D)
{
currentPrice = prod.ProductQuantity * unitPrice.UnitPriceforD;
currentPriceForD = currentPrice;
}
newCurrentPrice += currentPrice;
}
if (currentPriceForC == unitPrice.UnitPriceforC && currentPriceForD == unitPrice.UnitPriceforD)
{
newCurrentPrice = (newCurrentPrice - (currentPriceForC + currentPriceForD));
newCurrentPrice += promotion.PromotionforCnD;
}
totalPrice += newCurrentPrice;
return(totalPrice);
}
public ActionResult Save(UnitPrices unitPrice)
{
if (unitPrice.Id == 0)
{
_context.UnitPrice.Add(unitPrice);
}
else
{
var unitPriceInDb = _context.UnitPrice.Single(u => u.Id == unitPrice.Id);
unitPriceInDb.RoomPrice = unitPrice.RoomPrice;
unitPriceInDb.DiscountFromDay = unitPrice.DiscountFromDay;
unitPriceInDb.Discount = unitPrice.Discount;
unitPriceInDb.ExtraBedPrice = unitPrice.ExtraBedPrice;
unitPriceInDb.TouristTaxPrice = unitPrice.TouristTaxPrice;
}
_context.SaveChanges();
return(RedirectToAction("Index", "UnitPrices"));
}
public ActionResult New()
{
UnitPrices unitPrice = new UnitPrices();
return(View(unitPrice));
}
