/// <summary>
/// Create a new tbl_user object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
/// <param name="aDAccount">Initial value of the ADAccount property.</param>
/// <param name="email">Initial value of the Email property.</param>
/// <param name="isValid">Initial value of the IsValid property.</param>
/// <param name="isAdmin">Initial value of the IsAdmin property.</param>
/// <param name="fullName">Initial value of the FullName property.</param>
public static tbl_user Createtbl_user(global::System.Int32 id, global::System.String aDAccount, global::System.String email, global::System.Boolean isValid, global::System.Boolean isAdmin, global::System.String fullName)
{
tbl_user tbl_user = new tbl_user();
tbl_user.id = id;
tbl_user.ADAccount = aDAccount;
tbl_user.Email = email;
tbl_user.IsValid = isValid;
tbl_user.IsAdmin = isAdmin;
tbl_user.FullName = fullName;
return(tbl_user);
}
public static tbl_user GetUserInfoByAd(string sAdName)
{
tbl_user user = null;
using (FavLinkEntities context = new FavLinkEntities())
{
var people = from p in context.tbl_user
where (0 == String.Compare(p.ADAccount, sAdName, StringComparison.InvariantCultureIgnoreCase))
select p;
if (people.Any())
{
user = people.First();
}
}
return(user);
}
public static bool InsertUserInfo(string inputad, ref string errmsg)
{
bool bOk = false;
var adUser = GetAdInfo(inputad, out errmsg);
if (adUser == null)
{
errmsg = "AD login failed!";
return(false);
}
var adInfo = GetUserInfoByAd(inputad);
if (adInfo != null)
{
errmsg = "You had been registered!";
return(false);
}
using (FavLinkEntities context = new FavLinkEntities())
{
var entity = new tbl_user()
{
ADAccount = adUser.ADAccount,
Email = adUser.Email,
FullName = adUser.FirstName + ' ' + adUser.LastName,
IsAdmin = false,
IsValid = true
};
try
{
context.tbl_user.AddObject(entity);
context.SaveChanges();
bOk = true;
errmsg = string.Empty;
}
catch (Exception ex)
{
errmsg = ex.Message;
}
}
return(bOk);
}
/// <summary>
/// Deprecated Method for adding a new object to the tbl_user EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotbl_user(tbl_user tbl_user)
{
base.AddObject("tbl_user", tbl_user);
}