public static PrSchedule GetPlayerSchedule(int playerID, string type)
{
PrSchedule target = new PrSchedule();
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MrTimeZone mtz = new MrTimeZone();
DateTime etzNow = mtz.eastTimeNow();
var ps =
from pl in db.PlayersList
where ((pl.PlayerID == playerID) && (pl.Marked == 0))
join ev in db.Events
on pl.EventID equals ev.EventID
orderby ev.EventID
select new { ev.EventID, ev.Date, ev.Type, ev.Title, ev.Cost, ev.Time, ev.Deadline, ev.HostPhone, pl.Carpool };
futureCount = 0;
prevCount = 0;
if (ps != null)
{
foreach (var item in ps)
{
PrEvent pe = new PrEvent
{
PrEvID = item.EventID,
PrDate = item.Date,
PrType = item.Type,
PrTitle = item.Title,
PrCost = item.Cost,
PrTime = item.Time,
PrDeadline = item.Deadline,
PrHostPhone = item.HostPhone,
PrCarpool = item.Carpool
};
if (item.Date >= etzNow)
{
futureCount++;
pe.PrCompleted = false;
target.PEvents.Add(pe);
}
else
{
if (type == "0")
{
prevCount++;
pe.PrCompleted = true;
target.PEvents.Add(pe);
}
}
}
}
return(target);
}
protected int getPlayersEvents(string type)
{
this.PlayerScheduleRepeater.Visible = false;
int cnt = 0;
this.PlayerSchedule = PrSchedule.GetPlayerSchedule(selectedPlayerID, type);
cnt = this.PlayerSchedule.FutureCount;
int pcnt = this.PlayerSchedule.PrevCount;
int count = cnt + pcnt;
this.PlayerScheduleRepeater.DataSource = new PrSchedule[] { this.PlayerSchedule };
this.PlayerScheduleRepeater.DataBind();
if (count > 0)
{
this.PlayerScheduleRepeater.Visible = true;
}
return(cnt);
}