internal static IList <SPP_ParentCategoriesTransDistinct_Result> FindCatsParentList(string language)
{
using (IDalSearch dal = new DalSearch())
{
int lang = LanguageBL.FindIdLanguageByShortForm(language);
return(dal.GetAllCats(lang));
}
}
internal static IList <SPP_ProductTrans_Result> FindProductListByIdCat(string argument, string language)
{
using (IDalSearch dal = new DalSearch())
{
int id = int.Parse(argument);
int lang = LanguageBL.FindIdLanguageByShortForm(language);
return(dal.GetAllProductByIdCat(id, lang));
}
}
internal static IList <SPP_ChildCategoriesOfParent_Result> FindCatsChildList(string argument, string language)
{
using (IDalSearch dal = new DalSearch())
{
int id = int.Parse(argument);
int lang = LanguageBL.FindIdLanguageByShortForm(language);
return(dal.GetAllCats(id, lang));
}
}
internal static IList <SPP_ProductTrans_Result> FindAllProduct(string language)
{
using (IDalProduct dal = new DalProduct())
{
int lang;
if (int.TryParse(language, out int codeL))
{
lang = codeL;
}
else
{
lang = LanguageBL.FindIdLanguageByShortForm(language);
}
return(dal.GetAllProduct(lang));
}
}
internal static TrTicketViewModel FillTicket(string numTransaction, string language, bool?isChange)
{
using (IDalTransaction dal = new DalTransaction())
{
//find transac
var transac = TransactionBL.FindTransactionById(numTransaction);
//create ticket
TrTicketViewModel vm = new TrTicketViewModel();
int lang;
if (int.TryParse(language, out int codeL))
{
lang = codeL;
}
else
{
lang = LanguageBL.FindIdLanguageByShortForm(language);
}
vm.Language = lang.ToString();
//if rprint search dateTicket
DateTime d = new DateTime(2000, 1, 1, 0, 0, 0);
int dCompare = DateTime.Compare(transac.transactionDateEnd, d);
if (dCompare == 0)
{
vm.DateTicket = (DateTime.Now).ToString();
}
else
{
vm.DateTicket = transac.transactionDateEnd.ToString();
}
//n° transac
vm.Transaction = numTransaction;
//shop informations
vm.Shop = ShopBL.FindShopById(transac.shopId, lang);
//detail transaction
var listDetails = TransactionBL.ListDetailsWithTot(numTransaction);
vm.DetailsListWithTot = TranslationBL.TranslateDetailList(listDetails, lang);
//discount or not
if (transac.discountGlobal == null)
{
vm.DiscountG = " - ";
}
else
{
var temp = (transac.discountGlobal * 100).ToString();
var tempsplit = temp.Split(',');
var discount = tempsplit[0] + "%";
vm.DiscountG = discount;
}
////VAT
//to do --> provisoire vatId = 2 --> 21%
int tva = 2;
vm.VatG = VatBL.FindVatValById(tva);
//Total transaction
vm.TotalG = (transac.total).ToString();
//payment method & amount
vm.Payments = PaymentBL.FindPaymentsByTransacId(numTransaction);
////message
var messages = FindTicketMessageById(transac.idTransaction, lang, isChange);
vm.Messages = messages;
return(vm);
}
}
internal static void AddNewTransactionDetail(string codeProduct, string terminal, string transaction, bool minus, string language)
{
using (IDalTransaction dal = new DalTransaction())
{
//find productId with codeProduct
PRODUCT prod;
using (IDalProduct dalP = new DalProduct())
{
prod = dalP.GetProductByCode(codeProduct);
}
//verify if product exist in detail and Add or Remove itemDetail
IList <TRANSACTION_DETAILS> detailList = FindTransactionDetailsListById(transaction);
var result = VerifyProductInDetail(prod.idProduct, detailList);
if (result)
{
//Product exist --> Modify qty
foreach (var item in detailList)
{
if (item.productId == prod.idProduct)
{
var newqty = 0;
if (minus)
{
//qty--
newqty = item.quantity - 1;
if (newqty == 0)
{
dal.DeleteDetail(item.idTransactionDetails);
break;
}
dal.EditQtyToDetailById(item.idTransactionDetails, newqty);
break;
}
else
{
//qty++
newqty = item.quantity + 1;
dal.EditQtyToDetailById(item.idTransactionDetails, newqty);
break;
}
}
}
}
else
{
////Add new detail --> param product, terminalId, transactionId, vatItem
decimal vatItem;
using (IDalVat dalV = new DalVat())
{
vatItem = dalV.GetVatValById(prod.vatId);
}
int terminalId = int.Parse(terminal);
int transactionId = int.Parse(transaction);
int languageId = LanguageBL.FindIdLanguageByShortForm(language);
string name;
using (IDalProduct dalP = new DalProduct())
{
name = dalP.GetNameProductById(prod.idProduct, languageId);
}
dal.CreateDetail(prod, terminalId, transactionId, vatItem, name);
}
}
}
