public ActionResult Index(int account, string session) { AppState.AccountID = account; AppState.SessionID = session; acc_id = AppState.AccountID; session_id = AppState.SessionID; Models.CampaignListModel m = new Models.CampaignListModel(); using (var client = OltpLogicClient.Open(session_id)) { if (client == null) { return(PartialView("~/Views/Shared/_SessionExpiredView.cshtml")); } Oltp.CampaignDataTable t = client.Service.Campaign_Get(acc_id, null, null, null, false); m.Statuses = client.Service.CampaignStatus_Get().ToDictionary(x => x.ID, x => x.Name); m.Channels = client.Service.Channel_Get().ToDictionary(h => h.ID, h => h.DisplayName); foreach (Oltp.CampaignRow c in t) { m.Campaigns.Add(new Models.CampaignRowModel() { CampaignGK = c.GK, CampaignName = c.IsNameNull() ? "(no name)" : c.Name, Status = m.Statuses.ContainsKey(c.StatusID) ? m.Statuses[c.StatusID] : String.Format("Unknown ({0})", c.StatusID), ChannelName = m.Channels.ContainsKey(c.ChannelID) ? m.Channels[c.ChannelID] : String.Format("Unknown ({0})", c.ChannelID) }); } } return(View(m)); }
public PartialViewResult Find(FormCollection colls) { Models.CampaignListModel m = new Models.CampaignListModel(); using (var client = OltpLogicClient.Open(session_id)) { if (client == null) { return(PartialView("~/Views/Shared/_SessionExpiredView.cshtml")); } m.Statuses = client.Service.CampaignStatus_Get().ToDictionary(x => x.ID, x => x.Name); m.Channels = client.Service.Channel_Get().ToDictionary(h => h.ID, h => h.DisplayName); int? channelID = colls["Channel"] == "0" ? null : (int?)int.Parse(colls["Channel"]); int? statusID = colls["Status"] == "0" ? null : (int?)int.Parse(colls["Status"]); string textToSearch = colls["searchText"].Trim().Equals("") ? null : colls["searchText"].Trim() + "*"; bool filterByAdgroup = colls["typeOfSearch"] == "adgroup"; Oltp.CampaignDataTable t = client.Service.Campaign_Get(acc_id, channelID, statusID, textToSearch, filterByAdgroup); foreach (Oltp.CampaignRow c in t) { m.Campaigns.Add(new Models.CampaignRowModel() { CampaignGK = c.GK, CampaignName = c.Name, Status = m.Statuses[c.StatusID], ChannelName = m.Channels[c.ChannelID] }); } DataTable targets = client.Service.CampaignTargets_Get(acc_id, null); Dictionary <long, Models.CampaignRowModel> dic = m.Campaigns.ToDictionary(q => q.CampaignGK, q => q); foreach (DataRow r in targets.Rows) { long campaignGK = (long)(int)r["CampaignGK"]; if (dic.ContainsKey(campaignGK)) { dic[campaignGK].CPA1 = r["CPA_new_users"] == DBNull.Value ? null : (double?)r["CPA_new_users"]; dic[campaignGK].CPA2 = r["CPA_new_activations"] == DBNull.Value ? null : (double?)r["CPA_new_activations"]; } } } return(PartialView("Table", m.Campaigns)); }
public ActionResult Index(int account, string session) { AppState.AccountID = account; AppState.SessionID = session == "" ? null : ""; acc_id = AppState.AccountID; session_id = AppState.SessionID; Models.CampaignListModel m = new Models.CampaignListModel(); using (var client = new OltpLogicClient(session_id)) { //Oltp.CampaignDataTable t = client.Service.Campaign_Get(acc_id, null, null, null, false); m.Statuses = client.Service.CampaignStatus_Get().ToDictionary(x => x.ID, x => x.Name); m.Channels = client.Service.Channel_Get().ToDictionary(h => h.ID, h => h.DisplayName); //foreach(Oltp.CampaignRow c in t) // m.Campaigns.Add(new Models.CampaignRowModel() { CampaignGK = c.GK, CampaignName = c.Name, Status = m.Statuses[c.StatusID], ChannelName = m.Channels[c.ChannelID] }); } return(View(m)); }