protected void load_schedule()
{
this.Schedule = MrSchedule.LoadFromCsv(filename);
this.scheduleDate = this.Schedule.CreateTime.ToLongDateString();
countOfEvents = this.Schedule.Events.Count;
// this.GridView1.DataSource = new MrSchedule[] { this.Schedule };
// this.GridView1.DataBind();
// this.ScheduleRepeater.DataSource = new MrSchedule[] { this.Events };
// this.ScheduleRepeater.DataBind();
}
protected void LookAtEventsDB()
{
countOfEvents = 0;
this.dbEvents = MrSchedule.LoadFromDB();
countOfEvents = dbEvents.Events.Count;
if (countOfEvents > 0)
{
firstDate = dbEvents.Events[0].EDate;
lastDate = dbEvents.Events[countOfEvents - 1].EDate;
}
}
public static MrSchedule LoadFromDB()
{
MrSchedule target = new MrSchedule();
MrTimeZone mtz = new MrTimeZone();
DateTime etzNow = mtz.eastTimeNow();
DateTime yesterday = etzNow.Subtract(TimeSpan.FromDays(1));
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
var qevents =
from ev in db.Events
where (ev.Date >= yesterday)
orderby ev.EventID
select ev;
foreach (Events item in qevents)
{
SysEvent e = new SysEvent()
{
Id = item.EventID.Trim(),
EDate = item.Date,
EType = item.Type.Trim(),
ETitle = item.Title,
ECost = item.Cost.Trim(),
ETime = item.Date.ToString("h:mm t").ToLower(),
EDeadline = item.Deadline,
EPlayerLimit = item.PlayerLimit,
EHostPhone = item.HostPhone,
ESpecialRule = item.SpecialRule.Trim(),
EGuest = item.Guest.Trim(),
EHostID = item.HostID,
EPostDate = item.PostDate
};
if (item.PostDate == null)
{
e.EPostDate = DateTime.MinValue;
}
target.ScheduleYear = e.EDate.Year;
target.Events.Add(e);
}
return(target);
}
public static MrSchedule LoadFromDB()
{
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MrSchedule DBEntries = new MrSchedule();
var query = from q in db.Events
orderby q.Date
select q;
foreach (var item in query)
{
SysEvent dataEvent = new SysEvent()
{
Id = item.EventID,
EDate = item.Date,
EType = item.Type,
EHostID = item.HostID,
ETitle = item.Title,
ECost = item.Cost,
ETime = item.Time,
EDeadline = item.Deadline,
ESpecialRule = item.SpecialRule,
EGuest = item.Guest,
EHostPhone = item.HostPhone,
EPlayerLimit = item.PlayerLimit,
EPostDate = item.PostDate
};
DBEntries.Events.Add(dataEvent);
}
int entryCount = DBEntries.Events.Count;
return(DBEntries);
}
protected void load_schedule()
{
this.Schedule = MrSchedule.LoadFromDB();
this.ScheduleRepeater.DataSource = new MrSchedule[] { this.Schedule };
this.ScheduleRepeater.DataBind();
}
public static MrSchedule LoadFromCsv(string fileName)
{
string MRMISGADBConn = ConfigurationManager.ConnectionStrings["MRMISGADBConnect"].ToString();
MRMISGADB db = new MRMISGADB(MRMISGADBConn);
MRParams item = db.MRParams.FirstOrDefault(p => p.Key == keyMinDate);
if ((item == null))
{
MinDate = new DateTime(2000, 1, 1, 1, 0, 0);
}
else
{
MinDate = Convert.ToDateTime(item.Value);
}
MrSchedule target = new MrSchedule();
target.FileName = fileName;
target.CreateTime = System.IO.File.GetLastWriteTime(fileName);
string[] lines = System.IO.File.ReadAllLines(fileName);
foreach (String line in lines)
{
if (line.Trim() == "")
{
// Ignore this line
}
else if (line.Substring(0, 1) == "/")
{
// Ignore comment line
}
else
{
string[] fields = line.Split(delimiterChars);
if (fields.Length != 12)
// if (fields.Length != 11)
{
throw new InvalidOperationException("DERP: Incorrect number of fields in schedule.txt");
}
SysEvent e = new SysEvent()
{
Id = fields[0],
EDate = Convert.ToDateTime(fields[1]),
EType = fields[2],
ETitle = fields[3],
ECost = fields[4],
ETime = fields[5],
EDeadline = Convert.ToDateTime(fields[6]),
EHostPhone = fields[7],
ESpecialRule = fields[9],
EGuest = fields[10],
EHostID = fields[0].Substring(11, 3)
};
if (string.IsNullOrEmpty(fields[11]))
{
e.EPostDate = MinDate;
}
else
{
e.EPostDate = Convert.ToDateTime(fields[11]);
}
if (fields[8] == "")
{
e.EPlayerLimit = 6;
}
else
{
e.EPlayerLimit = Convert.ToInt32(fields[8]);
}
target.Events.Add(e);
Events ev = db.Events.FirstOrDefault(p => p.EventID == e.Id);
if (ev == null)
{
Events newEvent = new Events()
{
EventID = e.Id,
Date = e.EDate,
Type = e.EType,
Title = e.ETitle,
Cost = e.ECost,
Time = e.ETime,
Deadline = e.EDeadline,
HostID = e.EHostID,
SpecialRule = e.ESpecialRule,
PlayerLimit = e.EPlayerLimit,
Guest = e.EGuest,
HostPhone = e.EHostPhone,
PostDate = e.EPostDate
};
db.Events.InsertOnSubmit(newEvent);
}
else
{
ev.Date = e.EDate;
ev.Type = e.EType;
ev.Title = e.ETitle;
ev.Cost = e.ECost;
ev.Time = e.ETime;
ev.Deadline = e.EDeadline;
ev.HostID = e.EHostID;
ev.Guest = e.EGuest;
ev.PlayerLimit = e.EPlayerLimit;
ev.SpecialRule = e.ESpecialRule;
ev.HostPhone = e.EHostPhone;
ev.PostDate = e.EPostDate;
}
db.SubmitChanges();
}
}
return(target);
}
