public static List<Core.Models.TrophiesRosettes> getTandRForShow(int ShowId)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.TrophiesRosettes tr = new Fpp.Data.TrophiesRosettes(moduleSettings);
var list = new List<Core.Models.TrophiesRosettes>();
var ds = tr.getTandRForShow(ShowId);
foreach (DataRow rdr in ds.Tables[0].Rows)
{
list.Add(new Core.Models.TrophiesRosettes {
Id = Convert.ToInt32(rdr["Id"]),
ShowId = Convert.ToInt32( rdr["ShowId"]),
ShowDetailsId = Convert.ToInt32(rdr["ShowDetailsId"]),
ShowDate = Convert.ToDateTime(rdr["ShowDate"]),
ClassType = (Core.Enums.ClassType )Convert.ToInt16(rdr["ClassType"]),
ClsNo = Convert.ToInt32(rdr["ClsNo"]),
ClassName = rdr["ClassName"].ToString(),
Count = Convert.ToInt32(rdr["Count"]),
Rosettes = Convert.ToInt32(rdr["Rosettes"]),
Trophies = Convert.ToInt32(rdr["Trophies"]),
Lho = (rdr.Field<int?>("Lho") == null ? 0: Convert.ToInt32(rdr["Lho"])),
AwardByHeight = (rdr.Field<int?>("AwardByHeight") == null ? 0 : Convert.ToInt32(rdr["AwardByHeight"])),
});
};
return list;
}
public static Fpp.Core.Dto.TrophyRosetteDefaultsDto GetDefaults(int ShowId)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.TrophiesRosettes tr = new Fpp.Data.TrophiesRosettes(moduleSettings);
var ds = tr.GetDefaults(ShowId);
if (ds.Tables[0].Rows.Count == 0)
{
return new Core.Dto.TrophyRosetteDefaultsDto
{
Rosettes = 15,
TrophyLimit1 = 50,
TrophyLimit2 = 30
};
}
else
{
DataRow row = ds.Tables[0].Rows[0];
return new Core.Dto.TrophyRosetteDefaultsDto
{
Rosettes = Convert.ToDouble(row["Rosettes"]),
TrophyLimit1 = Convert.ToInt32(row["TrophyLimit1"]),
TrophyLimit2 = Convert.ToInt32(row["TrophyLimit2"]),
};
}
}
public static DateTime? GetLastGenerated(int ShowId)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.TrophiesRosettes tr = new Fpp.Data.TrophiesRosettes(moduleSettings);
DataSet ds = tr.GetLastGenerated(ShowId);
if (ds.Tables[0].Rows.Count > 0)
{
var row = ds.Tables[0].Rows[0];
if (row["LastGenerated"] != DBNull.Value)
{
return Convert.ToDateTime(ds.Tables[0].Rows[0]["LastGenerated"]);
}
return null;
}
return null;
}
public static void Delete(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.TrophiesRosettes tr = new Fpp.Data.TrophiesRosettes(moduleSettings);
tr.Delete(ShowID);
}
public static int Add(Core.Models.TrophiesRosettes trophiesRosettes)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.TrophiesRosettes tr = new Fpp.Data.TrophiesRosettes(moduleSettings);
return tr.Add(trophiesRosettes);
}
public static void UpdateDefaults(int ShowId, double RosetteValue, int TrophyLimit1, int TrophyLimit2)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.TrophiesRosettes tr = new Fpp.Data.TrophiesRosettes(moduleSettings);
tr.UpdateDefaults(ShowId, RosetteValue, TrophyLimit1, TrophyLimit2);
}
public static void Update(int Id, int Trophy, int Rosette)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.TrophiesRosettes tr = new Fpp.Data.TrophiesRosettes(moduleSettings);
tr.UpdateTrophyRosettes(Id, Trophy, Rosette);
}
public static void SetLastGenerated(int ShowId)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.TrophiesRosettes tr = new Fpp.Data.TrophiesRosettes(moduleSettings);
tr.SetLastGenerated(ShowId);
}
