public static int GetCount()
{
using (var db = new dbContainer())
{
var models = from i in db.tblDevices
select i;
return models.Count();
}
}
public static void Edit(Customer model)
{
using (var db = new dbContainer())
{
var customer = Mapper.Map<Customer, tblCustomers>(model);
db.Entry(customer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public static void Create(Application model)
{
using (var db = new dbContainer())
{
var application = Mapper.Map<Application, tblApplications>(model);
db.tblApplications.Add(application);
db.SaveChanges();
}
}
public static int GetCount()
{
using (var db = new dbContainer())
{
var count = from i in db.tblApplications
select i;
return count.Count();
}
}
public static List<Device> Get()
{
using (var db = new dbContainer())
{
var models = from i in db.tblDevices
select i;
return Mapper.Map<List<tblDevices>, List<Device>>(models.ToList());;
}
}
public static List<Customer> GetPagination(int itemPerPage = 0, int pageNumber = 1)
{
using (var db = new dbContainer())
{
var models = from i in db.tblCustomers
select i;
return Mapper.Map<List<tblCustomers>, List<Customer>>(models.OrderBy(m => m.customerId).Skip(itemPerPage * (pageNumber - 1)).Take(itemPerPage).ToList());
}
}
public static List<Customer> Get()
{
using (var db = new dbContainer())
{
var models = from i in db.tblCustomers
select i;
return Mapper.Map<List<tblCustomers>, List<Customer>>(models.ToList());
}
}
public static int GetCount()
{
using (var db = new dbContainer())
{
var count = from i in db.tblCrashReports
select i;
return count.Count();
}
}
public static List<Lib.Models.OperatingSystem> Get()
{
using (var db = new dbContainer())
{
var models = from i in db.tblOperatingSystems
select i;
return Mapper.Map<List<tblOperatingSystems>, List<Lib.Models.OperatingSystem>>(models.ToList());
}
}
public static List<CrashReport> Get()
{
using (var db = new dbContainer())
{
var models = from i in db.tblCrashReports
select i;
return Mapper.Map<List<tblCrashReports>, List<CrashReport>>(models.ToList());
}
}
public static List<Application> Get(int itemPerPage, int pageNumber = 1)
{
using (var db = new dbContainer())
{
var models = from i in db.tblApplications
select i;
return Mapper.Map<List<tblApplications>, List<Application>>(models.OrderBy(m=>m.name).Skip(itemPerPage * (pageNumber-1)).Take(itemPerPage).ToList());
}
}
public static Application AddMessage(MessageViewModel VMMessage)
{
using (var db = new dbContainer())
{
var application = db.tblApplications.Find(VMMessage.tblApplications_applicationId);
tblMessages msg = Mapper.Map<MessageViewModel, tblMessages>(VMMessage);
application.tblMessages.Add(msg);
db.SaveChanges();
return Mapper.Map<tblApplications, Application>(application);
}
}
public static void Create(Customer model)
{
using (var db = new dbContainer())
{
var customer = Mapper.Map<Customer, tblCustomers>(model);
customer.dateCreated = DateTime.Now;
db.tblCustomers.Add(customer);
db.SaveChanges();
}
}
public static List<Device> GetDevicesInRecentDate(int daysAgo)
{
daysAgo = daysAgo * -1;
using (var db = new dbContainer())
{
var dateweekago = DateTime.Now.AddDays(-7);
var models = from d in db.tblDevices
where d.insertDate > dateweekago
select d;
return Mapper.Map<List<tblDevices>, List<Device>>(models.ToList()); ;
}
}
public static Application GetDetails(int id = 0)
{
using (var db = new dbContainer())
{
var models = from a in db.tblApplications
where a.applicationId == id
select a;
//Result
tblApplications result = models.FirstOrDefault();
//mappen
return Mapper.Map<tblApplications, Application>(result);
}
}
public static Customer Delete(int customerId)
{
using (var db = new dbContainer())
{
var dbCustomer = (from c in db.tblCustomers where c.customerId == customerId select c).FirstOrDefault();
var customer = Mapper.Map<tblCustomers, Customer>(dbCustomer);
if (dbCustomer != null)
{
db.tblCustomers.Remove(dbCustomer);
db.SaveChanges();
}
return customer;
}
}
public static Customer GetDetails(int? id)
{
if (id.HasValue)
{
using (var db = new dbContainer())
{
var models = from c in db.tblCustomers
where c.customerId == id
select c;
var result = models.FirstOrDefault();
return Mapper.Map<tblCustomers, Customer>(result);
}
}
return null;
}
public static List<PopularViewModel> GetPopularApps(int limit)
{
using (var db = new dbContainer())
{
var models = (from a in db.tblApplications
join d in db.tblDevices on a.applicationId equals d.tblApplications_applicationId
group a by new {a.applicationId, a.name} into popular
select new PopularViewModel
{
applicationId = popular.Key.applicationId,
applicationName = popular.Key.name,
devices = popular.Count()
});
return models.Take(limit).ToList();
}
}
public static List<OSViewModel> GetStatistics()
{
// select tblOperatingSystems.name, COUNT(*) as counter from tblApplications JOIN tblOperatingSystems on tblApplications.tblOperatingSystems_operatingSystemId = tblOperatingSystems.operatingSystemId group by tblOperatingSystems.name
using (var db = new dbContainer())
{
var models = (from a in db.tblApplications
join d in db.tblOperatingSystems on a.tblOperatingSystems_operatingSystemId equals d.operatingSystemId
group a by d.name into OS
select new OSViewModel
{
name = OS.Key,
counter = OS.Count()
});
return models.ToList();
}
}
public static Application Delete(int appId)
{
using (var db = new dbContainer())
{
var dbApplication = (from i in db.tblApplications where i.applicationId == appId select i).FirstOrDefault();
var application = Mapper.Map<tblApplications, Application>(dbApplication);
if (dbApplication != null)
{
db.tblApplications.Remove(dbApplication);
db.SaveChanges();
}
return application;
}
}
public static List<Application> GetSearch(string searchtag)
{
using(var db = new dbContainer()) {
var dbApplications = (from a in db.tblApplications where a.name.Contains(searchtag) select a).ToList();
return Mapper.Map<List<tblApplications>, List<Application>>(dbApplications);
}
}
public static Counter GetProgramStatistics()
{
using (var db = new dbContainer())
{
var models = from c in db.tblCounts
select c;
//result
tblCounts result = models.FirstOrDefault();
return Mapper.Map<tblCounts, Counter>(result);
}
}
