public List <ProductEnt> Search(ProductEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * FROM products WHERE pro_name LIKE @pro_name";
cn.Parameters.Add("pro_name", SqlDbType.VarChar).Value = objTabela.Pro_name + "%";
cn.Connection = con;
SqlDataReader dr;
List <ProductEnt> lista = new List <ProductEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
ProductEnt dado = new ProductEnt();
dado.Pro_id = Convert.ToInt32(dr["pro_id"]);
dado.Pro_name = Convert.ToString(dr["pro_name"]);
dado.Pro_description = Convert.ToString(dr["pro_description"]);
dado.Pro_price = Convert.ToDecimal(dr["pro_price"]);
lista.Add(dado);
}
}
return(lista);
}
}
public Product(ProductEnt product)
{
Id = product.Id;
Name = product.Name;
Weight = product.Weight;
UnitWeight = new UnitWeight(product.UnitWeight);
}
public List <ProductEnt> Lista()
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "SELECT * from products ORDER BY pro_id DESC";
cn.Connection = con;
SqlDataReader dr;
List <ProductEnt> lista = new List <ProductEnt>();
dr = cn.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
ProductEnt dado = new ProductEnt();
dado.Pro_id = Convert.ToInt32(dr["pro_id"]);
dado.Pro_name = Convert.ToString(dr["pro_name"]);
dado.Pro_description = Convert.ToString(dr["pro_description"]);
dado.Pro_price = Convert.ToDecimal(dr["pro_price"]);
lista.Add(dado);
}
}
return(lista);
}
}
/// <summary>
/// Creates an item Product
/// </summary>
/// <param name="productEnt">Convertible item ProductEnt</param>
/// <returns> Product</returns>
public static Product NewProduct(ProductEnt productEnt)
{
Product product = new Product();
product.Id = productEnt.Id;
product.Name = productEnt.Name;
product.Weight = productEnt.Weight;
product.UnitWeight = NewUnitWeight(productEnt.UnitWeight);
product.ShelflifeDate = productEnt.ShelflifeDate;
product.UnitPrice = productEnt.UnitPrice;
product.DeliveryDate = productEnt.DeliveryDate;
return(product);
}
public int Delete(ProductEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "DELETE FROM products WHERE pro_id = @pro_id";
cn.Parameters.Add("pro_id", SqlDbType.Int).Value = objTabela.Pro_id;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
return(qtd);
}
}
public int Insert(ProductEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "INSERT INTO products ([pro_name], [pro_description], [pro_price]) VALUES (@pro_name, @pro_description, @pro_price)";
cn.Parameters.Add("pro_name", SqlDbType.VarChar).Value = objTabela.Pro_name;
cn.Parameters.Add("pro_description", SqlDbType.VarChar).Value = objTabela.Pro_description;
cn.Parameters.Add("pro_price", SqlDbType.Decimal).Value = objTabela.Pro_price;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
return(qtd);
}
}
public int Update(ProductEnt objTabela)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = Properties.Settings.Default.banco;
SqlCommand cn = new SqlCommand();
cn.CommandType = CommandType.Text;
con.Open();
cn.CommandText = "UPDATE products SET pro_name = @pro_name, pro_description = @pro_description, pro_price = @pro_price WHERE pro_id = @pro_id";
cn.Parameters.Add("pro_name", SqlDbType.VarChar).Value = objTabela.Pro_name;
cn.Parameters.Add("pro_description", SqlDbType.VarChar).Value = objTabela.Pro_description;
cn.Parameters.Add("pro_price", SqlDbType.Decimal).Value = objTabela.Pro_price;
cn.Parameters.Add("pro_id", SqlDbType.Int).Value = objTabela.Pro_id;
cn.Connection = con;
int qtd = cn.ExecuteNonQuery();
return(qtd);
}
}
/// <summary>
/// Конвертация в продукт
/// </summary>
/// <param name="client">Продукт БД</param>
/// <returns>Продукт</returns>
public static Product Convert(ProductEnt product, bool logic = true)
{
if (product != null)
{
SalesInvoice sales = null;
InvoiceForPurchase invoiceForPurchase = null;
Category category = null;
if (logic == true)
{
//sales = Convert(product.SalesInvoice, false);
category = Convert(product.Category, false);
invoiceForPurchase = Convert(product.InvoiceForPurchase, false);
}
Product productEnt = new Product
{
Description = product.Description,
//SalesInvoice = sales,
//SalesInvoiceId=product.SalesInvoiceId,
InvoiceForPurchase = invoiceForPurchase,
Commit = product.Commit,
InvoiceForPurchaseId = product.InvoiceForPurchaseId,
CategoryId = product.CategoryId,
CostPrice = product.CostPrice,
DateOfPurchase = product.DateOfPurchase,
DateOfSale = product.DateOfSale,
Id = product.Id,
Name = product.Name,
Archiving = product.Archiving,
Category = category, /*new { Name = product.Category.Name },*/
Price = product.Price,
Status = product.Status
};
return(productEnt);
}
else
{
return(null);
}
}
/// <summary>
/// Конвертация в продукт БД
/// </summary>
/// <param name="client">Продукт</param>
/// <returns>Продукт БД</returns>
public static ProductEnt Convert(Product product)
{
if (product != null)
{
var x = Unit.ProductRepository.GetItem(product.Id);
if (x != null)
{
return(x);
}
else
{
ProductEnt productEnt = new ProductEnt
{
Description = product.Description,
//SalesInvoice = Convert(product.SalesInvoice),
//SalesInvoiceId = product.SalesInvoiceId,
InvoiceForPurchase = Convert(product.InvoiceForPurchase),
Commit = product.Commit,
CostPrice = product.CostPrice,
DateOfPurchase = product.DateOfPurchase,
DateOfSale = product.DateOfSale,
Id = product.Id,
CategoryId = product.CategoryId,
InvoiceForPurchaseId = product.InvoiceForPurchaseId,
Name = product.Name,
Price = product.Price,
Category = Convert(product.Category),
Archiving = product.Archiving,
Status = product.Status
};
return(productEnt);
}
}
else
{
return(null);
}
}
public List <ProductEnt> Search(ProductEnt objTabela)
{
return(new ProductDAO().Search(objTabela));
}
public static int Update(ProductEnt objTabela)
{
return(new ProductDAO().Update(objTabela));
}
public static int Delete(ProductEnt objTabela)
{
return(new ProductDAO().Delete(objTabela));
}
public static int Insert(ProductEnt objTabela)
{
return(new ProductDAO().Insert(objTabela));
}
void AddProduct(string name, decimal weight, UnitWeight unitWeight)
{
ProductEnt product = new ProductEnt(name, weight, new UnitWeightEnt(unitWeight.Units));
Unit.ProductsRepository.AddItem(product);
}
/// <summary>
/// Creates an item ProductEnt
/// </summary>
/// <param name="product">Convertible item Product</param>
/// <returns> ProductEnt</returns>
public static ProductEnt NewProductEnt(Product product)
{
ProductEnt productEnt = new ProductEnt(product.Name, product.Weight, NewUnitWeightEnt(product.UnitWeight), product.ShelflifeDate, product.UnitPrice);
return(productEnt);
}
void AddPurchasedProducts(ProductEnt product, decimal price)
{
PurchasedProductEnt purchasedProduct = new PurchasedProductEnt(product, price);
Unit.PurchaserProdutsRepository.AddItem(purchasedProduct);
}
