public DataTable GetAllProducts()
{
DataAccessLayerCL dal = new DataAccessLayerCL();
DataTable dt = new DataTable();
dt = dal.SelectData("GetAllProducts", null);
dal.Close();
return(dt);
}
public DataTable GetAllCatigories()
{
DataAccessLayerCL dal = new DataAccessLayerCL();
DataTable datatable = new DataTable();
dal.Open();
datatable = dal.SelectData("GetAllCatigories", null);
return(datatable);
}
public void DeleteProduct(string id)
{
DataAccessLayerCL dal = new DataAccessLayerCL();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = id;
dal.Open();
dal.ExecuteCommand("DeleteProduct", param);
dal.Close();
}
public DataTable GetProductImage(string id)
{
DataAccessLayerCL dal = new DataAccessLayerCL();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = id;
DataTable dt = new DataTable();
dt = dal.SelectData("GetProductImage", param);
dal.Close();
return(dt);
}
public DataTable SearchOnDatabase(string words)
{
DataAccessLayerCL dal = new DataAccessLayerCL();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@words", SqlDbType.VarChar, 50);
param[0].Value = words;
DataTable dt = new DataTable();
dt = dal.SelectData("SearchOnDatabase", param);
dal.Close();
return(dt);
}
public DataTable UserLogin(string id,string password)
{
DataAccessLayerCL dal = new DataAccessLayerCL();
SqlParameter[] param = new SqlParameter[2];
param[0] =new SqlParameter("@ID_param", SqlDbType.VarChar,50);
param[0].Value = id;
param[1] = new SqlParameter("@Pass_param", SqlDbType.VarChar,50);
param[1].Value = password;
DataTable datatable = new DataTable();
datatable = dal.SelectData("SP_Login", param);
dal.Close();
return datatable;
}
public bool IsProductExist(string id)
{
DataAccessLayerCL dal = new DataAccessLayerCL();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 30);
param[0].Value = id;
DataTable dt = new DataTable();
dt = dal.SelectData("ProductExist", param);
dal.Close();
if (dt.Rows.Count >= 1)
{
return(true);
}
return(false);
}
public void SaveTheProduct(int CatId, string id, int quantity, string price, byte[] image, string ProductName)
{
DataAccessLayerCL dal = new DataAccessLayerCL();
dal.Open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 30);
param[0].Value = id;
param[1] = new SqlParameter("@ProductName", SqlDbType.VarChar, 30);
param[1].Value = ProductName;
param[2] = new SqlParameter("@Quantity", SqlDbType.Int);
param[2].Value = quantity;
param[3] = new SqlParameter("@Price", SqlDbType.VarChar, 50);
param[3].Value = price;
param[4] = new SqlParameter("@Image", SqlDbType.Image);
param[4].Value = image;
param[5] = new SqlParameter("@Categoty_ID", SqlDbType.Int);
param[5].Value = CatId;
dal.ExecuteCommand("AddProduct", param);
dal.Close();
}
