void FillAllData()
{
dto = SalaryBLL.GetAll();
if (!UserStatic.isAdmin)
{
dto.Salaries = dto.Salaries.Where(x => x.EmployeeID == UserStatic.EmployeeID).ToList();
}
dataGridView1.DataSource = dto.Salaries;
cmbDepartment.DataSource = dto.Departments;
cmbDepartment.DisplayMember = "DepartamentName";
cmbDepartment.ValueMember = "ID";
cmbPosition.DataSource = dto.Positions;
cmbPosition.DisplayMember = "Position1";
cmbPosition.ValueMember = "ID";
cmbDepartment.SelectedIndex = -1;
cmbPosition.SelectedIndex = -1;
if (dto.Departments.Count > 0)
{
comboFull = true;
}
cmbMonth.DataSource = dto.Months;
cmbMonth.DisplayMember = "MonthName";
cmbMonth.ValueMember = "ID";
cmbMonth.SelectedIndex = -1;
comboFull = true;
}
public static Salary MapSalaryDTOToSalary(SalaryDTO salary)
{
return(new Salary
{
id = salary.id,
IncomeMarie = salary.InkomstMarie,
IncomeSamuel = salary.InkomstSamuel,
date = salary.Datum
});
}
public static SalaryDTO GetAll()
{
SalaryDTO dto = new SalaryDTO();
dto.Employees = EmployeeDAO.GetEmployees();
dto.Departments = DepartmentDAO.GetDepartments();
dto.Positions = PositionDAO.GetPositions();
dto.Months = SalaryDAO.GetMonths();
dto.Salaries = SalaryDAO.GetSalaries();
return(dto);
}
private void Fr_Salary_Load(object sender, EventArgs e)
{
dto = SalaryBLL.GetAll();
if (!isUpdate)
{
dataGridView1.DataSource = dto.Employees;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "User No";
dataGridView1.Columns[2].HeaderText = "Name";
dataGridView1.Columns[3].HeaderText = "Surname";
dataGridView1.Columns[4].Visible = false;;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
dataGridView1.Columns[8].Visible = false;
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[10].Visible = false;
dataGridView1.Columns[11].Visible = false;
dataGridView1.Columns[12].Visible = false;
dataGridView1.Columns[13].Visible = false;
combofull = false;
cmbDepartment.DataSource = dto.Departments;
cmbDepartment.DisplayMember = "DepartmentName";
cmbDepartment.ValueMember = "ID";
cmbDepartment.SelectedIndex = -1;
cmbPosition.DataSource = dto.Positions;
cmbPosition.DisplayMember = "PositionName";
cmbPosition.ValueMember = "ID";
cmbPosition.SelectedIndex = -1;
if (dto.Departments.Count > 0)
{
combofull = true;
}
}
cmbMonth.DataSource = dto.Months;
cmbMonth.DisplayMember = "MonthName";
cmbMonth.ValueMember = "ID";
cmbMonth.SelectedIndex = -1;
if (isUpdate)
{
panel1.Hide();
txtName.Text = detail.Name;
txtUserNo.Text = detail.UserNo.ToString();
txtSurname.Text = detail.Surname;
txtSalary.Text = detail.SalaryAmount.ToString();
txtYear.Text = detail.SalaryYear.ToString();
cmbMonth.SelectedValue = detail.MonthID;
}
}
public async Task <long> Save(SalaryDTO entity)
{
try
{
return(await _salaryDAL.Save(_mapper.Map <Salary>(entity)));
}
catch (Exception ex)
{
return(0);
}
}
public static SalaryDTO GetAll()
{
SalaryDTO salaryDTO = new SalaryDTO();
salaryDTO.Employees = EmployeeDAO.GetEmployees();
salaryDTO.Departments = DepartmentDAO.GetDepartments();
salaryDTO.Positions = PositionDAO.GetPositions();
salaryDTO.Months = SalaryDAO.GetMonths();
salaryDTO.Salaries = SalaryDAO.GetSalaries();
return(salaryDTO);
}
public Salary ConvertToEF(SalaryDTO DTO)
{
var EF = new Salary()
{
SalaryId = DTO.SalaryId,
SMax = DTO.SMax,
SMin = DTO.SMin,
SShow = DTO.SShow
};
return(EF);
}
public SalaryDTO ConvertToDTO(Salary EF)
{
var DTO = new SalaryDTO()
{
SalaryId = EF.SalaryId,
SMax = EF.SMax,
SMin = EF.SMin,
SShow = EF.SShow
};
return(DTO);
}
public int UpdateSalary(SalaryDTO salary)
{
int result;
string updateQuery = "UPDATE inkomster SET " +
"InkomstMarie = @InkomstMarie," +
"InkomstSamuel = @InkomstSamuel," +
"Datum = @Datum " +
"WHERE id = @id";
using (IDbConnection db = new MySqlConnection(connectionString))
{
result = db.Execute(updateQuery, salary);
}
return(result);
}
public int AddNewSalary(SalaryDTO salary)
{
int result;
string insertQuery = "INSERT INTO inkomster (InkomstMarie, InkomstSamuel, Datum) " +
"VALUES (@InkomstMarie, @InkomstSamuel, @Datum);";
using (IDbConnection db = new MySqlConnection(connectionString))
{
result = db.Execute(insertQuery, new
{
salary.InkomstMarie,
salary.InkomstSamuel,
salary.Datum
});
}
return(result);
}
public async Task <IActionResult> Save(SalaryDTO model) => Ok(await _salaryDSL.Save(model));
