public List <pUsers> selectTable1(pUsers user) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "pUsers.db"))) { return(connection.Table <pUsers>().ToList()); } } catch (SQLiteException ex) { Log.Info("SQLite Error", ex.ToString()); return(null); } }
public bool insertIntoTable(pUsers user) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(folder, "pUsers.db"))) { connection.Insert(user); return(true); } } catch (SQLiteException ex) { Log.Info("SQLite Error", ex.ToString()); return(false); } }
public rValue <int> Add(pUsers prms, Bilet blt) { using (var db = getDb()) { var trns = db.Database.BeginTransaction(); try { var result = Add(prms, blt, db); trns.Commit(); return(result); } catch (Exception ex) { trns.Rollback(); LogYaz(ex, blt); throw; } } }
public rValue <int> Add(pUsers prms, Bilet blt, CuteModel db) { if (prms == null) { throw Exceptions.Parameter(); } if (prms.password.isEmpty()) { throw Exceptions.Parameter("Parola boş olamaz"); } if (prms.email.isEmpty()) { throw Exceptions.Parameter("Email boş olamaz"); } var ent = Get <DAL.Model.Users>(); ent.email = prms.email; ent.fullname = prms.fullname ?? prms.email; ent.password = prms.password; ent.role = "User"; if (Exist <dalUsers>(ent, db)) { throw Exceptions.Exist("Aynı kullanıcı daha önce kaydedilmiş."); } ent.guid = Guid.NewGuid().ToString(); ent.password = new Crypto(ent.guid).Encrypt(ent.password); Add(ent, blt, db); LogYaz("Kullanıcı eklendi", blt, prms, ent); return(new rValue <int>(ent.id)); }
public rValue <int> Update(pUsers prms, Bilet blt, CuteModel db) { var ent = Get <DAL.Model.Users>(prms.id, db); if (ent == null) { throw Exceptions.NotExist(); } string islemOncesiVeri = ent.toJson(); ent.fullname = prms.fullname; if (prms.password.isNoEmpty()) { ent.password = new Crypto(ent.guid).Encrypt(prms.password); } Update(ent, blt, db); LogYaz("Kullanıcı güncellendi.", blt, prms, ent, islemOncesiVeri); return(new rValue <int>(ent.id)); }