public void savenew(string lat, string lval, string city, string country, string comment) { User user = new User(); user.Lat = Convert.ToDecimal(lat); user.Long = Convert.ToDecimal(lval); user.PID = "222fe9"; user.City = city; user.Country = country; user.Comment = comment; user.Timestamp = DateTime.Now; db.Users.InsertOnSubmit(user); db.SubmitChanges(); }
public int AddUser(User user) { db.Users.InsertOnSubmit(user); db.SubmitChanges(); return user.UserID; }
partial void DeleteUser(User instance);
partial void UpdateUser(User instance);
partial void InsertUser(User instance);
public ActionResult SaveID(string phoneID) { var dataContext = new hioDataContext(); var userchk = (from u in dataContext.Users where u.PID == phoneID select u).Count(); int APIcallsAllowed = (from u in dataContext.Settings where u.id == 1 select u).First().APIcalls; int userID; var siteCount = "0"; var phonename = "No name"; if (userchk == 1) { //update user, write event var usertype = "Existing"; var userd = from u in dataContext.Users where u.PID == phoneID select u; userID = userd.First().UserID; phonename = userd.First().Comment; dataRepository.AddLogin(Convert.ToInt32(userID),usertype); dataRepository.updateUser(Convert.ToInt32(userID)); siteCount = dataRepository.SiteCount(Convert.ToInt32(userID)); } else { var usertype = "New User"; User newuser = new User(); newuser.PID = phoneID; newuser.Timestamp = DateTime.Now; //add user, get ID, write event var newuserID = dataRepository.AddUser(newuser); userID = Convert.ToInt32(newuserID); dataRepository.AddLogin(userID, usertype); } int APIcalls_today = (from ev in dataContext.hio_events where ev.Event == "API" where ev.Datetime >= DateTime.Now.AddDays(-1) select ev).Count(); var APIcalls = "0"; if (APIcallsAllowed - APIcalls_today > 0) { APIcalls = "1"; } else { APIcalls = "0"; } var total_sites = (from ev in dataContext.places where ev.Flag >= 0 select ev).Count(); var latest_pl = from p in dataContext.places where p.Flag >= 0 orderby p.PID descending select p; var latest_nm = latest_pl.First().Username; var latest_town = latest_pl.First().Town; //new { gloss_list = GlossaryList, answer = desc } return new JsonpResult(new { lat_nm = latest_nm, lat_tn = latest_town, total = total_sites, APIcalls = APIcalls, userID = userID, Name = phonename, site_ct = siteCount }); }
public ActionResult SaveBrowser(string username, string password, string newu) { var dataContext = new hioDataContext(); var ipaddr = Request.ServerVariables["REMOTE_ADDR"]; dataRepository.logIP(ipaddr); var ipstatus = dataRepository.checkIP(ipaddr); if (ipstatus >= 3) { var statusmsg = "No"; //(from u in dataContext.notices // where u.NID == 3 // select u).First().Ann_content; return new JsonpResult(new { status = "-2", statusmsg = statusmsg }); } else { int APIcallsAllowed = (from u in dataContext.Settings where u.id == 1 select u).First().APIcalls; var siteCount = "0"; int userID; int APIcalls_today = (from ev in dataContext.hio_events where ev.Event == "API" where ev.Datetime >= DateTime.Now.AddDays(-1) select ev).Count(); var APIcalls = "0"; if (APIcallsAllowed - APIcalls_today > 0) { APIcalls = "1"; } else { APIcalls = "0"; } var total_sites = (from ev in dataContext.places where ev.Flag >= 0 select ev).Count(); var latest_pl = from p in dataContext.places where p.Flag >= 0 orderby p.PID descending select p; var latest_nm = latest_pl.First().Username; var latest_town = latest_pl.First().Town; if (newu == "true") { //adduser0 var usertype = "New User"; User newuser = new User(); newuser.PID = "nondroid"; newuser.Timestamp = DateTime.Now; newuser.Comment = username; newuser.Password = password; //add user, get ID, write event var newuserID = dataRepository.AddUser(newuser); userID = Convert.ToInt32(newuserID); dataRepository.AddLogin(userID, usertype); return new JsonpResult(new { lat_nm = latest_nm, lat_tn = latest_town, total = total_sites, APIcalls = APIcalls, site_ct = siteCount, userID = newuserID }); } else { if (username == "undefined" && password == "undefined") { return new JsonpResult(new { lat_nm = latest_nm, lat_tn = latest_town, total = total_sites, APIcalls = APIcalls, site_ct = siteCount, status = "0" }); //not in db } else { //are in db var userchk = (from u in dataContext.Users where (u.Comment == username && u.Password == password) select u).Count(); if (userchk == 1) { //password ok var usertype = "Existing"; var userd = from u in dataContext.Users where (u.Comment == username && u.Password == password) select u; userID = userd.First().UserID; dataRepository.AddLogin(Convert.ToInt32(userID), usertype); dataRepository.updateUser(Convert.ToInt32(userID)); siteCount = dataRepository.SiteCount(Convert.ToInt32(userID)); return new JsonpResult(new { lat_nm = latest_nm, lat_tn = latest_town, total = total_sites, APIcalls = APIcalls, userID = userID, site_ct = siteCount, status = "1" }); } else { //incorrect deets return new JsonpResult(new { status = "-1" }); } } } } }