public Category(Guid id, string name) { CustomValidator.ValidateId(id); CustomValidator.ValidateString(name, 2, 40); Id = id; Name = name; }
public Customer(Guid id, string name, double balance) { CustomValidator.ValidateId(id); CustomValidator.ValidateString(name, 2, 40); CustomValidator.ValidateNumber(balance, 0, 100_000_000); Id = id; Name = name; Balance = balance; }
public CategoryDbModel(Guid id, string name) { CustomValidator.ValidateId(id); CustomValidator.ValidateString(name, 2, 40); Id = id; Name = name; _productDbModels = new List <ProductDbModel>(); _storeCategoryRelation = new List <StoreCategoryDbModel>(); StoreDbModelId = default; }
public MallDbModel(Guid id, string name, string location) { CustomValidator.ValidateId(id); CustomValidator.ValidateString(name, 2, 40); CustomValidator.ValidateString(location, 2, 40); Id = id; Name = name; Location = location; _storeDbModels = new List <StoreDbModel>(); }
public Product(Guid id, string name, double priceInUAH, ProductStatus productStatus, Guid categoryId) { CustomValidator.ValidateId(id); CustomValidator.ValidateId(categoryId); CustomValidator.ValidateString(name, 2, 40); CustomValidator.ValidateNumber(priceInUAH, 0, 100_000_000); Id = id; Name = name; PriceInUAH = priceInUAH; ProductStatus = productStatus; CategoryId = categoryId; }
public StoreDbModel(Guid id, string name, string location, double profit) { CustomValidator.ValidateId(id); CustomValidator.ValidateString(name, 2, 60); CustomValidator.ValidateString(location, 2, 60); CustomValidator.ValidateNumber(profit, 0, double.MaxValue); Id = id; Name = name; Location = location; Profit = profit; _storeCategoryRelation = new List <StoreCategoryDbModel>(); _storeProductRelation = new List <StoreProductDbModel>(); }
public ProductDbModel(Guid id, string name, double priceInUAH, ProductStatus productStatus, Guid categoryId) { CustomValidator.ValidateId(id); CustomValidator.ValidateId(categoryId); CustomValidator.ValidateString(name, 2, 60); CustomValidator.ValidateNumber(priceInUAH, 0, 100_000_000); Id = id; Name = name; PriceInUAH = priceInUAH; ProductStatus = productStatus; CategoryId = categoryId; _storeProductRelation = new List <StoreProductDbModel>(); }
public Store(Guid id, string name, string location, double profit, Guid?mallId) { CustomValidator.ValidateId(id); CustomValidator.ValidateString(name, 2, 40); CustomValidator.ValidateString(location, 2, 40); CustomValidator.ValidateNumber(profit, 0, double.MaxValue); CustomValidator.ValidateId(mallId); Id = id; Name = name; Location = location; Profit = profit; MallId = mallId; _categories = new List <Category>(); }
public T GetProperty <T>(string entityName, string propertyName, string idColumnName, Guid id) { CustomValidator.ValidateId(id); CustomValidator.ValidateString(entityName, 0, 100); CustomValidator.ValidateString(propertyName, 0, 100); CustomValidator.ValidateString(idColumnName, 0, 100); var tableName = GetTableName(entityName); var con = new SqlConnection(ConnectionString); var cm = new SqlCommand($"SELECT * FROM {tableName} WHERE {idColumnName} = @Id", con); con.Open(); var param = new SqlParameter("@Id", id); cm.Parameters.Add(param); T data; try { var dr = cm.ExecuteReader(); try { data = dr.Read() ? (T)dr[propertyName] : default; } catch (IndexOutOfRangeException) { data = default; } catch (InvalidCastException) { data = default; } finally { dr.Close(); } } catch (SqlException) { data = default; } con.Close(); return(data); }
public void UpdateName(string newName) { CustomValidator.ValidateString(newName, 2, 40); Name = newName; }
public PropertyGetter(string connectionString) { CustomValidator.ValidateString(connectionString, 0, 400); ConnectionString = connectionString; }