public void ReadFromDb(SqlDataReader rdr)
{
Id = (int)rdr["Id"];
Advertiser = (string)rdr["Advertizer"];
var rubId = (int)rdr["RubricId"];
Rubric = ClassifiedRubric.GetById(rubId);
Text = (string)rdr["AdText"];
Options = 0;
if ((bool)rdr["IsBorder"])
{
Options |= OptionsFlags.IsBorder;
}
if ((bool)rdr["IsBold"])
{
Options |= OptionsFlags.IsBold;
}
if ((bool)rdr["IsBackground"])
{
Options |= OptionsFlags.IsBackground;
}
if ((bool)rdr["IsCentered"])
{
Options |= OptionsFlags.IsCentered;
}
Info = (string)ResolveDbNull(rdr["Info"]);
IsPaid = (bool)rdr["IsPaid"];
PaymentMethod = rdr["PaymentMethod"] is DBNull ? PaymentMethodEnum.NotSet : (PaymentMethodEnum)(byte)rdr["PaymentMethod"];
Price = (decimal)ResolveDbNull(rdr["Price"], 0m);
StartIssue = new IssueNumber((int)rdr["StartIssueYear"], (short)rdr["StartIssueNumber"]);
EndIssue = new IssueNumber((int)rdr["EndIssueYear"], (short)rdr["EndIssueNumber"]);
SM = (string)ResolveDbNull(rdr["clasSM"]);
Created = (DateTime)rdr["clasTimestamp"];
WebsitePromitionPrice = (decimal)ResolveDbNull(rdr["WebsitePromitionPrice"], 0m);
WebsitePromotionExpirationDate = (DateTime?)ResolveDbNull(rdr["WebsitePromotionExpirationDate"]);
}
public ClassifiedAd()
{
StartIssue = new IssueNumber(DateTime.Now.Year, 1);
EndIssue = new IssueNumber(DateTime.Now.Year, 52);
}