public ActionResult CornerLiveQuestion(Answer corner) { var answer = corner; answer.Id = GolGuru.Instance.GetMatchLiveQuestionIdResponse().ToString(CultureInfo.InvariantCulture); var rightAnswer = new RightAnswer() { AnswerId = Convert.ToInt16(answer.Id), IsActive = true, Datetime = DateTime.Now, Points = Convert.ToInt16(answer.puntaje), Answer = answer.respuesta }; db.RightAnswers.InsertOnSubmit(rightAnswer); try { db.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); } GolGuru.Instance.BrodcastMatchLiveAnswer(answer); var redirectUrl = new UrlHelper(Request.RequestContext).Action("MainMenu", "Home"); return(Json(new { Url = redirectUrl })); }
public User UpdateMethodNotification(int userid, string radio) { using (DataLayerDataContext db = new DataLayerDataContext()) { User u = db.Users.FirstOrDefault(i => i.Id == userid); if (radio == "1") { u.ViaEmail = true; u.ViaText = false; } if (radio == "2") { u.ViaText = true; u.ViaEmail = false; } if (radio == "3") { u.ViaText = true; u.ViaEmail = true; } AddAction(userid, "Update Notification Method settings", DateTime.Now); db.SubmitChanges(); return(u); } }
public void SetupMemberRel(string token, int?userid, int currentUserId) { using (DataLayerDataContext db = new DataLayerDataContext()) { AddMemberToken a = db.AddMemberTokens.FirstOrDefault(i => i.Token == token); UserOrganization u = new UserOrganization(); if (a.UserId == null) { u.UserId = userid.Value; } else { u.UserId = a.UserId.Value; } u.Date = DateTime.Now; u.OrgId = a.OrgId; u.Permission = a.Permission; db.UserOrganizations.InsertOnSubmit(u); User j = db.Users.FirstOrDefault(r => r.Id == u.UserId); db.SubmitChanges(); DeleteToken(a.Id); AddOrgAction(a.OrgId, currentUserId, j.FullName + " setup Relationship with you", DateTime.Now); AddAction(u.UserId, "Setup Relationship with organization " + u.Organization.Name, DateTime.Now); } }
public User UpdateNotification(int userid, string name, string phone, string email) { using (DataLayerDataContext db = new DataLayerDataContext()) { User u = db.Users.FirstOrDefault(i => i.Id == userid); Contact f = db.Contacts.FirstOrDefault(i => i.UserId == userid); if (f == null) { Contact c = new Contact(); c.Name = name; c.UserId = userid; c.Email = email; c.Phone = phone; db.Contacts.InsertOnSubmit(c); } else { f.Name = name; f.Email = email; f.Phone = phone; } AddAction(userid, "Update Notification Contact settings", DateTime.Now); db.SubmitChanges(); return(u); } }
public void DeleteToken(int userid) { using (DataLayerDataContext db = new DataLayerDataContext()) { PasswordToken p = db.PasswordTokens.FirstOrDefault(i => i.userid == userid); db.PasswordTokens.DeleteOnSubmit(p); db.SubmitChanges(); } }
public void AddNEItem(NonExpirationItem n) { using (DataLayerDataContext db = new DataLayerDataContext()) { db.NonExpirationItems.InsertOnSubmit(n); db.SubmitChanges(); AddAction(n.UserId, "Add Non Expiration Item " + n.Name, DateTime.Now); } }
public void UpdateImage2(string gg, int identity, int userid) { using (DataLayerDataContext db = new DataLayerDataContext()) { Image i = db.Images.FirstOrDefault(j => j.ExpirationItemId == identity && j.IsBack == true); i.Path = gg; db.SubmitChanges(); } }
public void UpdatePassword(string password, int userid) { using (DataLayerDataContext db = new DataLayerDataContext()) { User i = db.Users.FirstOrDefault(u => u.Id == userid); i.HashedPassword = PasswordHelper.HashPassword(password, i.Salt); db.SubmitChanges(); } }
public void DeleteToken(int tokenid) { using (DataLayerDataContext db = new DataLayerDataContext()) { AddMemberToken c = db.AddMemberTokens.FirstOrDefault(i => i.Id == tokenid); db.AddMemberTokens.DeleteOnSubmit(c); db.SubmitChanges(); } }
public void AddCoreCourse(CoreCourse c) { using (DataLayerDataContext db = new DataLayerDataContext()) { db.CoreCourses.InsertOnSubmit(c); db.SubmitChanges(); AddAction(c.UserId, "Add Core Course " + c.CourseCategory.Name, DateTime.Now); } }
public void DeleteCoreCourse(int courseid) { using (DataLayerDataContext db = new DataLayerDataContext()) { CoreCourse c = db.CoreCourses.FirstOrDefault(i => i.Id == courseid); db.CoreCourses.DeleteOnSubmit(c); db.SubmitChanges(); AddAction(c.UserId, "Delete Core Course " + c.Name, DateTime.Now); } }
public void UpdatePassword(int userid, string newPasssword) { using (DataLayerDataContext db = new DataLayerDataContext()) { User u = db.Users.FirstOrDefault(i => i.Id == userid); u.HashedPassword = PasswordHelper.HashPassword(newPasssword, u.Salt); AddAction(userid, "Update Password", DateTime.Now); db.SubmitChanges(); } }
public void DeleteNEItem(int itemid) { using (DataLayerDataContext db = new DataLayerDataContext()) { var f = db.NonExpirationItems.FirstOrDefault(i => i.Id == itemid); db.NonExpirationItems.DeleteOnSubmit(f); db.SubmitChanges(); AddAction(f.UserId, "Delete Non Expiration Item " + f.Name, DateTime.Now); } }
public JsonResult Register(LoginModel model) { var result = new { Success = "false", Time = "0" }; try { if (model.UserName != null && model.Password != null) { var user = from c in db.Users where c.Email == model.UserName select c; if (!user.Any()) { var newUser = new User() { Email = model.UserName, IsActive = true, LastLogin = DateTime.UtcNow, Pass = model.Password }; db.Users.InsertOnSubmit(newUser); // Submit the change to the database. try { db.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); } result = new { Success = GolGuru.Instance.GetMatchStatus(), Time = GolGuru.Instance.GetMatchTime().ToString(CultureInfo.CurrentCulture) }; } } } catch (Exception es) { throw; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public void CreateOrgReqItems(int orgid, int catid) { using (DataLayerDataContext db = new DataLayerDataContext()) { OrgRequiredItem l = new OrgRequiredItem(); l.OrgId = orgid; l.CatId = catid; db.OrgRequiredItems.InsertOnSubmit(l); db.SubmitChanges(); } }
public void UpdateAccount(int userid, string name, string email, string phone) { using (DataLayerDataContext db = new DataLayerDataContext()) { User u = db.Users.FirstOrDefault(i => i.Id == userid); u.FullName = name; u.Email = email; u.PhoneNumber = phone; db.SubmitChanges(); AddAction(userid, "Update Account Info", DateTime.Now); } }
public void AddAction(int userid, string name, DateTime date) { using (DataLayerDataContext db = new DataLayerDataContext()) { Action a = new Action(); a.UserId = userid; a.Name = name; a.Date = date; db.Actions.InsertOnSubmit(a); db.SubmitChanges(); } }
public void UpdateNEItem(NonExpirationItem n) { using (DataLayerDataContext db = new DataLayerDataContext()) { NonExpirationItem item = db.NonExpirationItems.FirstOrDefault(i => i.Id == n.Id); item.Name = n.Name; item.Notes = n.Notes; item.Date = n.Date; db.SubmitChanges(); AddAction(item.UserId, "Update Non Expiration Item " + item.Name, DateTime.Now); } }
public void AddImage2(string gg, int identity) { using (DataLayerDataContext db = new DataLayerDataContext()) { Image i = new Image(); i.ExpirationItemId = identity; i.Path = gg; i.IsBack = true; db.Images.InsertOnSubmit(i); db.SubmitChanges(); } }
public void AddSharedItems(int userid, int orgid, int itemid) { using (DataLayerDataContext db = new DataLayerDataContext()) { ItemShareWithCompany i = new ItemShareWithCompany(); i.UserId = userid; i.OrgId = orgid; i.ExpirationItemId = itemid; i.Share = false; db.ItemShareWithCompanies.InsertOnSubmit(i); db.SubmitChanges(); } }
public void UpdateCoreCourse(int itemid, string notes, DateTime date, int category, string name) { using (DataLayerDataContext db = new DataLayerDataContext()) { CoreCourse c = db.CoreCourses.FirstOrDefault(i => i.Id == itemid); c.Name = name; c.Notes = notes; c.Date = date; c.CatId = category; db.SubmitChanges(); AddAction(c.UserId, "Update Core Course " + c.Name, DateTime.Now); } }
public void CreateInitialUserOrdRel(int orgid, int userid) { using (DataLayerDataContext db = new DataLayerDataContext()) { UserOrganization l = new UserOrganization(); l.OrgId = orgid; l.UserId = userid; l.Permission = 3; l.Date = DateTime.Now; db.UserOrganizations.InsertOnSubmit(l); db.SubmitChanges(); } }
public void AddReminder(int userid, int expirationItemId, int reminder, DateTime expiredate) { using (DataLayerDataContext db = new DataLayerDataContext()) { Reminder r = new Reminder(); r.UserId = userid; r.ExpirationItemId = expirationItemId; r.Days = reminder; r.Date = expiredate.AddDays(-reminder).Date; db.Reminders.InsertOnSubmit(r); db.SubmitChanges(); } }
public void DisableUser(int userid, int orgid, int currentUserId) { using (DataLayerDataContext db = new DataLayerDataContext()) { var item = db.UserOrganizations.FirstOrDefault(i => i.UserId == userid && i.OrgId == orgid); Organization o = db.Organizations.FirstOrDefault(j => j.Id == orgid); User u = db.Users.FirstOrDefault(r => r.Id == userid); AddAction(userid, o.Name + " Disabled organization relationship", DateTime.Now); AddOrgAction(orgid, currentUserId, "Disabled relationship with " + u.FullName, DateTime.Now); db.UserOrganizations.DeleteOnSubmit(item); db.SubmitChanges(); } }
public void AddUser(string name, string password, string phone, string email) { using (DataLayerDataContext db = new DataLayerDataContext()) { User u = new User(); u.FullName = name; u.Email = email; u.PhoneNumber = phone; u.Salt = PasswordHelper.GenerateSalt(); u.HashedPassword = PasswordHelper.HashPassword(password, u.Salt); db.Users.InsertOnSubmit(u); db.SubmitChanges(); } }
public void AddReminder(int addReminder, int expirationItemId) { using (DataLayerDataContext db = new DataLayerDataContext()) { Reminder o = db.Reminders.FirstOrDefault(i => i.ExpirationItemId == expirationItemId); Reminder r = new Reminder(); r.ExpirationItemId = o.ExpirationItemId; r.UserId = o.UserId; r.Days = addReminder; r.Date = o.ExpirationItem.ExpirationDate.AddDays(addReminder); db.Reminders.InsertOnSubmit(r); db.SubmitChanges(); AddAction(r.UserId, "Add Reminder for " + r.ExpirationItem.Name + " " + r.ExpirationItem.Category.Name, DateTime.Now); } }
public void AddMember(string email, int permission, string token, int?userid, int orgid) { using (DataLayerDataContext db = new DataLayerDataContext()) { var t = new AddMemberToken(); t.Email = email; t.Permission = permission; t.Token = token; t.OrgId = orgid; if (userid != null) { t.UserId = userid; } db.AddMemberTokens.InsertOnSubmit(t); db.SubmitChanges(); } }
public void UpdateOrganization(int userid, int orgid, string name, string email, string phone, string address, string city, string state, string zip, int year) { using (DataLayerDataContext db = new DataLayerDataContext()) { var j = db.Organizations.FirstOrDefault(i => i.Id == orgid); j.Name = name; j.Email = email; j.PhoneNumber = phone; j.Address = address; j.City = city; j.State = state; j.Zip = zip; j.YearFounded = year; db.SubmitChanges(); AddOrgAction(j.Id, userid, " Updated company profile", DateTime.Now); } }
public PasswordToken CreateToken(string email) { using (DataLayerDataContext db = new DataLayerDataContext()) { User i = db.Users.FirstOrDefault(u => u.Email == email); Guid g = Guid.NewGuid(); string gg = g.ToString(); PasswordToken p = new PasswordToken { userid = i.Id, guid = gg, date = DateTime.Now }; db.PasswordTokens.InsertOnSubmit(p); db.SubmitChanges(); return(p); } }
public int AddItem(int userid, string name, int category, int reminder, DateTime?issuedate, DateTime expiredate, string notes) { using (DataLayerDataContext db = new DataLayerDataContext()) { ExpirationItem i = new ExpirationItem(); i.Name = name; i.Notes = notes; i.ExpirationDate = expiredate; i.CategoryId = category; i.UserId = userid; i.IssueDate = issuedate; db.ExpirationItems.InsertOnSubmit(i); db.SubmitChanges(); AddReminder(userid, i.Id, reminder, expiredate); AddAction(userid, "Add Expiration Item " + i.Name + " " + i.Category.Name, DateTime.Now); return(i.Id); } }