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