public List <get_all_site_Result> PostAdminSite([FromBody] Admin admin)
{
List <get_all_site_Result> gSites = new List <get_all_site_Result>();
Authorization auth = new Authorization(admin.email);
var result = auth.service.Management.Profiles.List("~all", "~all");
try
{
var sites = result.Execute();
Dictionary <string, get_all_site_Result> dbSites = new Dictionary <string, get_all_site_Result>();
using (var data = new digimarketEntities1().get_all_site())
{
dbSites = data.ToDictionary(t => t.site_url, t => t);
}
foreach (var site in sites.Items)
{
if (!dbSites.ContainsKey(site.WebsiteUrl))
{
gSites.Add(new get_all_site_Result()
{
site_url = site.WebsiteUrl, site_name = site.Name, ga_id = site.Id, custom = false
});
}
}
}catch (Exception e)
{
}
return(gSites);
}
public List <PendingUsers> GetPending()
{
List <PendingUsers> resultUsers = new List <PendingUsers>();
List <get_pending_user_Result> pUsers = new List <get_pending_user_Result>();
using (var data = new digimarketEntities1().get_pending_user())
{
pUsers = data.ToList <get_pending_user_Result>();
}
foreach (var user in pUsers)
{
PendingUsers temp = new PendingUsers()
{
uid = user.uid, fullname = user.fullname, photourl = user.photourl, status = user.status, username = user.username, date = user.date, sources = new List <get_user_sources_Result>()
};
using (var data = new digimarketEntities1().get_user_sources(temp.uid))
{
temp.sources = data.ToList <get_user_sources_Result>();
}
resultUsers.Add(temp);
}
return(resultUsers);
}
public int Put_Notification([FromBody] Notification notification)
{
int result = 0;
IHubContext _hubs1 = GlobalHost.ConnectionManager.GetHubContext <NotificationHub>();
string uid;
using (var data = new digimarketEntities1().get_uid(notification.uid))
{
uid = data.FirstOrDefault <string>();
}
result = new digimarketEntities1().add_notification(notification.message, notification.category, uid, false, System.DateTime.Now);
List <get_notification_Result> notifications = new List <get_notification_Result>();
using (var data = new digimarketEntities1().get_notification())
{
notifications = data.ToList <get_notification_Result>();
}
_hubs1.Clients.All.broadcastData(notifications);
return(result);
}
public List <get_notification_Result> get_Notification()
{
List <get_notification_Result> notifications = new List <get_notification_Result>();
using (var data = new digimarketEntities1().get_notification())
{
notifications = data.ToList <get_notification_Result>();
}
return(notifications);
}
public admin_site_list PostAdmin([FromBody] admin_sign_in_Result admin)
{
try
{
int site_count = 0;
admin_site_list administrator = new admin_site_list();
int count = 0;
using (var data = new digimarketEntities1().admin_sign_in(admin.email))
{
count = data.Count <admin_sign_in_Result>();
}
if (count == 0)
{
Authorization authfirst = new Authorization(admin.email);
try
{
site_count = authfirst.service.Management.Profiles.List("~all", "~all").Execute().TotalResults.Value;
if (site_count == 0 || site_count.Equals(null))
{
return(null);
}
else
{
new digimarketEntities1().admin_sign_up(admin.email, admin.adminname, admin.photo_url);
}
}
catch (Exception ex)
{
return(null);
}
}
new digimarketEntities1().admin_update(admin.email, admin.adminname, admin.photo_url);
admin_sign_in_Result _admin = new digimarketEntities1().admin_sign_in(admin.email).ElementAt <admin_sign_in_Result>(0);
List <get_site_Result> sites = new List <get_site_Result>();
try {
foreach (get_site_Result site in new digimarketEntities1().get_site(_admin.email))
{
sites.Add(site);
}
}
catch (Exception e)
{ }
administrator.email = _admin.email;
administrator.adminname = _admin.adminname;
administrator.photo_url = _admin.photo_url;
administrator.sites = sites;
return(administrator);
}
catch (Exception e)
{
return(null);
}
}
public List <get_site_Result> DeleteAdminSite([FromBody] siteInput site_Result)
{
new digimarketEntities1().delete_site(site_Result.site_url, site_Result.email);
List <get_site_Result> AdminSites = new List <get_site_Result>();
using (var data = new digimarketEntities1().get_site(site_Result.email))
{
AdminSites = data.ToList <get_site_Result>();
}
return(AdminSites);
}
public List <get_site_Result> AddAdminSite([FromBody] siteInput site_Result)
{
new digimarketEntities1().add_site(site_Result.site_url, site_Result.site_name, site_Result.ga_id, site_Result.email, site_Result.custom);
List <get_site_Result> AdminSites = new List <get_site_Result>();
using (var data = new digimarketEntities1().get_site(site_Result.email))
{
AdminSites = data.ToList <get_site_Result>();
}
return(AdminSites);
}
public void Execute(IJobExecutionContext context)
{
if (PingNetwork())
{
get_all_site_Result[] siteResult;
using (var sites = new digimarketEntities1().get_all_site())
{
siteResult = sites.ToArray <get_all_site_Result>();
}
foreach (var site in siteResult)
{
DateTime date = DateTime.Now;
deleteExtra(site.site_url);
insertNew(site.site_url);
DateTime date2 = DateTime.Now;
}
}
}
public Dictionary <string, RealtimeModel> statistics()
{
List <getAllUser_Result> users = new List <getAllUser_Result>();
digimarketEntities1 db = new digimarketEntities1();
using (var data = db.getAllUser())
{
users = data.ToList <getAllUser_Result>();
}
Dictionary <string, RealtimeModel> realtimeList = new Dictionary <string, RealtimeModel>();
foreach (var user in users)
{
TrafficController trafficController = new TrafficController();
//List < List < UserStats >> total_stats = new List<List<UserStats>>();
RealtimeModel final = new RealtimeModel()
{
total_traffic = 0, message = "BackEnd Task for" + user.fullname, country_stats = new List <CountryStat>()
};
List <get_user_traffic_Result> res = trafficController.get_all_sites(user.uid);
foreach (var item in res)
{
Authorization auth = new Authorization(item.email);
var result = auth.service.Data.Realtime.Get("ga:" + item.ga_id, "rt:activeUsers");
result.Dimensions = "rt:country";
result.Filters = "ga:campaign=@" + user.username;
try {
var response = result.Execute();
if (response.TotalResults != 0)
{
final.total_traffic = final.total_traffic + Int64.Parse(response.TotalsForAllResults["rt:activeUsers"]);
foreach (var row in response.Rows)
{
// UserStats temp = user_stats.Last<UserStats>();
CountryStat cStats = new CountryStat();
cStats = final.country_stats.FirstOrDefault(x => x.country == row[0]);
if (cStats == null)
{
cStats = new CountryStat()
{
country = row[0], sessions = Int64.Parse(row[1])
};
final.country_stats.Add(cStats);
}
else
{
final.country_stats.Remove(cStats);
cStats.sessions = cStats.sessions + Int64.Parse(row[1]);
final.country_stats.Add(cStats);
}
}
}
}
catch (Exception e)
{ }
}
realtimeList.Add(user.uid, final);
}
return(realtimeList);
}
public PaymentStats payment_details([FromBody] User user)
{
PaymentStats stats = new PaymentStats()
{
total_earned = 0, total_traffic = 0, available = 0, last_paid = 0, unpaid_traffic = 0
};
user_earned earned = new user_earned()
{
premium = 0, non_premium = 0
};
get_payment_Result last = new get_payment_Result();
DateTime joiningDate = new DateTime();
using (var join = new digimarketEntities1().get_joining_date(user.uid))
{
joiningDate = join.FirstOrDefault <get_joining_date_Result>().date;
}
user_traffic traffic = new TrafficController().UserSession(new DataModel.User_Analytic_Input()
{
uid = user.uid, from_date = new ArticleController().convertDate(joiningDate), to_date = new ArticleController().convertDate(DateTime.Now),
extra = user.username
});
using (var rate = new digimarketEntities1().get_rate("premium"))
{
earned.premium = earned.premium + ((traffic.premium * Decimal.ToDouble(rate.FirstOrDefault <get_rate_Result>().rate)) / 1000);
}
using (var rate = new digimarketEntities1().get_rate("non-premium"))
{
earned.non_premium = earned.non_premium + ((traffic.non_premium * Decimal.ToDouble(rate.FirstOrDefault <get_rate_Result>().rate)) / 1000);
}
stats.total_traffic = traffic.premium + traffic.non_premium;
stats.total_earned = earned.premium + earned.non_premium;
using (var history = new digimarketEntities1().get_payment(user.uid))
{
try {
last = history.OrderByDescending(m => m.payment_date).FirstOrDefault() ?? new get_payment_Result()
{
traffic = 0, amount = 0, uid = user.uid
};
}
catch (Exception ex)
{
}
}
stats.last_paid = Decimal.ToDouble(last.amount);
using (var history = new digimarketEntities1().get_total_earned(user.uid))
{
try
{
var result = history.FirstOrDefault <get_total_earned_Result>();
stats.available = stats.total_earned - Decimal.ToDouble(result.totalAmount ?? 0);
stats.unpaid_traffic = stats.total_traffic - Decimal.ToInt64(result.totalTraffic ?? 0);
}
catch (Exception ex)
{
}
}
return(stats);
}
