public void FillRentAvailable(DateTime From, DateTime To)
{
DataTable dataTable = Product_DAL.GetDataTable();
DataRow dataRow;
Product product;
OrderRentArr orderRentArr = new OrderRentArr();
orderRentArr.Fill();
// orderRentArr = orderRentArr.FilterNoReturned();
orderRentArr = orderRentArr.Filter(From, To);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
dataRow = dataTable.Rows[i];
product = new Product(dataRow);
if (
(product.Status == "Rent") &&
(!orderRentArr.DoesExist(product))
)
{
this.Add(product);
}
}
}
public void FillBuyAvailable()
{
DataTable dataTable = Product_DAL.GetDataTable();
//להעביר את הערכים מהטבלה לתוך אוסף הלקוחות
//להעביר כל שורה בטבלה ללקוח
DataRow dataRow;
Product product;
for (int i = 0; i < dataTable.Rows.Count; i++)
{
dataRow = dataTable.Rows[i];
product = new Product(dataRow);
if (
(product.Status == "Buy") &&
(product.Doesavailable == "")
)
{
this.Add(product);
}
}
}
public Product_BAL()
{
Product = new Product_DAL();
product_Image_Bal = new ProductImage_BAL();
ProductImage = new ProductImage_DAL();
}
public int?GetId(Product_DAL product)
{
var temp = context.Products.FirstOrDefault(p => (p.Name == product.Name));
if (temp == null)
{
return(null);
}
else
{
return(temp.Id);
}
}
public bool DeleteRecord(int iId)
{
bool objReturn = false;
try
{
using (Product_DAL objDAL = new Product_DAL())
{
objReturn = objDAL.DeleteRecord(iId);
}
}
catch (Exception ex)
{
log.Error("DeleteRecord Error: ", ex);
}
return(objReturn);
}
public ProductPage GetRecordPage(int iPageNo, int iPageSize)
{
ProductPage objReturn = new ProductPage();
try
{
using (Product_DAL objDAL = new Product_DAL())
{
objReturn = objDAL.GetRecordPage(iPageNo, iPageSize);
}
}
catch (Exception ex)
{
log.Error("GetRecordPage Error: ", ex);
}
return(objReturn);
}
public Product GetRecordById(Guid iId)
{
Product objReturn = null;
try
{
using (Product_DAL objDAL = new Product_DAL())
{
objReturn = objDAL.GetRecordById(iId);
}
}
catch (Exception ex)
{
log.Error("GetRecordById Error: ", ex);
}
return(objReturn);
}
public Guid InsertUpdateRecord(Product objProduct)
{
Guid objReturn = new Guid();
try
{
using (Product_DAL objDAL = new Product_DAL())
{
objReturn = objDAL.InsertUpdateRecord(objProduct);
}
}
catch (Exception ex)
{
log.Error("InsertUpdateRecord Error: ", ex);
}
return(objReturn);
}
public List <Product> GetAllRecord()
{
List <Product> objReturn = null;
try
{
using (Product_DAL objDAL = new Product_DAL())
{
objReturn = objDAL.GetAllRecord();
}
}
catch (Exception ex)
{
log.Error("GetAllRecord Error: ", ex);
}
return(objReturn);
}
public Product Validate(string email, string password)
{
Product objReturn = null;
try
{
using (Product_DAL objDAL = new Product_DAL())
{
objReturn = objDAL.Validate(email, password);
}
}
catch (Exception ex)
{
log.Error("Validate Error: ", ex);
}
return(objReturn);
}
public void Fill()
{
//להביא מה-DAL טבלה מלאה בכל הלקוחות
DataTable dataTable = Product_DAL.GetDataTable();
//להעביר את הערכים מהטבלה לתוך אוסף הלקוחות
//להעביר כל שורה בטבלה ללקוח
DataRow dataRow;
Product product;
for (int i = 0; i < dataTable.Rows.Count; i++)
{
dataRow = dataTable.Rows[i];
product = new Product(dataRow);
this.Add(product);
}
}
public void FillRentAvailable()
{
DataTable dataTable = Product_DAL.GetDataTable();
//להעביר את הערכים מהטבלה לתוך אוסף הלקוחות
//להעביר כל שורה בטבלה ללקוח
DataRow dataRow;
Product product;
OrderRent orderRent;
OrderRentArr orderRentArr = new OrderRentArr();
orderRentArr.Fill();
// orderRentArr = orderRentArr.FilterNoReturned();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
dataRow = dataTable.Rows[i];
product = new Product(dataRow);
for (int j = 0; j < orderRentArr.Count; j++)
{
orderRent = orderRentArr[j] as OrderRent;
if (
(product.Status == "Rent") &&
(orderRent.Product.Id != product.Id) &&
(orderRent.Product.Doesavailable == "InRent")
)
{
this.Add(product);
}
}
}
}
public string GenerateProductCode(LP_GenerateTransNumber_Property objtransno)
{
string TransactionNumber = "";
objProduct_DAL = new Product_DAL();
DataTable dt = objProduct_DAL.GenerateProductCode(objtransno);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
TransactionNumber = dr["TransNumber"].ToString();
TransactionNumber = "P-00" + TransactionNumber + "-" + objtransno.userid;
}
return(TransactionNumber);
}
else
{
TransactionNumber = "P-001-" + objtransno.userid;
return(TransactionNumber);
}
//return _objMRNDAL.GenerateMRNNo(objtransno);
}
public static bool SuaSPCH(Product_DTO sanpham)
{
return(Product_DAL.SuaSanPhamCH(sanpham));
}
public static List <Product_DTO> LoadProduct()
{
return(Product_DAL.LoadProduct());
}
public Product_BUS()
{
temp = new Product_DAL();
}
public FrontEndBAL()
{
Product_DAL = new Product_DAL();
frontEnd_DAL = new FrontEnd_DAL();
}
public DataTable ddlSubCategory()
{
objProduct_DAL = new Product_DAL(objProductProperty);
return(objProduct_DAL.ddlSubCategory());
}
public DataTable GetById(int?id)
{
objProduct_DAL = new Product_DAL(objProductProperty);
return(objProduct_DAL.SelectById(id));
}
public void Update(Product_DAL item)
{
var product = context.Products.FirstOrDefault(p => (p.Id == item.Id));
product.Name = item.Name;
}
public bool Insert()
{
objProduct_DAL = new Product_DAL(objProductProperty);
return(objProduct_DAL.Insert());
}
public void Add(Product_DAL product)
{
context.Products.Add(ToEntity(product));
}
public static bool XoaSPCH(Product_DTO sanpham)
{
return(Product_DAL.XoaSPCH(sanpham));
}
public DataTable ddlUnit()
{
objProduct_DAL = new Product_DAL(objProductProperty);
return(objProduct_DAL.ddlUnit());
}
public bool Delete(int?id)
{
objProduct_DAL = new Product_DAL(objProductProperty);
return(objProduct_DAL.Delete(id));
}
public DataTable ViewAll()
{
objProduct_DAL = new Product_DAL(objProductProperty);
return(objProduct_DAL.SelectAll());
}
public bool Update()
{
objProduct_DAL = new Product_DAL(objProductProperty);
return(objProduct_DAL.Update());
}
