public static string LoginBox() { string str = ""; if (CKUser.IsLogin) { str = @"<div class='loginhead'>欢迎回来 {0}</div> <div class='loginbody'> <div style='float:left;width:90px;'><a href='/{0}{1}'><img src='/upload/photo/{0}.jpg' class='loginphoto' {3} /></a> </div><div style='float:right;width:140px;line-height:150%;'> <a href='/{0}{1}'>我的博客</a><br /><a href='/group/{0}{1}'>我的群组</a><br /><span>博客访问量:{2}</span> </div><div class='clear'></div> <p class='loginline'><a class='edit' href='/baseinfo.aspx'>修改个人资料</a> <br /><a class='publish' href='/write.aspx'>发表文章</a></p></div>"; DBUser u = new DBUser(CKUser.Username); str = String.Format(str, u.Username, Settings.Ext, u.ViewCount, Strings.UserBigImageError); } else { str = @"<div class='loginhead'>用 户 登 陆</div> <div class='loginbody'> <p>用户名 <input id='txtName' type='text' class='put' style='width:160px;' /><span></span></p> <p>密<span style='padding-left:12px;'></span>码 <input id='txtPassword' type='password' class='put' style='width:160px;' onkeydown='if(isEnter(event))login();' /><span></span></p> <p style='padding-left:46px;'><label id='chkRe' class='chkRe' onclick='javascript:checkRemember(this);'>下次自动登录</label></p> <p style='padding:10px 0px 10px 46px;'><a class='btns' href='javascript:void(0);' onclick='javascript:login();return false;'>登 录</a> <a href='/resetpwd.aspx'>忘记密码?</a></p> </div>"; } return str; }
/* * ARE YOU LOST? Usuarios y contraseñas se deben configurar * desde la funcion GetDBUser(). Recuerda que cada nivel de * usuario tiene su propio usuario en base de datos y si no * se establece uno se utiliza uno la clase arrojará un error * cuando aun no has autenticado al usuario utiliza el permiso * de Visor */ /// <summary> /// Devuelve una conexion a SQL Server con los parametos preconfigurados /// de la clase <see cref="ConexionSQL"/> /// </summary> /// <returns>Conexión nueva SIN ABRIR</returns> /// <remarks> /// El usuario de esta clase será el responsable de abrir y cerrar las /// conexiones devueltas. Esta clase solo ayuda a mantener los parametros /// de conexion juntos para facilitar el mantenimiento. /// </remarks> public SqlConnection GetConnection() { DBUser user = GetDBUser(); string conString = @"DATA SOURCE = " + Server + " ; USER ID = " + user.Username + "; PASSWORD = "******"; INITIAL CATALOG = " + DBName + "; TIMEOUT = 10;"; //string conString = @"DATA SOURCE = DESKTOP-PQOR5LH\SQLEXPRESS ; USER ID = " + user.Username + "; PASSWORD = "******"; INITIAL CATALOG = " + DBName + "; TIMEOUT = 10;"; SqlConnection conn = new SqlConnection(conString); return(conn); }
private void bindFormPatientAndSurgeonUUID() { DBPatientInfo patient = new DBPatientInfo(selectedPatientuuid); lb_PatientInfo.Text = String.Format("Name: {0}\r\rBirth: {1}", patient.fullName, patient.birthdayDBString); DBUser surgeon = new DBUser(selectedBookedsurgeonuuid); lb_BookedInfo.Text = String.Format("Surgeon: {0}", surgeon.displayName); }
public void AddAccount() { //if(SecureStringToString()) //byte[] salt; //new RNGCryptoServiceProvider().GetBytes(salt = new byte[16]); //var pbkdf2 = new Rfc2898DeriveBytes(SecureStringToString(SecurePassword), salt, 10000); //byte[] hash = pbkdf2.GetBytes(20); //byte[] hashBytes = new byte[36]; //Array.Copy(salt, 0, hashBytes, 0, 16); //Array.Copy(hash, 0, hashBytes, 16, 20); if (!String.IsNullOrEmpty(NewUser)) { bool flaga = false; using (var context = new StudentAppContext()) { var users = context.DBUsers.ToList(); for (int i = 0; i < users.Count; i++) { if (NewUser.Equals(users[i].Login)) { flaga = true; break; } } } if (NewPassword1.Equals(NewPassword2) && flaga == false) { //test_haslo = CreatePasswordHash(NewPassword1); var dbuser = new DBUser { Login = newUser, Password = CreatePasswordHash(NewPassword1) }; int userId; using (var context = new StudentAppContext()) { context.DBUsers.Add(dbuser); context.SaveChanges(); var obiektChwilowy = context.DBUsers.OrderByDescending(x => x.DBUserId).FirstOrDefault(); userId = obiektChwilowy.DBUserId; } IsDialogOpen = false; } } //trzeba zapisać savedPasswordHash do bazy }
private void BindAuthorData() { DBUser dbuser = new DBUser(who); if (!dbuser.Exist) { Server.Transfer("~/note.aspx?q=Notfound"); } title = dbuser.Fullname + "的迷你博客"; Page.Title = title + " - cnOpenBlog"; StringBuilder sb = new StringBuilder(); sb.AppendFormat("<p style='text-align:center;'><a href='/{0}{1}'><img id='author_img' src='/upload/photo/{0}.jpg' {2} alt='{0}' class='photo' /></a></p>", dbuser.Username, Settings.Ext, Strings.UserBigImageError); string age = ""; if (dbuser.ShowBirthday) age = "," + Convert.ToString(DateTime.Now.Year - dbuser.Birthday.Year); string editstr = ""; if (CKUser.Username == dbuser.Username) { editstr = " <a class='edit' href='/baseinfo.aspx'>[编辑资料]</a>"; } else { editstr = String.Format(" <a class='addf' href='{0}' onclick='javascript:addFriend(this,\"{1}\");return false;'>[加为好友]</a>", Strings.JSVoid, dbuser.Username); } sb.AppendFormat("<p><a href='/{0}{5}'>{1}</a>,{2}{3}{4}</p>", dbuser.Username, dbuser.Fullname, dbuser.Sex, age, editstr, Settings.Ext); sb.AppendFormat("<p>访问次数:{0}</p>", dbuser.ViewCount); if (dbuser.State != "") { sb.Append("<p>城市:"); if (dbuser.City.Length == 2 || dbuser.State.Substring(0, 2) == dbuser.City.Substring(0, 2)) { sb.AppendFormat("<a href='/city/{0}{1}'>{0}</a>", dbuser.City, Settings.Ext); } else { sb.AppendFormat("<a href='/city/{2}{1}'>{2}</a>,<a href='/city/{0}{1}'>{0}</a>", dbuser.City, Settings.Ext, dbuser.State); } sb.Append("</p>"); } if (dbuser.Hangye != "") sb.AppendFormat("<p>行业:<a href='/industry/{0}{1}'>{0}</a></p>", dbuser.Hangye, Settings.Ext); if (dbuser.ShowEmail) sb.AppendFormat("<p>Email:<a href='mailto:{0}'>{0}</a></p>", dbuser.Email); if (dbuser.ShowQQ && dbuser.QQ != "") sb.AppendFormat("<p>QQ:<a href='http://wpa.qq.com/msgrd?V=1&Uin={0}&Site=cnopenblog.com&Menu=yes'>{0}</a></p>", dbuser.QQ); if (dbuser.ShowMSN && dbuser.MSN != "") sb.AppendFormat("<p>MSN:<a href='mailto:{0}'>{0}</a></p>", dbuser.MSN); if (dbuser.Url != "") { sb.AppendFormat("<p>主页:<a href='{0}'>", dbuser.Url); if (dbuser.Url.Length > 24) sb.AppendFormat("{0}<br />{1}", dbuser.Url.Substring(0, 22), dbuser.Url.Substring(22)); else sb.Append(dbuser.Url); sb.Append("</a></p>"); } sb.AppendFormat("<br /><p>个人简介:</p><p style='text-indent:2em;'>{0}</p>", Tools.HtmlEncode(dbuser.Jianjie)); if (dbuser.Xingqu != "") sb.AppendFormat("<br /><p>兴趣爱好:</p><p style='text-indent:2em;'>{0}</p>", Tools.HtmlEncode(dbuser.Xingqu)); lblAuthorData.Text = sb.ToString(); }
public static IdentityDBUser Create(DBUser dBUser) { dBUser.Id = Guid.NewGuid().ToString().Replace("-", ""); return(new IdentityDBUser() { Email = dBUser.Email, PhoneNumber = dBUser.PhoneNumber, UserName = dBUser.UserName, DBUser = dBUser }); }
public void PasswordHashHasCorrectLength() { var u = new DBUser(); u.Username = "******"; var password = "******"; u.CreateCryptoFields(password); Assert.AreEqual(64, u.PasswordHash.Length); }
private void AddUserToDatabaseIfNonExisting(string userID) { DBUserProcessor userProcessor = new DBUserProcessor(); DBUser userData = userProcessor.getByKey(userID); // if userData null, add user if (userData == null) { userProcessor.AddUser(userID); } }
public static bool Register() { ICollection <User> users = DBUser.ReadUsers(); ConsoleUI.ShowLine("press 0 anytime to exit"); bool exit; exit = ConsoleUI.GetString(out string username, "give username: "******"give password: "******"repeat password: "******"passwords are not the same!!"); return(false); } string encryptedPassword = CryptoManager.EncryptPassword(password1, out string encryptedSalt); try { int headMasterSaved = DBUser.CreateUser(username, encryptedPassword, encryptedSalt, "headmaster", out int id); if (headMasterSaved == 0) { throw new Exception("head master NOT saved"); } } catch (Exception e) { ConsoleUI.ShowLine(e.Message); ConsoleUI.ReadKey(); return(false); } ConsoleUI.ShowLine("head master created"); ConsoleUI.ReadKey(); return(true); }
public bool Authorize(ClientAuthStruct auth, IMWRObject request) { DBUser dbUser = new DBUser(dataProvider); dbUser.Connection = connection; dbUser.Load(auth.UserName, auth.Password); if (dbUser.BusinessObject == null) { return false; } return true; }
public MockData(SQLiteConnection database) { var users = from p in database.Table <DBUser>() select p; if (users.Count() == 0) { List <DBClock> dBClocksList1 = new List <DBClock>() { new DBClock() { ClockHeadColor = ColorConverter.ColorToHex(Color.Red), ClockFaceColor = ColorConverter.ColorToHex(Color.Black), ClockTimeZoneId = TimeZoneInfo.Local.Id }, new DBClock() { ClockHeadColor = ColorConverter.ColorToHex(Color.Green), ClockFaceColor = ColorConverter.ColorToHex(Color.Yellow), ClockTimeZoneId = TimeZoneInfo.Local.Id } }; List <DBClock> dBClocksList2 = new List <DBClock>() { new DBClock() { ClockHeadColor = ColorConverter.ColorToHex(Color.Purple), ClockFaceColor = ColorConverter.ColorToHex(Color.Blue), ClockTimeZoneId = TimeZoneInfo.Local.Id } }; DBUser user1 = new DBUser() { Login = "******", Password = "******", }; DBUser user2 = new DBUser() { Login = "******", Password = "******" }; database.Insert(user1); database.InsertAll(dBClocksList1); user1.Clocks = dBClocksList1; database.UpdateWithChildren(user1); database.Insert(user2); database.InsertAll(dBClocksList2); user2.Clocks = dBClocksList2; database.UpdateWithChildren(user2); } }
public void AddUser(VMUser user) { if (user.UserID != null) { var newUser = new DBUser { UserID = user.UserID, UserName = user.UserName }; db.Users.Add(newUser); db.SaveChanges(); } }
public UserDTOOut GetById(int Id) { DBUser user = _context.Users.SingleOrDefault(x => x.Id == Id); return(new UserDTOOut { Firstname = user.Firstname, Id = user.Id, Lastname = user.Lastname, Username = user.Username }); }
private void BindData() { DBUser u = new DBUser(username); StringBuilder sb = new StringBuilder(); sb.Append("<table id='box-1'><tr><td style='vertical-align:top;'>"); sb.AppendFormat("<img id='uph' class='photo' alt='{0}' src='/upload/photo/{0}.jpg' onerror='this.src=\"/upload/photo/nophoto.jpg\";' />", username); sb.Append("<p style='text-align:center;'><a class='upphoto' href='#photo' onclick=\"javascript:show('photo');\">更改头像</a></p>"); sb.AppendFormat("<p>姓名:{0}<br />性别:{1}<br />年龄:{2}岁(<i>{3}</i>)</p>", u.Fullname, u.Sex, DateTime.Now.Year - u.Birthday.Year, u.ShowBirthday ? "公开" : "未公开"); sb.Append("</td><td style='vertical-align:top; padding-left:20px;'>"); sb.Append("<p><a class='edit' href='#edit' onclick=\"javascript:show('edit');\">编辑我的资料</a></p>"); sb.AppendFormat("<p>行业:{0}</p>", u.Hangye); sb.AppendFormat("<p>QQ:{0}(<i>{1}</i>)</p>", u.QQ,u.ShowQQ?"公开":"未公开"); sb.AppendFormat("<p>MSN:{0}(<i>{1}</i>)</p>", u.MSN, u.ShowMSN ? "公开" : "未公开"); sb.AppendFormat("<p>E-mail:<a href='mailto:{0}'>{0}</a>(<i>{1}</i>)</p>", u.Email, u.ShowEmail ? "公开" : "未公开"); sb.AppendFormat("<p>个人网站:<a href='{0}'>{0}</a></p>", u.Url); sb.AppendFormat("<p>所在城市:{0},{1}</p>", u.City, u.State); sb.AppendFormat("<p>博客标题:{0}</p>",Tools.HtmlEncode(u.BlogTitle)); sb.AppendFormat("<p>博客副标题:{0}</p>", Tools.HtmlEncode(u.BlogSubtitle)); sb.AppendFormat("<p>个人简介:{0}</p>", Tools.HtmlEncode(u.Jianjie)); sb.AppendFormat("<p>兴趣爱好:{0}</p>", Tools.HtmlEncode(u.Xingqu)); sb.AppendFormat("<p>个性签名:{0}</p>", Tools.HtmlEncode(u.Qianming)); sb.Append("</td></tr></table>"); lblBox1.Text = sb.ToString(); sb = new StringBuilder(); sb.Append("setValue = function(){"); sb.AppendFormat("el('txtFullname').value='{0}';", u.Fullname); sb.AppendFormat("el('txtEmail').value='{0}';", u.Email); if (u.Sex == "男") sb.Append("el('radsex1').checked=true;"); else sb.Append("el('radsex2').checked=true;"); sb.AppendFormat("el('selYear').value='{0}';", u.Birthday.Year); sb.AppendFormat("el('selMonth').value='{0}';", u.Birthday.Month); sb.AppendFormat("el('selHangye').value='{0}';", u.Hangye); sb.AppendFormat("el('txtUrl').value='{0}';", u.Url); sb.AppendFormat("el('txtQQ').value='{0}';", u.QQ); sb.AppendFormat("el('txtMSN').value='{0}';", u.MSN); sb.AppendFormat("el('txtJianjie').value='{0}';", u.Jianjie.Replace("'","\\'")); sb.AppendFormat("el('txtXingqu').value='{0}';", u.Xingqu.Replace("'", "\\'")); sb.AppendFormat("el('txtQianming').value='{0}';", u.Qianming.Replace("'", "\\'")); sb.AppendFormat("el('txtBlogtitle').value='{0}';", u.BlogTitle.Replace("'", "\\'")); sb.AppendFormat("el('txtBlogsubtitle').value='{0}';", u.BlogSubtitle.Replace("'", "\\'")); if (u.ShowBirthday) sb.Append("el('chkBirthday').checked=true;"); if (u.ShowEmail) sb.Append("el('chkEmail').checked=true;"); if (u.ShowQQ) sb.Append("el('chkQQ').checked=true;"); if (u.ShowMSN) sb.Append("el('chkMSN').checked=true;"); sb.AppendFormat("_init_state('{0}');_init_city('{0}','{1}');", u.State, u.City); sb.Append("};"); script = sb.ToString(); }
/// <summary> /// Takes a username and an un-hashed password from the WCF, and returns a the corrosponding user, if there is a user with that username and password in the Database. Otherwise, returns null. /// </summary> public User ValidateUser(String username, string unHashedPassword) { DBUser dbUser = new DBUser(); User user = dbUser.GetByName(username); //Salt added to unHashedPassword if (user != null && user.Password != User.HashThisPassword(user.Salt + unHashedPassword)) { user = null; } return(user); }
public void GetPlaintextMasterKeyReturns256Bit() { var u = new DBUser(); u.Username = "******"; var password = "******"; u.CreateCryptoFields(password); var master_key = u.GetPlaintextMasterKey(password); Assert.AreEqual(32, master_key.Length); }
// private UserRepository userRepository; public FormUsers() { InitializeComponent(); dBUserContext = new DBUser(); var types = dBUserContext.UserTypes.ToList(); foreach (UserType item in types) { comboBoxTip.Items.Add(item); } refreshGrid(); }
public static void getUser() { DBUser user = new DBUser(); sortPaging sr = new sortPaging(); sr.pageNumber = 1; sr.pageSize = 10; sr.sortColumn = "Firstname"; sr.sortDirection = "asc"; user.getUser(sr); }
internal static List <DBNews> GetNewsAuthor(DBUser author) { using (SampleContext context = new SampleContext()) { var tmp = context.news.Where(u => u.userId == author.userId).Select(u => u).ToList(); if (tmp != null) { return(tmp); } } return(new List <DBNews>()); }
public async Task <ActionResult <DBUser> > updateregistration([FromBody] DBUser user) { var _user = await _context.DBUser.FirstOrDefaultAsync(e => e.UUID == user.UUID); //ocaisonaly notification hub tokens will expire and when they do the backeend database will need the new device id they registered // _user. // _context.Update() await _context.SaveChangesAsync(); return(CreatedAtAction("GetUser", user));//new { id = user.ID }, }
public static int SaveUser(DBUser user) { int userId = user.Id; using (ApplicationContext db = new ApplicationContext()) { DBUser usr; if (userId < 1) { userId = db.Users.OrderBy(x => x.Id).LastOrDefault()?.Id ?? 1; user.Id = ++userId; db.Users.Add(user); usr = user; } else { usr = db.Users.FirstOrDefault(x => x.Id == userId); if (usr == null) { throw new Exception($"Нет записи user с таким Id = {userId}"); } user.CityId = usr.CityId; db.Entry(usr).CurrentValues.SetValues(user); //db.Update(usr); } db.SaveChanges(); usr = db.Users.FirstOrDefault(x => x.Id == userId); foreach (var login in user.Logins) { DBLogin lgn = db.Logins .FirstOrDefault(x => x.Login == login.Login); if (lgn == null) { lgn = login; lgn.UserId = userId; db.Logins.Add(lgn); } else { lgn = login; } } db.SaveChanges(); } return(userId); }
internal User Map(DBUser dbUser) { if (dbUser == null) { return(null); } return(new User() { Id = dbUser.Id, Email = dbUser.Email, Password = dbUser.PassHash }); }
public DatabaseNoteRepository(string username) { dbConnection = DbConfig.GetConnection(); dbUser = dbConnection.First <DBUser> (u => u.Username == username); storage = new DbStorage(dbUser); engine = new Engine(storage); if (dbUser.Manifest == null || string.IsNullOrEmpty(dbUser.Manifest.ServerId)) { // the user may not yet have synced dbUser.Manifest.ServerId = Guid.NewGuid().ToString(); } }
public static DBUser GetUser(int Id) { var filter = new FilterUser() { Id = Id }.ToFilter(); var user = new DBUser(); using (ApplicationContext db = new ApplicationContext()) { user = db.Users.Include(x => x.City).Where(filter).FirstOrDefault(); } return(user); }
public bool Update(User m_User, string oldUserName) { if (m_User.UserName != oldUserName) { if (!DBUser.isUserNameAvailable(m_User.UserName)) { return(false); } } DBUser.userUpdate(m_User); return(true); }
public void GetPlaintextMasterKeyReturnsSameKeyForSamePassword() { var u = new DBUser(); u.Username = "******"; var password = "******"; u.CreateCryptoFields(password); var key1 = u.GetPlaintextMasterKey(password); var key2 = u.GetPlaintextMasterKey(password); Assert.AreEqual(key1, key2); Assert.AreEqual(key1.ToHexString(), key2.ToHexString()); }
public void InsertUser() { User user = new User("ThureKasperJesperHenrikOle1234", User.HashThisPassword("4321")); var dbUser = new DBUser(); //var userCtr = new UserCtr(); //userCtr.InsertUser("ThureKasperJesperHenrikOle1234", user.Password); dbUser.InsertUser(user); User extractedUser = dbUser.GetByName(user.Username); //Assert.IsTrue(extractedUser.Password.Equals(user.Password)); Assert.IsTrue(extractedUser.Username.Equals(user.Username)); }
/// <summary> /// POST /admin/user /// /// creates a new user. /// /// returns HTTP Response => /// 201 Created /// Location: http://localhost/admin/user/{Username} /// </summary> public object Post(UserRequest user) { var new_user = new DBUser(); // TODO explicit mapping new_user.PopulateWith(user); // TODO move into RequestFilter if (string.IsNullOrEmpty(user.Username)) { throw new ArgumentNullException("user.Username"); } // TODO move into RequestFilter if (!(user.Username.IsOnlySafeChars() && user.Password.IsOnlySafeChars() && user.EmailAddress.Replace("@", "").IsOnlySafeChars())) { throw new ArgumentException("found unsafe/unallowed characters"); } // TODO move into RequestFilter // lowercase the username new_user.Username = new_user.Username.ToLower(); using (var conn = DbConfig.GetConnection()) { var existing_user = conn.FirstOrDefault <DBUser> ("Username = {0}", new_user.Username); if (existing_user != null) { throw new ConflictException() { ErrorMessage = "A user by that name already exists" } } ; conn.Insert <DBUser> (new_user); } return(new HttpResult(new_user) { StatusCode = HttpStatusCode.Created, StatusDescription = "Sucessfully created user " + new_user.Username, Headers = { { HttpHeaders.Location, base.Request.AbsoluteUri.CombineWith(new_user.Username) } } }); }
private void BindFriend() { string fields = "[f_id],[_name],[fullname],[hangye],[state],[city],[jianjie]"; string where = "[f_friend_name]=[_name] and [f_user_name]='" + username + "'"; string sql = "select {0} from [friends],[users] where {1}"; sql = String.Format(sql, fields, where); DataTable dt = DB.GetTable(sql); StringBuilder sb = new StringBuilder(); int i = 0; foreach (DataRow row in dt.Rows) { sb.AppendFormat("<div class='gitem{0}'>", i % 2 == 1 ? " gitem2" : ""); sb.AppendFormat("<div class='col1'><a href='/{0}{1}'><img src='/upload/photo/{0}-s.jpg' {2} alt='{0}' /></a></div>", row["_name"], Settings.Ext, Strings.UserSmallImageError); sb.AppendFormat("<div class='col2'><a href='/{0}{1}'>{0}</a> ({2})", row["_name"], Settings.Ext, row["fullname"]); if (row["state"].ToString() != "") { if (row["state"].ToString().Substring(0, 2) == row["city"].ToString().Substring(0, 2)) { sb.AppendFormat(" <a href='/city/{0}{1}'>{0}</a>", row["city"], Settings.Ext); } else { sb.AppendFormat(" <a href='/city/{0}{1}'>{0}</a>,<a href='/city/{2}{1}'>{2}</a>", row["state"], Settings.Ext, row["city"]); } } if (row["hangye"].ToString() != "") { sb.AppendFormat(" <span class='hui'>行业:</span><a href='/industry/{0}{1}'>{0}</a>", row["hangye"], Settings.Ext); } sb.AppendFormat("<p><span class='hui'>简介:</span>{0}</p></div>", Tools.HtmlEncode(Tools.CutString(row["jianjie"].ToString(), 60))); sb.AppendFormat("<div class='col3'><a href='{0}' onclick='javascript:sendMsg(this,\"{1}\");return false;'>发送消息</a><a href='{0}' onclick='javascript:deleteFriend(this,\"{1}\");return false;'>删除好友</a></div>", Strings.JSVoid, row["_name"]); sb.Append("<div class='clear'></div></div>"); i++; } if (i == 0) { sb.Append("<p>您还没有添加任何好友。</p>"); DBUser u = new DBUser(username); sb.Append("<ul>"); if (u.City != "") sb.AppendFormat("<li><a href='/city/{0}{1}'>查看<b>{0}</b>的所有用户</a></li>", u.City, Settings.Ext); if (u.Hangye != "") sb.AppendFormat("<li><a href='/industry/{0}{1}'>查看<b>{0}</b>行业的所有用户</a></li>", u.Hangye, Settings.Ext); sb.Append("</ul>"); } lblFriend.Text = sb.ToString(); }
public int SaveUser(User user) { try { DBUser newUser = Mapper.Map <User, DBUser>(user); uow.Users.Create(newUser); uow.Save(); int id = CheckUser(user.Login, user.Password); return(id); } catch (Exception) { return(0); } }
public Models.User Create(string name, string paasword, string email, bool enabled) { if ((DBUser.name == name).Count <DBUser>(DB) > 0) { return(null); } DBUser user = new DBUser(); user.Name = name; user.Password = paasword; user.Email = email; user.Enabled = enabled; user.Save(DB); return(user.MemberCopyTo <Models.User>()); }
private void NewPasswordUserClick(object sender, ItemClickEventArgs e) { try { var user = DBUser.Users_Select_Id(CurrentUser.Id); if (user.UpdatePassword(new ChangePasswordForm().ChangePassword(user.UserPassword, true))) { MessageWindow.GetInstance("Пароль успешно изменён.", MessageType.Info); } } catch (Exception) { MessageWindow.GetInstance("Пожалуйста, сохраните изменения!", MessageType.Attention); } }
public DatabaseNoteRepository(IDbConnectionFactory factory, DbStorageFactory storageFactory, IUser user) : base(factory) { this.storage = storageFactory.GetDbStorage(user); engine = new Engine(storage); using (var db = connFactory.OpenDbConnection()) { this.dbUser = db.Select <DBUser> (u => u.Username == user.Username)[0]; } if (dbUser.Manifest == null || string.IsNullOrEmpty(dbUser.Manifest.ServerId)) { // the user may not yet have synced dbUser.Manifest.ServerId = Guid.NewGuid().ToString(); } }
public void AddClock(ClockModel clockModel, int id) { DBUser user = GetUser(id); DBClock dBClock = new DBClock() { ClockHeadColor = ColorConverter.ColorToHex(clockModel.HeadColor), ClockFaceColor = ColorConverter.ColorToHex(clockModel.FaceColor), ClockTimeZoneId = clockModel.ClockTimeZone.Id }; database.Insert(dBClock); user.Clocks.Add(dBClock); database.UpdateWithChildren(user); }
public async Task <ActionResult <DBUser> > AddDevice([FromBody] DBUser user) { // if (user.UUID == null || user.devices == null || user == null) { return(BadRequest()); } Console.WriteLine(user.devices); var result = _context.DBUser.FirstOrDefault(x => x.UUID == user.UUID); user.pingAll(); if (result != null) { if (result.devices == null) { result.devices = user.devices; } else { result.devices.AddRange(user.devices); } /* * Console.WriteLine(result.devices.GetType()); * Console.WriteLine(typeof(List<device>)); * if (result.devices.GetType()== typeof(List<device>)) { * result.devices.AddRange(user.devices); * } else { * result.devices = user.devices; * }//*/ } else { return(NotFound()); } try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { throw; } return(NoContent()); }
private void SignIn(string u, string p, bool remember) { DBUser user = new DBUser(u); bool ok = false; if (user.Username != "") { ok = p.ToLower() == user.Password.ToLower(); } if (ok) { CKUser.Login(user.Username, user.Fullname, user.Email, remember); if (redirect == "null") redirect = ""; if (redirect != "") Response.Redirect(redirect); else Response.Redirect(CKUser.Username + Settings.Ext); } else { Response.Redirect("login.aspx?er=1"); } }
public void DeleteUserTest() { using (DBUser dbUser = new DBUser()) { User user = new User(); dbUser.Connection = new MySqlConnection(connString); dbUser.Connection.Open(); user.Name = "TestDelete"; user.Password = "******"; user.Group = 1; Assert.IsTrue(dbUser.Save(user)); int lastID = (int)dbUser.LastID; dbUser.Load(lastID); Assert.IsNotNull(dbUser.BusinessObject); dbUser.Delete(); dbUser.Load(lastID); Assert.IsNull(dbUser.BusinessObject); Assert.IsTrue(dbUser.Save(user)); lastID = (int)dbUser.LastID; dbUser.Delete(lastID); dbUser.Load(lastID); Assert.IsNull(dbUser.BusinessObject); } }
public void GetUserData(string userName, string password, out MachineWithPrivilleges [] machines, out User user) { DBUser dbUser = new DBUser(dataProvider); dbUser.Connection = connection; dbUser.Load(userName, password); user = dbUser.BusinessObject; DBMachineToPrivCollection dbMachineCol = new DBMachineToPrivCollection(dataProvider); dbMachineCol.Connection = connection; machines = dbMachineCol.Load(dbUser.BusinessObject.Group); }
public void LoadUserTest() { DBUser user = new DBUser(); User bUser = new User(); user.Connection = new MySqlConnection(connString); user.Connection.Open(); user.Load(1); Assert.IsNotNull(user.BusinessObject); Assert.IsTrue(user.BusinessObject.Name == "Tester"); }
public void LoadUser2Test() { using (DBUser dbUser = new DBUser()) { User user = new User(); dbUser.Connection = new MySqlConnection(connString); dbUser.Connection.Open(); dbUser.Load("Tester", "test"); Assert.IsNotNull(dbUser.BusinessObject); } }
public static IEnumerator CheckAndCreateGameUser(string facebookID, int globalID) { Debug.Log("Checking if Game User exists..."); dbUser = null; yield return Instance.StartCoroutine(GetGameUser(facebookID)); if(dbUser == null) { yield return Instance.StartCoroutine(CreateGameUser(facebookID, globalID)); yield return Instance.StartCoroutine(GetGameUser(facebookID)); } else Debug.Log("Game user already exists"); }
private static IEnumerator GetGameUser(string facebookID) { Debug.Log("DBHandler.GetGameUser()"); string post_url = getGameUserURL + "facebookID=" + facebookID; Debug.Log(string.Format("GetGameUser URL: {0}", post_url)); // Post the URL to the site and create a download object to get the result. WWW getUser_post = new WWW(post_url); yield return getUser_post; // Wait until the download is done if (getUser_post.error != null) Debug.Log("There was an error posting the GetUser : "******"WWW post: {0}", getUser_post.text)); if(!string.IsNullOrEmpty(getUser_post.text)) { Dictionary<string, object> data = Json.Deserialize(getUser_post.text) as Dictionary<string, object>; dbUser = new DBUser(int.Parse(data["id"].ToString()), data["facebookID"].ToString(), int.Parse(data["score"].ToString())); } }