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