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