private void button1_Click(object sender, EventArgs e)
{
file_dataclassesDataContext database = new file_dataclassesDataContext();
/* var log_data = from u in database.users
where u.login == textBox1.Text && u.password == textBox2.Text
select new { u.u_id };*/
SqlConnection conn = new SqlConnection("Data Source=.\\SQLSRVR;AttachDbFilename=G:\\GitHub\\mmnote\\Data_base\\Data_base\\files_db.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
SqlDataReader log_data = null;
var ex = 0;
string quer = "select u_id from users where login = '******' and password = '******'";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(quer, conn);
log_data = cmd.ExecuteReader();
while(log_data.Read())
{
ex++;
uid = (int)log_data[0];
}
}
finally
{
if (conn != null) conn.Close();
}
if (ex == 0)
{
label3.Text = "Inncorect login or password!";
return;
}
action log_act = new action
{
u_id = uid,
act_type = "LOG",
action_time = DateTime.Now
};
database.actions.InsertOnSubmit(log_act);
database.SubmitChanges();
Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
var get_money = from m in pay_doc.Element("payments").Elements("userdata").Elements("u_paid")
where (string)m.Attribute("idp").Value == user_id.ToString()
select m;
foreach (var m in get_money)
{
money = Convert.ToInt32(m.Value);
}
money++;
var inc = max_files + 5;
max_files += 5;
XElement ref_to_files = pay_doc.Element("payments").Elements("userdata").Elements("u_files")
.Where(id => (string)id.Attribute("idf").Value == user_id.ToString()).FirstOrDefault();
ref_to_files.SetValue(inc.ToString());
XElement ref_to_paid = pay_doc.Element("payments").Elements("userdata").Elements("u_paid")
.Where(id => (string)id.Attribute("idp").Value == user_id.ToString()).FirstOrDefault();
ref_to_paid.SetValue(money.ToString());
pay_doc.Save("Payments.xml");
file_dataclassesDataContext database = new file_dataclassesDataContext();
action pay_act = new action
{
u_id = user_id,
act_type = "PAY",
action_time = DateTime.Now
};
database.actions.InsertOnSubmit(pay_act);
database.SubmitChanges();
Close();
}
else
{
MessageBox.Show("Invalid code!", "Error");
return;
}
}
private void button1_Click(object sender, EventArgs e)
{
file_dataclassesDataContext database = new file_dataclassesDataContext();
var if_exist = from u in database.users
where u.login == textBox1.Text
select new { u.u_id };
var ex = 0;
foreach (var u in if_exist)
{
ex++;
}
if (ex != 0)
{
statuslabel.Text = "This login is used!";
return;
}
if (textBox2.Text != textBox3.Text)
{
statuslabel.Text = "Password boxes are not equal!";
return;
}
using (var trans = new TransactionScope())
{
DateTime teraz = DateTime.Now;
user register_new = new user
{
login = textBox1.Text,
password = textBox2.Text,
first_name = textBox4.Text,
last_name = textBox5.Text,
email = textBox6.Text,
join_date = teraz
};
database.users.InsertOnSubmit(register_new);
try
{
database.SubmitChanges();
}
catch (Exception)
{
}
var get_uid = from usr in database.users
where usr.login == textBox1.Text
select new { usr.u_id };
foreach (var usr in get_uid)
{
user_id = usr.u_id;
}
action reg_act = new action
{
u_id = user_id,
act_type = "REG",
action_time = teraz
};
database.actions.InsertOnSubmit(reg_act);
database.SubmitChanges();
trans.Complete();
}
if (user_id != 0)
{
XDocument pay_doc = XDocument.Load("Payments.xml");
pay_doc.Element("payments").Add(new XElement("userdata",
new XElement("u_files", "5", new XAttribute("idf", user_id.ToString()))));
pay_doc.Element("payments").Elements("userdata").Elements("u_files")
.Where(u_f => u_f.Attribute("idf").Value == user_id.ToString()).FirstOrDefault()
.AddAfterSelf(new XElement("u_paid", "0", new XAttribute("idp", user_id.ToString())));
pay_doc.Save("Payments.xml");
}
Close();
}
private void login_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter)
{
file_dataclassesDataContext database = new file_dataclassesDataContext();
var log_data = from u in database.users
where u.login == textBox1.Text && u.password == textBox2.Text
select new { u.u_id };
var ex = 0;
foreach (var u in log_data)
{
ex++;
uid = u.u_id;
}
if (ex == 0)
{
label3.Text = "Inncorect login or password!";
return;
}
action log_act = new action
{
u_id = uid,
act_type = "LOG",
action_time = DateTime.Now
};
database.actions.InsertOnSubmit(log_act);
database.SubmitChanges();
Close();
}
}
