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