public static void delete(int ind)
{
try
{
using (var db = new AgendaDBContext())
{
var x=(from n in db.Agenda where n.Id==ind select n).FirstOrDefault();
db.Agenda.Remove(x);
db.SaveChanges();
MessageBox.Show("Intrarea a fost stearsa cu succes!");
}
}
catch (DbEntityValidationException e)
{
string err = "";
foreach (var eve in e.EntityValidationErrors)
{
err += "Entity of type " + Convert.ToString(eve.Entry.Entity.GetType().Name) + " in state " + Convert.ToString(eve.Entry.State) + " has the following validation errors:\n\n";
foreach (var ve in eve.ValidationErrors)
{
err += "- Property: " + Convert.ToString(ve.PropertyName) + ", Error: " + Convert.ToString(ve.ErrorMessage) + "\n";
}
}
MessageBox.Show(err);
}
}
private void Init_Database()
{
using (var db = new AgendaDBContext())
{
//var user = new Users { UserId = 1, Username = "******", Password = "******" };
//db.Users.Add(user);
//db.SaveChanges();
//IO_on_Db.write_users_table();
//user = new Users { UserId = 2, Username = "******", Password = "******" };
//db.Users.Add(user);
//db.SaveChanges();
//var query = from u in db.Users
// select u;
//foreach (var item in query)
//{
// MessageBox.Show(item.Username + item.Password, "info", MessageBoxButtons.OK);
//}
IEnumerable<int> id = (from u in db.Users
select u.UserId);
int max;
if (id.Count() != 0)
max = id.Max();
else
{
max = 0;
DatabaseManagement.set_next_agenda_id(max);
IO_on_Db.read_users_table();
}
//MessageBox.Show(max.ToString());
DatabaseManagement.set_next_user_id(max);
id = (from u in db.Agenda
select u.Id);
if (id.Count() != 0)
max = id.Max();
else
max = 0;
//MessageBox.Show(max.ToString());
DatabaseManagement.set_next_agenda_id(max);
id = from u in db.Fisiere select u.FisierId;
if (id.Count() != 0)
max = id.Max();
else
max = 0;
DatabaseManagement.set_next_fisier_id(max);
}
}
public static DataTable get_agenda_for_uid(int uid)
{
try
{
DataTable dt = new DataTable();
using (var db = new AgendaDBContext())
{
var query = (from a in db.Agenda
where a.UserId == uid
select new {Id_intrare=a.Id, a.data_si_ora , Titlu=a.titlu, Detalii=a.notita }
).ToList();
// Am facut conversia in tabel aici (in datalayer) pentru ca nu se poate returna o lista anonima de tipul query...
dt.Columns.Add().ColumnName="Id_intrare";
dt.Columns.Add().ColumnName = "Data";
dt.Columns.Add().ColumnName = "Ora";
dt.Columns.Add().ColumnName = "Titlu";
dt.Columns.Add().ColumnName = "Detalii";
string ora = "";
string data = "";
foreach (var item in query)
{
string[] words = Convert.ToString(item.data_si_ora).Split(' ');
data = words[0];
ora = words[1];
dt.Rows.Add(item.Id_intrare, data, ora, item.Titlu, item.Detalii);
}
}
return dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Eroare", MessageBoxButtons.OK);
return null;
}
}
public static void insert(int uid,string data_ora,string titl,string detalii)
{
try
{
using (var db = new AgendaDBContext())
{
// Preiau userul logat ca sa il pot adauga in clasa Agenda pentru ca...
var query = from u in db.Users
select u;
Users us_logat = null;
foreach (var user in query)
{
if (user.UserId == uid)
us_logat = user;
}
int agid = DatabaseManagement.get_next_agenda_id();
DatabaseCreate.Agenda a = new DatabaseCreate.Agenda { Id = agid, UserId = uid,data_si_ora= Convert.ToDateTime(data_ora), titlu = titl, notita = detalii,Users=us_logat };
db.Agenda.Add(a);
db.SaveChanges();
DatabaseManagement.increment_next_agenda_id();
}
}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
// //MessageBox.Show("Eroare la inserare in agenda!");
//}
catch (DbEntityValidationException e)
{
string err = "";
foreach (var eve in e.EntityValidationErrors)
{
err += "Entity of type " + Convert.ToString(eve.Entry.Entity.GetType().Name) + " in state " + Convert.ToString(eve.Entry.State) + " has the following validation errors:\n\n";
foreach (var ve in eve.ValidationErrors)
{
err += "- Property: " + Convert.ToString(ve.PropertyName) + ", Error: " + Convert.ToString(ve.ErrorMessage) + "\n";
}
}
MessageBox.Show(err);
}
}
public static void insert(string username,string password)
{
try
{
using (var db = new AgendaDBContext())
{
int userid = DatabaseManagement.get_next_user_id();
Users u = new Users { Username = username, Password = password, UserId = userid };
db.Users.Add(u);
db.SaveChanges();
DatabaseManagement.increment_next_user_id();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Eroare", MessageBoxButtons.OK);
}
}
public static void share(string username, string fis_nume)
{
using (var db = new AgendaDBContext())
{
int userid;
var query = (from u in db.Users
where u.Username.CompareTo(username) == 0
select u);
if (query.Count() == 0)
{
MessageBox.Show("nu exista userul");
return;
}
var query2 = (from u in db.Users
where u.Username.CompareTo(username) == 0
select u).First();
userid = query2.UserId;
var query3 = (from f in db.Fisiere
where f.NumeReal.CompareTo(fis_nume) == 0
select f).First();
int fis_id = query3.FisierId;
int uid = query3.UserId;
var query4 = (from f in db.Fisiere
where f.FisierId == fis_id
select f).First();
string sharelist = query4.ShareList;
if (sharelist.Contains(Convert.ToString(userid)))
return;
if (String.Compare(sharelist,"")!=0)
sharelist = sharelist + "#";
sharelist = sharelist + Convert.ToString(userid);
var us = (from u in db.Users
where u.UserId == uid
select u).First();
query4.Users = us;
query4.ShareList = sharelist;
try
{
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
string err = "";
foreach (var eve in e.EntityValidationErrors)
{
err += "Entity of type " + Convert.ToString(eve.Entry.Entity.GetType().Name) + " in state " + Convert.ToString(eve.Entry.State) + " has the following validation errors:\n\n";
foreach (var ve in eve.ValidationErrors)
{
err += "- Property: " + Convert.ToString(ve.PropertyName) + ", Error: " + Convert.ToString(ve.ErrorMessage) + "\n";
}
}
MessageBox.Show(err);
}
}
}
public static void remove_access(string fisier)
{
int user = ManageAgenda.get_userid();
using (var db = new AgendaDBContext())
{
var query = (from f in db.Fisiere
where f.NumeReal.CompareTo(fisier) == 0
select f).First();
int fis_id = query.FisierId;
int uid = query.UserId;
if (query.ShareList.Contains('#'))
{
string[] sharelist = query.ShareList.Split('#');
string newsharelist="";
foreach (string x in sharelist)
if (Convert.ToInt32(x) != user)
{
newsharelist += x;
newsharelist+="#";
}
newsharelist=newsharelist.Substring(0,newsharelist.Length-1);
query.ShareList = newsharelist;
}
else
{
if (Convert.ToInt32(query.ShareList) == user)
query.ShareList = "";
}
var us = (from u in db.Users
where u.UserId == uid
select u).First();
query.Users=us;
try
{
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
string err = "";
foreach (var eve in e.EntityValidationErrors)
{
err += "Entity of type " + Convert.ToString(eve.Entry.Entity.GetType().Name) + " in state " + Convert.ToString(eve.Entry.State) + " has the following validation errors:\n\n";
foreach (var ve in eve.ValidationErrors)
{
err += "- Property: " + Convert.ToString(ve.PropertyName) + ", Error: " + Convert.ToString(ve.ErrorMessage) + "\n";
}
}
MessageBox.Show(err);
}
}
}
public static void insert(int uid, string data_ora, string nume_real, string nume_criptat)
{
using (var db = new AgendaDBContext())
{
// Preiau userul logat ca sa il pot adauga in clasa Agenda pentru ca...
var query = from u in db.Users
select u;
Users us_logat = null;
foreach (var user in query)
{
if (user.UserId == uid)
us_logat = user;
}
int fid = DatabaseManagement.get_next_fisier_id();
DatabaseCreate.Fisier a = new DatabaseCreate.Fisier { FisierId = fid, UserId = uid, data_si_ora = Convert.ToDateTime(data_ora), NumeReal = nume_real, NumeCriptat = nume_criptat, Open = false, ShareList = "", Users = us_logat };
db.Fisiere.Add(a);
db.SaveChanges();
DatabaseManagement.increment_next_agenda_id();
}
}
public static DataTable get_fisiere_pr(int uid)
{
try
{
DataTable dt = new DataTable();
using (var db = new AgendaDBContext())
{
var query = (from a in db.Fisiere
where a.UserId == uid
select new { Nume_Fisier=a.NumeReal,a.data_si_ora, SharedWith=a.ShareList ,a.FisierId,a.NumeCriptat}
).ToList();
// Am facut conversia in tabel aici (in datalayer) pentru ca nu se poate returna o lista anonima de tipul query...
dt.Columns.Add().ColumnName = "File_Id";
dt.Columns.Add().ColumnName ="Nume_Fisier";
dt.Columns.Add().ColumnName = "Data_si_Ora";
dt.Columns.Add().ColumnName = "ShareList";
dt.Columns.Add().ColumnName = "Nume_Criptat";
//string ora = "";
//string data = "";
foreach (var item in query)
{
// string[] words = Convert.ToString(item.data_si_ora).Split(' ');
// data = words[0];
// ora = words[1];
dt.Rows.Add(item.FisierId,item.Nume_Fisier,item.data_si_ora,item.SharedWith,item.NumeCriptat);
}
}
return dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Eroare", MessageBoxButtons.OK);
return null;
}
}
public static DataTable get_fisiere_ext(int uid)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add().ColumnName ="Nume_Fisier";
dt.Columns.Add().ColumnName ="Owner";
dt.Columns.Add().ColumnName ="Data_si_Ora";
dt.Columns.Add().ColumnName = "File_Id";
dt.Columns.Add().ColumnName = "Nume_Criptat";
using (var db = new AgendaDBContext())
{
var query = from f in db.Fisiere
join u in db.Users on f.UserId equals u.UserId
select new { f.NumeReal, f.NumeCriptat, f.FisierId, f.ShareList, u.Username ,f.data_si_ora };
foreach (var intrare in query)
{
if (intrare.ShareList.Contains('#'))
{
string[] shared = intrare.ShareList.Split('#');
foreach (var x in shared)
{
if (String.Compare(intrare.ShareList, "") == 0) continue;
if (Convert.ToInt32(x) == uid)
{
dt.Rows.Add(intrare.NumeReal,intrare.Username,intrare.data_si_ora,intrare.FisierId,intrare.NumeCriptat);
break;
}
}
}
else
{
if (String.Compare(intrare.ShareList, "") == 0) continue;
if (Convert.ToInt32(intrare.ShareList) == uid)
dt.Rows.Add(intrare.NumeReal, intrare.Username, intrare.data_si_ora, intrare.FisierId, intrare.NumeCriptat);
}
}
return dt;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Eroare", MessageBoxButtons.OK);
return null;
}
}
public static void updated(int uid, int index, string data_si_ora, string titlu, string detalii)
{
try
{
using (var db = new AgendaDBContext())
{
var query = from u in db.Users
select u;
Users us_logat = null;
foreach (var user in query)
{
if (user.UserId == uid)
us_logat = user;
}
var intrare = (from s in db.Agenda
where s.Id == index
select s).FirstOrDefault();
intrare.notita = detalii;
intrare.titlu = titlu;
intrare.data_si_ora = Convert.ToDateTime(data_si_ora);
intrare.Users = us_logat;
db.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
string err = "";
foreach (var eve in e.EntityValidationErrors)
{
err += "Entity of type " + Convert.ToString(eve.Entry.Entity.GetType().Name) + " in state " + Convert.ToString(eve.Entry.State) + " has the following validation errors:\n\n";
foreach (var ve in eve.ValidationErrors)
{
err += "- Property: " + Convert.ToString(ve.PropertyName) + ", Error: " + Convert.ToString(ve.ErrorMessage) + "\n";
}
}
MessageBox.Show(err);
}
}
//apelat cand se initializeaza aplicatia iar lista de useri este GOALA (sau de fiecare data cand se deschide aplicatia... trebuie hotarat
public static void read_users_table()
{
try
{
using (var db = new AgendaDBContext())
{
//creez un tabel in care citesc datele din tabelul de useri!
DataTable dt = new DataTable("useri");
DataColumn cUserID = new DataColumn("UserId");
cUserID.DataType = typeof(int);
dt.Columns.Add(cUserID);
DataColumn cUsername = new DataColumn("Username");
cUsername.DataType = typeof(string);
dt.Columns.Add(cUsername);
DataColumn cPassword = new DataColumn("Password");
cPassword.DataType = typeof(string);
dt.Columns.Add(cPassword);
//citesc tabelul intr-un fisier .xml
dt.ReadXml("users.xml");
//adaug randurile din tabelul de useri
for (int i = 0; i < dt.Rows.Count; i++)
{
var user = new Users { UserId = Convert.ToInt32(dt.Rows[i][0]), Username = Convert.ToString(dt.Rows[i][1]), Password = Convert.ToString(dt.Rows[i][2]) };
db.Users.Add(user);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Eroare la scriere xml useri", MessageBoxButtons.OK);
}
}
public static bool verify(string username, string password)
{
try
{
using (var db = new AgendaDBContext())
{
var query = from u in db.Users
select u;
foreach (var user in query)
{
if (user.Username == username && user.Password == ManageUsers.criptare_pass(password))
{
ManageAgenda.set_userid(user.UserId);
return true;
}
}
return false;
}
}
catch (Exception e)
{
MessageBox.Show(e.Message.ToString(), "eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
}
//apelat de cate ori se face o modificare asupra tabelei de useri
public static void write_users_table()
{
try
{
using (var db = new AgendaDBContext())
{
//creez un tabel in care scriu datele din tabelul de useri!
DataTable dt = new DataTable("useri");
DataColumn cUserID = new DataColumn("UserId");
cUserID.DataType = typeof(int);
dt.Columns.Add(cUserID);
DataColumn cUsername = new DataColumn("Username");
cUsername.DataType = typeof(string);
dt.Columns.Add(cUsername);
DataColumn cPassword = new DataColumn("Password");
cPassword.DataType = typeof(string);
dt.Columns.Add(cPassword);
//adaug randurile din tabelul de useri
var query = from u in db.Users
select u;
foreach (var user in query)
{
dt.Rows.Add(user.UserId, user.Username, user.Password);
}
//scriu tabelul intr-un fisier .xml
dt.WriteXml("users.xml");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Eroare la scriere xml useri", MessageBoxButtons.OK);
}
}