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(); }