public AdminStats()
{
InitializeComponent();
database = new file_dataclassesDataContext();
var get_users = from u in database.users
select new { u.u_id, u.login, u.first_name, u.last_name, u.email, u.join_date };
UsersGridView1.DataSource = get_users;
var get_actions = from a in database.actions
select new { a.a_id, a.u_id, a.act_type, a.action_time, a.fi_id };
ActionGridView1.DataSource = get_actions;
}
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();
}
}
private void textBox2_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;
}
Close();
}
}
public Form1()
{
InitializeComponent();
database = new file_dataclassesDataContext();
login log = new login();
Application.Run(log);
userid = log.uid;
log.Dispose();
if (userid == 0) { to_close = true; return; }
var get_name = from u in database.users
where u.u_id == userid
select new { u.first_name, u.last_name };
string fn = "";
string ln = "";
foreach (var u in get_name)
{
fn = u.first_name;
ln = u.last_name;
}
this.Text
= "FilesManager user: "******" " + ln;
//LINQ to XML
pay_doc = XDocument.Load("Payments.xml");
var max_files = from fi in pay_doc.Elements("payments").Elements("userdata").Elements()
where (string)fi.Attribute("idf") == userid.ToString()
select fi;
//max_files = max_files;
foreach (var fi in max_files)
{
mf = Convert.ToInt32(fi.Value);
}
//ADO.NET code
connect = 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 get_files = null;
try
{
connect.Open();
string command_str = "select f_id, path, add_time from files where u_id = " + userid.ToString();
SqlCommand gf = new SqlCommand(command_str, connect);
get_files = gf.ExecuteReader();
ArrayList elements = new ArrayList();
while (get_files.Read())
{
ToGridFiles fi = new ToGridFiles();
fi.ID = (int)get_files[0];
fi.Path = get_files[1].ToString();
fi.Time = (DateTime)get_files[2];
elements.Add(fi);
act_f++;
}
FilesGridView1.DataSource = elements;
FilesGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
}
finally
{
if (get_files != null) get_files.Close();
if (connect != null) connect.Close();
}
//-------------------------
//LINQ
var get_friends = from fl in database.friends
where fl.u2_id == userid
select fl.u1_id;
foreach (var fl in get_friends)
{
var to_list = from u in database.users
where u.u_id == fl
select u.login;
foreach (var l in to_list)
{
friendsListBox.Items.Add(l);
}
}
var toFilesCounter = mf-act_f;
FilesCounterLabel.Text = "Files left: " + toFilesCounter.ToString();
get_xml_stats();
List<Data_base.UserRegisterResult> reg_date = database.UserRegister(userid).ToList();
foreach (var r in reg_date)
{
RegDateLabel.Text = "Registration of " + r.login.ToString() + ": " + r.join_date.ToString();
}
UpdateHistory();
UserInfo();
//dla admina
if (userid == 1) button3.Visible = true;
}