protected void btnSave_Click(object sender, EventArgs e)
{
try
{
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter dep_Adapter = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
DataTable dt = dep_Adapter.GetDepartmentByShortName(txtCompanyShortName.Text, loggedInUserCoId);
if (dt.Rows.Count == 0)
{
int coId = 0;
if (loggedInUserRole == WebConstants.Roles.Admin)
{
coId = int.Parse(ddlCompany.SelectedValue);
}
else
{
coId = loggedInUserCoId;
}
dep_Adapter.InsertDepartment(coId, false, txtCompanyShortName.Text, txtCompanyLongName.Text, txtContactTitle.Text, txtContactInitial.Text.Trim(), txtForename.Text.Trim(), txtSurname.Text.Trim(), txtAddressNo.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), txtAddress3.Text.Trim(), txtAddress4.Text.Trim(), txtAddress5.Text.Trim(), txtPostalCode.Text.Trim(),GetFullAddress(), txtTele.Text.Trim(), txtTele1.Text.Trim(), txtFax.Text.Trim(), txtEmail.Text.Trim(), txtCoNotes.Text.Trim(), loggedInUserId, DateTime.Now, loggedInUserId, DateTime.Now);
Response.Redirect("DepartmentList.aspx");
}
else
{
SetErrorMessage(WebConstants.Messages.Error.ALREAD_EXISTS);
}
}
catch
{
SetErrorMessage(WebConstants.Messages.Error.CONNECTION_ERROR);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
CompanyTableAdapters.un_co_detailsTableAdapter coTA = new CompanyTableAdapters.un_co_detailsTableAdapter();
if (coTA.GetCompanyByName(txtCompanyShortName.Text, null).GetEnumerator().MoveNext())
{
SetErrorMessage(WebConstants.Messages.Error.ALREAD_EXISTS);
}
else
{
IEnumerator ie = coTA.InsertAndReturn(false, txtCompanyShortName.Text, txtCompanyLongName.Text, txtContactTitle.Text, txtContactInitial.Text, txtForename.Text, txtSurname.Text,
txtAddressNo.Text, txtAddress1.Text, txtAddress2.Text, txtAddress3.Text, txtAddress4.Text, txtAddress5.Text, txtPostalCode.Text, getFullAddress(),
txtTele.Text, txtTele1.Text, txtFax.Text, txtEmail.Text, txtCoNotes.Text, 0, 0, false,null, DateTime.Now, null,
DateTime.Now, cbAutoSave.Checked, tbFireWarden.Text, tbFirstAider.Text, cbMultiSups.Checked, tbSupervisor.Text, true, 1, true,
DateTime.Today, 15, Utility.GetTrialEndDate(DateTime.Today,15),true).GetEnumerator();
if (ie.MoveNext())
{
int coId = ((Company.un_co_detailsRow)ie.Current).co_id;
Session[WebConstants.Session.REG_CO_ID] = coId;
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter deptTA = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
IEnumerator ieDept = deptTA.InsertAndReturn(coId,false,txtCompanyShortName.Text,txtCompanyLongName.Text,txtContactTitle.Text, txtContactInitial.Text, txtForename.Text, txtSurname.Text,
txtAddressNo.Text, txtAddress1.Text, txtAddress2.Text, txtAddress3.Text, txtAddress4.Text, txtAddress5.Text, txtPostalCode.Text, getFullAddress(),
txtTele.Text, txtTele1.Text, txtFax.Text, txtEmail.Text,txtCoNotes.Text,null,DateTime.Now,null,DateTime.Now).GetEnumerator();
if(ieDept.MoveNext())
{
Session[WebConstants.Session.REG_DEPT_ID] = ((Department.DepartmentSelectCommandRow)ieDept.Current).dept_id;
}
SetInfoMessage(WebConstants.Messages.Information.RECORD_SAVED);
Session[WebConstants.Session.WIZARD_STEP] = 2;
Response.Redirect("~/Register/AddDepartment.aspx");
}
}
}
public static Department.DepartmentSelectCommandRow GetDepartment(int deptId)
{
Department.DepartmentSelectCommandRow dataRow = null;
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter da = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
IEnumerator iEnumerator = da.GetDepartmentByDeptId(deptId).GetEnumerator();
if (iEnumerator.MoveNext())
{
dataRow = (Department.DepartmentSelectCommandRow)iEnumerator.Current;
}
return dataRow;
}
protected override void Page_Load_Extended(object sender, EventArgs e)
{
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter tableAdapter = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
IEnumerator iEnum = tableAdapter.GetDepartmentsByCoId(loggedInUserCoId).GetEnumerator();
if (iEnum.MoveNext())
{
Department.DepartmentSelectCommandRow dataRow = (Department.DepartmentSelectCommandRow)iEnum.Current;
firstDepartmentId = dataRow.dept_id;
Department_Page_Handling(sender, e);
}
else
{
Response.Redirect("~/Maintenance/AddDepartment.aspx?" + WebConstants.Request.NO_DEPT + "=true");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["userEmail"] != null && Request["clientIP"] != null && Request["key"] != null && Request["key"].Equals("CC17DEC2-5727-4FA8-937A-C4D3107BBE8B"))
{
UserTableAdapters.un_co_user_detailsTableAdapter ta = new UserTableAdapters.un_co_user_detailsTableAdapter();
IEnumerator ie = ta.GetUserByLogonName(Request["userEmail"], null).GetEnumerator();
if (ie.MoveNext())
{
User.un_co_user_detailsRow user = (User.un_co_user_detailsRow)ie.Current;
Session[WebConstants.Session.USER_ID] = user.user_id;
Session[WebConstants.Session.USER_ROLE] = user.role;
Session[WebConstants.Session.USER_CO_ID] = user.co_id;
Session[WebConstants.Session.COMPANY_NAME] = user.co_name_short;
TimeSpan SessTimeOut = new TimeSpan(0, 0, HttpContext.Current.Session.Timeout, 0, 0);
Cache.Insert(user.user_id.ToString(), Request["clientIP"], null, DateTime.MaxValue, SessTimeOut, System.Web.Caching.CacheItemPriority.NotRemovable, null);
Company.un_co_detailsRow company = DatabaseUtility.GetCompany(user.co_id);
if (company != null && company.flg_show_wizard)
{
Session[WebConstants.Session.REG_CO_ID] = company.co_id;
Session[WebConstants.Session.REG_USER_ID] = user.user_id;
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter deptTA = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
IEnumerator ieDept = deptTA.GetDepartmentsByCoId(company.co_id).GetEnumerator();
if (ieDept.MoveNext())
{
Department.DepartmentSelectCommandRow department = (Department.DepartmentSelectCommandRow)ieDept.Current;
Session[WebConstants.Session.REG_DEPT_ID] = department.dept_id;
}
Response.Redirect("~/Register/AddCompany.aspx");
}
else
{
Response.Redirect("~/UserHome.aspx");
}
}
else
{
Response.Redirect(ConfigurationManager.AppSettings["SCurl"]);
}
}
else
{
Response.Redirect(ConfigurationManager.AppSettings["SCurl"]);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter dep_Adapter = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
DataTable count = dep_Adapter.GetShortNameCountByDeptId(int.Parse(Request[WebConstants.Request.DEPT_ID]), txtCompanyShortName.Text);
if (count.Rows.Count == 0)
{
dep_Adapter.UpdateDepartment(txtCompanyShortName.Text, txtCompanyLongName.Text, txtContactTitle.Text, txtContactInitial.Text.Trim(), txtForename.Text.Trim(), txtSurname.Text.Trim(), txtAddressNo.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), txtAddress3.Text.Trim(), txtAddress4.Text.Trim(), txtAddress5.Text.Trim(), txtPostalCode.Text.Trim(), GetFullAddress(), txtTele.Text.Trim(), txtTele1.Text.Trim(), txtFax.Text.Trim(), txtEmail.Text.Trim(), txtCoNotes.Text.Trim(), loggedInUserId, DateTime.Now, int.Parse(Request[WebConstants.Request.DEPT_ID]));
Response.Redirect("DepartmentList.aspx");
}
else
{
SetErrorMessage(WebConstants.Messages.Error.ALREAD_EXISTS);
}
}
catch
{
SetErrorMessage(WebConstants.Messages.Error.CONNECTION_ERROR);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter dep_Adapter = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
DataTable count = dep_Adapter.GetShortNameCountByDeptId((int)Session[WebConstants.Session.REG_DEPT_ID], txtCompanyShortName.Text);
if (count.Rows.Count == 0)
{
dep_Adapter.UpdateDepartment(txtCompanyShortName.Text, txtCompanyLongName.Text, txtContactTitle.Text, txtContactInitial.Text.Trim(), txtForename.Text.Trim(), txtSurname.Text.Trim(), txtAddressNo.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), txtAddress3.Text.Trim(), txtAddress4.Text.Trim(), txtAddress5.Text.Trim(), txtPostalCode.Text.Trim(), GetFullAddress(), txtTele.Text.Trim(), txtTele1.Text.Trim(), txtFax.Text.Trim(), txtEmail.Text.Trim(), txtCoNotes.Text.Trim(), null, DateTime.Now, (int)Session[WebConstants.Session.REG_DEPT_ID] );
Session[WebConstants.Session.WIZARD_STEP] = 3;
Response.Redirect("~/Register/AddUser.aspx");
}
else
{
SetErrorMessage(WebConstants.Messages.Error.ALREAD_EXISTS);
}
}
catch
{
SetErrorMessage(WebConstants.Messages.Error.CONNECTION_ERROR);
}
}
public void HandlePostLoginProcess(int userId, string role, int coId)
{
TimeSpan SessTimeOut = new TimeSpan(0, 0, HttpContext.Current.Session.Timeout, 0, 0);
HttpContext.Current.Cache.Insert(userId.ToString(), HttpContext.Current.Request.UserHostAddress, null, DateTime.MaxValue, SessTimeOut, System.Web.Caching.CacheItemPriority.NotRemovable, null);
Company.un_co_detailsRow company = DatabaseUtility.GetCompany(coId);
if (company != null && company.flg_show_wizard)
{
HttpContext.Current.Session[WebConstants.Session.REG_CO_ID] = company.co_id;
HttpContext.Current.Session[WebConstants.Session.REG_USER_ID] = userId;
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter deptTA = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
IEnumerator ie = deptTA.GetDepartmentsByCoId(coId).GetEnumerator();
if (ie.MoveNext())
{
Department.DepartmentSelectCommandRow department = (Department.DepartmentSelectCommandRow)ie.Current;
HttpContext.Current.Session[WebConstants.Session.REG_DEPT_ID] = department.dept_id;
}
if (company.Isflg_trialNull() == true || company.flg_trial == false)
{
company.trial_start_date = DateTime.Today;
company.flg_trial = true;
company.trial_num_of_days = 15;
company.trial_end_date = Utility.GetTrialEndDate(DateTime.Today, 15);
CompanyTableAdapters.un_co_detailsTableAdapter coTA = new CompanyTableAdapters.un_co_detailsTableAdapter();
coTA.Update(company);
}
HttpContext.Current.Response.Redirect("~/Register/AddCompany.aspx");
}
else if (role.Equals(WebConstants.Roles.User))
{
HttpContext.Current.Response.Redirect("TermsConditions.aspx");
}
else
{
HttpContext.Current.Response.Redirect(role + "Home.aspx");
}
}
protected void DeleteDepartment(Object sender, CommandEventArgs e)
{
int dept_id = int.Parse(e.CommandArgument.ToString());
department = getDepartment(dept_id);
if (department == null)
{
SetErrorMessage(WebConstants.Messages.Error.INVALID_ID);
}
else
{
try
{
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter tableAdapter = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
tableAdapter.DeleteDepartment(int.Parse(department.Rows[0]["dept_id"].ToString()));
SetInfoMessage(WebConstants.Messages.Information.RECORD_DELETED);
GridView1.DataBind();
}
catch
{
SetErrorMessage(WebConstants.Messages.Error.CONNECTION_ERROR);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Session[WebConstants.Session.REG_CO_ID] != null)
{
int coId = (int)Session[WebConstants.Session.REG_CO_ID];
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter dep_Adapter = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
DataTable dt = dep_Adapter.GetDepartmentByShortName(txtCompanyShortName.Text, coId);
if (dt.Rows.Count == 0)
{
IEnumerator ie = dep_Adapter.InsertAndReturn(coId, false, txtCompanyShortName.Text, txtCompanyLongName.Text, txtContactTitle.Text, txtContactInitial.Text.Trim(), txtForename.Text.Trim(), txtSurname.Text.Trim(), txtAddressNo.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), txtAddress3.Text.Trim(), txtAddress4.Text.Trim(), txtAddress5.Text.Trim(), txtPostalCode.Text.Trim(), GetFullAddress(), txtTele.Text.Trim(), txtTele1.Text.Trim(), txtFax.Text.Trim(), txtEmail.Text.Trim(), txtCoNotes.Text.Trim(), null, DateTime.Now, null, DateTime.Now).GetEnumerator();
if (ie.MoveNext())
{
Department.DepartmentSelectCommandRow department = (Department.DepartmentSelectCommandRow)ie.Current;
Session[WebConstants.Session.REG_DEPT_ID] = department.dept_id;
Session[WebConstants.Session.WIZARD_STEP] = 3;
Response.Redirect("~/Register/AddUser.aspx");
}
}
else
{
SetErrorMessage(WebConstants.Messages.Error.ALREAD_EXISTS);
}
}
}
private void GoToPage(bool isShowWizard, int companyId, User.un_co_user_detailsRow user)
{
if (isShowWizard)
{
HttpContext.Current.Session[WebConstants.Session.REG_CO_ID] = companyId;
HttpContext.Current.Session[WebConstants.Session.REG_USER_ID] = user.user_id;
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter deptTA = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
IEnumerator ieDept = deptTA.GetDepartmentsByCoId(companyId).GetEnumerator();
if (ieDept.MoveNext())
{
Department.DepartmentSelectCommandRow department = (Department.DepartmentSelectCommandRow)ieDept.Current;
HttpContext.Current.Session[WebConstants.Session.REG_DEPT_ID] = department.dept_id;
}
HttpContext.Current.Response.Redirect("~/Register/AddCompany.aspx");
}
else
{
if (user.role.Equals(WebConstants.Roles.User))
{
HttpContext.Current.Response.Redirect("TermsConditions.aspx");
}
else
{
HttpContext.Current.Response.Redirect(user.role + "Home.aspx");
}
}
}
private DataTable getDepartment(int departmentId)
{
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter tableAdapter = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
DataTable dt = tableAdapter.GetDepartmentByDeptId(departmentId);
return dt;
}
private void BindDepartmentDDL()
{
DepartmentTableAdapters.DepartmentSelectCommandTableAdapter departmentTA = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
ddlDepartment.DataSource = departmentTA.GetDepartmentsByCoId((int)Session[WebConstants.Session.USER_CO_ID]);
ddlDepartment.DataTextField = "co_name_short";
ddlDepartment.DataValueField = "dept_id";
ddlDepartment.DataBind();
}
