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);
}
}
