public void sortAll() { dgvSalary.DataSource = SalaryManagement.SelectAllSalaries(); dgvPosition.DataSource = PositionManagement.SelectAllPositions(); cmbSalary.DataSource = SalaryManagement.SelectAllSalaries(); cmbSalary.DisplayMember = "salaryAmount"; }
private void txtSearchSalary_KeyPress(object sender, KeyPressEventArgs e) { string text = txtSearchSalary.Text; try { if (text != "") { dgvSalary.DataSource = SalaryManagement.SelectSalaryByRegistrationDate(text); //Buscar por cantidad } else { dgvSalary.DataSource = SalaryManagement.SelectAllSalaries(); } } catch (Exception) { throw; } }
private void deleteSalaryButton_Click(object sender, EventArgs e) { string id = dgvSalary.CurrentRow.Cells[0].Value.ToString(); try { if (SalaryManagement.DeleteSalaryById(id)) { sortAll(); FrmMain.Instance.ToolStripLabel.Text = "Se elimino el salario correctamente"; } else { FrmMain.Instance.ToolStripLabel.Text = "Error al eliminar el salario"; } } catch (Exception) { throw; } }
private void btnUpdateSalary_Click(object sender, EventArgs e) { string id = txtID.Text; string salary = txtQuantity.Text; try { if (SalaryManagement.UpdateSalaryById(id, salary)) { sortAll(); FrmMain.Instance.ToolStripLabel.Text = "Se modifico el salario correctamente"; } else { FrmMain.Instance.ToolStripLabel.Text = "Error al modificar el salario"; } } catch (Exception) { throw; } }
//CRUD private void createSalaryButton_Click(object sender, EventArgs e) { string id = txtID.Text; string salary = txtQuantity.Text; try { if (SalaryManagement.InsertSalary(salary)) { sortAll(); FrmMain.Instance.ToolStripLabel.Text = "Se inserto el salario correctamente"; } else { FrmMain.Instance.ToolStripLabel.Text = "Error al insertar el salario"; } } catch (Exception) { throw; } }
public string[] createStaffSalaryDataBase(CreateStaffSalary structData) { SalaryManagement smDB = new SalaryManagement(); if (int.Parse(smDB._StaffhaveRoles[2]) == 1) { return smDB.createStaffSalaryData(structData); } else { return new string[2] { _noRole, _errorMsg }; } }
public string[] setExternalTeacherDataBase(CreateExternal StaffData) { SalaryManagement smDB = new SalaryManagement(); if (int.Parse(smDB._StaffhaveRoles[1]) == 1) { return smDB.setExternalTeacherDataBase(StaffData); } else { return new string[2] { _noRole, _errorMsg }; } }
public string[] setStaffSalaryDataBase(CreateStaffSalary structData, List<string> DelAddItem, List<string> DelMinusItem) { SalaryManagement smDB = new SalaryManagement(); if (int.Parse(smDB._StaffhaveRoles[1]) == 1) { return smDB.setStaffSalaryData(structData, DelAddItem, DelMinusItem); } else { return new string[2] { _noRole, _errorMsg }; } }
public string[] SearchStaffSalaryBaseCount(SearchStaff SearchStaffCondition) { SalaryManagement smDB = new SalaryManagement(); if (int.Parse(smDB._StaffhaveRoles[3]) == 1) { return smDB.SearchStaffSalaryBaseCount(SearchStaffCondition); } else { return new string[2] { _noRole, _errorMsg }; } }
public List<StaffDataList> SearchStaffSalaryDataBase(int index, SearchStaff SearchStaffCondition) { SalaryManagement smDB = new SalaryManagement(); return smDB.SearchStaffSalaryData(index, SearchStaffCondition); }
public List<SearchExternalResult> SearchExternalTeacherDataBase(int index, SearchExternal SearchStaffCondition) { SalaryManagement smDB = new SalaryManagement(); return smDB.SearchExternalTeacherDataBase(index, SearchStaffCondition); }
public string[] createExternalTeacherWorkDataBase(ExternalWorkData SearchTeacher) { SalaryManagement smDB = new SalaryManagement(); if (int.Parse(smDB._StaffhaveRoles[2]) == 1) { return smDB.createExternalTeacherWorkDataBase(SearchTeacher); } else { return new string[2] { _noRole, _errorMsg }; } }
public List<string[]> getStaffSalaryexplanationDataBase(string staffID) { SalaryManagement smDB = new SalaryManagement(); return smDB.getStaffSalaryexplanationData(staffID); }
public CreateStaffSalary getStaffSalaryDataBase(string sID) { SalaryManagement smDB = new SalaryManagement(); CreateStaffSalary returnValue = new CreateStaffSalary(); if (int.Parse(smDB._StaffhaveRoles[3]) == 1) { returnValue= smDB.getStaffSalaryData(sID); } else { returnValue.checkNo = _noRole; returnValue.errorMsg = _errorMsg; } StaffDataBase sDB = new StaffDataBase(); List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); if (returnValue.Unit != UserFile[2] && int.Parse(smDB._StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0) { returnValue.checkNo = _getcheckNo; returnValue.errorMsg = _errorMsg; } return returnValue; }
public CreateExternal getExternalTeacherDataBase(string sID) { SalaryManagement smDB = new SalaryManagement(); CreateExternal returnValue = new CreateExternal(); if (int.Parse(smDB._StaffhaveRoles[3]) == 1) { returnValue = smDB.getExternalTeacherDataBase(sID); } else { returnValue.checkNo = _noRole; returnValue.errorMsg = _errorMsg; } return returnValue; }