public ActionResult StationDashboard()
{
int stationID = int.Parse(Session["StationId"].ToString());
StationData data = new StationData();
data.Station = new station();
data.ProgramList = new List<Models.Programme>();
data.ProducerList = new List<UserProfile>();
//List<int> userids = db.webpages_Roles.Where(c => c.RoleId == 4).FirstOrDefault().UserProfiles.Select(x => x.UserId).ToList();
//var stattionusers = from r in db.StationUsers
// where userids.Contains((int)r.UserId)
// & r.StationId == stationID
// select r;
var z = db.webpages_Roles.Where(c => c.RoleId == 4).First().UserProfiles.ToList(); // all announcer userprofiles
var proUP = db.webpages_Roles.Where(c => c.RoleId == 3).First().UserProfiles.ToList(); // all producer userprofiles
var y = db.StationUsers.Where(v => v.StationId == stationID).Select(b => b.UserId).ToList();// all users list of station list int
data.AnnouncerList = z.Where(n => y.Contains(n.UserId)).ToList();
data.ProducerList = proUP.Where(n => y.Contains(n.UserId)).ToList();
station st = db.stations.Where(c => c.id == stationID).First();
data.Station = st;
List<Programme> plist = db.Programmes.Where(c => c.stationId == stationID).ToList();
foreach (var item in plist)
{
Models.Programme p = new Models.Programme { moto = item.moto, name = item.name, StationId = item.stationId.Value };
data.ProgramList.Add(p);
}
return View(data);
}
/// <summary>
/// Paparkan maklumat program pada page.
/// </summary>
protected void BindProgramme()
{
Models.Programme programme = null;
var programmeId = Request.QueryString["programmeId"];
if (programmeId != null)
{
// Dapatkan maklumat program
programme = GetProgramme(int.Parse(programmeId));
ProgrammeIdHidden.Value = programmeId;
}
// Dapatkan Id bagi template
var templateId = Request.QueryString["templateId"];
if (templateId == null)
{
// Jika tiada template yang ditentukan sediakan template kosong
SetEmptyTemplate();
return;
}
var template = GetTemplate(int.Parse(templateId));
BindTemplate(template);
if (template.ProgrammeId != null)
{
programme = GetProgramme((int)template.ProgrammeId);
}
if (programme == null)
{
return;
}
ProgrammeLiteral.Text = programme.Code + " - " + programme.Name;
BackLink.NavigateUrl = "~/Pages/Programme/View.aspx?Id=" + programme.Id;
}