/// <summary> /// Save all personalAgencyName to database (direct) /// </summary> /// <param name="companyId">companyId</param> public void Save(int companyId) { PersonalAgencyInformationTDS personalAgencyInformationChanges = (PersonalAgencyInformationTDS)Data.GetChanges(); if (personalAgencyInformationChanges != null) { if (personalAgencyInformationChanges.PersonalAgencyInformation.Rows.Count > 0) { PersonalAgencyInformationGateway sizeInformationGateway = new PersonalAgencyInformationGateway(personalAgencyInformationChanges); foreach (PersonalAgencyInformationTDS.PersonalAgencyInformationRow row in (PersonalAgencyInformationTDS.PersonalAgencyInformationDataTable)personalAgencyInformationChanges.PersonalAgencyInformation) { // Insert new personal agency if ((!row.Deleted) && (!row.InDatabase)) { EmployeePersonalAgencyGateway employeePersonalAgencyGateway = new EmployeePersonalAgencyGateway(); EmployeePersonalAgency employeePersonalAgency = new EmployeePersonalAgency(null); if (!employeePersonalAgencyGateway.ExistPersonalAgency(row.PersonalAgencyName, row.COMPANY_ID)) { employeePersonalAgency.InsertDirect(row.PersonalAgencyName, row.COMPANY_ID, row.Deleted); } else { employeePersonalAgency.UnDeleteDirect(row.PersonalAgencyName, row.COMPANY_ID); } } // Update personal agency if ((!row.Deleted) && (row.InDatabase)) { string originalPersonalAgencyName = row.NewPersonalAgencyName; string newPersonalAgencyName = row.PersonalAgencyName; int originalCompanyId = companyId; EmployeePersonalAgencyGateway employeePersonalAgencyGateway = new EmployeePersonalAgencyGateway(); EmployeePersonalAgency employeePersonalAgency = new EmployeePersonalAgency(null); if (!employeePersonalAgencyGateway.ExistPersonalAgency(row.PersonalAgencyName, row.COMPANY_ID)) { employeePersonalAgency.InsertDirect(newPersonalAgencyName, originalCompanyId, false); } else { employeePersonalAgency.UnDeleteDirect(newPersonalAgencyName, originalCompanyId); } if (employeePersonalAgencyGateway.IsUsedInEmployee(originalPersonalAgencyName, companyId)) { EmployeeGateway employeeGateway = new EmployeeGateway(null); employeeGateway.UpdatePersonalAgencyName(originalPersonalAgencyName, newPersonalAgencyName); } employeePersonalAgency.DeleteDirect(originalPersonalAgencyName, companyId); } // Delete personal agency if ((row.Deleted) && (row.InDatabase)) { EmployeePersonalAgency employeePersonalAgency = new EmployeePersonalAgency(null); employeePersonalAgency.DeleteDirect(row.PersonalAgencyName, row.COMPANY_ID); } } } } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_ADMIN"])) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Validate query string if ((string)Request.QueryString["source_page"] == null) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in employees_personal_agency.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfUpdate.Value = "yes"; Session.Remove("personalAgencyInformationDummy"); Session.Remove("personalAgencyInformation"); ViewState["update"] = Request.QueryString["update"]; // ... Load personalAgency to edit personalAgencyInformationTDS = new PersonalAgencyInformationTDS(); PersonalAgencyInformationGateway personalAgencyInformationGateway = new PersonalAgencyInformationGateway(personalAgencyInformationTDS); personalAgencyInformationGateway.Load(Int32.Parse(hdfCompanyId.Value.Trim())); // ... Store datasets Session["personalAgencyInformationTDS"] = personalAgencyInformationTDS; Session["personalAgencyInformation"] = personalAgencyInformationTDS.PersonalAgencyInformation; } else { // Restore datasets personalAgencyInformationTDS = (PersonalAgencyInformationTDS)Session["personalAgencyInformationTDS"]; personalAgencyInformation = personalAgencyInformationTDS.PersonalAgencyInformation; } }
protected void cvPersonalAgencyNameEdit_ServerValidate(object source, ServerValidateEventArgs args) { args.IsValid = true; string originalPersonalAgencyName = ((HiddenField)grdPersonalAgency.Rows[grdPersonalAgency.EditIndex].FindControl("hdfPersonalAgencyNameEdit")).Value; if (originalPersonalAgencyName != args.Value.Trim()) { PersonalAgencyInformationGateway personalAgencyInformationGateway = new PersonalAgencyInformationGateway(personalAgencyInformationTDS); if (personalAgencyInformationGateway.Table.Rows.Count > 0) { foreach (PersonalAgencyInformationTDS.PersonalAgencyInformationRow row in (PersonalAgencyInformationTDS.PersonalAgencyInformationDataTable)personalAgencyInformationGateway.Table) { if (row.PersonalAgencyName == args.Value.Trim()) { args.IsValid = false; } } } } }
protected void cvPersonalAgencyNameNew_ServerValidate(object source, ServerValidateEventArgs args) { args.IsValid = true; PersonalAgencyInformationGateway personalAgencyInformationGateway = new PersonalAgencyInformationGateway(personalAgencyInformationTDS); if (personalAgencyInformationGateway.Table.Rows.Count > 0) { foreach (PersonalAgencyInformationTDS.PersonalAgencyInformationRow row in (PersonalAgencyInformationTDS.PersonalAgencyInformationDataTable)personalAgencyInformationGateway.Table) { if (row.PersonalAgencyName == args.Value.Trim()) { args.IsValid = false; } } } }