/// <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); } } } } }
protected void grdPersonalAgency_RowDeleting(object sender, GridViewDeleteEventArgs e) { //Page.Validate("personalAgencyData"); EmployeePersonalAgencyGateway employeePersonalAgencyGateway = new EmployeePersonalAgencyGateway(); string personalAgencyName = e.Keys["PersonalAgencyName"].ToString(); int companyId = Int32.Parse(hdfCompanyId.Value); if (!employeePersonalAgencyGateway.IsUsedInEmployee(personalAgencyName, companyId)) { // If the gridview is edition mode if (grdPersonalAgency.EditIndex >= 0) { grdPersonalAgency.UpdateRow(grdPersonalAgency.EditIndex, true); } PersonalAgencyInformation model = new PersonalAgencyInformation(personalAgencyInformationTDS); // Delete Personnel Agency model.Delete(personalAgencyName, companyId); // Store dataset Session.Remove("personalAgencyInformationDummy"); Session["personalAgencyInformationTDS"] = personalAgencyInformationTDS; Session["personalAgencyInformation"] = personalAgencyInformationTDS.PersonalAgencyInformation; } else { Page.Validate("personalAgencyData"); e.Cancel = true; } }
protected void cvPersonalAgencyName_ServerValidate(object source, ServerValidateEventArgs args) { args.IsValid = true; EmployeePersonalAgencyGateway employeePersonalAgencyGateway = new EmployeePersonalAgencyGateway(); if (employeePersonalAgencyGateway.IsUsedInEmployee(args.Value.Trim(), Int32.Parse(hdfCompanyId.Value))) { args.IsValid = false; } }
/// <summary> /// Update PersonalAgencyName (direct to DB) /// </summary> /// <param name="originalPersonalAgencyName">originalPersonalAgencyName</param> /// <param name="originalCompanyId">originalCompanyId</param> /// <param name="originalDeleted">originalDeleted</param> /// /// <param name="newPersonalAgencyName">newPersonalAgencyName</param> /// <param name="newCompanyId">newCompanyId</param> /// <param name="newDeleted">newDeleted</param> public void UpdateDirect(string originalPersonalAgencyName, int originalCompanyId, bool originalDeleted, string newPersonalAgencyName, int newCompanyId, bool newDeleted) { EmployeePersonalAgencyGateway employeePersonalAgencyGateway = new EmployeePersonalAgencyGateway(null); employeePersonalAgencyGateway.Update(originalPersonalAgencyName, originalCompanyId, originalDeleted, newPersonalAgencyName, newCompanyId, newDeleted); }
/// <summary> /// Undelete PersonalAgencyName /// </summary> /// <param name="personalAgencyName">personalAgencyName</param> /// <param name="companyId">companyId</param> public void UnDeleteDirect(string personalAgencyName, int companyId) { EmployeePersonalAgencyGateway employeePersonalAgencyGateway = new EmployeePersonalAgencyGateway(null); employeePersonalAgencyGateway.UnDelete(personalAgencyName, companyId); }
// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // /// <summary> /// Insert material /// </summary> /// <param name="personalAgencyName">personalAgencyName</param> /// <param name="companyId">companyId</param> /// <param name="deleted">deleted</param> public void InsertDirect(string personalAgencyName, int companyId, bool deleted) { EmployeePersonalAgencyGateway employeePersonalAgencyGateway = new EmployeePersonalAgencyGateway(null); employeePersonalAgencyGateway.Insert(personalAgencyName, companyId, deleted); }