public static user createUser(user userObj) { GeoStoreDBEntities db = new GeoStoreDBEntities(); db.users.AddObject(userObj); db.SaveChanges(); return (getUserByName(userObj.name)); }
public static user getUserByOpenID(string openid) { GeoStoreDBEntities db = new GeoStoreDBEntities(); var userQuery = from userObj in db.users where userObj.open_id == openid select userObj; var users = userQuery.ToList(); if (users.Count > 0) return users.Single(); else return null; }
public static user getUserByName(string userName) { GeoStoreDBEntities db = new GeoStoreDBEntities(); var userQuery = from userObj in db.users where userObj.name == userName select userObj; var users = userQuery.ToList(); if (users.Count > 0) return users.Single(); else return null; }
public static user getUserByEmail(string email) { GeoStoreDBEntities db = new GeoStoreDBEntities(); var userQuery = from userObj in db.users where userObj.email == email select userObj; var users = userQuery.ToList(); if (users.Count > 0) return users.Single(); else return null; }
//check if open id exists in our system. private VerificationResponse VerifyOpenId(string openid) { VerificationResponse verificationResponse = new VerificationResponse(); GeoStoreDBEntities db = new GeoStoreDBEntities(); user userObj = user.getUserByOpenID(openid); if (userObj != null) { verificationResponse.status = 0; verificationResponse.message = "This openid is already registered. You might have already registered with us."; } else { verificationResponse.status = 1; verificationResponse.message = "The openid is successfully authenticated."; } return verificationResponse; }
public string VerifyUser(string userName) { VerificationResponse verificationResponse = new VerificationResponse(); GeoStoreDBEntities db = new GeoStoreDBEntities(); user userObj = user.getUserByName(userName); if (userObj != null) { verificationResponse.status = 0; verificationResponse.message = "This user name is not available. Please choose another name."; } else { verificationResponse.status = 1; verificationResponse.message = "This User name is available."; } return JsonConvert.SerializeObject(verificationResponse); }
public string VerifyEmailAddress(string email) { VerificationResponse verificationResponse = new VerificationResponse(); GeoStoreDBEntities db = new GeoStoreDBEntities(); var userObj = user.getUserByEmail(email); if (userObj != null) { verificationResponse.status = 0; verificationResponse.message = "This email is already registered. You might have already registered with us."; } else { verificationResponse.status = 1; verificationResponse.message = ""; } return JsonConvert.SerializeObject(verificationResponse); }