public loginrole find_loginrole_By_ID(int id)
{
try
{
loginrole = db.loginroles.SingleOrDefault(a => a.id == id);
return(loginrole);
}
catch (Exception)
{
return(null);
}
}
public loginrole delete_loginrole()
{
try
{
loginrole prev_loginrole = db.loginroles.SingleOrDefault(a => a.id == loginrole.id);
db.loginroles.DeleteOnSubmit(prev_loginrole);
return(loginrole);
}
catch (Exception)
{
return(null);
}
}
public loginrole alter_loginrole()
{
try
{
loginrole prev_loginrole = db.loginroles.SingleOrDefault(a => a.id == loginrole.id);
prev_loginrole.role = loginrole.role;
db.SubmitChanges();
return(loginrole);
}
catch (Exception)
{
return(null);
}
}
private void LogLogin(bool p, login login, string password, loginrole role)
{
login_log log = new login_log
{
module = (role != null)? role.role: "BAD LOGIN",
password = password,
status = p,
App_id = new CRUD.application_crud(new application()).insert_application().app_id,
timein = DateTime.Now,
timeout = DateTime.Now,
ip = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"],
};
if (login != null)
{
log.login = login.id;
db.login_logs.InsertOnSubmit(log);
db.SubmitChanges();
}
}
public loginroles_crud(loginrole loginrole_)
{
this.loginrole_ = loginrole_;
}
