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