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