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