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); }