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