public void IsPasswordTooLong()
{
var user = new Userdata();
var actual = user.IsPasswordOK("123455ljjhfjsdhfkjsdhfksjdhfkjsdhfkjsdhfkjsdhfkjsdhfkjsdhfkjsdhfkjsdfhksjdfhsdkjf66778");
Assert.AreEqual(false, actual);
}
private void databind()
{
string strSql = "select id,name,class,station,createtime,workshop From jh_mes.tuser where 1=1 ";
if ((txtID.Text.Trim()) != "")
{
strSql = strSql + " and id='" + txtID.Text.Trim() + "'";
}
if ((txtName.Text.Trim()) != "")
{
strSql = strSql + " and name='" + txtName.Text.Trim() + "'";
}
if ((ddlClass.Text.Trim()) != "")
{
strSql = strSql + " and class='" + ddlClass.Text.Trim() + "'";
}
if ((txtStation.Text.Trim()) != "")
{
strSql = strSql + " and station='" + txtStation.Text.Trim() + "'";
}
if ((ddlWorkShop.Text.Trim()) != "")
{
strSql = strSql + " and workshop='" + ddlWorkShop.Text.Trim() + "'";
}
DataTable dt = Userdata.Query(strSql);
this.UserGrd.DataSource = dt;
this.UserGrd.DataBind();
}
public void IsPasswordShortEnough()
{
var user = new Userdata();
var actual = user.IsPasswordOK("123455lj66778");
Assert.AreEqual(true, actual);
}
private void OnInsertCompleted(IRestResponse <Userdata> response)
{
if (!response.IsError && response.StatusCode == HttpStatusCode.Created)
{
Debug.Log("OnInsertItemCompleted: " + response.Content + " status code:" + response.StatusCode + " data:" + response.Data);
Userdata item = response.Data; // if successful the item will have an 'id' property value
// Debug.Log("JONG MER ====== "+item);
// _score = item;
SceneManager.LoadScene("Dashboard");
}
else
{
Debug.LogWarning("Insert Error Status:" + response.StatusCode + " Url: " + response.Url);
if (response.StatusCode.ToString() == "Conflict")
{
//Userdata is existed, do update operation instead
Debug.Log("UPDATING DATA OPERATOIN");
UpdateData();
}
if (response.StatusCode.ToString() == "0")
{
//TODO: Show alert, No connection
AlertPanel.SetActive(true);
BGTransparency.SetActive(true);
popUpInfoText.text = "You don't seem to have an active internet connection which is mandatory for us to store your data. Please retry.";
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
Userdata users = Userdata.getUserInfo(txtID.Text);
if (users.ID == null)
{
JScript.Alert("用户不存在！", this);
}
else
{
if (users.Pwd != txtPassWord.Text)
{
JScript.Alert("密码错误！", this);
}
else
{
System.Web.Security.FormsAuthentication.SetAuthCookie(txtID.Text, false);
//设置车间cookie
Response.Cookies["workshop"].Value = users.Workshop;
Response.Cookies["name"].Value = HttpUtility.UrlEncode(users.Name);
Response.Cookies["userID"].Value = users.ID;
log.Info("登陆成功");
JScript.JavaScriptLocationHref("Index.aspx", this);
}
}
}
public Userdata GetEditprofileById(int UserId)
{
Userdata Cust = new Userdata();
try
{
using (var dBContext = new CustomerReportContext())
{
var dep = dBContext.User.Where(x => x.UserId == UserId).SingleOrDefault();
if (dep != null)
{
Cust.UserId = dep.UserId;
Cust.FirstName = dep.FirstName;
Cust.LastName = dep.LastName;
Cust.UserName = dep.UserName;
Cust.Password = dep.Password;
Cust.Dob = dep.Dob;
Cust.Gender = dep.Gender;
Cust.Usertype = dep.Usertype;
Cust.Region = dep.Region;
}
return(Cust);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
}
public ActionResult Login(login uData)
{
if (ModelState.IsValid)
{
using (db)
{
Userdata obj = db.Userdatas.FirstOrDefault(u => u.Email.Equals(uData.Email) && u.Password.Equals(uData.Password));
if (obj != null)
{
if (uData.Email == "*****@*****.**")
{
return(RedirectToAction("Index", "Events"));
}
else
{
Session["Email"] = uData.Email;
return(RedirectToAction("Index", "Home"));
}
}
else
{
Response.Write("<script> alert('Please enter a valid password')</script>");
}
}
}
return(View());
}
//写入文件
public static void isAllow(string name, Page page, string power)
{
if (!Userdata.getUserPower(name, power))
{
JScript.JavaScriptLocationHref("../denied.aspx", page);
}
}
public void IsAtLeastOneSpecialCaseIncluded()
{
var user = new Userdata();
var actual = user.IsPasswordOK("JLSDFdfSDJFLK!JDF");
Assert.AreEqual(true, actual);
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
if (txtConfirmPWD.Text != txtConfirmPWD.Text)
{
JScript.Alert("新密码和确认密码不一致！", this);
return;
}
Userdata newUser = new Userdata();
newUser = Userdata.getUserInfo(txtUserID.Text);
if (newUser.ID != null)
{
if (newUser.Pwd != txtOriginalPWD.Text)
{
JScript.Alert("原始密码错误", this);
return;
}
int result = Userdata.ChangePWD(txtUserID.Text, txtNewPWD.Text);
if (result > 0)
{
JScript.AlertAndRedirect("密码修改成功！", "../Index.aspx", this);
}
}
else
{
JScript.Alert("用户不存在", this);
return;
}
}
public string PostTest([FromBody] object value)
{
try
{
Userdata oLogin = JsonConvert.DeserializeObject <Userdata>(value.ToString());
string insertdata = $"SELECT id_profile, user_name FROM Profile WHERE user_name='" + oLogin.user + "' AND password ='******'";
DataSet a = Settings.LoadDataSet(insertdata);
if (a.Tables[0].Rows.Count > 0)
{
json = JsonConvert.SerializeObject(a, Formatting.None);
}
else
{
//json = "{\r\n \"Table\":[\r\n {\r\n \"status\":\"gagal\"\r\n}\r\n ]\r\n}";
json = JsonConvert.SerializeObject("{\"Table\":[{\"status\":\"gagal\"}]}", Formatting.Indented);
}
return(json);
//return value;
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ActionResult Create([Bind(Include = "UserID,Username,Password,Email")] Userdata userdata)
{
try
{
if (ModelState.IsValid)
{
using (db)
{
//Checks for existing user email in the Userdata table
List <Userdata> obj = db.Userdatas.Where(u => u.Email == userdata.Email).ToList();
if (obj.Count > 0)
{
Response.Write("<script> alert('User already exists, Please enter a valid password')</script>");
//Session["Email"] = uData.Email;
//return RedirectToAction("Index", "Home");
}
else
{
db.Userdatas.Add(userdata);
db.SaveChanges();
return(RedirectToAction("Login", "Home"));
}
}
}
return(View(userdata));
}
catch (Exception)
{
return(RedirectToAction("Contact", "Home"));
}
}
public void IsAtLeastOneUppercaseIncluded()
{
var user = new Userdata();
var actual = user.IsPasswordOK("hjaKkjhakjha");
Assert.AreEqual(true, actual);
}
public void Insert()
{
Userdata userdata = GetUserData();
// if (Validate (score)) {
StartCoroutine(_table.Insert <Userdata> (userdata, OnInsertCompleted));
// }
}
public ActionResult DeleteConfirmed(int id)
{
Userdata userdata = db.Userdatas.Find(id);
db.Userdatas.Remove(userdata);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public Boolean MatchRule(Userdata usr)
{
String rule = "";
foreach (Object o in listBoxRegras.Items)
{
String s = o.ToString();
if (s == "E")
{
s = "And";
}
if (s == "OU")
{
s = "Or";
}
if (s.Contains("="))
{
String left = s.Split('=').First().Trim();
String right = s.Split('=').Last().Trim();
if (right.Contains("\"")) // valor
{
right = right.Trim('\"');
s = (usr[left] == right).ToString();
}
else // campo
{
s = (usr[left] == usr[right]).ToString();
}
}
//s = s.Replace("=", "Equal");
if (s.Contains("≠"))
{
String left = s.Split('≠').First().Trim();
String right = s.Split('≠').Last().Trim();
if (right.Contains("\"")) // valor
{
right = right.Trim('\"');
s = (usr[left] != right).ToString();
}
else // campo
{
s = (usr[left] != usr[right]).ToString();
}
}
//s = s.Replace("≠", "NotEqual");
rule += " " + s;
}
rule = rule.Trim();
try
{
return(new Parser(new Tokenizer(rule).Tokenize()).Parse());
}
catch
{
return(false);
}
}
public IActionResult AddTrace(Userdata tracer)
{
int count = Helper.HelperClass.Userdatalist.Count;
count++;
tracer.id = count;
Helper.HelperClass.Userdatalist.Add(tracer);
return(Ok());
}
public void CleanGame(Userdata player)
{
GameObject.Destroy(GameObject.Find(player.CurrentPlanet));
player.nextPlanet();
player.CurrentDistanceTraveled = 0;
ApplicationModel.Instance.Player = player;
ApplicationModel.Instance.SendCompletedData();
ApplicationModel.Instance.ChangeToMenuState();
}
public void GetAzureUserData()
{
// ResetList ();
Userdata userdata = PrepareUserData();
string filter = string.Format("username eq '{0}'", GameManager.Instance.profileName);
//string orderBy = "score desc";
CustomQuery query = new CustomQuery(filter);
Query(query);
}
public IActionResult UpdateTracer(int id, Userdata tracer)
{
var list = Helper.HelperClass.Userdatalist.Find(s => s.id == id);
list.observationname = tracer.observationname;
list.observationdate = tracer.observationdate;
list.noobservation = tracer.noobservation;
list.tracername = tracer.tracername;
return(Ok());
}
public void FillMissingUsers(IEnumerable <User> users, UserStatus status, bool skipInactive)
{
foreach (var item in users)
{
if (!Userdata.ContainsKey(item) && (!skipInactive || item.active == 1))
{
Userdata[item] = status;
}
}
}
public void IsPasswordTooShort()
{
var user = new Userdata();
var isPasswordLongEnough = "12345";
var actual = user.IsPasswordOK(isPasswordLongEnough);
var expected = false;
Assert.AreEqual(actual, expected);
}
public ActionResult Edit([Bind(Include = "id,surname,firstname,email,phone,username,password,regdate,gender,dob,maritalstatus,address,medicalhistry,otherinfo,age,role")] Userdata userdata)
{
if (ModelState.IsValid)
{
db.Entry(userdata).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userdata));
}
public IActionResult AddTrace(string usermail, Userdata tracer)
{
tracer.useremail = usermail;
int count = Helper.HelperClass.Userdatalist.Count;
count++;
tracer.id = count;
Helper.HelperClass.Userdatalist.Add(tracer);
return(Ok());
}
public ActionResult Edit([Bind(Include = "UserID,Username,Password,Email")] Userdata userdata)
{
if (ModelState.IsValid)
{
db.Entry(userdata).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userdata));
}
IEnumerator Login()
{
string loginURL = baseURL + "login";
WWWForm form = new WWWForm();
form.AddField("username", username);
form.AddField("password", password);
WWW request = new WWW(loginURL, form);
uiBlockGo.SetActive(true);
yield return(request);
uiBlockGo.SetActive(false);
if (!string.IsNullOrEmpty(request.error))
{
Debug.Log(request.error);
}
else
{
Debug.Log("Server contacted!");
}
//Debug.Log(request.text);
if (request.text.Equals("Failure_Password"))
{
responseLoginText = responseLoginGo.GetComponent <Text>();
responseLoginText.text = "Wrong password!";
}
else if (request.text.Equals("Failure_User"))
{
responseLoginText = responseLoginGo.GetComponent <Text>();
responseLoginText.text = "Wrong Username!";
}
else
{
jsonUser = JsonUtility.FromJson <Userdata>(request.text);
responseLoginText.text = "Logged in";
setupPlayerManagement();
loadMainScene();
}
//ToDo: save jsonUser -> PlayerManager Object
//Debug.Log(jsonUser.username);
//Debug.Log(jsonUser.user_email);
//Debug.Log(jsonUser.user_credit);
//Debug.Log(jsonUser.user_level);
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
//设置user群组
Userdata.deleteUsergroup(Request.QueryString["id"].ToString());
for (int i = 0; i < cblUsergroup.Items.Count; i++)
{
if (cblUsergroup.Items[i].Selected == true)
{
Userdata.addUsergroup(Request.QueryString["id"].ToString(), cblUsergroup.Items[i].Value);
}
}
}
[HttpPost]//Login
public IActionResult Post([FromBody] Userdata Model)
{
var user = _authenticateService.Authenticate(Model);
if (user == null)
{
return(BadRequest(new { message = "Username or Password is incorrect" }));
}
else
{
return(Ok(user));
}
}
public bool OfflineLogin()
{
//First check if any saved data is in store in phone, if not then create new data.
if (GameControl.control.LoadGameData())
{
Userdata player = new Userdata();
player.CurrentDistanceTraveled = GameControl.control.gameData.planedCurrentDistance;
player.CurrentPlanet = GameControl.control.gameData.currentPlanet;
SolarSystem system = new SolarSystem();
system.SystemName = "Solar System";
system.AddPlanet("Mercury", 91652559700, 1);
system.AddPlanet("Venus", 50290000000, 2);
system.AddPlanet("Moon", 384403000, 0);
system.AddPlanet("Mars", 119740000000, 3);
system.AddPlanet("Jupiter", 720420000000, 4);
system.AddPlanet("Saturn", 646270000000, 5);
system.AddPlanet("Uranus", 1448950000000, 6);
system.AddPlanet("Neptune", 1627450000000, 7);
system.AddPlanet("Pluto", 4265932000000, 8);
player.SolarSystem = system;
ApplicationModel.Instance.Player = player;
return(true);
}
//Create new data
else
{
Userdata player = new Userdata();
player.CurrentDistanceTraveled = 0;
player.CurrentPlanet = "Moon";
SolarSystem system = new SolarSystem();
system.SystemName = "Solar System";
system.AddPlanet("Mercury", 91652559700, 1);
system.AddPlanet("Venus", 50290000000, 2);
system.AddPlanet("Moon", 384403000, 0);
system.AddPlanet("Mars", 119740000000, 3);
system.AddPlanet("Jupiter", 720420000000, 4);
system.AddPlanet("Saturn", 646270000000, 5);
system.AddPlanet("Uranus", 1448950000000, 6);
system.AddPlanet("Neptune", 1627450000000, 7);
system.AddPlanet("Pluto", 4265932000000, 8);
player.SolarSystem = system;
ApplicationModel.Instance.Player = player;
return(true);
}
}
/* ===============================================================================================
* SECTION FOR UI VALIDATION
* ===============================================================================================
*/
// / <summary>
// / Validate data before sending
// / </summary>
private bool Validate(Userdata userdata)
{
bool isGenderValid = true, isBirthDayValid = true, isBirthMonthValid = true, isBirthYearValid = true, isHeightValid = true, isWeightValid = true;
// Validate birth day
if (userGenderDropDown.value == 0)
{
isGenderValid = false;
Debug.LogWarning("gender input error");
ShowErrorText("Gender");
}
if (userBirthDayDropDown.value == 0)
{
isBirthDayValid = false;
Debug.LogWarning("birth day input error");
ShowErrorText("Day");
}
if (userBirthMonthDropDown.value == 0)
{
isBirthMonthValid = false;
Debug.LogWarning("birth month input error");
ShowErrorText("Month");
}
if (userBirthYearDropDown.value == 0)
{
isBirthYearValid = false;
Debug.LogWarning("birth year input error");
ShowErrorText("Year");
}
// Validate height
if (String.IsNullOrEmpty(userHeightInput.text))
{
isHeightValid = false;
Debug.LogWarning("height input error");
ShowErrorText("Height");
}
// Validate height
if (String.IsNullOrEmpty(userWeightInput.text))
{
isWeightValid = false;
Debug.LogWarning("weight input error");
ShowErrorText("Weight");
}
return(isGenderValid && isBirthDayValid && isBirthMonthValid && isBirthYearValid && isHeightValid && isWeightValid);
}
