public IHttpActionResult DeleteSalary(int id, int loggedId, string sessionKey)
{
Constants.VerifyUserErrors error = AuthHandler.VerifyUserSession(sessionKey, loggedId, db);
Salary salary = db.Salaries.Find(id);
if (error == Constants.VerifyUserErrors.OK)
{
if (salary == null)
{
return(NotFound());
}
if (salary.UserID != 0)
{
SalaryHandler.DeleteOneSalary(db, salary);
User deletedUserSalary = db.Users.FirstOrDefault(u => u.ID == salary.UserID);
if (deletedUserSalary != null)
{
User loggedUser = db.Users.FirstOrDefault(u => u.ID == loggedId);
if (loggedUser != null)
{
LogHandler.CreateLogEntry(db, loggedId, $"The user {loggedUser.Name} (ID: {loggedId}) has deleted the salary for {deletedUserSalary.Name} (ID: {deletedUserSalary.ID})", (int)LogHandler.RequestTypes.DELETE);
}
}
return(Ok(salary));
}
salary.UserID = -1;
return(Ok(salary));
}
return(StatusCode(CommonMethods.StatusCodeReturn(error)));
}
private void btnCalc_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SQLiteConnection conn = new SQLiteConnection();
try
{
conn = new SQLiteConnection(strConnect);
conn.Open();
SQLiteCommand CMD = conn.CreateCommand();
CMD.CommandText = "SELECT p.id, username, date, baseSalary, coeffDate, maxDate FROM LoginTable l" +
" INNER JOIN PersonalInfoTable p ON l.id = p.id" +
" INNER JOIN RoleTable r ON p.roleID = r.roleID";
SQLiteDataReader dr = CMD.ExecuteReader();
dt.Load(dr);
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
SalaryHandler.changeDateSalary(dt);
SalaryHandler.ChangeSurchargeForAll(dt);
ShowListOfAllUsers();
}
public IHttpActionResult GetSalaries()
{
Dictionary <int, Salary> salaries = SalaryHandler.GetAllSalaries(db);
if (salaries.Count == 0)
{
return(NotFound());
}
return(Ok(salaries));
}
public IHttpActionResult GetSalary(int id)
{
Salary salary = SalaryHandler.GetOneSalary(id, db);
if (salary == null)
{
return(NotFound());
}
return(Ok(salary));
}
public ActionResult UpdateEmployee(long Id)
{
try
{
tblUser user = Session[WebUtil.CURRENT_USER] as tblUser;
if (!(user != null))
{
return(RedirectToAction("RedirectToLogin", "user"));
}
DAL.Employee tblEmployee = new EmployeeHandler().GetEmployee(Id);
DAL.tblSalary tblSalary = new SalaryHandler().GetSalaryOfEmployee(Id);
VMEmployee Model = new VMEmployee {
Id = Id, Designation = tblEmployee.Designation, FirstName = tblEmployee.FirstName, LastName = tblEmployee.LastName, Salary = (float)tblSalary.Salary
};
return(PartialView("~/Views/Employee/_UpdateEmployee.cshtml", Model));
}
catch (Exception ex)
{
return(JavaScript("showMessage('error', 'Something went wrong','bottom-right','Employee', 'Manage')"));
}
}
static void Main(string[] args)
{
IEnumerable <IBaseCalculator> calculators = new List <IBaseCalculator>()
{
new SeniorDeveloperCalculator(new DeveloperReportModel {
Id = 1, Name = "Dev1", Level = "Senior developer", HourlyRate = 30.5, WorkingHours = 160
}),
new JuniorDeveloperCalculator(new DeveloperReportModel {
Id = 2, Name = "Dev2", Level = "Junior developer", HourlyRate = 20, WorkingHours = 150
}),
new SeniorDeveloperCalculator(new DeveloperReportModel {
Id = 3, Name = "Dev3", Level = "Senior developer", HourlyRate = 30.5, WorkingHours = 180
}),
new CTOCalculator(new ExecutiveReportModel()
{
Name = "CTO", Bonus = 3500, HourlyRate = 50, WorkingHours = 200
})
};
var calculator = new SalaryHandler(calculators);
Console.WriteLine($"Sum of all the salaries is {calculator.CalculateSalary()} dollars");
}
