protected void btnUpdate_Click(object sender, EventArgs e)
{
var idWindows = WindowsIdentity.GetCurrent();
// The WindowsPrincipal object contains the current user's Group membership.
var prinWindows = new WindowsPrincipal(idWindows);
var domainUser = idWindows.Name;
string firstName = Environment.UserName;
string lastName = string.Empty;//prinWindows.Identity.Name;//TODO
string email = string.Empty;
GetDomainInfo(ref firstName, ref lastName, ref email);
using (var db = new HRPaidTimeOffDataContext())
{
//Create a ENTUserAccount object and set the properties
var userAccount = new ENTUserAccount
{
WindowsAccountName = @domainUser,
FirstName = firstName,
LastName = lastName,
Email = email,
IsActive = false,
UpdateDate = DateTime.Now,
UpdateENTUserAccountId = 1
};
userAccount.ENTUserAccountId = Convert.ToInt32(ViewState["ENTUserAccountId"]);
userAccount.Version = (Binary)ViewState["Version"];
db.ENTUserAccounts.Attach(userAccount, true);
db.SubmitChanges();
}
}
protected void btnInsert_Click(object sender, EventArgs e)
{
//Create an instance of the data context
using (var db = new HRPaidTimeOffDataContext())
{
var idWindows = WindowsIdentity.GetCurrent();
// The WindowsPrincipal object contains the current user's Group membership.
var prinWindows = new WindowsPrincipal(idWindows);
var domainUser = idWindows.Name;
string firstName = Environment.UserName;
string lastName = string.Empty;//prinWindows.Identity.Name;//TODO
string email = string.Empty;
GetDomainInfo(ref firstName, ref lastName, ref email);
//Create a new ENTUserAccount object and set the properties
var userAccount = new ENTUserAccount
{
WindowsAccountName = domainUser,
FirstName = firstName, //"FirstName",
LastName = lastName, //"LastName",
Email = email,
IsActive = true,
InsertDate = DateTime.Now,
InsertENTUserAccountId = 1,
UpdateDate = DateTime.Now,
UpdateENTUserAccountId = 1
};
//Signal the context to insert this record
db.ENTUserAccounts.InsertOnSubmit(userAccount);
//Save the changes to the database
db.SubmitChanges();
}
}
protected override void MapEntityToCustomProperties(IENTBaseEntity entity)
{
ENTUserAccount userAccount = (ENTUserAccount)entity;
ID = userAccount.ENTUserAccountId;
WindowAccountName = userAccount.WindowsAccountName;
FirstName = userAccount.FirstName;
LastName = userAccount.LastName;
Email = userAccount.Email;
IsActive = userAccount.IsActive;
}
protected void Page_Load(object sender, EventArgs e)
{
using (var db = new HRPaidTimeOffDataContext())
{
ENTUserAccount userAccount = db.ENTUserAccounts.FirstOrDefault(ua => ua.WindowsAccountName == @"admin");//ENTUserAccounts.FirstOrDefault();
ViewState["ENTUserAccountId"] = userAccount.ENTUserAccountId;
ViewState["InsertENTUserAccountId"] = userAccount.InsertENTUserAccountId;
ViewState["InsertDate"] = userAccount.InsertDate;
ViewState["Version"] = userAccount.Version;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
using (var db = new HRPaidTimeOffDataContext())
{
//Create a ENTUserAccount object and set the properties
var userAccount = new ENTUserAccount();
userAccount.ENTUserAccountId = Convert.ToInt32(ViewState["ENTUserAccountId"]);
userAccount.Version = (Binary)ViewState["Version"];
db.ENTUserAccounts.Attach(userAccount);
db.ENTUserAccounts.DeleteOnSubmit(userAccount);
db.SubmitChanges();
}
}
