public List <FollowingTO> GetFollowingForId(int id)
{
List <FollowingTO> followingTOs = new List <FollowingTO>();
// FollowingTO to2 = new FollowingTO { id = 234, followedId = 22, followedUsername = "******", rating = 6 };
// FollowingTO to3 = new FollowingTO { id = 345, followedId = 33, followedUsername = "******", rating = 7 };
using (var db = new WamAppEntities1())
{
var fs = from f in db.Followings
where f.followerId == id
select f;
foreach (var ff in fs)
{
FollowingTO to = new FollowingTO
{
followedId = ff.followedId.Value,
followedUsername = ff.followedUsername
};
followingTOs.Add(to);
}
}
// followingTOs.Add(to2);
// followingTOs.Add(to3);
return(followingTOs);
}
public List <WidgetTO> GetWidgetsForPage(int pageId)
{
List <WidgetTO> widgetTOs = new List <WidgetTO>();
using (var db = new WamAppEntities1())
{
var widgets = from w in db.Widgets
orderby w.order
where w.pageId == pageId
select w;
foreach (var widget in widgets)
{
WidgetTO widgetTO = new WidgetTO {
id = widget.Id,
name = widget.name,
pageId = widget.pageId.Value,
widgetType = widget.widgetType,
url = widget.url,
href = widget.href,
src = widget.src,
html = widget.html,
style = widget.style,
cssClass = widget.cssClass,
width = widget.width.Value,
height = widget.height.Value,
value = widget.value
};
widgetTOs.Add(widgetTO);
}
}
return(widgetTOs);
}
// GET api/<controller>
public List <DeveloperTO> GetAllDevelopers()
{
List <DeveloperTO> developers = new List <DeveloperTO>();
using (var db = new WamAppEntities1())
{
var devs = from d in db.Developers select d;
foreach (Developer d in devs)
{
DeveloperTO dev = new DeveloperTO {
id = d.Id, password = d.password, username = d.username
};
developers.Add(dev);
}
}
/*
* DeveloperTO d1 = new DeveloperTO { id=123, username = "******", password = "******" };
* DeveloperTO d2 = new DeveloperTO { id=234, username = "******", password = "******" };
* DeveloperTO d3 = new DeveloperTO { id=345, username = "******", password = "******" };
*
* developers.Add(d1);
* developers.Add(d2);
* developers.Add(d3);
* */
return(developers);
}
public WidgetTO GetWidgets(int widgetId)
{
using (var db = new WamAppEntities1())
{
Widget widget = db.Widgets.Find(widgetId);
WidgetTO wto = new WidgetTO
{
id = widget.Id,
name = widget.name,
pageId = widget.pageId.Value,
widgetType = widget.widgetType,
url = widget.url,
href = widget.href,
src = widget.src,
html = widget.html,
style = widget.style,
cssClass = widget.cssClass,
width = widget.width.Value,
height = widget.height.Value,
value = widget.value,
order = widget.order.Value,
label = widget.label,
data = widget.data,
content = widget.content
};
return(wto);
}
}
// DELETE api/<controller>/5
public int DeleteDeveloper(int id)
{
using (var db = new WamAppEntities1())
{
Developer dev = db.Developers.Find(id);
db.Developers.Remove(dev);
db.SaveChanges();
}
return(id);
}
// PUT api/<controller>/5
public string PutDeveloper(int id, DeveloperTO developer)
{
using (var db = new WamAppEntities1())
{
Developer dev = db.Developers.Find(id);
dev.password = developer.password;
db.SaveChanges();
}
return(developer.username + " " + id);
}
// POST api/<controller>
public string PostDeveloper(DeveloperTO developer)
{
using (var db = new WamAppEntities1())
{
Developer newDeveloper = new Developer();
newDeveloper.username = developer.username;
newDeveloper.password = developer.password;
db.Developers.Add(newDeveloper);
db.SaveChanges();
}
return(developer.username);
}
public void DeleteWidgets(int id)
{
using (var db = new WamAppEntities1())
{
Widget widget = db.Widgets.Find(id);
if (widget != null)
{
db.Widgets.Remove(widget);
db.SaveChanges();
}
}
}
// GET api/<controller>/5
public DeveloperTO GetDeveloper(int id)
{
DeveloperTO d4 = null;// new DeveloperTO { id = id, username = "******" + id, password = "******" };
using (var db = new WamAppEntities1())
{
Developer dev = db.Developers.Find(id);
d4 = new DeveloperTO {
id = dev.Id, username = dev.username, password = dev.password
};
}
return(d4);
}
public List <ApplicationTO> GetAllApplications()
{
List <ApplicationTO> applicationTOs = new List <ApplicationTO>();
using (var db = new WamAppEntities1())
{
var applications = from a in db.Applications select a;
foreach (Application app in applications)
{
ApplicationTO appTO = new ApplicationTO {
id = app.Id, name = app.name
};
applicationTOs.Add(appTO);
}
}
return(applicationTOs);
}
public void PutWidgets(WidgetTO widgetTO)
{
using (var db = new WamAppEntities1())
{
Widget widget = db.Widgets.Find(widgetTO.id);
widget.name = widgetTO.name;
widget.width = widgetTO.width;
widget.height = widgetTO.height;
widget.order = widgetTO.order;
widget.label = widgetTO.label;
widget.html = widgetTO.html;
widget.value = widgetTO.value;
widget.style = widgetTO.style;
widget.content = widgetTO.content;
widget.data = widgetTO.data;
if (widgetTO.order != widget.order.Value)
{
int min = Math.Min(widget.order.Value, widgetTO.order);
int max = Math.Max(widget.order.Value, widgetTO.order);
var widgets = from w in db.Widgets
where w.order >= min &&
w.order <= max
select w;
if (widgetTO.order > widget.order.Value)
{
foreach (var wid in widgets)
{
wid.order--;
}
}
else
{
foreach (var wid in widgets)
{
wid.order++;
}
}
widget.order = widgetTO.order;
}
db.SaveChanges();
}
}
public List <PageTO> GetPagesForApplication(int application)
{
List <PageTO> pageTOs = new List <PageTO>();
using (var db = new WamAppEntities1())
{
var pages = from p in db.Pages
where p.applicationId == application
select p;
foreach (var page in pages)
{
PageTO pageTO = new PageTO {
id = page.Id, name = page.name
};
pageTOs.Add(pageTO);
}
}
return(pageTOs);
}
public DeveloperTO GetDeveloperByUsernameAndPassword(string username, string password)
{
DeveloperTO d5 = null;
using (var db = new WamAppEntities1())
{
var devs = from d in db.Developers where d.username == username && d.password == password select d;
Developer dd = devs.FirstOrDefault();
if (dd != null)
{
d5 = new DeveloperTO {
id = dd.Id, password = dd.password, username = dd.username
}
}
;
}
return(d5);
}
public List <ApplicationTO> GetApplicationsForUsername(string username)
{
List <ApplicationTO> applicationTOs = new List <ApplicationTO>();
using (var db = new WamAppEntities1())
{
var applications = from a in db.Applications
join d in db.Developers
on a.userId equals d.Id
where d.username == username
select a;
foreach (Application app in applications)
{
ApplicationTO appTO = new ApplicationTO {
id = app.Id, name = app.name
};
applicationTOs.Add(appTO);
}
}
return(applicationTOs);
}
// actually this is not a get, should be a post.
// creates new widget for pageId
public void GetWidgetForPage(int pageId, string widgetType, int order)
{
widgetType = widgetType.ToUpper();
using (var db = new WamAppEntities1())
{
Widget widget = new Widget();
widget.name = "Widget Name";
widget.pageId = pageId;
widget.widgetType = widgetType;
widget.height = 0;
widget.width = 0;
widget.src = "";
widget.order = order;
widget.href = "";
widget.html = "";
widget.value = "";
widget.style = "";
widget.cssClass = "";
db.Widgets.Add(widget);
db.SaveChanges();
}
}
