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