public UserShows(int UserShowID)
: base()
{
_userShows = new Data.UserShows(ModuleSettings);
DataSet ds = _userShows.GetUserShows(UserShowID);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
LoadFromRow(ds.Tables[0].Rows[0]);
}
public UserShows(int UserID, int ShowID)
: base()
{
_userShows = new Data.UserShows(ModuleSettings);
_userid = UserID;
_showid = ShowID;
DataSet ds = _userShows.GetUserShows(_userid, _showid);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
LoadFromRow(ds.Tables[0].Rows[0]);
}
public UserShows(DataRow row)
: base()
{
_userShows = new Data.UserShows(ModuleSettings);
LoadFromRow(row);
}
public void Delete()
{
_userShows = new Data.UserShows(ModuleSettings);
_userShows.Delete(_userid, ShowID);
}
public UserShows()
: base()
{
_userShows = new Data.UserShows(ModuleSettings);
}
public static List<UserShows> getListUsersForShow(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.UserShows us = new Data.UserShows(moduleSettings);
DataSet ds = us.getAllUsersForShow(ShowID);
List<UserShows> list = new List<UserShows>();
foreach (DataRow row in ds.Tables[0].Rows)
{
list.Add(new UserShows(row));
}
return list;
}
public static void ResetBulkEmailStatus(int ShowId)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.UserShows us = new Data.UserShows(moduleSettings);
us.ResetBulkEmailStatus( ShowId);
}
public static List<ShowEntry> getAllUserShowDetails(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.UserShows us = new Data.UserShows(moduleSettings);
var list = new List<ShowEntry>();
var ds = us.getAllUserShowDetails(ShowID);
foreach (DataRow row in ds.Tables[0].Rows)
{
list.Add(new ShowEntry
{
UserShowId = Convert.ToInt32(row["UserShowsID"]),
UserName = row["Name"].ToString(),
ContactDate = (row["ContactDate"] == DBNull.Value ? DateTime.MinValue: Convert.ToDateTime(row["ContactDate"])),
ContactStatus = Convert.ToInt32(row["ContactStatus"]),
EntryStatus = Convert.ToInt32(row["Status"])
});
}
return list;
}
public static DataSet getAllUserShowDetailsDS(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.UserShows us = new Data.UserShows(moduleSettings);
return us.getAllUserShowDetails(ShowID);
}
public static List<AdminEntryUserShowDetailsDto> getAdminEntryUserShow(int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.UserShows us = new Data.UserShows(moduleSettings);
DataSet ds = us.getAdminEntryUserShow(ShowID);
List<AdminEntryUserShowDetailsDto> list = new List<AdminEntryUserShowDetailsDto>();
foreach (DataRow row in ds.Tables[0].Rows)
{
var tmp = new AdminEntryUserShowDetailsDto
{
UserShowId = Convert.ToInt32(row["UserShowsId"]),
UserId = Convert.ToInt32(row["UserId"]),
HandlerName = Convert.ToString(row["Name"]),
HandlerType = Convert.ToInt32(row["HandlerType"]),
Amount = (row["Amount"] != DBNull.Value) ? Convert.ToDecimal(row["Amount"]) : (decimal?)null,
EnteredBy = (row["EnteredBy"] != DBNull.Value) ? Convert.ToInt32(row["EnteredBy"]) : (int?)null,
Status = Convert.ToInt32(row["Status"]),
HasPaid = (row["HasPaid"] != DBNull.Value) ? Convert.ToInt32(row["HasPaid"]) : (int?)null,
};
if (tmp.Status == 3)
{
tmp.EntryOrder = 3;
if (tmp.Amount != 0) { tmp.EntryOrder = 2; }
}
list.Add(tmp);
}
return list
.OrderByDescending(x => x.EntryOrder)
.ToList();
}
public static void DeleteEntry(int UserID, int ShowID)
{
String moduleSettings = ModuleConfig.GetSettings();
Data.UserShows us = new Data.UserShows(moduleSettings);
us.Delete(UserID, ShowID);
}
public UserShows(DataRow row)
: base()
{
_userShows = new Fpp.WebModules.Data.UserShows(_moduleSettings);
LoadFromRow(row);
}
public UserShows()
: base()
{
_userShows = new Fpp.WebModules.Data.UserShows(_moduleSettings);
}
public void Delete()
{
_userShows = new Fpp.WebModules.Data.UserShows(_moduleSettings);
_userShows.Delete(_userid, ShowID);
}
