public TblUser GetById(int id)
{
using (var service = new SocIDContext())
{
var data = service.TblUsers.FirstOrDefault(balik => balik.Id == id);
return(data);
}
}
public List <TblUser> GetAllUsers()
{
using (var service = new SocIDContext())
{
var data = service.TblUsers.ToList();
return(data);
}
}
public void Delete(int id)
{
using (var service = new SocIDContext())
{
var _user = service.TblUsers.Find(id);
service.TblUsers.Remove(_user);
service.SaveChanges();
}
}
public void Insert(TblUser user)
{
using (var service = new SocIDContext())
{
user.CreateDate = DateTime.Now;
service.TblUsers.Add(user);
service.SaveChanges();
}
}
public void Update(TblUser user)
{
using (var service = new SocIDContext())
{
var _user = service.TblUsers.Find(user.Id);
_user.ModifyDate = user.ModifyDate;
_user.Username = user.Username;
_user.Password = user.Password;
service.SaveChanges();
}
}
public int Login(string username, string password) //Logincontrollerdan çekilen user ın girdiği username ve passwordun dbde olup olmadıgını lontrol eder.
{
int result = 0;
using (var service = new SocIDContext())
{
var data = service.TblUsers.FirstOrDefault(x => x.Username == username && x.Password == password);
result = data != null && data.Id > 0 ? data.Id : 0;
}
return(result);
}
