public static List <COMCategory> GetCategories()
{
//using (DBEntities context = new DBEntities())
//{
// return MAPPER.ConvertListDALcategoryToListCOMcategory(context.Categories_tbl.ToList());
//}
using (var connection = new MySqlConnection(csb.ConnectionString))
{
List <COMCategory> list = new List <COMCategory>();
connection.Open();
MySqlCommand select_all_categories = new MySqlCommand("SELECT * FROM Categories_tbl", connection);
using (var reader = select_all_categories.ExecuteReader())
{
while (reader.Read())
{
//TODO: put the right syntax here
COMCategory category = new COMCategory()
{
CategoryId = Convert.ToInt32(reader["categoryId"]),
CategoryName = Convert.ToString(reader["categoryName"]),
ImageURL = Convert.ToString(reader["imageURL"])
};
list.Add(category);
}
}
return(list);
//return (List<COMCategory>)select_all_categories.ExecuteScalar();
}
}
public IHttpActionResult GetCategoryById(int id)
{
COMCategory cat = BLLcategory.GetCategoryById(id);
if (cat == null)
{
return(BadRequest("category does not exist"));
}
return(Ok(cat));
}
public IHttpActionResult PostCategory([FromBody] COMCategory com)
{
COMCategory c = BLLcategory.GetCategoryById(com.CategoryId);
if (c != null)
{
return(BadRequest("category already exist"));
}
BLLcategory.AddCategory(com, Form1.categoriesCounter);
return(Ok());
}
public static void AddCategory(COMCategory cat)
{
//using (DBEntities context = new DBEntities())
//{
// context.Categories_tbl.Add(MAPPER.ConvertCOMcategoryToDALcategory(cat));
// context.SaveChanges();
//}
using (var connection = new MySqlConnection(csb.ConnectionString))
{
Int64 categoryId = nextCategoryId();
connection.Open();
MySqlCommand insert_table = new MySqlCommand("INSERT INTO Categories_tbl (categoryName, imageURL, categoryId) values (@categoryName, @imageURL, @categoryId);", connection);
insert_table.Parameters.AddWithValue("categoryId", categoryId);
insert_table.Parameters.AddWithValue("categoryName", cat.CategoryName);
insert_table.Parameters.AddWithValue("imageURL", cat.ImageURL);
insert_table.ExecuteNonQuery();
connection.Close();
}
}
private void button6_Click(object sender, EventArgs e)
{
COMCategory cat = new COMCategory();
cat.CategoryName = textBox6.Text;
cat.ImageURL = path;
BLLcategory.AddCategory(cat, categoriesCounter);
int catId = BLLcategory.GetCategoryIdByCategoryName(cat.CategoryName);
try
{
BLLcategory.UpdateURL(catId, BLLgoogleVision.Storage(catId, cat.ImageURL, categoriesCounter, true));
}
catch (Exception)
{
throw;
}
groupBox2.Visible = false;
textBox6.Text = string.Empty;
}
public static COMCategory GetCategoryById(int id)
{
//using (DBEntities context = new DBEntities())
//{
// return MAPPER.ConvertDALcategoryToCOMcategory(context.Categories_tbl.FirstOrDefault(cat=>cat.CategoryID==id));
//}
using (var connection = new MySqlConnection(csb.ConnectionString))
{
COMCategory c = new COMCategory();
connection.Open();
MySqlCommand get_category_by_id = new MySqlCommand("SELECT * FROM Categories_tbl WHERE categoryId=@catId;", connection);
get_category_by_id.Parameters.AddWithValue("catId", id);
using (var reader = get_category_by_id.ExecuteReader())
{
if (reader.Read())
{
c.CategoryId = Convert.ToInt32(reader["categoryId"]);
c.CategoryName = Convert.ToString(reader["categoryName"]);
c.ImageURL = Convert.ToString(reader["imageURL"]);
}
}
return(c);
}
}
public static void AddCategory(COMCategory cat, Dictionary <string, int> categoriesCounter)
{
DALcategory.AddCategory(cat);
}
