/// <summary> /// This method returns Json string with a user information /// </summary> /// <param name="command"></param> /// <returns></returns> public string GetOne(string command) { DBRest db = new DBRest(); var users1 = db.Users.Select(p => new { p.NickName, p.FullName }).Where(p => p.NickName == command); string serialized1 = JsonConvert.SerializeObject(users1); return(serialized1); }
/// <summary> /// This method returns Json string with all users information /// </summary> /// <returns></returns> public string GetAll() { DBRest db = new DBRest(); var users = db.Users.Select(p => new { p.NickName, p.FullName }); /*from p in db.Users * select p.NickName + " " + p.FullName;*/ string serialized = JsonConvert.SerializeObject(users); return(serialized); }
/// <summary> /// This method returns Json string with delete procedure result /// </summary> /// <param name="command"></param> /// <returns></returns> public string DelUser(string command) { DBRest db = new DBRest(); string serialized1, serialized2; try { var deleted = db.Users.Where(p => p.NickName == command).FirstOrDefault(); db.Users.Remove(deleted); db.SaveChanges(); string answer1 = "Operation successful!"; serialized1 = JsonConvert.SerializeObject(answer1); } catch (Exception ex) { string answer2 = "Operation failed!" + ex.Message; serialized2 = JsonConvert.SerializeObject(answer2); return(serialized2); } return(serialized1); }
/// <summary> /// This method returns Json string with add procedure result /// </summary> /// <param name="command1"></param> /// <param name="command2"></param> /// <returns></returns> public string AddUser(string command1, string command2) { DBRest db = new DBRest(); string serialized1, serialized2; try { db.Users.Add(new User { NickName = command1, FullName = command2 }); db.SaveChanges(); string answer1 = "Operation successful!"; serialized1 = JsonConvert.SerializeObject(answer1); } catch (Exception ex) { string answer2 = "Operation failed!" + ex.Message; serialized2 = JsonConvert.SerializeObject(answer2); return(serialized2); } return(serialized1); }