private void ListView2_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
textBox29.Clear();
textBox18.Clear();
comboBox2.SelectedIndex = -1;
textBox17.Clear();
textBox15.Clear();
textBox12.Clear();
textBox11.Clear();
textBox29.Text = listView2.SelectedItems[0].SubItems[1].Text;
textBox18.Text = listView2.SelectedItems[0].SubItems[2].Text;
textBox17.Text = listView2.SelectedItems[0].SubItems[4].Text;
textBox15.Text = listView2.SelectedItems[0].SubItems[5].Text;
textBox12.Text = listView2.SelectedItems[0].SubItems[6].Text;
textBox11.Text = listView2.SelectedItems[0].SubItems[7].Text;
Product urun = DalProduct.GetProduct(Convert.ToInt32(textBox29.Text));
comboBox2.SelectedValue = urun.CategoryID;
}
catch (Exception)
{
}
}
internal static PRODUCT FindProductByCode(string codeProduct)
{
using (IDalProduct dal = new DalProduct())
{
return(dal.GetProductByCode(codeProduct));
}
}
internal static List <PRODUCT> FindAllProductByName(string product)
{
using (IDalProduct dal = new DalProduct())
{
return(dal.GetAllProductByName(product));
}
}
internal static object FindProductByName(string product)
{
using (IDalProduct dal = new DalProduct())
{
return(dal.GetProductByName(product));
}
}
internal static string FindCodeProductById(int id)
{
using (IDalProduct dal = new DalProduct())
{
return(dal.GetCodeProductById(id));
}
}
void GuncelleSatilacakListe()
{
try
{
listView5.Items.Clear();
foreach (var product in DalProduct.GetProductModels((int)comboBox3.SelectedValue))
{
if (product.Count > 0)
{
ListViewItem c = new ListViewItem();
c.SubItems.Add(product.ProductID.ToString());
c.SubItems.Add(product.ProductName);
c.SubItems.Add(product.Count.ToString());
c.SubItems.Add(product.SalePrice.ToString());
c.SubItems.Add(product.Description);
listView5.Items.Add(c);
}
}
if (listView5.Items.Count == 0)
{
MessageBox.Show("Bu kategoride gösterilecek ürün yoktur.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
groupBox19.Visible = true;
}
}
catch (Exception)
{
MessageBox.Show("Kategori seçmediniz.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public DtoProduct GetProductByIDTest([PexAssumeUnderTest] DalProduct target, string id)
{
DtoProduct result = target.GetProductByID(id);
return(result);
// TODO: add assertions to method DalProductTest.GetProductByIDTest(DalProduct, String)
}
public List <ProductsPro> ListRetreive(GetProduct request)
{
List <ProductsPro> lstProductsPro = new List <ProductsPro>();
DalProduct objDalProduct = new DalProduct();
lstProductsPro = objDalProduct.SelectProductList(request);
return(lstProductsPro);
}
public ProductsPro Retreive(GetProduct request)
{
var product = new ProductsPro();
var objDalProduct = new DalProduct();
product = objDalProduct.SelectProductDetail(request.Name.ToLower().Replace("-", " "));
return(product);
}
internal static void AddNewTransactionDetail(string codeProduct, string terminal, string transaction, bool minus)
{
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);
dal.CreateDetail(prod, terminalId, transactionId, vatItem);
}
}
}
//public long DeleteData()
//{
// DalProduct dalProduct = new DalProduct();
// long status;
// status = 0;
// try
// {
// status = dalProduct.DeleteProduct(this);
// dalProduct = null;
// }
// catch (Exception ex)
// {
// }
// return status;
//}
//public void SelectData()
//{
// DalProduct dalProduct = new DalProduct();
// IProduct iProduct;
// iProduct = (IProduct)dalProduct.SelectProduct(this);
// //_ShortName = iProduct.ShortName;
// //_Name = iProduct.Name;
// //_Address1 = iProduct.Address1;
// //_Address2 = iProduct.Address2;
// //_Address3 = iProduct.Address3;
// //_Active = iProduct.Active;
// dalProduct = null;
//}
public DataTable SelectAllData()
{
DataTable dtbl = new DataTable();
DalProduct dalProduct = new DalProduct();
dtbl = dalProduct.SelectAllProduct(this);
dalProduct = null;
return(dtbl);
}
internal static IList <TrDetailsViewModel> TranslateDetailList(IList <TrDetailsViewModel> listDetails, int lang)
{
using (IDalProduct dal = new DalProduct())
{
foreach (var item in listDetails)
{
var prod = dal.GetProductByCode(item.ProductCode);
item.ProductName = dal.GetNameProductById(prod.idProduct, lang);
}
return(listDetails);
}
}
public List <OilBaoYangProductPriority> GetOilBaoYangProductSeries()
{
var result = new List <OilBaoYangProductPriority>();
try
{
result = TuhuProductcatalogReadDbScopeManager.Execute(conn => DalProduct.GetOilBaoYangProductSeries(conn)).ToList();
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 雨刷查询逻辑
/// </summary>
/// <param name="category">分类</param>
/// <param name="brakePosition">位置</param>
/// <param name="type">雨刷类型 （非总成）（总成）</param>
/// <returns></returns>
public List <BaoYangProductPriorityModel> GetBaoYangWiperProductSeries(string category, string brakePosition, string type)
{
var result = new List <BaoYangProductPriorityModel>();
try
{
result = TuhuProductcatalogReadDbScopeManager.Execute(conn => DalProduct.GetBaoYangWiperProductSeries(conn, category, brakePosition, type)).ToList();
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
return(result);
}
private void Button15_Click(object sender, EventArgs e)
{
try
{
var urunID = Convert.ToInt32(listView5.SelectedItems[0].SubItems[1].Text);
var satilacakUrun = DalProduct.GetProduct(urunID);
var EmptyArea = EmptyTextBoxControl(groupBox18);
if (EmptyArea)
{
MessageBox.Show("Eksik bilgi girdiniz.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (satilacakUrun.Count >= Convert.ToInt32(textBox26.Text))
{
var newSale = new Sale();
newSale.ProductID = satilacakUrun.ProductID;
newSale.DateSold = DateTime.Now.Date;
newSale.CustomerID = (int)comboBox4.SelectedValue;
newSale.UserID = Form1.LoggedInUser.UserID;
newSale.SoldUnit = Convert.ToInt32(textBox26.Text);
var sorgu = DalSale.CUD(newSale, System.Data.Entity.EntityState.Added);
if (sorgu)
{
satilacakUrun.Count -= Convert.ToInt32(textBox26.Text);
DalProduct.CUD(satilacakUrun, System.Data.Entity.EntityState.Modified);
GuncelleSatilacakListe();
MessageBox.Show("Ürün satıldı.", "İşlem Başarılı", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Satış gerçekleşmedi.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Stoklarda bu kadar ürün yok.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
catch (Exception)
{
}
}
/// <summary>
/// 根据类别查询品牌名称
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public string[] GetProductPrioritySettingsBrand(string category)
{
try
{
return(TuhuProductcatalogReadDbScopeManager.Execute(conn =>
{
return DalProduct.GetProductBrand(conn, category);
}));
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
return(null);
}
private void Button5_Click(object sender, EventArgs e)
{
try
{
var anyEmptyArea = EmptyTextBoxControl(groupBox6);
if (anyEmptyArea)
{
MessageBox.Show("Eksik bilgi girdiniz.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
Product productToUpdate = new Product
{
ProductID = Convert.ToInt32(textBox29.Text),
ProductName = textBox18.Text,
CategoryID = (int)comboBox2.SelectedValue,
PurchasePrice = Convert.ToInt32(textBox17.Text),
SalePrice = Convert.ToInt32(textBox15.Text),
Count = Convert.ToInt32(textBox12.Text),
Description = textBox11.Text,
};
var sorgu = DalProduct.CUD(productToUpdate, System.Data.Entity.EntityState.Modified);
if (sorgu == true)
{
textBox29.Clear();
textBox18.Clear();
comboBox2.SelectedIndex = -1;
textBox17.Clear();
textBox15.Clear();
textBox12.Clear();
textBox11.Clear();
GuncelleUrunler();
MessageBox.Show("Ürün güncellendi.", "İşlem Başarılı", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Ürün güncelleme başarısız.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
catch (Exception)
{
MessageBox.Show("Eksik bilgi girdiniz.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void ListView5_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
groupBox18.Visible = true;
var urunID = Convert.ToInt32(listView5.SelectedItems[0].SubItems[1].Text);
var satilacakUrun = DalProduct.GetProduct(urunID);
textBox25.Text = satilacakUrun.ProductName;
textBox26.Text = satilacakUrun.Count.ToString();
}
catch (Exception)
{
}
}
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));
}
}
public long DeleteData()
{
_UserAction = 3;
DalProduct dalProduct = new DalProduct();
long status;
status = 0;
try
{
status = dalProduct.DeleteProduct(this);
dalProduct = null;
}
catch (Exception ex)
{
}
return(status);
}
public long UpdateData()
{
DalProduct dalProduct = new DalProduct();
long status;
status = 0;
try
{
_UserAction = 2;
status = dalProduct.UpdateProduct(this);
dalProduct = null;
}
catch (Exception ex)
{
}
return(status);
}
private void Button7_Click(object sender, EventArgs e)
{
try
{
var productID = Convert.ToInt32(listView2.SelectedItems[0].SubItems[1].Text);
var sorgu = DalProduct.DeleteProduct(productID);
if (sorgu)
{
GuncelleUrunler();
MessageBox.Show("Ürün silindi.", "İşlem Başarılı", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception)
{
MessageBox.Show("Ürün seçilmedi.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// 根据品牌和类别查询系列产品
/// </summary>
/// <param name="category"></param>
/// <param name="brand"></param>
/// <returns></returns>
public string[] GetProductPrioritySettingsSeries(string category, string brand)
{
try
{
return(TuhuProductcatalogReadDbScopeManager.Execute(conn =>
{
if (category == "Oil")
{
return DalProduct.GetOilProductSeries(conn, category, brand);
}
return DalProduct.GetProductSeries(conn, category, brand);
}));
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
return(null);
}
private void GuncelleUrunler()
{
try
{
listView2.Items.Clear();
foreach (var product in DalProduct.GetProductModels())
{
ListViewItem c = new ListViewItem();
c.SubItems.Add(product.ProductID.ToString());
c.SubItems.Add(product.ProductName);
c.SubItems.Add(product.Category.CategoryName);
c.SubItems.Add(product.PurchasePrice.ToString());
c.SubItems.Add(product.SalePrice.ToString());
c.SubItems.Add(product.Count.ToString());
c.SubItems.Add(product.Description);
listView2.Items.Add(c);
}
}
catch (Exception)
{
}
}
public ProductController()
{
dalCategory = new DalCategory();
dalProduct = new DalProduct();
}
public BllProduct()
{
_dalProduct = new DalProduct();
}
public bool Add(ProductsPro detail)
{
DalProduct objDalProduct = new DalProduct();
return(true);// objDalProduct.AddProduct(detail);
}
