//SELECT EVENTTITLE,VenueName,StreetAddress,City,StateProvision,ZipCode FROM Event INNER JOIN Venue ON EVENT.VenueID = Venue.VenueID WHERE EventSPID='E03061304390215'
public EventVenueModel GetEventVenueModelDetails(string EventID)
{
try
{
string sql = "SELECT EVENTTITLE,ImagePath,EventDate,EventFromTime,EventToTime, VenueName,StreetAddress,City,StateProvision,ZipCode FROM Event INNER JOIN Venue ON EVENT.VenueID = Venue.VenueID INNER JOIN EventTimeDetails ON EVENT.EventSPID = EventTimeDetails.EventSPID WHERE EVENT.EventSPID='" + EventID + "'";
EventVenueModel _eventVenueModel = new EventVenueModel();
using (SqlConnection conn = new SqlConnection(ConnString))
{
using (SqlCommand cmdDel = new SqlCommand(sql, conn))
{
conn.Open();
SqlDataReader dr = cmdDel.ExecuteReader();
while (dr.Read())
{
_eventVenueModel.EventName = dr["EVENTTITLE"].ToString();
_eventVenueModel.EventToTime = dr["EventToTime"].ToString();
_eventVenueModel.EventFromTime = dr["EventFromTime"].ToString();
_eventVenueModel.EventDate = dr["EventDate"].ToString();
_eventVenueModel.EventImage = dr["ImagePath"].ToString();
_eventVenueModel.VenueName = dr["VenueName"].ToString();
_eventVenueModel.StreetAddress = dr["StreetAddress"].ToString();
_eventVenueModel.City = dr["City"].ToString();
_eventVenueModel.StateProvision = dr["StateProvision"].ToString();
_eventVenueModel.ZipCode = dr["ZipCode"].ToString();
}
}
}
return _eventVenueModel;
}
catch (Exception ex)
{
throw ex;
}
}
protected void GetVenueEventDetails()
{
try
{
EventVenueViewModel _eventVenueViewModel = new EventVenueViewModel();
EventVenueModel _eventVenueModel = new EventVenueModel();
_eventVenueModel = _eventVenueViewModel.GetEventVenueModelDetails(EID);
if (_eventVenueModel != null)
{
EvtImage.Src = _eventVenueModel.EventImage;
lblEventName.Text = _eventVenueModel.EventName;
lblStreetAddress.Text = _eventVenueModel.StreetAddress;
lblCity.Text = _eventVenueModel.City;
lblState.Text = _eventVenueModel.StateProvision;
lblZip.Text = _eventVenueModel.ZipCode;
lblDateTime.Text = Convert.ToDateTime(_eventVenueModel.EventDate).ToString("dd/MMM/yyyy") + " " + Convert.ToDateTime(_eventVenueModel.EventFromTime).ToString("HH:mm");// +" - " + Convert.ToDateTime(_eventVenueModel.EventToTime).ToString("HH:mm"); //-kk
lblVenueName.Text = _eventVenueModel.VenueName;
}
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
}
}