public int UpdateCategory(Category cate) { _Cateservice = new CategoryService(); if (_Cateservice.Update(cate) == 1) return 1; else return 0; }
public int AddCategory(Category cate) { _Cateservice = new CategoryService(); if (_Cateservice.Add(cate) == 1) return 1; else return 0; }
public Category Get(int id) { Category cate = new Category(); string sqlCommand = "Select * from Categories where CategoryID=" + id; using (IDataReader dataReader = ConnectionClass.GetInstance().ExecuteReader(sqlCommand)) { if (dataReader.Read()) { cate.CategoryID = dataReader.GetInt32(0); cate.CategoryName = dataReader.GetString(1); cate.Description = dataReader.GetString(2); } dataReader.Close(); } return cate; }
public IQueryable<Category> GetAll() { List<Category> lscate = new List<Category>(); string sqlcm = "Select * from Categories"; using (IDataReader dr = ConnectionClass.GetInstance().ExecuteReader(sqlcm)) { while (dr.Read()) { Category cate = new Category(); cate.CategoryID = dr.GetInt32(0); cate.CategoryName = dr.GetString(1); cate.Description = dr.GetString(2); lscate.Add(cate); } dr.Close(); } return lscate.AsQueryable(); }
public int Update(Category cate) { string sqlcm = "update Categories set CategoryName='"+ cate.CategoryName +"',Description='"+ cate.Description +"' where CategoryID=" + cate.CategoryID; return ConnectionClass.GetInstance().ExecuteNonQuery(sqlcm); }
public int Add(Category cate) { string sqlcm = "insert into Categories(CategoryName,Description) values('" + cate.CategoryName +"','" + cate.Description +"')"; //+ cate.Picture == null ? " " : ",Picture=" + cate.Picture + ")"; return ConnectionClass.GetInstance().ExecuteNonQuery(sqlcm); }