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