public static List <ClaimSkuSubCategorySupplier> GetClaimSkuSubCategorySupplierListByFilter(string searchValue, int companyId)
{
List <ClaimSkuSubCategorySupplier> list = new List <ClaimSkuSubCategorySupplier>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuSubCategorySupplierListByFilter";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@SearchValue", DbType.String, searchValue);
db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, companyId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
ClaimSkuSubCategorySupplier claimSkuSubCategorySupplier = new ClaimSkuSubCategorySupplier();
claimSkuSubCategorySupplier.ClaimSkuSubCategorySupplierId = Convert.ToInt32(dataReader["ClaimSkuSubCategorySupplierId"]);
claimSkuSubCategorySupplier.Sku = dataReader["Sku"].ToString();
claimSkuSubCategorySupplier.Supplier = dataReader["Supplier"].ToString();
claimSkuSubCategorySupplier.Location = dataReader["Location"].ToString();
list.Add(claimSkuSubCategorySupplier);
}
}
return(list);
}
public static List <ClaimSkuSubCategorySupplier> GetClaimSkuSubCategorySupplierListByClaimSupplierId(int claimSupplierId)
{
List <ClaimSkuSubCategorySupplier> list = new List <ClaimSkuSubCategorySupplier>();
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuSubCategorySupplierListByClaimSupplierId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ClaimSupplierId", DbType.Int32, claimSupplierId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
ClaimSkuSubCategorySupplier claimSkuSubCategorySupplier = new ClaimSkuSubCategorySupplier();
claimSkuSubCategorySupplier.ClaimSkuSubCategorySupplierId = Convert.ToInt32(dataReader["ClaimSkuSubCategorySupplierId"]);
claimSkuSubCategorySupplier.ClaimSupplierId = Convert.ToInt32(dataReader["ClaimSupplierId"]);
claimSkuSubCategorySupplier.ClaimSkuCategoryId = Convert.ToInt32(dataReader["ClaimSkuCategoryId"]);
claimSkuSubCategorySupplier.ClaimSkuCategory = dataReader["ClaimSkuCategory"].ToString();
claimSkuSubCategorySupplier.ClaimSkuSubCategoryId = Convert.ToInt32(dataReader["ClaimSkuSubCategoryId"]);
claimSkuSubCategorySupplier.ClaimSkuSubCategory = dataReader["ClaimSkuSubCategory"].ToString();
claimSkuSubCategorySupplier.Barcode = dataReader["Barcode"].ToString();
claimSkuSubCategorySupplier.Size = dataReader["Size"].ToString();
claimSkuSubCategorySupplier.IsMaas = dataReader["IsMaas"].ToString();
list.Add(claimSkuSubCategorySupplier);
}
}
return(list);
}
public static ClaimSkuSubCategorySupplier GetClaimSkuSubCategorySupplierByClaimSkuSubCategorySupplierId(int claimSkuSubCategorySupplierId)
{
Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep");
string sqlCommand = "GetClaimSkuSubCategorySupplierByClaimSkuSubCategorySupplierId";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ClaimSkuSubCategorySupplierId", DbType.Int32, claimSkuSubCategorySupplierId);
db.AddOutParameter(dbCommand, "@ClaimSkuSubCategoryId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@ClaimSupplierId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@Sku", DbType.String, 500);
db.AddOutParameter(dbCommand, "@Supplier", DbType.String, 100);
db.AddOutParameter(dbCommand, "@Location", DbType.String, 100);
db.ExecuteNonQuery(dbCommand);
ClaimSkuSubCategorySupplier claimSkuSubCategorySupplier = new ClaimSkuSubCategorySupplier();
claimSkuSubCategorySupplier.ClaimSkuSubCategorySupplierId = claimSkuSubCategorySupplierId;
claimSkuSubCategorySupplier.ClaimSkuSubCategoryId = Convert.ToInt32(db.GetParameterValue(dbCommand, "ClaimSkuSubCategoryId"));
claimSkuSubCategorySupplier.ClaimSupplierId = Convert.ToInt32(db.GetParameterValue(dbCommand, "ClaimSupplierId"));
claimSkuSubCategorySupplier.LocationId = Convert.ToInt32(db.GetParameterValue(dbCommand, "LocationId"));
claimSkuSubCategorySupplier.Sku = db.GetParameterValue(dbCommand, "Sku").ToString();
claimSkuSubCategorySupplier.Supplier = db.GetParameterValue(dbCommand, "Supplier").ToString();
claimSkuSubCategorySupplier.Location = db.GetParameterValue(dbCommand, "Location").ToString();
return(claimSkuSubCategorySupplier);
}
