/// <summary>
/// Deletes the login with the given stringId
/// </summary>
/// <param name="stringId"></param>
public int DeleteUser(string stringId)
{
try
{
var id = Int64.Parse(stringId);
using (var db = new ReportAppLoginEntities())
{
db.Login.Remove(db.Login.FirstOrDefault(x => x.ID == id));
db.SaveChanges();
}
return (int)codes.success;
}
catch (Exception e)
{
return (int)codes.fail;
}
}
/// <summary>
/// Creates a login with the given parameters
/// </summary>
/// <param name="login"></param>
public int CreateLogin(LoginDTO login)
{
try
{
using (var db = new ReportAppLoginEntities())
{
db.Login.Add(new Login()
{
Username = login.Username,
Password = login.Password
});
db.SaveChanges();
}
return (int)codes.success;
}
catch (DbUpdateException e)
{
return (int)codes.user_exists;
}
catch (Exception e)
{
return (int)codes.fail;
}
}
/// <summary>
/// Return the Login with the given username
/// </summary>
/// <param name="username"></param>
/// <returns>A LoginDTO</returns>
public LoginDTO GetUserByUsername(string username)
{
try
{
using (var db = new ReportAppLoginEntities())
{
var login = db.Login.FirstOrDefault(x => x.Username.Equals(username));
if (login == null)
{
return new LoginDTO() { Code = (int)codes.no_user };
}
return new LoginDTO()
{
ID = login.ID,
Username = login.Username,
Password = login.Password,
Code = (int)codes.success
};
}
}
catch (Exception e)
{
return new LoginDTO() { Code = -1 };
}
}