public Camping(int ShowID)
: base()
{
_camping = new Fpp.Data.Camping(ModuleSettings);
DataSet ds = _camping.getCampingForShow(ShowID);
if (ds.Tables[0].Rows.Count > 0)
{
LoadFromRow(ds.Tables[0].Rows[0]);
}
}
public static List<Camping>GetDaysList(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
DataSet ds = c.getCampingForShow(ShowID);
var list = new List<Camping>();
foreach (DataRow row in ds.Tables[0].Rows ){
list.Add(new Camping(row));
}
return list;
}
public static List<ShowCampingList> GetCampingForPaidUsers(int ShowId)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
var res = new List<ShowCampingList>();
DataSet ds = c.getCampingForPaidUsers(ShowId);
foreach (DataRow row in ds.Tables[0].Rows)
{
res.Add(new ShowCampingList(row));
}
return res;
}
public static void DeleteForUser(int UserShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
c.DeleteForUser(UserShowID);
}
public static void Add(int UserId, Fpp.Core.Models.UserCampingModel UserCamping)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
var nights = (UserCamping.CampingDays.Split(',').Length == 0) ? 1 : UserCamping.CampingDays.Split(',').Length;
c.AddUserCamping(UserId, Core.Utils.HTMLToSqlQuote(UserCamping.PartyName), Core.Utils.HTMLToSqlQuote(UserCamping.Comments), UserCamping.CampingDays, nights, UserCamping.PitchSize);
}
public static List<int> getCampingTotals(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
List<int> list = new List<int>();
DataSet ds = c.getCampingTotals(ShowID);
foreach (DataRow row in ds.Tables[0].Rows)
{
int tmp = Convert.ToInt32(row[0]);
list.Add(tmp);
}
return list;
}
public static void SetPartyName(int CampingID, String PartyName)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
var uc = UserCamping.Get(CampingID);
c.SetPartyName(uc.UserShowId, PartyName);
}
public static void SetCode(int CampingID, String Code)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
c.SetCode(CampingID, Code);
}
public static UserCamping GetUserShow(int UserShowId)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
var ds = c.getCampingForUserShow(UserShowId);
if (ds.Tables[0].Rows.Count > 0)
{
return new UserCamping(ds.Tables[0]);
}
return new UserCamping();
}
public UserCamping(int UserShowID)
: base()
{
initialise();
_camping = new Fpp.Data.Camping(ModuleSettings);
DataSet ds = _camping.getCampingForUserShow(UserShowID);
foreach (DataRow row in ds.Tables[0].Rows)
{
LoadFromRow(row);
}
}
public UserCamping()
: base()
{
_camping = new Fpp.Data.Camping(ModuleSettings);
initialise();
}
public static List<ShowCampingList> getShowCampingList(int ShowID, String sorttype, int direction)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
List<ShowCampingList> list = new List<ShowCampingList>();
DataSet ds = c.getShowCampingList(ShowID, sorttype, direction);
foreach (DataRow row in ds.Tables[0].Rows)
{
list.Add(new ShowCampingList(row));
}
return list;
}
public Camping()
: base()
{
_camping = new Fpp.Data.Camping(ModuleSettings);
}
public static List<UnpaidUsers> getUnpaidCampingUsers(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
var list = new List<UnpaidUsers>();
DataSet ds = c.getUnpaidCampingUsers(ShowID);
foreach (DataRow row in ds.Tables[0].Rows)
{
var tmp = new UnpaidUsers
{
UserId = Convert.ToInt32(row[0]),
Name = row[1].ToString()
};
list.Add(tmp);
}
return list;
}
public static List<CampingSummary> GetCampingSummary(int ShowId, int UserId)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
var res = new List<CampingSummary>();
DataSet ds = c.GetCampingSummary(ShowId, UserId);
foreach (DataRow row in ds.Tables[0].Rows )
{
List<DateTime> days = new List<DateTime>();
var daysList = Convert.ToString(row["CampingDays"]).Split(',');
foreach(string day in daysList)
{
var d = DateTime.Parse(day);
var tmp = res.FirstOrDefault (x => x.CampingDay == d);
if (tmp == null) {
res.Add(new CampingSummary {
CampingDay = d,
Count = 1
});
} else {
tmp.Count ++;
}
}
}
return res;
}
public UserCamping(DataRow row)
: base()
{
initialise();
_camping = new Fpp.Data.Camping(ModuleSettings);
LoadFromRow(row);
}
public static DataSet GetDays(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
return c.getCampingForShow(ShowID);
}
public UserCamping(DataTable table)
: base()
{
initialise();
_camping = new Fpp.Data.Camping(ModuleSettings);
LoadFromTable(table);
}
public static List<CampingPitch> GetUserShowPitchCamping(int UserShowId)
{
List<CampingPitch> campingPitches = new List<CampingPitch>();
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
DataSet ds = c.GetUserShowPitchingCamping(UserShowId);
foreach (DataRow row in ds.Tables[0].Rows)
{
campingPitches.Add(new CampingPitch(row));
}
return campingPitches;
}
public Camping(DataRow row)
: base()
{
_camping = new Fpp.Data.Camping(ModuleSettings);
LoadFromRow(row);
}
public static void SetComments(int CampingId, string comments)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
c.SetComments(CampingId, comments);
}
public static void Add(int UserShowID, String campingParty, String campingComments, String campingDates, string pitchSize)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
var nights = (campingDates.Split(',').Length == 0) ? 1 : campingDates.Split(',').Length;
c.AddUserCamping(UserShowID, Core.Utils.HTMLToSqlQuote( campingParty), Core.Utils.HTMLToSqlQuote( campingComments), campingDates, nights, pitchSize);
}
public static void SetPitchNo(int CampingID, string PitchNo)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
var uc = UserCamping.Get(CampingID);
c.SetPitchNo(CampingID, PitchNo);
}
public static List<MemberCamping> getCampingMembersFor(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Fpp.Data.Camping c = new Fpp.Data.Camping(moduleSettings);
List<MemberCamping> mc = new List<MemberCamping>();
DataSet ds = c.getCampingMembersFor(ShowID);
foreach (DataRow row in ds.Tables[0].Rows)
{
mc.Add(new MemberCamping(row));
}
return mc;
}
