public static List <Product> GetAllProduct()
{
DatabaseClass databaseClass = new DatabaseClass();
var sql = "select * from Products;";
databaseClass.Query(sql);
List <Product> productList = new List <Product>();
databaseClass.sqlConnection.Open();
using (databaseClass.sqlConnection)
{
SqlDataReader dr = databaseClass.sqlCommand.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Product obj = new Product();
obj.ID = Convert.ToInt32(dr[0]);
obj.ProductName = Convert.ToString(dr[1]);
obj.ProductPrice = Convert.ToInt32(dr[2]);
obj.ProductDetails = Convert.ToString(dr[3]);
productList.Add(obj);
}
productList.TrimExcess();
}
return(productList);
}
}
public static List <Product> GetById(int id)
{
DatabaseClass databaseClass = new DatabaseClass();
var sql = "SELECT * FROM Products WHERE Id=@id";
databaseClass.Query(sql);
List <Product> productList = new List <Product>();
//Product product = new Product();
databaseClass.sqlConnection.Open();
using (databaseClass.sqlConnection)
{
databaseClass.sqlCommand.Parameters.AddWithValue("@id", id);
SqlDataReader dataReader = databaseClass.sqlCommand.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
Product product = new Product();
product.ID = Convert.ToInt32(dataReader[0]);
product.ProductName = Convert.ToString(dataReader[1]);
product.ProductPrice = Convert.ToInt32(dataReader[2]);
product.ProductDetails = Convert.ToString(dataReader[3]);
productList.Add(product);
}
productList.TrimExcess();
}
}
return(productList);
}
public static void Delete(int id)
{
DatabaseClass db = new DatabaseClass();
var sql = "Delete From Products WHERE Id=@id";
db.Query(sql);
db.sqlConnection.Open();
using (db.sqlConnection)
{
db.sqlCommand.Parameters.AddWithValue("@id", id);
db.sqlCommand.ExecuteNonQuery();
}
}
public static void UpdateProduct(Product product)
{
DatabaseClass databaseClass = new DatabaseClass();
var sql = "UPDATE Products SET ProductName = @name, ProductPrice = @price,ProductDetails = @details WHERE Id = @id; ";
databaseClass.Query(sql);
databaseClass.sqlConnection.Open();
using (databaseClass.sqlConnection)
{
databaseClass.sqlCommand.Parameters.AddWithValue("@name", product.ProductName);
databaseClass.sqlCommand.Parameters.AddWithValue("@price", product.ProductPrice);
databaseClass.sqlCommand.Parameters.AddWithValue("@details", product.ProductDetails);
databaseClass.sqlCommand.Parameters.AddWithValue("@id", product.ID);
databaseClass.sqlCommand.ExecuteNonQuery();
}
}
public static void InsertProduct(Product p)
{
DatabaseClass databaseClass = new DatabaseClass();
var sql = "insert into Products (Id, ProductName,ProductPrice,ProductDetails) values (@id, @proName,@pPrice,@Discription);";
databaseClass.Query(sql);
databaseClass.sqlConnection.Open();
using (databaseClass.sqlConnection)
{
databaseClass.sqlCommand.Parameters.AddWithValue("@id", p.ID);
databaseClass.sqlCommand.Parameters.AddWithValue("@proName", p.ProductName);
databaseClass.sqlCommand.Parameters.AddWithValue("@pPrice", p.ProductPrice);
databaseClass.sqlCommand.Parameters.AddWithValue("@Discription", p.ProductDetails);
databaseClass.sqlCommand.ExecuteNonQuery();
}
}