public void ChangeOutfitUpdatersStatus(OutfitUpdaterStatus from, OutfitUpdaterStatus to, Season currentSeason)
{
string query = string.Format("call uspUpdateOutfitUpdaterStatusPerSeason({0},{1},{2});", (int)from, (int)to, (int)currentSeason);
IQuery q = NHibernateSession.Current.CreateSQLQuery(query);
q.ExecuteUpdate();
}
public bool HasUpdaters(OutfitUpdaterStatus atLeastFrom, Season currentSeason)
{
ICriteria crit = Session.CreateCriteria(typeof(OutfitUpdater));
crit.Add(Expression.Ge("Status", atLeastFrom));
crit.Add(Expression.Eq("Season", currentSeason));
crit.SetProjection(Projections.Count("Id"));
int count = crit.UniqueResult <int>();
return(count != 0);
}
public OutfitUpdater(int id, string name, string keywords, string description, string externalId, double price, string buyUrl, string imageUrl, int partnerId, int silouhetteId, int patternId, int colorFamilyId, int status)
{
this.Id = id;
this.name = name;
this.description = description;
this.keywords = keywords;
this.externalId = externalId;
if (price > 0)
{
this.price = Convert.ToDecimal(price);
}
this.buyUrl = buyUrl;
this.imageUrl = imageUrl;
this.partner = new Partner(partnerId);
this.silouhette = new Silouhette(silouhetteId);
this.pattern = new Pattern(patternId);
this.colorFamily = new ColorFamily(colorFamilyId);
this.status = (OutfitUpdaterStatus)status;
}
