/// <summary> /// See all the achievements that are unlocked by this task. if they arent already conferred, confer them /// Recalculate rewards unlocked by the achievement, if they arent already conferred, confer them /// Recalculate Pilot levels unlocked by the achievement if they arent already conferred, confer them /// </summary> /// <param name="dc"></param> /// <param name="taskID"></param> /// <param name="email"></param> private void ProcessTaskDependents(DBClassesDataContext dc, Guid taskID, string email) { // recalculate achievements for this pilot List <Guid> Achievements = RecalculateAchievements(dc, email); // save these achievements if (Achievements.Count > 0) { PilotAchievement.saveAchievements(dc, email, Achievements); } dc.SubmitChanges(); // Now calculate all rewards which are unlocked by this achievement List <Guid> Rewards = RecalculateRewards(dc, email, Achievements); if (Rewards.Count > 0) { PilotReward.saveRewards(dc, email, Rewards); } dc.SubmitChanges(); // Now calculate all rewards which are unlocked by this achievement List <Guid> Levels = RecalculateLevels(dc, email, Achievements); if (Rewards.Count > 0) { PilotClass.saveClasses(dc, email, Levels); } dc.SubmitChanges(); }
internal static void delete(Guid achID) { using (DBClassesDataContext dbc = new DBClassesDataContext()) { // first remove any prereq involving this achievement IEnumerable <AchievementPrereq> achPrereqs = (from u in dbc.AchievementPrereqs where u.RequiredAchievementID == achID select u); dbc.AchievementPrereqs.DeleteAllOnSubmit(achPrereqs); // first remove any prereq involving this achievement IEnumerable <RewardPrereq> rewPrereqs = (from u in dbc.RewardPrereqs where u.RequiredAchievement == achID select u); dbc.RewardPrereqs.DeleteAllOnSubmit(rewPrereqs); // first remove any prereq involving this achievement IEnumerable <PilotClassPrereq> pcPrereqs = (from u in dbc.PilotClassPrereqs where u.AchievementID == achID select u); dbc.PilotClassPrereqs.DeleteAllOnSubmit(pcPrereqs); AchievementDefinition ach = (from u in dbc.AchievementDefinitions where u.AchievementID == achID select u).SingleOrDefault(); if (ach != null) { dbc.AchievementDefinitions.DeleteOnSubmit(ach); dbc.SubmitChanges(); } } }
public void ProcessRequest(HttpContext context) { string pilotclassid = context.Request.Form["pilotclassid"]; string achname = context.Request.Form["pilotclassname"]; string logo = context.Request.Form["pilotlogo"]; string achdesc = context.Request.Form["pilotclassdescription"]; PilotClassDefinition ach = new PilotClassDefinition(); using (DBClassesDataContext dc = new DBClassesDataContext()) { try { if (String.IsNullOrEmpty(pilotclassid)) { dc.PilotClassDefinitions.InsertOnSubmit(ach); ach.PilotClassID = Guid.NewGuid(); } else { ach = (from u in dc.PilotClassDefinitions where u.PilotClassID == Guid.Parse(pilotclassid) select u).SingleOrDefault(); } ach.Logo = logo; ach.PilotClassName = achname; ach.PilotClassDescription = achdesc; dc.SubmitChanges(); } catch (Exception e) { } } }
public void ProcessRequest(HttpContext context) { string achievementid = context.Request.Form["achievementid"]; string achname = context.Request.Form["achievementname"]; string achdesc = context.Request.Form["achievementdescription"]; AchievementDefinition ach = new AchievementDefinition(); using (DBClassesDataContext dc = new DBClassesDataContext()) { try { if (String.IsNullOrEmpty(achievementid)) { dc.AchievementDefinitions.InsertOnSubmit(ach); ach.AchievementID = Guid.NewGuid(); } else { ach = (from u in dc.AchievementDefinitions where u.AchievementID == Guid.Parse(achievementid) select u).SingleOrDefault(); } ach.AchievementName = achname; ach.AchievementDesc = achdesc; dc.SubmitChanges(); } catch (Exception e) { } } }
protected void Page_Load(object sender, EventArgs e) { mUser = dashboard.getUserFromSessionOrCookie(Request, Session); if (mUser == null) { Response.Redirect("login.aspx"); Response.Close(); return; } String uid = Request.Params["uid"]; if (String.IsNullOrEmpty(uid) || !mUser.IsAdmin) { Response.Redirect("dashboard.aspx"); Response.Close(); return; } DBClassesDataContext dbc = new DBClassesDataContext(); AppUser usr = (from u in dbc.AppUsers where u.UserEmail == uid select u).SingleOrDefault(); if (usr != null) { dbc.AppUsers.DeleteOnSubmit(usr); dbc.SubmitChanges(); } Response.Redirect("dashboard.aspx"); Response.Close(); return; }
protected void Page_Load(object sender, EventArgs e) { mUser = dashboard.getUserFromSessionOrCookie(Request, Session); if (mUser == null) { Response.Redirect("login.aspx"); Response.Close(); return; } String tail = Request.Params["tail"]; if (String.IsNullOrEmpty(tail) || !mUser.IsAdmin) { Response.Redirect("dashboard.aspx"); Response.Close(); return; } DBClassesDataContext dbc = new DBClassesDataContext(); Aircraft ship = (from u in dbc.Aircrafts where u.TailNumber == tail select u).SingleOrDefault(); if (ship != null) { dbc.Aircrafts.DeleteOnSubmit(ship); dbc.SubmitChanges(); } Response.Redirect("dashboard.aspx"); Response.Close(); return; }
protected void btnSave_Click(object sender, EventArgs e) { DBClassesDataContext dbc = new DBClassesDataContext(); if (NewType == null) { Aircraft ship = (from u in dbc.Aircrafts where u.TailNumber == mShip.TailNumber select u).SingleOrDefault(); mShip = ship; } else { dbc.Aircrafts.InsertOnSubmit(mShip); mShip.TailNumber = TailNum.Text; } mShip.Make = Make.Text; mShip.Model = Model.Text; mShip.Year = Year.Text; mShip.Status = ListStatus.SelectedIndex; dbc.SubmitChanges(); ExitPage(); }
public static void AddEquipment(DBClassesDataContext db, string name, decimal dimLength) { Equipment equipment = new Equipment(); equipment.Name = name; equipment.DimLength = dimLength; db.Equipments.InsertOnSubmit(equipment); db.SubmitChanges(); }
internal static void delete(Guid achID) { using (DBClassesDataContext dbc = new DBClassesDataContext()) { PilotClassDefinition ach = (from u in dbc.PilotClassDefinitions where u.PilotClassID == achID select u).SingleOrDefault(); if (ach != null) { dbc.PilotClassDefinitions.DeleteOnSubmit(ach); dbc.SubmitChanges(); } } }
public void ProcessRequest(HttpContext context) { string postData = new System.IO.StreamReader(context.Request.InputStream).ReadToEnd(); AchievementDeps deps = JsonConvert.DeserializeObject <AchievementDeps>(postData); if (String.IsNullOrEmpty(deps.AchievementID)) { return; } using (DBClassesDataContext dc = new DBClassesDataContext()) { try { // first remove all existing prereqs for this ach IEnumerable <AchievementPrereq> prereqs = (from u in dc.AchievementPrereqs where u.AchievementID == Guid.Parse(deps.AchievementID) select u); if (prereqs.Count <AchievementPrereq>() > 0) { dc.AchievementPrereqs.DeleteAllOnSubmit(prereqs); } List <AchievementPrereq> newItems = new List <AchievementPrereq>(); foreach (String s in deps.Achievements) { AchievementPrereq newach = new AchievementPrereq(); newach.AchievementID = Guid.Parse(deps.AchievementID); newach.RequiredAchievementID = Guid.Parse(s); dc.AchievementPrereqs.InsertOnSubmit(newach); } foreach (String s in deps.Tasks) { AchievementPrereq newach = new AchievementPrereq(); newach.AchievementID = Guid.Parse(deps.AchievementID); newach.TaskID = Guid.Parse(s); dc.AchievementPrereqs.InsertOnSubmit(newach); } dc.SubmitChanges(); } catch (Exception e) { } } }
internal static void deleteTask(Guid taskID) { using (DBClassesDataContext dbc = new DBClassesDataContext()) { // first remove any prereq involving this task IEnumerable <AchievementPrereq> achPrereqs = (from u in dbc.AchievementPrereqs where u.TaskID == taskID select u); dbc.AchievementPrereqs.DeleteAllOnSubmit(achPrereqs); TaskDefinition tsk = (from u in dbc.TaskDefinitions where u.TaskID == taskID select u).SingleOrDefault(); if (tsk != null) { dbc.TaskDefinitions.DeleteOnSubmit(tsk); } dbc.SubmitChanges(); } }
public void ProcessRequest(HttpContext context) { string email = context.Request.Params["email"]; string taskid = context.Request.Params["taskid"]; string reviewer = context.Request.Params["reviewer"]; string date = context.Request.Params["date"]; PilotTask task = new PilotTask(); using (DBClassesDataContext dc = new DBClassesDataContext()) { try { task = (from u in dc.PilotTasks where u.TaskID == Guid.Parse(taskid) && u.PilotEmail == email select u).SingleOrDefault(); if (task == null) { task = new PilotTask(); task.TaskID = Guid.Parse(taskid); task.PilotEmail = email; dc.PilotTasks.InsertOnSubmit(task); task.DateAdded = DateTime.Now; } task.InstructorEmail = reviewer; try { task.DateCompleted = DateTime.Parse(date); } catch { task.DateCompleted = DateTime.Today; } task.IsCompleted = true; task.IsVerified = true; // for now no need to verify dc.SubmitChanges(); // this is the right time to now look at the achievements and rewards and pilot levels this entails. ProcessTaskDependents(dc, task.TaskID, email); } catch (Exception e) { } } }
public void ProcessRequest(HttpContext context) { string rewardname = context.Request.Form["rewardname"]; string logo = context.Request.Form["rewardlogo"]; string rewardtype = context.Request.Form["rewardtype"]; string rewarditem = context.Request.Form["rewarddetail"]; string rewardcount = context.Request.Form["rewardcount"]; string rewardvalidity = context.Request.Form["rewardvalidtill"]; string description = context.Request.Form["rewarddescription"]; string rewardid = context.Request.Form["rewardid"]; RewardDefinition reward = new RewardDefinition(); using (DBClassesDataContext dc = new DBClassesDataContext()) { try { if (String.IsNullOrEmpty(rewardid)) { dc.RewardDefinitions.InsertOnSubmit(reward); reward.RewardID = Guid.NewGuid(); } else { reward = (from u in dc.RewardDefinitions where u.RewardID == Guid.Parse(rewardid) select u).SingleOrDefault(); } reward.RewardName = rewardname; reward.Logo = logo; reward.RewardType = rewardtype; try { reward.RewardCount = Decimal.Parse(rewardcount); } catch { } reward.RewardDesc = description; reward.RewardItem = rewarditem; try{ reward.RewardValidityTill = DateTime.Parse(rewardvalidity); } catch { } dc.SubmitChanges(); } catch (Exception e) { } } }
public void ProcessRequest(HttpContext context) { string email = context.Request.Params["email"]; string taskid = context.Request.Params["taskid"]; using (DBClassesDataContext dc = new DBClassesDataContext()) { try { PilotTask task = (from u in dc.PilotTasks where u.TaskID == Guid.Parse(taskid) && u.PilotEmail == email select u).SingleOrDefault(); if (task != null) { dc.PilotTasks.DeleteOnSubmit(task); dc.SubmitChanges(); } } catch (Exception e) { } } }
public void ProcessRequest(HttpContext context) { string email = context.Request.Params["email"]; string taskid = context.Request.Params["taskid"]; PilotTask task = new PilotTask(); using (DBClassesDataContext dc = new DBClassesDataContext()) { try { dc.PilotTasks.InsertOnSubmit(task); task.TaskID = Guid.Parse(taskid); task.DateAdded = DateTime.Now; task.IsCompleted = false; task.IsVerified = false; task.PilotEmail = email; dc.SubmitChanges(); } catch (Exception e) { } } }
protected void btnSave_Click(object sender, EventArgs e) { DBClassesDataContext dbc = new DBClassesDataContext(); if (NewType == null) { AppUser usr = (from u in dbc.AppUsers where u.UserEmail == mEditingUser.UserEmail select u).SingleOrDefault(); mEditingUser = usr; if (!String.IsNullOrEmpty(PasswordChange.Text)) { mEditingUser.PasswordHash = System.Text.Encoding.UTF8.GetBytes(PasswordChange.Text); } } else { dbc.AppUsers.InsertOnSubmit(mEditingUser); mEditingUser.UserEmail = Email.Text; if (!String.IsNullOrEmpty(Password.Text)) { mEditingUser.PasswordHash = System.Text.Encoding.UTF8.GetBytes(Password.Text); } mEditingUser.CreatedOn = DateTime.Now; //mEditingUser.PasswordHash = new ASCIIEncoding().GetBytes(Password.Text); } // now save all the data and move to the previous page. mEditingUser.Address1 = Address1.Text; mEditingUser.Address2 = Address2.Text; mEditingUser.Address3 = Address3.Text; mEditingUser.CellPhone = CellPhone.Text; mEditingUser.City = City.Text; mEditingUser.Country = Country.Text; try { mEditingUser.DOB = DateTime.Parse(DOB.Text); } catch { } mEditingUser.Employer = Employer.Text; mEditingUser.FirstName = FName.Text; mEditingUser.Gender = (ListGender.SelectedIndex == 0 ? "M" :(ListGender.SelectedIndex == 1?"F":null)); mEditingUser.HomePhone = HomePhone.Text; mEditingUser.LastName = LName.Text; mEditingUser.MI = MI.Text; mEditingUser.State = State.Text; mEditingUser.WorkPhone = WorkPhone.Text; mEditingUser.ZIP = ZIP.Text; mEditingUser.IsAdmin = IsAdmin.Checked; mEditingUser.IsInstructor = IsInstructor.Checked; mEditingUser.IsStudent = IsStudent.Checked; if (!mEditingUser.IsStudent && !mEditingUser.IsInstructor && !mEditingUser.IsAdmin) { mEditingUser.IsStudent = true; } dbc.SubmitChanges(); ExitPage(); }
public void create(Language record) { dataContext.Languages.InsertOnSubmit(record); dataContext.SubmitChanges(); }
public void setLastVisitTimeToNow() { dataContext.application_settings.Single(s => s.settingName.Equals("lastVisitTime")).settingValue = DateTime.Now.ToString(); dataContext.SubmitChanges(); }
private void ExtractAndSaveSelections() { DBClassesDataContext dbc = new DBClassesDataContext(); List <int> LessonsWithLogs = new List <int>(); List <string> selectedCourses = new List <string>(); foreach (string s in Request.Params.Keys) { if (s.StartsWith("CHK-")) { if (Request.Params[s] == "on") { selectedCourses.Add(s); } } else if (s.StartsWith("TIMELOG-")) { String val = Request.Params[s]; if (!String.IsNullOrEmpty(val)) { try { decimal decval = Decimal.Parse(val); String[] comps = s.Split(new char[] { '-' }); // second part describes the field, and third part is the lesson id if (comps.Length == 4) { int lessonID = int.Parse(comps[2]); int stageID = int.Parse(comps[3]); if (!LessonsWithLogs.Contains(lessonID)) { LessonsWithLogs.Add(lessonID); } } } catch { } } } } foreach (int i in LessonsWithLogs) { ProcessTimeLogging(dbc, i); } // now delete every course thats not in this list // insert courses that are in the list but not in the database // first get the list of existing courses for this student. IEnumerable <CompletionLog> log = CompletionLog.LoadStudentLog(dbc, mStudent.UserEmail); foreach (CompletionLog l in log) { bool bFound = false; // check which items are not in the new list, these are to be deleted foreach (string s in selectedCourses) { string logid = s.Substring(4); // skip the first 4 chars if (logid == l.LessonGUID) { bFound = true; // log needs to stay break; } } if (!bFound) { //log needs to be deleted dbc.CompletionLogs.DeleteOnSubmit(l); } } foreach (string s in selectedCourses) { string logid = s.Substring(4); // skip the first 4 chars bool bFound = false; // check which items are not in the old list, these are to be added foreach (CompletionLog l in log) { if (logid == l.LessonGUID) { bFound = true; // log needs to stay break; } } if (!bFound) { //a new entry needs to be added CompletionLog cl = new CompletionLog(); cl.AircraftUsed = null; cl.DateCompleted = DateTime.Now; cl.Instructor = mUser.UserEmail; cl.LessonGUID = logid; cl.SetLessonAndStage(cl.LessonGUID); cl.Student = mStudent.UserEmail; dbc.CompletionLogs.InsertOnSubmit(cl); } } dbc.SubmitChanges(); }
public void create(Word record) { dataContext.Words.InsertOnSubmit(record); dataContext.SubmitChanges(); }
public void create(Translation record) { dataContext.Translations.InsertOnSubmit(record); dataContext.SubmitChanges(); }
public void ProcessRequest(HttpContext context) { string tasktype = context.Request.Form["tasktype"]; string aircraft = context.Request.Form["ChooseAC"]; string hours = context.Request.Form["hours"]; string airport = context.Request.Form["airport"]; string taskname = context.Request.Form["taskname"]; string description = context.Request.Form["description"]; string maneuver = context.Request.Form["maneuver"]; string lessonname = context.Request.Form["lessonname"]; string ratingname = context.Request.Form["ratingname"]; string pinnacle = context.Request.Form["pinnacle"]; string destination = context.Request.Form["destination"]; string classname = context.Request.Form["classname"]; string taskid = context.Request.Form["taskid"]; TaskDefinition task = new TaskDefinition(); using (DBClassesDataContext dc = new DBClassesDataContext()) { try { if (String.IsNullOrEmpty(taskid)) { dc.TaskDefinitions.InsertOnSubmit(task); task.TaskID = Guid.NewGuid(); } else { task = (from u in dc.TaskDefinitions where u.TaskID == Guid.Parse(taskid) select u).SingleOrDefault(); } task.AircraftType = aircraft; task.TaskType = int.Parse(tasktype); try { task.Hours = Decimal.Parse(hours); } catch { } task.Airport = airport; task.Course = classname; task.Lesson = lessonname; task.Rating = ratingname; task.Maneuver = maneuver; task.TaskDescription = description; task.TaskName = taskname; task.AircraftType = aircraft; try { task.Hours = decimal.Parse(hours); } catch { } if (task.TaskType == TaskDefinition.TASK_DESTINATION) { task.Detail = destination; } else if (task.TaskType == TaskDefinition.TASK_PINNACLE) { task.Detail = pinnacle; } dc.SubmitChanges(); } catch (Exception e) { } } }