private void setUserInfo() { TUsers tmpUser; try { using (var dc = new PTMessengerEntitiesModel()) { tmpUser = dc.TUsers.Where(u => u.TUsers_login == this.login).First(); } if (tmpUser != null) { tmpUser.TUser_imie = binRead.ReadString(); tmpUser.TUser_nazwisko = binRead.ReadString(); tmpUser.TUsers_email = binRead.ReadString(); } using (var dc = new PTMessengerEntitiesModel()) { dc.Entry(tmpUser).State = System.Data.Entity.EntityState.Modified; dc.SaveChanges(); } binWrite.Write("CHANGE_SUCCESS"); Console.WriteLine("{0} Uzytkownik {1} zmienil dane na: {2}, {3}, {4}", DateTime.Now, this.login, tmpUser.TUser_imie, tmpUser.TUser_nazwisko, tmpUser.TUsers_email); } catch (Exception ex) { Console.WriteLine("{0} {1}", DateTime.Now, ex); } }
private void passChange() { TUsers tmpUser; try { using (var dc = new PTMessengerEntitiesModel()) { tmpUser = dc.TUsers.Where(u => u.TUsers_login == this.login).First(); } if (tmpUser != null) { tmpUser.TUsers_passwd = binRead.ReadString(); } using (var dc = new PTMessengerEntitiesModel()) { dc.Entry(tmpUser).State = System.Data.Entity.EntityState.Modified; dc.SaveChanges(); } binWrite.Write("CHANGE_PASS_SUCCESS"); Console.WriteLine("{0} Uzytkownik {1} zmienil haslo", DateTime.Now, this.login); } catch (Exception ex) { Console.WriteLine("{0} {1}", DateTime.Now, ex); } }
public void saveLoginInfo(TUsers user, bool correct) { TLastLogin ll = new TLastLogin(); using (var dcx = new PTMessengerEntitiesModel()) { try { TUsers tmpUser = user; DateTime dateTime1H = DateTime.Now.AddHours(-1); var failLoginCount = (from c in dcx.TLastLogin where c.TLastLogin_TS > dateTime1H && c.TLastLogin_Success == false && c.TLastLogin_TUsers_id == user.TUsers_id select c).Count(); if (failLoginCount >= 3) { tmpUser.TUser_lock = true; binWrite.Write("LOGIN_DENY"); } else { tmpUser.TUser_lock = false; } dcx.Entry(tmpUser).State = System.Data.Entity.EntityState.Modified; ll.TLastLogin_TUsers_id = user.TUsers_id; var ip_add = tcp_client.Client.RemoteEndPoint.ToString().Split(':'); ll.TLastLogin_UserIP = ip_add[0]; ll.TLastLogin_TS = DateTime.Now; ll.TLastLogin_Success = correct; dcx.TLastLogin.Add(ll); dcx.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
public void setMsg() { try { List <TMessage> tmessageList; using (var dc = new PTMessengerEntitiesModel()) { tmessageList = dc.TMessageSet.Where(x => x.User_dst.TUsers_login == this.login && x.TMessage_deliver == false).ToList(); if (tmessageList.Count > 0) { binWrite.Write("NEW_MSG"); } else { binWrite.Write("NO_MSG"); return; } binWrite.Write(tmessageList.Count); foreach (var v in tmessageList) { binWrite.Write(v.User_src.TUsers_login); binWrite.Write(v.TMessage_text); binWrite.Write(v.TMessage_ts.ToString()); v.TMessage_deliver = true; dc.Entry(v).State = System.Data.Entity.EntityState.Modified; } dc.SaveChanges(); Console.WriteLine("{0} Wysłano {1} wiadomosci do {2}", DateTime.Now, tmessageList.Count, this.login); } } catch (Exception ex) { Console.WriteLine("{0} {1}", DateTime.Now, ex); } }