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);
}
}