/// <summary>
/// Deletes the employeeLeasing.
/// </summary>
/// <param name="employeeLeasing">The employeeLeasing.</param>
/// <returns></returns>
public string DeleteEmployeeLeasing(EmployeeLeasingEntity employeeLeasing)
{
const string sql = @"uspDelete_EmployeeLeasing";
object[] parms = { "@EmployeeLeasingId", employeeLeasing.EmployeeLeasingId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified employee leasing.
/// </summary>
/// <param name="employeeLeasing">The employee leasing.</param>
/// <returns></returns>
private static object[] Take(EmployeeLeasingEntity employeeLeasing)
{
return(new object[]
{
"@EmployeeLeasingID", employeeLeasing.EmployeeLeasingId,
"@EmployeeLeasingCode", employeeLeasing.EmployeeLeasingCode,
"@EmployeeLeasingName", employeeLeasing.EmployeeLeasingName,
"@Description", employeeLeasing.Description,
"@JobCandidate", employeeLeasing.JobCandidate,
"@StartDate", employeeLeasing.StartDate,
"@EndDate", employeeLeasing.EndDate,
"@IsActive", employeeLeasing.IsActive,
"@IsLeasing", employeeLeasing.IsLeasing,
"@SalaryPrice", employeeLeasing.SalaryPrice,
"@InsurancePrice", employeeLeasing.InsurancePrice,
"@UniformPrice", employeeLeasing.UniformPrice
});
}
/// <summary>
/// Updates the employeeLeasing.
/// </summary>
/// <param name="employeeLeasing">The employeeLeasing.</param>
/// <returns></returns>
public string UpdateEmployeeLeasing(EmployeeLeasingEntity employeeLeasing)
{
const string sql = @"uspUpdate_EmployeeLeasing";
return(Db.Update(sql, true, Take(employeeLeasing)));
}
/// <summary>
/// Inserts the employeeLeasing.
/// </summary>
/// <param name="employeeLeasing">The employeeLeasing.</param>
/// <returns></returns>
public int InsertEmployeeLeasing(EmployeeLeasingEntity employeeLeasing)
{
const string sql = @"uspInsert_EmployeeLeasing";
return(Db.Insert(sql, true, Take(employeeLeasing)));
}
