public ActionResult CourseDetails(int CID, int YID, string course)
{
var dataContext = new lb3dataDataContext();
var data = from c in dataContext.Holes
where c.CourseID == CID
where c.YearID == YID
orderby c.HoleNum ascending
select c;
var data_group = from c in dataContext.Groups
where c.CourseID == CID
where c.YearID == YID
//orderby u.Timestamp descending
select c;
var year = (from y in dataContext.Years
where y.YID == YID
select y).First().Year1.ToString();
ViewData["Course"] = course;
ViewData["Year"] = year;
ViewData["Holes"] = data;
ViewData["Groups"] = data_group;
ViewData["CourseID"] = CID;
ViewData["YID"] = YID;
//topqa_ad.Union(topqa.Take(5 - admin_ct)).OrderBy(t => t.Marks.First().Timestamp);
return View("CourseDetails");
}
public ActionResult CourseCard(int CID, int YID, string course, int GID)
{
var dataContext = new lb3dataDataContext();
var year = (from y in dataContext.Years
where y.YID == YID
select y).First().Year1.ToString();
ViewData["Course"] = course;
ViewData["Year"] = year;
var data = from c in dataContext.UserGroups
where c.GID == GID
//orderby u.Timestamp descending
select c;
var hole_data = from c in dataContext.Courses
where c.CID == CID
where c.YID == YID
//orderby u.Timestamp descending
select c;
ViewData["Card"] = data;
ViewData["holes"] = hole_data;
return View("CourseCard");
}
public ActionResult AddTourn()
{
var dataContext = new lb3dataDataContext();
var data = from c in dataContext.UserGroups
where c.UserID == 2
orderby c.Group.Year.Name ascending
select c;
return View();
}
public IEnumerable<Hole> GetHolesForCoursess(int CID, int YID)
{
var dataContext = new lb3dataDataContext();
var comment = from a in dataContext.Holes
where a.CourseID == CID
where a.YearID == YID
select a;
return (comment);
}
//view course ua holes +
public ActionResult AddCourseUAholes(int id, string CourseName)
{
var dataContext = new lb3dataDataContext();
var data = from c in dataContext.HoleUAs
where c.CourseUAID == id
orderby c.HoleNum ascending
select c;
ViewData["Holes"] = data;
ViewData["CourseName"] = CourseName;
ViewData["UAHoles"] = data;
ViewData["CUAID"] = id;
return View("AddCourseUAholes");
}
public int checkScore(int HoleID, int YID, int UserID)
{
var dataContext = new lb3dataDataContext();
var comment = from a in dataContext.Scores
where a.HoleID == HoleID
where a.YearID == YID
where a.UserID == UserID
select a;
var next = from a in dataContext.Scores
where a.HoleID == (HoleID - 1)
where a.YearID == YID
where a.UserID == UserID
select a;
var score = 0;
try
{
//hole has a score
score = Convert.ToInt32(comment.First().Score1);
}
catch
{
try
{
score = Convert.ToInt32(next.First().Score1);
if (score > 0)
{
score = 0;
}
}
catch
{
score = -1;
}
}
return score;
}
public ActionResult Hole(int YID, int CID, int GID, string course)
{
var dataContext = new lb3dataDataContext();
var year = (from y in dataContext.Years
where y.YID == YID
select y).First().Year1.ToString();
var group = from c in dataContext.Groups
where c.GID == GID
select c;
var data = from c in dataContext.Holes
where c.CourseID == CID
where c.YearID == YID
select c;
var holedataJ = from c in dataContext.Holes
where c.CourseID == CID
where c.YearID == YID
select new
{
HoleID = c.HoleID,
HoleNum = c.HoleNum,
HolePin = c.N_pin,
HoleLD = c.L_drive,
Par = c.Par
//Scre = (from s in dataContext.Scores where s.HoleID == c.HoleID && s.UserID == user
};
var scoredataJ = from c in dataContext.Scores
where c.YearID == YID
select new
{
UserID = c.UserID,
Score = c.Score1,
HID = c.HoleID,
ScoreID = c.ScID
};
var grouplistJ = from y in db.UserGroups
where y.GID == GID
select new
{
Nickname = y.User.Nickname,
UserID = y.UserID
};
var grouplist = from y in db.UserGroups
where y.GID == GID
select new
{
name = y.User.Nickname
};
var gplist = "";
int gpint = 0;
System.Collections.Generic.List<string> UserArray = new System.Collections.Generic.List<string>();
foreach (var sc in grouplist)
{
//UserArray.Add(sc.name);
//UserArray.Add(Convert.ToString(sc.userid));
if (gpint == (grouplist.Count() -1))
{
gplist = gplist + " and " + sc.name;
}
else if (gpint == 0)
{
gplist = sc.name;
}
else
{
gplist = gplist + ", " + sc.name;
}
gpint++;
}
var nexthole = from h in dataContext.Holes
where h.HoleNum == 1
where h.YearID == YID
where h.CourseID == CID
select h;
var NextHoleID = nexthole.First().HoleID;
string jsonUsers = JsonConvert.SerializeObject(grouplistJ.ToArray());
string jsonHoleData = JsonConvert.SerializeObject(holedataJ.ToArray());
string jsonScoreData = JsonConvert.SerializeObject(scoredataJ.ToArray());
ViewData["YearID"] = YID;
ViewData["Year"] = year;
ViewData["GID"] = GID;
ViewData["CID"] = CID;
ViewData["course"] = course;
ViewData["Group"] = group.First().GroupName;
ViewData["GroupCount"] = grouplist.Count();
ViewData["names"] = gplist;
ViewData["NextHoleID"] = NextHoleID;
ViewData["HoleCount"] = data.Count();
ViewData["JSONnames"] = jsonUsers;
ViewData["JSONHoleData"] = jsonHoleData;
ViewData["JSONScoreData"] = jsonScoreData;
return View("Hole", data);
}
public ActionResult CourseDetails(FormCollection formCollection)
{
var dataContext = new lb3dataDataContext();
int UACourseID = Convert.ToInt32(formCollection["UACourseID"]);
var TournName = formCollection["tname"];
var CourseName = formCollection["CourseName"];
int OwnerID = Convert.ToInt32(formCollection["OwnerID"]);
int ST = 5;
DateTime Date = DateTime.Today;//Convert.ToDateTime(formCollection["Date"]);
int Yr = Date.Year;
int YID = dataRepository.SaveNewYear(TournName, Date, Yr, OwnerID);
int CID = dataRepository.SaveNewTournCourse(CourseName, YID, ST);
var holeList = (from u in dataContext.HoleUAs
where u.CourseUAID == UACourseID
orderby u.HoleNum ascending
select new
{
holenum = u.HoleNum,
par = u.Par,
SIndx = u.SI,
}).ToArray();
foreach (var item in holeList)
{
var Pin = formCollection["pin"];
var LD = formCollection["drive"];
//Pin = pin_1
var PinID = "pin_" + item.holenum;
var LDID = "drive_" + item.holenum;
//var LD = formCollection[LDID];
//var Pin = formCollection[PinID];
int LDval = 0;
int Pinval = 0;
if (LD == LDID)
{
LDval = 1;
}
if (Pin == PinID)
{
Pinval = 1;
}
dataRepository.SaveNewHole(CID, YID, item.holenum, item.par, Pinval, LDval, item.SIndx);
}
var data = from c in dataContext.Holes
where c.CourseID == CID
where c.YearID == YID
orderby c.HoleNum ascending
select c;
var data_group = from c in dataContext.Groups
where c.CourseID == CID
where c.YearID == YID
//orderby u.Timestamp descending
select c;
var year = (from y in dataContext.Years
where y.YID == YID
select y).First().Year1.ToString();
ViewData["Course"] = CourseName;
ViewData["Year"] = year;
ViewData["Holes"] = data;
ViewData["Groups"] = data_group;
ViewData["CourseID"] = CID;
ViewData["CID"] = CID;
ViewData["YID"] = YID;
ViewData["Tname"] = TournName;
ViewData["Date"] = Date;
var userList = (from u in dataContext.Users
orderby u.Name ascending
select new
{
name = u.Name,
id = u.UserID,
}).ToArray();
var dd_items = "";
dd_items = "<option>Select User</option>";
foreach (var item in userList)
{
dd_items = dd_items + "<option value=" + item.id + ">" + item.name + "</option>";
}
ViewData["dd_vals"] = dd_items;
return RedirectToAction("MyTourn", new { UserID = OwnerID });
//return View("CourseDetails");
}
public ActionResult MyTourn(int UserID)
{
var dataContext = new lb3dataDataContext();
var data = from c in dataContext.Years
where c.OwnerID == UserID
//orderby c.Group.Year.Name ascending
select c;
return View("MyTourn", data);
}
//public ActionResult HolePartialEdit(int HoleID)
// {
// var dataContext = new lb3dataDataContext();
// Hole hole = dataRepository.GetHole(HoleID);
// return PartialView("HolePartialEdit", hole);
// }
public PartialViewResult HoleUAPartialNew(int CUAID)
{
var dataContext = new lb3dataDataContext();
int next = 1;
try
{
var data = from c in dataContext.HoleUAs
orderby c.HoleNum descending
where c.CourseUAID == CUAID
select c;
next = Convert.ToInt32(data.First().HoleNum) + 1;
}
catch
{
}
//Hole hole = dataRepository.GetHole(HoleID);
ViewData["CUAID"] = CUAID;
ViewData["NextNum"] = next;
return PartialView("HoleUAPartialNew");
}
public ActionResult Login()
{
var dataContext = new lb3dataDataContext();
var userList = from u in dataContext.Users
orderby u.Name ascending
select u;
return View("Login", userList);
}
public ActionResult getAllEvents()
{
var dataContext = new lb3dataDataContext();
var allevents = from e in dataContext.Events
orderby e.Timestamp descending
select new
{
UserID = e.UserID,
Comment = e.Comment,
Name = e.Name,
Timest = Convert.ToDateTime(e.Timestamp).ToShortTimeString(),
EID = e.EID,
type = e.Type
};
return Json(new { events = allevents });
}
public ActionResult getLatestEvents(int EID)
{
var dataContext = new lb3dataDataContext();
// if (EID > 0) //not first load
// {
var allevents = from e in dataContext.Events
orderby e.Timestamp ascending
where e.EID > EID
select new
{
UserID = e.UserID,
Comment = e.Comment,
Name = e.Name,
Timest = Convert.ToDateTime(e.Timestamp).ToShortTimeString(),
EID = e.EID,
type = e.Type
};
var speech_item = from e in dataContext.Events
orderby e.Timestamp descending
where e.EID > EID && e.Speech != null
select new
{
speech = e.Speech
};
// if (allevents.Count() > 0)
// {
return Json(new { events = allevents, speech = speech_item.Take(2) }, JsonRequestBehavior.AllowGet);
// }
// else
// {
// return Json(new { events = "none", speech = "none" }, JsonRequestBehavior.AllowGet);
// }
// }
// else
/// {
// return Json(new { events = "none" }, JsonRequestBehavior.AllowGet);
// }
}
//used
public ActionResult EventsFeed()
{
var dataContext = new lb3dataDataContext();
var allevents = from e in dataContext.Events
orderby e.Timestamp descending
select e;
return PartialView("EventsPartial", allevents.Take(1));
}
public PartialViewResult EventsPartial2()
{
var dataContext = new lb3dataDataContext();
var data = from c in dataContext.Events
//where c.CourseID == CID
orderby c.Timestamp descending
select c;
return PartialView("EventsPartial2", data.Take(1));
}
public ActionResult CourseUA()
{
var dataContext = new lb3dataDataContext();
var courseUA = from c in dataContext.CourseUAs
orderby c.CourseName
select c;
return View("CourseUA", courseUA);
}
public ActionResult CourseHolesView(int YID)
{
var dataContext = new lb3dataDataContext();
var year = (from y in dataContext.Years
where y.YID == YID
select y).First().Year1.ToString();
var data = from c in dataContext.Courses
where c.YID == YID
//orderby u.Timestamp descending
select c;
ViewData["YearID"] = YID;
ViewData["Year"] = year;
return View("CourseHolesView", data);
}
public ActionResult CourseDetails_o(int CID, int YID, string CourseName)
{
var dataContext = new lb3dataDataContext();
int ST = 5;
DateTime Date = DateTime.Today;//Convert.ToDateTime(formCollection["Date"]);
int Yr = Date.Year;
var data = from c in dataContext.Holes
where c.CourseID == CID
where c.YearID == YID
orderby c.HoleNum ascending
select c;
var data_group = from c in dataContext.Groups
where c.CourseID == CID
where c.YearID == YID
//orderby u.Timestamp descending
select c;
var year = (from y in dataContext.Years
where y.YID == YID
select y).First().Year1.ToString();
ViewData["Course"] = CourseName;
ViewData["Year"] = year;
ViewData["Holes"] = data;
ViewData["Groups"] = data_group;
ViewData["CourseID"] = CID;
ViewData["YID"] = YID;
ViewData["Tname"] = "t name";
ViewData["Date"] = Date;
var userList = (from u in dataContext.Users
orderby u.Name ascending
select new
{
name = u.Name,
id = u.UserID,
}).ToArray();
var dd_items = "";
dd_items = "<option>Select User</option>";
foreach (var item in userList)
{
dd_items = dd_items + "<option value=" + item.id + ">" + item.name + "</option>";
}
ViewData["dd_vals"] = dd_items;
return View("CourseDetails");
}
public ActionResult HoleCard(int CID, int YID, string course, int GID, int HoleID)
{
var dataContext = new lb3dataDataContext();
var year = (from y in dataContext.Years
where y.YID == YID
select y).First().Year1.ToString();
var hole = from h in dataContext.Holes
where h.HoleID == HoleID
select h;
var par = hole.First().Par;
var HoleNum = hole.First().HoleNum;
try
{
var nexthole = from h in dataContext.Holes
where h.HoleNum == HoleNum + 1
where h.YearID == YID
where h.CourseID == CID
select h;
var NextHoleID = nexthole.First().HoleID;
ViewData["NextHoleID"] = NextHoleID;
ViewData["NextHole"] = HoleNum + 1;
}
catch
{
ViewData["NextHoleID"] = null;
}
ViewData["Course"] = course;
ViewData["Year"] = year;
ViewData["HID"] = HoleID;
ViewData["GID"] = GID;
ViewData["CID"] = CID;
ViewData["YID"] = YID;
ViewData["HoleNum"] = HoleNum;
ViewData["Par"] = par;
var pin = (from p in dataContext.Holes
where p.HoleID == HoleID
select p.N_pin).First();
ViewData["Pin"] = pin;
var ld = (from p in dataContext.Holes
where p.HoleID == HoleID
select p.L_drive).First();
ViewData["LD"] = ld;
if (pin == 1)
{
try
{
var pinuser = (from p in dataContext.Scores
where p.HoleID == HoleID
where p.PinUserID != null
select p.PinUserID).First();
if (pinuser == null)
{
ViewData["PinUser"] = 0;
}
else
{
ViewData["PinUser"] = pinuser;
}
}
catch
{
}
}
if (ld == 1)
{
try
{
var lduser = (from p in dataContext.Scores
where p.HoleID == HoleID
where p.DriveUserID != null
select p.DriveUserID).First();
if (lduser == null)
{
ViewData["LDUser"] = 0;
}
else
{
ViewData["LDUser"] = lduser;
}
}
catch
{
}
}
var data = from c in dataContext.UserGroups
where c.GID == GID
select c;
return View("HoleCard", data);
}
public ActionResult GetLocalTourn(int CID, int YID)
{
var dataContext = new lb3dataDataContext();
var data = from c in dataContext.Years
where c.YID == YID
orderby c.Name ascending
select c;
ViewData["CID"] = CID;
ViewData["YID"] = YID;
return PartialView("PasscodeResults", data);
}
public ActionResult Users()
{
var dataContext = new lb3dataDataContext();
var userList = from u in dataContext.Users
orderby u.Name ascending
select u;
ViewData["Users"] = userList;
return View("Users");
}
public JsonResult getMiniLB(int CID, int YID, int HoleNum)
{
var dataContext = new lb3dataDataContext();
//gp
var miniLBdata = from r in dataContext.Scores
where r.Hole.CourseID == CID
where r.YearID == YID
orderby r.Score1 descending
group r by new {
r.User.Nickname,
//r.Hole.CourseID,
// r.Hole.Par
// r.Description
} into g
orderby g.Sum(s => s.Score1)
select new {
//g.Key..Category,
g.Key.Nickname,
TotalScore = g.Sum(x => x.Score1),
//CID = g.Key.CourseID,
Pars = g.Sum(x => x.Hole.Par),
//get sum of all completed holes for pars
};
//take sum of scores
return Json(new { miniLBdata });
}
public ActionResult Index()
{
var dataContext = new lb3dataDataContext();
var data = from c in dataContext.Events
//where c.CourseID == CID
orderby c.Timestamp descending
select c;
ViewData["Holes"] = data.Take(1);
return View("Front");
}
public ActionResult YearGroups(int YID)
{
var dataContext = new lb3dataDataContext();
var data = from y in dataContext.Groups
where y.YearID == YID
//orderby u.Timestamp descending
select y;
//var message = Convert.ToString(data.First().Timestamp) + ": " + data.First().Comment;
return View();
}
public ActionResult MyCourseDetails()
{
var dataContext = new lb3dataDataContext();
var data = from c in dataContext.Years
where c.OwnerID == 2
orderby c.Name ascending
select c;
return View("MyCourseDetails", data);
}
public PartialViewResult GroupPartialNew(int CID, int YID)
{
var dataContext = new lb3dataDataContext();
//Hole hole = dataRepository.GetHole(HoleID);
ViewData["CID"] = CID;
ViewData["YID"] = YID;
return PartialView("GroupPartialNew");
}
public JsonResult newScore(int GID, int YID, int HID, int UserID, int score, int Pin, int LD)
{
var dataContext = new lb3dataDataContext();
var otherplayers = from users in dataContext.UserGroups
where users.GID == GID
where users.UserID != UserID
select new
{
UserID = users.UserID
};
var HoleData = from h in dataContext.Holes
where h.HoleID == HID
select h;
var HoleNum = HoleData.First().HoleNum;
var CID = HoleData.First().CourseID;
var winner = from users in dataContext.Users
where users.UserID == UserID
select users;
var ck_score = from s in dataContext.Scores
where s.YearID == YID
where s.UserID == UserID
where s.HoleID == HID
select s;
var ck_pin = from s in dataContext.Scores
where s.YearID == YID
where s.PinUserID == UserID
where s.HoleID == HID
select s;
var ck_LD = from s in dataContext.Scores
where s.YearID == YID
where s.DriveUserID == UserID
where s.HoleID == HID
select s;
var type = "";
if (ck_score.Count() == 1 || ck_pin.Count() == 1 || ck_LD.Count() == 1)
{
//update stuff
type = "Updated";
if (score > 0)
{
dataRepository.UpdateScore(ck_score.First().ScID, score);
}
else
{
if (Pin == 1)
{
dataRepository.ResetPin(YID, HID);
dataRepository.UpdatePin(ck_score.First().ScID, UserID);
dataRepository.CheckScorePLD(HID, UserID, "Pin");
}
if (LD == 1)
{
dataRepository.ResetLD(YID, HID);
dataRepository.UpdateLD(ck_score.First().ScID, UserID);
dataRepository.CheckScorePLD(HID, UserID, "LD");
}
}
}
else
{
//insert stuff
type = "Saved";
if (Pin == 1)
{
dataRepository.ResetPin(YID, HID);
Score sc = new Score();
sc.PinUserID = UserID;
sc.UserID = UserID;
sc.YearID = YID;
sc.HoleID = HID;
sc.GID = GID;
dataRepository.Add(sc);
dataRepository.Save();
dataRepository.CheckScore(0, GID, YID, HID, UserID);
dataRepository.CheckScorePLD(HID, UserID, "Pin");
}
else if (LD == 1)
{
dataRepository.ResetLD(YID, HID);
Score sc = new Score();
sc.DriveUserID = UserID;
sc.UserID = UserID;
sc.YearID = YID;
sc.HoleID = HID;
sc.GID = GID;
dataRepository.Add(sc);
dataRepository.Save();
dataRepository.CheckScore(0, GID, YID, HID, UserID);
dataRepository.CheckScorePLD(HID, UserID, "LD");
}
else
{
Score sc = new Score();
sc.HoleID = HID;
sc.YearID = YID;
sc.GID = GID;
sc.UserID = UserID;
sc.Score1 = score;
dataRepository.Add(sc);
dataRepository.Save();
dataRepository.CheckScore(0, GID, YID, HID, UserID);
}
}
if (type == "Saved")
{
return Json(new { members = otherplayers, winner = winner.First().Nickname, type = "Saved to server", HoleNum = HoleNum, CID = CID, YID = YID });
}
else
{
return Json(new { members = otherplayers, winner = winner.First().Nickname, type = "Updated to server", HoleNum = HoleNum, CID = CID, YID = YID });
}
}
public ActionResult Groups(string target, int YID, int CID)
{
var dataContext = new lb3dataDataContext();
var data = from y in dataContext.Groups
where y.YearID == YID
where y.CourseID == CID
orderby y.GroupName ascending
select y;
var course = data.First().Course.CourseName;
var year = (from y in dataContext.Years
where y.YID == YID
select y).First().Year1.ToString();
ViewData["YID"] = YID;
ViewData["CID"] = CID;
ViewData["course"] = course;
ViewData["year"] = year;
ViewData["tname"] = data.First().Year.Name;
ViewData["GroupTarget"] = target;
//string cookie = Request.Cookies["last"].Value;
//var cookietxt = cookie + ", " + year + ", " + course;
//var histCookie = new HttpCookie("last", cookietxt);
//histCookie.Expires = DateTime.Now.AddDays(1);
//Response.AppendCookie(histCookie);
return View("Groups", data);
}
public ActionResult getScore(int HID, int UserID, int GID)
{
var dataContext = new lb3dataDataContext();
//gp
var data = from c in dataContext.Scores
where c.HoleID == HID
where c.UserID == UserID
//orderby u.Timestamp descending
select c;
ViewData["HID"] = HID;
ViewData["GID"] = GID;
ViewData["UserID"] = UserID;
return PartialView("ScorePartial", data);
}
public ActionResult Years(string target)
{
var dataContext = new lb3dataDataContext();
//if has userid and
var data = from y in dataContext.Years
orderby y.YID descending
select y;
ViewData["YearTarget"] = target;
//ViewData["CourseName"] = data.First().Courses.First().CourseName;
return View("Index", data);
}
