public List <CategoryDE> selectAll()
{
String connectstring = ConfigurationManager.ConnectionStrings["MyDataDB"].ConnectionString;
List <CategoryDE> categorylist = new List <CategoryDE>();
CategoryDE categoryResult = new CategoryDE();
SqlConnection connection = new SqlConnection(connectstring);
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = "select * from Category";
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable table = new DataTable();
adapter.Fill(table);
foreach (DataRow row in table.Rows)
{
CategoryDE category = new CategoryDE()
{
CategoryId = Convert.ToInt32(row["CategoryId"]),
CategoryName = Convert.ToString(row["CategoryName"]),
};
categorylist.Add(category);
}
connection.Close();
return(categorylist);
}
//public CategoryDE Insert(CategoryDE category)
//{
// dataAcess.Open();
// dataAcess.BeginTran();
// QueryParameter[] list = new QueryParameter[2];
// list[0] = new QueryParameter("CategoryId", category.CategoryId, DbType.Int32);
// list[1] = new QueryParameter("CategoryName", category.CategoryName, DbType.String);
// string sql = "insert into Category values(@CategoryName)";
// dataAcess.ExecuteNonQuery(sql, list);
// dataAcess.CommitTran();
// dataAcess.Close();
// return category;
//}
//public bool Update(CategoryDE category)
//{
// return true;
//}
//public bool Delete(int id)
//{
// return true;
//}
public CategoryDE GetById(int id)
{
String connectstring = ConfigurationManager.ConnectionStrings["MyDataDB"].ConnectionString;
List <CategoryDE> categoryList = new List <CategoryDE>();
CategoryDE categoryResult = new CategoryDE();
if (id >= 0)
{
SqlConnection connection = new SqlConnection(connectstring);
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = "select * from Category where CategoryId = @id";
command.Parameters.AddWithValue("id", id);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable table = new DataTable();
adapter.Fill(table);
foreach (DataRow row in table.Rows)
{
CategoryDE category = new CategoryDE()
{
CategoryName = Convert.ToString(row["CategoryName"]),
CategoryId = Convert.ToInt32(row["CategoryId"])
};
categoryList.Add(category);
categoryResult = categoryList.First();
}
connection.Close();
}
return(categoryResult);
}
public async Task UpdateCategory([FromBody] CategoryModel category)
{
CategoryDE categoryDE = new CategoryDE();
await categoryDE.AddOrEdit(category);
}
public async Task <IEnumerable <CategoryModel> > GetCategories(int categoryID = 0)
{
CategoryDE categoryDE = new CategoryDE();
return(await categoryDE.GetCategories(categoryID));
}
