public IHttpActionResult Save(SalaryDefinitionViewModel def)
{
SalaryDefinition definition = Mapper.Map <SalaryDefinition>(def);
definition.CompanyId = iHUser.GetCurrentCompanyId();
return(Json(definitionService.Save(definition)));
}
public SalaryDefinition Save(SalaryDefinition def)
{
if (def.DefinitionId == 0)
{
def.DefinitionId = repository.Save(def);
}
else
{
repository.Update(def);
}
return(def);
}
public Int64 Save(SalaryDefinition def)
{
return(Convert.ToInt64(db.GetScalar(@"INSERT INTO payroll.salary_definition(row_id, definition_name,
company_id, formula, formula_percentage, minimum, maximum, is_deduction, is_variable, is_incentive, is_lop)
VALUES(@row_id, @definition_name, @company_id, @formula, @formula_percentage, @minimum, @maximum, @is_deduction,
@is_variable, @is_incentive, @is_lop) RETURNING definition_id;", new
{
row_id = def.RowId,
definition_name = def.DefinitionName,
company_id = def.CompanyId,
formula = def.Formula ?? string.Empty,
formula_percentage = def.FormulaPercentage,
minimum = def.Minimum,
maximum = def.Maximum,
is_deduction = def.IsDeduction,
is_variable = def.IsVariable,
is_incentive = def.IsIncentive,
is_lop = def.IsLOP
})));
}
public void Update(SalaryDefinition def)
{
db.GetScalar(@"UPDATE payroll.salary_definition
SET row_id = @row_id, definition_name=@definition_name, company_id=@company_id, formula=@formula,
formula_percentage=@formula_percentage, minimum=@minimum, maximum=@maximum, is_deduction=@is_deduction,
is_variable=@is_variable, is_incentive=@is_incentive, is_lop=@is_lop
WHERE definition_id = @definition_id;" , new
{
row_id = def.RowId,
definition_id = def.DefinitionId,
definition_name = def.DefinitionName,
company_id = def.CompanyId,
formula = def.Formula,
formula_percentage = def.FormulaPercentage,
minimum = def.Minimum,
maximum = def.Maximum,
is_deduction = def.IsDeduction,
is_variable = def.IsVariable,
is_incentive = def.IsIncentive,
is_lop = def.IsLOP
});
}
