public int DeleteDataBL(StoreInventoryBL oStoreInventoryBL)
{
StoreDataAccessLayer oStoreDataAccessLayer = new StoreDataAccessLayer();
StoreInventoryDL oStoreInventoryDL = new StoreInventoryDL();
oStoreInventoryDL.Id = oStoreInventoryBL.Id;
int rowCount = oStoreDataAccessLayer.DeleteDataDL(oStoreInventoryDL);
return(rowCount);
}
/// <summary>
/// Method to Insert Data
/// </summary>
/// <param name="oStoreInventoryBL"></param>
/// <returns></returns>
public int InsertDataDL(StoreInventoryBL oStoreInventoryBL)
{
StoreDataAccessLayer oStoreDataAccessLayer = new StoreDataAccessLayer();
StoreInventoryDL oStoreInventoryDL = new StoreInventoryDL();
oStoreInventoryDL.ContentName = oStoreInventoryBL.ContentName;
oStoreInventoryDL.ContentQuantity = oStoreInventoryBL.ContentQuantity;
int rowCount = oStoreDataAccessLayer.InsertDataDL(oStoreInventoryDL);
return(rowCount);
}
/// <summary>
/// Method to Delete Data
/// </summary>
/// <param name="oStoreInventoryDL"></param>
/// <returns></returns>
public int DeleteDataDL(StoreInventoryDL oStoreInventoryDL)
{
if (ConnectionState.Closed == oConnection.oSqlConnection.State)
{
oConnection.oSqlConnection.Open();
}
oSqlCommand.CommandText = "DELETE FROM dbo.StoreInventory WHERE ID = @ContentID";
oSqlCommand.Parameters.AddWithValue("@ContentID", oStoreInventoryDL.Id);
//Open Connection
oSqlCommand.Connection = oConnection.oSqlConnection;
//execute command
int rowCount = oSqlCommand.ExecuteNonQuery();
return(rowCount);
}
/// <summary>
/// Metod to Insert Data
/// </summary>
/// <param name="oStoreInventoryDL"></param>
/// <returns></returns>
public int InsertDataDL(StoreInventoryDL oStoreInventoryDL)
{
if (ConnectionState.Closed == oConnection.oSqlConnection.State)
{
oConnection.oSqlConnection.Open();
}
oSqlCommand.CommandText = "INSERT INTO dbo.StoreInventory(ContentName, ContentQuantity) VALUES (@ContentName, @ContentQuantity)";
oSqlCommand.Parameters.AddWithValue("@ContentName", oStoreInventoryDL.ContentName);
oSqlCommand.Parameters.AddWithValue("@ContentQuantity", oStoreInventoryDL.ContentQuantity);
//Open Connection
oSqlCommand.Connection = oConnection.oSqlConnection;
//execute command
int rowCount = oSqlCommand.ExecuteNonQuery();
return(rowCount);
}
/// <summary>
/// Metho to Update Data
/// </summary>
/// <param name="oStoreInventoryDL"></param>
/// <returns></returns>
public int UpdateDataDL(StoreInventoryDL oStoreInventoryDL)
{
if (ConnectionState.Closed == oConnection.oSqlConnection.State)
{
oConnection.oSqlConnection.Open();
}
oSqlCommand.CommandText = "UPDATE dbo.StoreInventory SET ContentName = @ContentName, ContentQuantity = @ContentQuantity WHERE ID = @ContentID";
oSqlCommand.Parameters.AddWithValue("@ContentName", oStoreInventoryDL.ContentName);
oSqlCommand.Parameters.AddWithValue("@ContentQuantity", oStoreInventoryDL.ContentQuantity);
oSqlCommand.Parameters.AddWithValue("@ContentID", oStoreInventoryDL.Id);
//Open Connection
oSqlCommand.Connection = oConnection.oSqlConnection;
//execute command
int rowCount = oSqlCommand.ExecuteNonQuery();
return(rowCount);
}
/// <summary>
/// Method to read data
/// </summary>
/// <returns></returns>
public IList <StoreInventoryDL> ReadDataDL()
{
//List collection to store data models
IList <StoreInventoryDL> iStoreInventoryDL = new List <StoreInventoryDL>();
//Object to data models
StoreInventoryDL oStoreInventoryDL = null;
if (ConnectionState.Closed == oConnection.oSqlConnection.State)
{
oConnection.oSqlConnection.Open();
}
oSqlCommand.CommandText = "SELECT * FROM dbo.StoreInventory";
oSqlCommand.Connection = oConnection.oSqlConnection;
try
{
SqlDataReader oSqlDataReader = oSqlCommand.ExecuteReader();
while (oSqlDataReader.Read())
{
oStoreInventoryDL = new StoreInventoryDL();
oStoreInventoryDL.Id = Convert.ToInt32(oSqlDataReader["Id"]);
oStoreInventoryDL.ContentName = oSqlDataReader["ContentName"].ToString();
oStoreInventoryDL.ContentQuantity = Convert.ToInt32(oSqlDataReader["ContentQuantity"]);
iStoreInventoryDL.Add(oStoreInventoryDL);
}
}
catch
{
throw;
}
//return oStoreInventory;
return(iStoreInventoryDL);
}
