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); } }
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); } }
public void registration() { String login, passwd, username, surname, email; login = binRead.ReadString(); passwd = binRead.ReadString(); username = binRead.ReadString(); surname = binRead.ReadString(); email = binRead.ReadString(); using (var dc = new PTMessengerEntitiesModel()) { var log_count = (from l in dc.TUsers where l.TUsers_login == login select l).Count(); if (log_count > 0) { binWrite.Write("LOGIN_EXIST"); Console.WriteLine("{0} Nowy uzytkownik chcial uzyc istniejacego loginu {1}", DateTime.Now, login); return; } } var newUser = new TUsers(); newUser.TUser_imie = username; newUser.TUser_nazwisko = surname; newUser.TUsers_login = login; newUser.TUsers_passwd = passwd; newUser.TUsers_email = email; newUser.TUser_lock = false; try { using (var dc = new PTMessengerEntitiesModel()) { dc.TUsers.Add(newUser); dc.SaveChanges(); } binWrite.Write("REG_SUCCESS"); Console.WriteLine("{0} Dodano nowego uzytkownika {1}, {2}, {3}, {4}", DateTime.Now, username, surname, login, email); } 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 getMsg() { string dst_login = ""; try { TMessage tmpMess = new TMessage(); dst_login = binRead.ReadString(); tmpMess.TMessage_text = binRead.ReadString(); string date = binRead.ReadString(); tmpMess.TMessage_ts = DateTime.Parse(date); tmpMess.TMessage_deliver = false; try { using (var dc = new PTMessengerEntitiesModel()) { tmpMess.TMessage_src = dc.TUsers.Where(u => u.TUsers_login == this.login) .Select(u => u.TUsers_id).First(); tmpMess.TMessage_dst = dc.TUsers.Where(u => u.TUsers_login == dst_login) .Select(u => u.TUsers_id).First(); dc.TMessageSet.Add(tmpMess); dc.SaveChanges(); } binWrite.Write("MSG_ACCEPT"); //setMsg(tmpMess); } 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); } } } } catch { binWrite.Write("MSG_DISACCEPT"); Console.WriteLine("{0} Nie udało się pobrać wiadomości od {1}", DateTime.Now, dst_login); } finally { binWrite.Flush(); } }
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); } }