public IHttpActionResult SaveModelSalarys(List <ModelSalary> salary) { EmpDbEntities entity = new EmpDbEntities(); salary.ForEach(d => { SalaryTable exist = entity.SalaryTables.Where(k => k.EmployeeId == d.EmployeeId).FirstOrDefault(); if (exist != null) { throw new Exception("Record is Already exist"); } SalaryTable table = new SalaryTable(); table.Salary = d.Salary; table.EmployeeId = d.EmployeeId; entity.SalaryTables.Add(table); }); int result = entity.SaveChanges(); if (result > 0) { return(Ok("Successfully Saved")); } else { return(BadRequest("Failed to Save")); } }
public IHttpActionResult SaveModelSalary(ModelSalary salary) { EmpDbEntities entity = new EmpDbEntities(); SalaryTable exist = entity.SalaryTables.Where(d => d.EmployeeId == salary.EmployeeId).FirstOrDefault(); if (exist != null) { throw new Exception("The salary already added for this employee."); } SalaryTable table = new SalaryTable(); table.Salary = salary.Salary; table.EmployeeId = salary.EmployeeId; entity.SalaryTables.Add(table); int result = entity.SaveChanges(); if (result > 0) { return(Ok("Successfully save")); } else { return(BadRequest("Failed to Save")); } }
public IHttpActionResult UpdateModelSalary(long employeeId, ModelSalary salary) { EmpDbEntities entity = new EmpDbEntities(); SalaryTable exist = entity.SalaryTables.Where(d => d.EmployeeId == employeeId).FirstOrDefault(); if (exist != null) { SalaryTable table = new SalaryTable(); table.Salary = salary.Salary; table.EmployeeId = employeeId; entity.SalaryTables.AddOrUpdate(table); int result = entity.SaveChanges(); if (result > 0) { return(Ok("Successfully Updated")); } else { return(BadRequest("Failed to Update")); } } else { return(BadRequest("Failed to Update")); } }
public IHttpActionResult GetModelSalary(long employeeId) { EmpDbEntities entity = new EmpDbEntities(); SalaryTable exist = entity.SalaryTables.Where(d => d.EmployeeId == employeeId).FirstOrDefault(); if (exist != null) { ModelSalary model = new ModelSalary(); model.Salary = Convert.ToSingle(exist.Salary); model.EmployeeId = employeeId; return(Ok(model)); } else { return(NotFound()); } }
/// <summary>加载员工工资信息列表。</summary> private void LoadSalaryList() { int iYear = int.Parse(this.cboYear.Text); int iMonth = int.Parse(this.cboMonth.Text); List <SalaryTable> lstSalaryTable = SalaryTable.SelectList(iYear, iMonth); this.dgvSalary.AutoGenerateColumns = false; this.dgvSalary.Rows.Clear(); decimal dSum = 0; foreach (SalaryTable objSalaryTable in lstSalaryTable) { dSum += objSalaryTable.LastTotal; this.dgvSalary.Rows.Add(new object[] { objSalaryTable.WorkNumber, objSalaryTable.Name, objSalaryTable.PostName, objSalaryTable.MonthTotal, objSalaryTable.Salary, objSalaryTable.Bonus, objSalaryTable.Award, objSalaryTable.Deduct, objSalaryTable.LastTotal }); } this.lblSum.Text = "合计实发工资:¥" + dSum.ToString("f2"); this.lblSum.Top = this.ClientSize.Height - 18; }
public IHttpActionResult GetmodelSalarys() { EmpDbEntities entity = new EmpDbEntities(); List <SalaryTable> salarys = entity.SalaryTables.ToList(); if (salarys.Count > 0) { List <SalaryTable> result = new List <SalaryTable>(); salarys.ForEach(d => { SalaryTable table = new SalaryTable(); table.Salary = d.Salary; table.EmployeeId = d.EmployeeId; result.Add(table); }); return(Ok(result)); } else { return(NotFound()); } }
public IHttpActionResult DeleteModelSalary(long employeeId) { EmpDbEntities entity = new EmpDbEntities(); SalaryTable exist = entity.SalaryTables.Where(k => k.EmployeeId == employeeId).FirstOrDefault(); if (exist != null) { entity.SalaryTables.Remove(exist); int result = entity.SaveChanges(); if (result > 0) { return(Ok("Successfully Deleted")); } else { return(BadRequest("Failed to Delete")); } } else { return(BadRequest("Failed to Delete")); } }