public static HR_EmployeePackage GetHR_EmployeePackageByEmployeePackageID(int EmployeePackageID)
{
HR_EmployeePackage hR_EmployeePackage = new HR_EmployeePackage();
SqlHR_EmployeePackageProvider sqlHR_EmployeePackageProvider = new SqlHR_EmployeePackageProvider();
hR_EmployeePackage = sqlHR_EmployeePackageProvider.GetHR_EmployeePackageByEmployeePackageID(EmployeePackageID);
return hR_EmployeePackage;
}
public bool UpdateHR_EmployeePackage(HR_EmployeePackage hR_EmployeePackage)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_EmployeePackage", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmployeePackageID", SqlDbType.Int).Value = hR_EmployeePackage.EmployeePackageID;
cmd.Parameters.Add("@PackageName", SqlDbType.NVarChar).Value = hR_EmployeePackage.PackageName;
cmd.Parameters.Add("@PackageName", SqlDbType.NVarChar).Value = hR_EmployeePackage.PackageName;
cmd.Parameters.Add("@PackageName", SqlDbType.NVarChar).Value = hR_EmployeePackage.PackageName;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_EmployeePackage.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_EmployeePackage.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertHR_EmployeePackage(HR_EmployeePackage hR_EmployeePackage)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertHR_EmployeePackage", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmployeePackageID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@PackageName", SqlDbType.NVarChar).Value = hR_EmployeePackage.PackageName;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_EmployeePackage.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_EmployeePackage.AddedDate;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_EmployeePackage.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_EmployeePackage.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@EmployeePackageID"].Value;
}
}
public HR_EmployeePackage GetHR_EmployeePackageFromReader(IDataReader reader)
{
try
{
HR_EmployeePackage hR_EmployeePackage = new HR_EmployeePackage
(
DataAccessObject.IsNULL<int>(reader["EmployeePackageID"]),
DataAccessObject.IsNULL<string>(reader["PackageName"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_EmployeePackage;
}
catch(Exception ex)
{
return null;
}
}
public static bool UpdateHR_EmployeePackage(HR_EmployeePackage hR_EmployeePackage)
{
SqlHR_EmployeePackageProvider sqlHR_EmployeePackageProvider = new SqlHR_EmployeePackageProvider();
return sqlHR_EmployeePackageProvider.UpdateHR_EmployeePackage(hR_EmployeePackage);
}
public static int InsertHR_EmployeePackage(HR_EmployeePackage hR_EmployeePackage)
{
SqlHR_EmployeePackageProvider sqlHR_EmployeePackageProvider = new SqlHR_EmployeePackageProvider();
return sqlHR_EmployeePackageProvider.InsertHR_EmployeePackage(hR_EmployeePackage);
}
