private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
EmployeeAdd employeeAdd = new EmployeeAdd(employeesAddTDS);
int employeeId = employeeAdd.Save();
EmployeeAddTypeHistory employeeAddTypeHistory = new EmployeeAddTypeHistory(employeesAddTDS);
employeeAddTypeHistory.Save(employeeId);
hdfEmployeeId.Value = employeeId.ToString();
DB.CommitTransaction();
// Store datasets
employeesAddTDS.AcceptChanges();
Session["employeesAddTDS"] = employeesAddTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void PostPageChanges()
{
// Load user data
int loginId = Int32.Parse(Session["selectedLoginId"].ToString());
int companyId = Convert.ToInt32(Session["companyID"]);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId((int)loginId, companyId);
int? contactsId = loginGateway.GetContactsId((int)loginId, companyId);
string fullName = loginGateway.GetRealName((int)loginId, companyId);
string firstName = hdfFirstName.Value;
string middleInitial = "";
string lastName = hdfLastName.Value;
string type = hdfType.Value;
string state = hdfState.Value;
bool isSalesman = false;
bool requestProjectTime = bool.Parse(hdfRequestTimesheet.Value);
bool deleted = false;
bool salaried = bool.Parse(hdfSalaried.Value); ;
string eMail = hdfMail.Value;
bool assignableSrs = bool.Parse(hdfAssignableSrs.Value);
bool inDataBase = false;
string jobClass = ddlJobClassType.SelectedValue;
string category = ddlCategory.SelectedValue;
bool isVacationsManager = ckbxVacationsManager.Checked;
string personalAgency = ddlPersonalAgency.SelectedValue;
bool approveTimesheets = ckbxApproveTimesheets.Checked;
decimal? bourdenFactor = null;
decimal? usHealthBenefitFactor = null;
decimal? benefitFactorCad = null;
decimal? benefitFactorUsd = null;
int newEmployeeId = 0;
EmployeeAdd model = new EmployeeAdd(employeesAddTDS);
newEmployeeId = model.Insert(loginId, contactsId, fullName, firstName, middleInitial, lastName, type, state, isSalesman, requestProjectTime, deleted, salaried, eMail, assignableSrs, inDataBase, jobClass, category, personalAgency, isVacationsManager, approveTimesheets, bourdenFactor, usHealthBenefitFactor, benefitFactorCad, benefitFactorUsd);
// Add type history
if (contactsId.HasValue)
{
EmployeeAddTypeHistory modelEmployeeAddTypeHistory = new EmployeeAddTypeHistory(employeesAddTDS);
modelEmployeeAddTypeHistory.Insert(newEmployeeId, DateTime.Now, type, deleted, companyId, false);
}
// Store session
Session["employeesAddTDS"] = employeesAddTDS;
}