public List <DTO_OpenDraw> CreateDraw(DTO_NewDraw draw)
{
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
List <DTO_OpenDraw> openDrawList = new List <DTO_OpenDraw>();
DTO_OpenDraw openDraw = new DTO_OpenDraw();
int? temp = 1;
draws sqlobj = new draws();
sqlobj.CategoryID = draw.DrawCategoryID;
sqlobj.DoodlerUserID = draw.DoodlerID;
sqlobj.Answer = draw.Answer;
sqlobj.DrawStatusID = temp;
sqlobj.StartTime = draw.StartTime;
sqlobj.EndTime = System.DateTime.Now;
db.draws.Add(sqlobj);
db.SaveChanges();
int temp2 = 1;
openDraw.DrawID = sqlobj.DrawID;
//openDraw.Doodler = db.users.Where(c => c.UserID.Equals(draw.DoodlerID)).FirstOrDefault().DisplayName;
//openDraw.DrawStatusDesc = db.drawStatus.Where(c => c.DrawStatusID.Equals(temp2)).FirstOrDefault().DrawStatusDesc;
//openDraw.DrawCategoryName = db.drawCategories.Where(c => c.DrawCategoryID.Equals(draw.DrawCategoryID)).FirstOrDefault().DrawCategoryName;
openDraw.Doodler = "Test Doodler";
openDraw.DrawStatusDesc = "Test DrawStatusDesc";
openDraw.DrawCategoryName = "Test DrawCategoryName";
openDraw.StartTime = System.DateTime.Now;
openDrawList.Add(openDraw);
return(openDrawList);
}
}
public List <DTO_User> AddUser(DTO_User user)
{
List <DTO_User> users = new List <DTO_User>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
var sqllist = db.users.Where(c => c.Email == user.EmailAddress).ToList();
if (sqllist.Count == 0)
{
user sqlobj = new user();
sqlobj.UserID = user.ID;
sqlobj.DisplayName = user.DisplayName;
sqlobj.Email = user.EmailAddress;
sqlobj.Password = user.Password;
sqlobj.Picture = user.Picture;
sqlobj.Active = true;
db.users.Add(sqlobj);
users.Add(user);
db.SaveChanges();
}
else
{
users.Clear();
}
return(users);
}
}
public List <DTO_DrawPoints> GetLinePoints(DTO_DrawID d)
{
List <DTO_DrawPoints> dp = new List <DTO_DrawPoints>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
var list = db.drawPoints.Where(c => c.DrawID == d.DrawID).ToList();
foreach (var record in list)
{
DTO_DrawPoints dpo = new DTO_DrawPoints();
dpo.DrawID = record.DrawID.Value;
dpo.DrawPointID = record.DrawPointID;
dpo.DrawPointX = record.DrawPointX.Value;
dpo.DrawPointX2 = record.DrawPointX2.Value;
dpo.DrawPointY = record.DrawPointY.Value;
dpo.DrawPointY2 = record.DrawPointY2.Value;
dp.Add(dpo);
break;
}
}
return(dp);
}
public List <DTO_DrawID> EndDraw(DTO_DrawID drawid)
{
List <DTO_DrawID> list = new List <DTO_DrawID>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
int temp = 3;
db.draws.Where(c => c.DrawID.Equals(drawid.DrawID)).FirstOrDefault().DrawStatusID = temp;
db.SaveChanges();
}
list.Add(drawid);
return(list);
}
public List <DTO_OpenDraw> StartDraw(DTO_OpenDraw draw)
{
List <DTO_OpenDraw> list = new List <DTO_OpenDraw>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
int?temp = 2;
db.draws.Where(c => c.DrawID == draw.DrawID).FirstOrDefault().DrawStatusID = temp;
db.SaveChanges();
}
list.Add(draw);
return(list);
}
public List <DTO_LineCount> GetLineCount(DTO_DrawID drawid)
{
List <DTO_LineCount> list = new List <DTO_LineCount>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
int lc = db.drawPoints.Where(c => c.DrawID == drawid.DrawID).Count();
DTO_LineCount o = new DTO_LineCount();
o.lineCount = lc;
list.Add(o);
return(list);
}
}
public List <DTO_DrawPoints> ClearDrawPoints(DTO_DrawID drawID)
{
List <DTO_DrawPoints> drawpointlist = new List <DTO_DrawPoints>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
var points = db.drawPoints.Where(c => c.DrawID == drawID.DrawID).ToList();
foreach (var s in points)
{
db.drawPoints.Remove(s);
}
db.SaveChanges();
}
return(drawpointlist);
}
public List <DTO_GameStatus> GetGameStatuses()
{
List <DTO_GameStatus> list = new List <DTO_GameStatus>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
var sqllist = db.drawStatus.ToList();
foreach (var s in sqllist)
{
DTO_GameStatus gameStatus = new DTO_GameStatus();
gameStatus.GameStatusID = s.DrawStatusID;
gameStatus.GameStatusDesc = s.DrawStatusDesc;
list.Add(gameStatus);
}
return(list);
}
}
public List <DTO_GameCategory> GetDrawCategories()
{
List <DTO_GameCategory> list = new List <DTO_GameCategory>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
var sqllist = db.drawCategories.ToList();
foreach (var s in sqllist)
{
DTO_GameCategory gamecategory = new DTO_GameCategory();
gamecategory.CategoryID = s.DrawCategoryID;
gamecategory.CategoryName = s.DrawCategoryName;
list.Add(gamecategory);
}
return(list);
}
}
public List <DTO_DrawPoints> PushLine(DTO_DrawPoints lineSegment)
{
List <DTO_DrawPoints> ret = new List <DTO_DrawPoints>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
drawPoint dp = new drawPoint();
dp.DrawID = lineSegment.DrawID;
dp.DrawPointX = lineSegment.DrawPointX;
dp.DrawPointY = lineSegment.DrawPointY;
dp.DrawPointX2 = lineSegment.DrawPointX2;
dp.DrawPointY2 = lineSegment.DrawPointY2;
db.drawPoints.Add(dp);
db.SaveChanges();
}
return(ret);
}
public List <DTO_JoinDraw> JoinDraw(DTO_JoinDraw join)
{
List <DTO_JoinDraw> joinlist = new List <DTO_JoinDraw>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
noodler sqlobj = new noodler();
sqlobj.DrawID = join.DrawID;
sqlobj.UserID = join.UserID;
sqlobj.Winner = false;
db.noodlers.Add(sqlobj);
db.SaveChanges();
var sqlrecord = db.noodlers.Where(c => c.UserID == join.UserID).FirstOrDefault();
join.NoodlerID = sqlrecord.DrawNoodlerID;
joinlist.Add(join);
}
return(joinlist);
}
public List <DTO_Guess> CheckGuess(DTO_Guess guess)
{
List <DTO_Guess> list = new List <DTO_Guess>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
var record = db.draws.Where(c => c.DrawID == guess.DrawID).FirstOrDefault();
if (guess.Guess == record.Answer)
{
guess.IsCorrect = true;
}
else
{
guess.IsCorrect = false;
}
}
list.Add(guess);
return(list);
}
public List <DTO_Winner> SetWinner(DTO_Winner winner)
{
List <DTO_Winner> list = new List <DTO_Winner>();
DTO_Winner win = new DTO_Winner();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
//db.users.Find(u.ID).Active = true;
var obj = db.noodlers.Where(c => c.DrawNoodlerID == winner.NoodlerID).FirstOrDefault();
if (obj != null)
{
obj.Winner = true;
db.SaveChanges();
}
}
list.Add(win);
return(list);
}
public List <DTO_User> Login(DTO_Login login)
{
List <DTO_User> users = new List <DTO_User>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
var sqllist = db.users.Where(c => c.Email.ToLower() == login.Email.ToLower() &&
c.Password == login.Password).ToList();
foreach (var s in sqllist)
{
DTO_User u = new DTO_User();
u.DisplayName = s.DisplayName;
if (s.Active.HasValue)
{
u.Active = s.Active.Value;
}
u.EmailAddress = s.Email;
u.ID = s.UserID;
u.Password = s.Password;
u.Picture = s.Picture;
users.Add(u);
}
if (sqllist.Count == 1)
{
userLogin sqlobj = new userLogin();
sqlobj.UserID = sqllist[0].UserID;
sqlobj.Latitude = login.Latitude;
sqlobj.Longitude = login.Longitude;
sqlobj.LoginDateTime = System.DateTime.Now;
db.userLogins.Add(sqlobj);
db.users.Find(users[0].ID).Active = true;
db.SaveChanges();
}
else
{
users.Clear();
}
}
return(users);
}
public DTO_User GetDoodleUser(DTO_User uo)
{
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
var record = db.users.Where(c => c.UserID == uo.ID).FirstOrDefault();
if (record != null)
{
uo.Active = record.Active.Value;
uo.DisplayName = record.DisplayName;
uo.EmailAddress = record.Email;
uo.ID = record.UserID;
uo.Password = record.Password;
uo.Picture = record.Picture;
return(uo);
}
else
{
return(uo);
}
}
}
public List <DTO_DrawPoints> GetDrawPoints(DTO_DrawID drawID)
{
List <DTO_DrawPoints> drawpointlist = new List <DTO_DrawPoints>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
var points = db.drawPoints.Where(c => c.DrawID == drawID.DrawID).ToList();
foreach (var s in points)
{
DTO_DrawPoints u = new DTO_DrawPoints();
u.DrawID = s.DrawID.Value;
u.DrawPointID = s.DrawPointID;
u.DrawPointX = s.DrawPointX.Value;
u.DrawPointY = s.DrawPointY.Value;
u.DrawPointX2 = s.DrawPointX2.Value;
u.DrawPointY2 = s.DrawPointY2.Value;
drawpointlist.Add(u);
}
}
return(drawpointlist);
}
public List <DTO_OpenDraw> GetOpenDraws(List <DTO_OpenDraw> list)
{
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
int temp = 2;
var sqllist = db.draws.Where(c => c.DrawStatusID.Value == temp).ToList();
foreach (var s in sqllist)
{
DTO_OpenDraw o = new DTO_OpenDraw();
o.Doodler = "Test Doodler";
o.DrawCategoryName = "Test DrawCategoryName";
o.DrawID = s.DrawID;
if (s.StartTime.HasValue)
{
o.StartTime = s.StartTime;
}
o.DrawStatusDesc = "Test DrawStatusDesc";
list.Add(o);
}
return(list);
}
}
public List <DTO_User> GetAllUsers(DTO_User user)
{
List <DTO_User> users = new List <DTO_User>();
using (DB_122744_doodleEntities db = new DB_122744_doodleEntities())
{
var sqllist = db.users.OrderBy(c => c.DisplayName).ToList();
foreach (var s in sqllist)
{
DTO_User u = new DTO_User();
u.DisplayName = s.DisplayName;
if (s.Active.HasValue)
{
u.Active = s.Active.Value;
}
u.EmailAddress = s.Email;
u.ID = s.UserID;
u.Password = s.Password;
u.Picture = s.Picture;
users.Add(u);
}
}
return(users);
}
