/// <summary>
/// Builds a nailvent control given a guid
/// </summary>
/// <param name="gEventGUID">guid of the event</param>
/// <returns>nailvent control for the specified guid</returns>
public NailVent BuildEventControl(Guid gEventGUID)
{
var qryResults = from r in m_db.Event
where (r.bIsDeleted == false && r.gEventGUID == gEventGUID)
select r;
foreach (MVCEventBench.Models.Event results in qryResults)
{
NailVent nv = new NailVent();
//Initialize the events main properties
nv.EventGUID = results.gEventGUID;
nv.Name = results.strEventName;
nv.Location = results.strEventLocation;
nv.City = results.strEventCity;
nv.State = results.strEventState;
nv.Address = results.strEventAddress;
try
{
nv.DateStart = (DateTime)results.dEventDateStart;
}
catch
{
nv.DateStart = DateTime.Now;
}
try
{
nv.DateEnd = (DateTime)results.dEventDateEnd;
}
catch
{
nv.DateEnd = DateTime.MaxValue;
}
nv.Contact = results.strContact;
nv.Description = results.strDescription;
nv.Details = results.strDetails;
nv.PhoneNumber = results.strPhoneNumber;
nv.Sponsor = results.strSponsor;
nv.Webpage = results.strWebpage;
//Initialize the properties
nv.AddressFontFamily = results.strAddressFontFamily;
nv.AddressFontSize = results.strAddressFontSize;
nv.DateFontFamily = results.strDateFontFamily;
nv.DateFontSize = results.strDateFontSize;
return(nv);
}
//Nothing found
return(null);
}
/// <summary>
/// Builds a nailvent control given a guid
/// </summary>
/// <param name="gEventGUID">guid of the event</param>
/// <returns>nailvent control for the specified guid</returns>
public NailVent BuildEventControl(Guid gEventGUID)
{
var qryResults = from r in m_db.Event
where (r.bIsDeleted == false && r.gEventGUID == gEventGUID)
select r;
foreach (MVCEventBench.Models.Event results in qryResults)
{
NailVent nv = new NailVent();
//Initialize the events main properties
nv.EventGUID = results.gEventGUID;
nv.Name = results.strEventName;
nv.Address = results.strEventAddress;
nv.Date = (DateTime)results.dEventDate;
nv.Time = results.strEventTime;
nv.Contact = results.strContact;
nv.Description = results.strDescription;
nv.Details = results.strDetails;
nv.PhoneNumber = results.strPhoneNumber;
nv.Sponsor = results.strSponsor;
nv.Webpage = results.strWebpage;
if (results.imgEvent != null)
{
nv.ImgPath = results.imgEvent.ToString();
}
//Initialize the properties
nv.AddressFontFamily = results.strAddressFontFamily;
nv.AddressFontSize = results.strAddressFontSize;
nv.DateFontFamily = results.strDateFontFamily;
nv.DateFontSize = results.strDateFontSize;
nv.TimeFontFamily = results.strTimeFontFamily;
nv.TimeFontSize = results.strTimeFontSize;
return(nv);
}
//Nothing found
return(null);
}
/// <summary>
/// Method to parse the Events result query into actual controls.
/// </summary>
/// <param name="qryResults">Results set or the database query</param>
public void QryResultsToColumnControls(System.Data.Objects.ObjectQuery qryResults, List <NailVent> listNailVentToday, List <NailVent> listNailVentWeek, List <NailVent> listNailVentMonth)
{
DateTime dateNow = DateTime.Now;
string strDateNow = dateNow.ToString("d");
foreach (MVCEventBench.Models.Event result in qryResults)
{
//Create a new event
NailVent nv = new NailVent();
//Initialize the events main properties
nv.EventGUID = result.gEventGUID;
nv.Name = result.strEventName;
nv.Address = result.strEventAddress;
nv.Date = (DateTime)result.dEventDate;
nv.Time = result.strEventTime;
nv.Contact = result.strContact;
nv.Description = result.strDescription;
nv.Details = result.strDetails;
nv.PhoneNumber = result.strPhoneNumber;
nv.Sponsor = result.strSponsor;
nv.Webpage = result.strWebpage;
if (result.imgEvent != null)
{
nv.ImgPath = result.imgEvent.ToString();
}
//Initialize the properties
nv.AddressFontFamily = result.strAddressFontFamily;
nv.AddressFontSize = result.strAddressFontSize;
nv.DateFontFamily = result.strDateFontFamily;
nv.DateFontSize = result.strDateFontSize;
nv.TimeFontFamily = result.strTimeFontFamily;
nv.TimeFontSize = result.strTimeFontSize;
//If this is an event that is past date don't process it
DateTime.TryParse(strDateNow, out dateNow);
if (nv.Date < dateNow)
{
continue;
}
else
{
string strTimeCategory = FindEventTimeCategory(nv.Date);
switch (strTimeCategory)
{
case "day":
{
listNailVentToday.Add(nv);
break;
}
case "week":
{
listNailVentWeek.Add(nv);
break;
}
case "month":
{
listNailVentMonth.Add(nv);
break;
}
default:
{
break;
}
}
}
}
}