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