public static HR_SalaryPackage GetHR_SalaryPackageBySalaryPackageID(int SalaryPackageID)
{
HR_SalaryPackage hR_SalaryPackage = new HR_SalaryPackage();
SqlHR_SalaryPackageProvider sqlHR_SalaryPackageProvider = new SqlHR_SalaryPackageProvider();
hR_SalaryPackage = sqlHR_SalaryPackageProvider.GetHR_SalaryPackageBySalaryPackageID(SalaryPackageID);
return hR_SalaryPackage;
}
public static HR_SalaryPackage GetHR_DepartmentByDepartmentID(int DepartmentID)
{
HR_SalaryPackage hR_SalaryPackage = new HR_SalaryPackage();
SqlHR_SalaryPackageProvider sqlHR_SalaryPackageProvider = new SqlHR_SalaryPackageProvider();
hR_SalaryPackage = sqlHR_SalaryPackageProvider.GetHR_SalaryPackageByDepartmentID(DepartmentID);
return hR_SalaryPackage;
}
public static int InsertHR_SalaryPackage(HR_SalaryPackage hR_SalaryPackage)
{
SqlHR_SalaryPackageProvider sqlHR_SalaryPackageProvider = new SqlHR_SalaryPackageProvider();
return sqlHR_SalaryPackageProvider.InsertHR_SalaryPackage(hR_SalaryPackage);
}
public static bool UpdateHR_SalaryPackage(HR_SalaryPackage hR_SalaryPackage)
{
SqlHR_SalaryPackageProvider sqlHR_SalaryPackageProvider = new SqlHR_SalaryPackageProvider();
return sqlHR_SalaryPackageProvider.UpdateHR_SalaryPackage(hR_SalaryPackage);
}
public bool UpdateHR_SalaryPackage(HR_SalaryPackage hR_SalaryPackage)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_SalaryPackage", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SalaryPackageID", SqlDbType.Int).Value = hR_SalaryPackage.SalaryPackageID;
cmd.Parameters.Add("@SalaryPackageName", SqlDbType.NVarChar).Value = hR_SalaryPackage.SalaryPackageName;
cmd.Parameters.Add("@DepartmentID", SqlDbType.Int).Value = hR_SalaryPackage.DepartmentID;
cmd.Parameters.Add("@Rank", SqlDbType.NVarChar).Value = hR_SalaryPackage.Rank;
cmd.Parameters.Add("@Ratio", SqlDbType.Decimal).Value = hR_SalaryPackage.Ratio;
cmd.Parameters.Add("@Ratio", SqlDbType.Decimal).Value = hR_SalaryPackage.Ratio;
cmd.Parameters.Add("@Ratio", SqlDbType.Decimal).Value = hR_SalaryPackage.Ratio;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_SalaryPackage.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_SalaryPackage.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_SalaryPackage GetHR_SalaryPackageFromReader(IDataReader reader)
{
try
{
HR_SalaryPackage hR_SalaryPackage = new HR_SalaryPackage
(
DataAccessObject.IsNULL<int>(reader["SalaryPackageID"]),
DataAccessObject.IsNULL<string>(reader["SalaryPackageName"]),
DataAccessObject.IsNULL<int>(reader["DepartmentID"]),
DataAccessObject.IsNULL<string>(reader["Rank"]),
DataAccessObject.IsNULL<decimal>(reader["Ratio"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_SalaryPackage;
}
catch(Exception ex)
{
return null;
}
}
