public RequirementList ReadProductListByID(SqlDataReader reader)
{
RequirementList requirementList = new RequirementList();
requirementList.RowID = reader.GetInt32(0);
requirementList.UserName = reader.GetString(1);
requirementList.RequestedProductQuantity = reader.GetInt32(2);
requirementList.CategoryID = reader.GetInt32(3);
requirementList.CategoryName = reader.GetString(4);
requirementList.SubCategoryID = reader.GetInt32(5);
requirementList.SubCategoryName = reader.GetString(6);
requirementList.ProductID = reader.GetInt32(7);
requirementList.ProductName = reader.GetString(8);
requirementList.RequestedDate = reader.GetDateTime(9);
return(requirementList);
}
public RequirementList ReadProductList(SqlDataReader reader)
{
RequirementList requirementList = new RequirementList();
requirementList.CompanyID = reader.GetInt32(0);
requirementList.DepartmentID = reader.GetInt32(1);
requirementList.ProductID = reader.GetInt32(2);
requirementList.AssignedProductQuantity = reader.GetInt32(3);
requirementList.CompanyName = reader.GetString(4);
requirementList.DepartmentName = reader.GetString(5);
requirementList.UserName = reader.GetString(6);
requirementList.CategoryName = reader.GetString(7);
requirementList.SubCategoryName = reader.GetString(8);
requirementList.ProductName = reader.GetString(9);
requirementList.AvailableProductQuantity = reader.IsDBNull(10)? 0 : reader.GetInt32(10);
requirementList.RowID = reader.GetInt32(11);
return(requirementList);
}
public List <RequirementList> GetAssignedStockByRowID(int AssignedRowID)
{
List <RequirementList> prodByID = new List <RequirementList>();
using (SqlConnection connection = new SqlConnection(this._connectionString))
{
try
{
using (SqlCommand command = new SqlCommand(ProductServiceSQL.GET_ASSIGN_PROD))
{
command.Parameters.AddWithValue("@AssignedRowID", AssignedRowID);
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
RequirementList requirementList = new RequirementList();
prodByID.Add(new RequirementList
{
RowID = reader.GetInt32(0),
RequirementID = reader.GetInt32(1),
UserName = reader.GetString(2),
RequestedProductQuantity = reader.GetInt32(3),
AssignedProductQuantity = reader.GetInt32(4),
CategoryID = reader.GetInt32(5),
CategoryName = reader.GetString(6),
SubCategoryID = reader.GetInt32(7),
SubCategoryName = reader.GetString(8),
ProductID = reader.GetInt32(9),
ProductName = reader.GetString(10),
AssignedDate = reader.GetDateTime(11),
CompanyID = reader.GetInt32(12)
});
}
}
}
catch (SqlException ex)
{
logger.Error("Error while executing SQL Statement", ex);
throw new DbException("Error while executing SQL Statement");
}
}
return(prodByID);
}
public List <RequirementList> GetStockByProductID(int ProductID)
{
List <RequirementList> prodByID = new List <RequirementList>();
using (SqlConnection connection = new SqlConnection(this._connectionString))
{
try
{
using (SqlCommand command = new SqlCommand(ProductServiceSQL.GET_PROD_QTYID))
{
command.Parameters.AddWithValue("@ProductID", ProductID);
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
RequirementList requirementList = new RequirementList();
requirementList.ProductName = reader.GetString(0);
requirementList.CompanyID = reader.GetInt32(0);
requirementList.DepartmentID = reader.GetInt32(1);
requirementList.ProductID = reader.GetInt32(2);
requirementList.AssignedProductQuantity = reader.GetInt32(3);
requirementList.CompanyName = reader.GetString(4);
requirementList.DepartmentName = reader.GetString(5);
requirementList.UserName = reader.GetString(6);
requirementList.CategoryName = reader.GetString(7);
requirementList.SubCategoryName = reader.GetString(8);
requirementList.AvailableProductQuantity = reader.IsDBNull(10) ? 0 : reader.GetInt32(10);
requirementList.RowID = reader.GetInt32(11);
}
}
}
catch (SqlException ex)
{
logger.Error("Error while executing SQL Statement", ex);
throw new DbException("Error while executing SQL Statement");
}
}
return(prodByID);
}
