private void tb_login_Click_1(object sender, EventArgs e)
{
int userIdExist = 0;
string cryptPw = "";
using (var context = new mssqlDBContext())
{
var uid = tb_userId.Text;
// var item = context.logininfo.SingleOrDefault(p => p.userid == uid);
var item2 = context.logininfo.Where(p => p.userid == uid);
int cnt = item2.Count();
userIdExist = item2.Count();
if (userIdExist == 1)
{
foreach (var i in item2)
{
cryptPw = i.userpassword;
}
}
context.SaveChanges();
}
if (userIdExist == 0)
{
label1.Text = "잘못된 정보가 입력되었습니다.";
}
else
{
var des = new DES(Properties.Resources.DesKey);
var descrypt = des.result(DesType.Decrypt, cryptPw);
descrypt.Replace("\0", "").Trim();
if (descrypt.Equals(tb_pwd.Text))
{
label1.Text = "로그인되었습니다.";
//데이터베이스에서 친구정보를 로드
//친구정보를 화면에 출력
this.Hide();
mf = new SignIn(this);
mf.Show();
}
else
{
label1.Text = "아이디와 패스워드를 확인하여 다시 입력하세요.";
}
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var context = new mssqlDBContext())
{
context.Database.Log += (log) =>
{
Console.WriteLine($"log : {log}");
};
var loginInfo = context.logininfo.First();
loginInfo.userpassword = "******";
context.SaveChanges();
}
}
private void loginBtn_Click(object sender, EventArgs e)
{
int userIdExist = 0;
string cryptPw = "";
using (var context = new mssqlDBContext()) {
var uid = loginId.Text;
// var item = context.logininfo.SingleOrDefault(p => p.userid == uid);
var item = context.logininfo.Where(p => p.userid == uid);
userIdExist = item.Count();
if (userIdExist == 1)
{
foreach (var i in item)
{
cryptPw = i.userpassword;
}
}
context.SaveChanges();
}
if (userIdExist == 0)
{
infoCheck.Text = "잘못된 정보가 입력되었습니다.";
}
else
{
var des = new DES(Properties.Resources.DesKey);
var descrypt = des.result(DesType.Decrypt, cryptPw);
descrypt.Replace("\0", "").Trim();
if (descrypt.Equals(loginPw.Text))
{
infoCheck.Text = "로그인되었습니다.";
///데이터베이스에서 친구정보를 로드 && 친구정보를 화면에 출력
this.Hide();
mainForm = new MainForm(this);
mainForm.Show();
}
else
{
infoCheck.Text = "아이디와 패스워드를 확인하여 다시 입력하세요.";
}
}
}
private void button2_Click(object sender, EventArgs e)
{
using (var context = new mssqlDBContext())
{
context.Database.Log += (log) =>
{
Console.WriteLine($"log : {log}");
};
var loginInfo = context.logininfo
.Where(b => b.userid == tb_userId.Text)
.FirstOrDefault();
context.logininfo.Remove(loginInfo);
context.SaveChanges();
}
}
private void overlapCheck_Click(object sender, EventArgs e)
{
using (var ctx = new mssqlDBContext())
{
string uid = newId.Text;
var item = ctx.logininfo.SingleOrDefault(p => p.userid == uid);
if (item == null)
{
idFlag = true;
warn.Text = "사용가능한 아이디입니다.";
addInfoBtn.Enabled = true;
}
else
{
warn.Text = "중복된 아이디입니다.";
}
}
}
private void tb_login_Click(object sender, EventArgs e)
{
using (var context = new mssqlDBContext())
{
context.Database.Log += (log) =>
{
Console.WriteLine($"log : {log}");
};
var loginInfo = new tb_logininfo()
{
userid = "id02",
userpassword = "******"
};
context.logininfo.Add(loginInfo);
context.SaveChanges();
}
}
private void addInfoBtn_Click(object sender, EventArgs e)
{
using (var context = new mssqlDBContext())
{
string uid = newId.Text;
string upw = newPwd.Text;
var des = new DES(Properties.Resources.DesKey);
var encrypt = des.result(DesType.Encrypt, upw);
var loginInfo = new tb_logininfo()
{
userid = uid,
userpassword = encrypt
};
context.logininfo.Add(loginInfo);
context.SaveChanges();
}
formExit();
}