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(); }