public static SQLPLUS_PRODUCT_PROFILE GetSQLPLUS_PRODUCT_PROFILEByID(int id)
{
SQLPLUS_PRODUCT_PROFILE sQLPLUS_PRODUCT_PROFILE = new SQLPLUS_PRODUCT_PROFILE();
SqlSQLPLUS_PRODUCT_PROFILEProvider sqlSQLPLUS_PRODUCT_PROFILEProvider = new SqlSQLPLUS_PRODUCT_PROFILEProvider();
sQLPLUS_PRODUCT_PROFILE = sqlSQLPLUS_PRODUCT_PROFILEProvider.GetSQLPLUS_PRODUCT_PROFILEByID(id);
return(sQLPLUS_PRODUCT_PROFILE);
}
public bool UpdateSQLPLUS_PRODUCT_PROFILE(SQLPLUS_PRODUCT_PROFILE sQLPLUS_PRODUCT_PROFILE)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateSQLPLUS_PRODUCT_PROFILE", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SQLPLUS_PRODUCT_PROFILEID", SqlDbType.Int).Value = sQLPLUS_PRODUCT_PROFILE.SQLPLUS_PRODUCT_PROFILEID;
cmd.Parameters.Add("@PRODUCT", SqlDbType.VarChar).Value = sQLPLUS_PRODUCT_PROFILE.PRODUCT;
cmd.Parameters.Add("@USERID", SqlDbType.Int).Value = sQLPLUS_PRODUCT_PROFILE.USERID;
cmd.Parameters.Add("@ATTRIBUTE", SqlDbType.VarChar).Value = sQLPLUS_PRODUCT_PROFILE.ATTRIBUTE;
cmd.Parameters.Add("@SCOPE", SqlDbType.VarChar).Value = sQLPLUS_PRODUCT_PROFILE.SCOPE;
cmd.Parameters.Add("@NUMERIC_VALUE", SqlDbType.Int).Value = sQLPLUS_PRODUCT_PROFILE.NUMERIC_VALUE;
cmd.Parameters.Add("@CHAR_VALUE", SqlDbType.VarChar).Value = sQLPLUS_PRODUCT_PROFILE.CHAR_VALUE;
cmd.Parameters.Add("@DATE_VALUE", SqlDbType.DateTime).Value = sQLPLUS_PRODUCT_PROFILE.DATE_VALUE;
cmd.Parameters.Add("@LONG_VALUE", SqlDbType.Int).Value = sQLPLUS_PRODUCT_PROFILE.LONG_VALUE;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public SQLPLUS_PRODUCT_PROFILE GetSQLPLUS_PRODUCT_PROFILEFromReader(IDataReader reader)
{
try
{
SQLPLUS_PRODUCT_PROFILE sQLPLUS_PRODUCT_PROFILE = new SQLPLUS_PRODUCT_PROFILE
(
(int)reader["SQLPLUS_PRODUCT_PROFILEID"],
reader["PRODUCT"].ToString(),
(int)reader["USERID"],
reader["ATTRIBUTE"].ToString(),
reader["SCOPE"].ToString(),
(int)reader["NUMERIC_VALUE"],
reader["CHAR_VALUE"].ToString(),
(DateTime)reader["DATE_VALUE"],
(int)reader["LONG_VALUE"]
);
return(sQLPLUS_PRODUCT_PROFILE);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateSQLPLUS_PRODUCT_PROFILE(SQLPLUS_PRODUCT_PROFILE sQLPLUS_PRODUCT_PROFILE)
{
SqlSQLPLUS_PRODUCT_PROFILEProvider sqlSQLPLUS_PRODUCT_PROFILEProvider = new SqlSQLPLUS_PRODUCT_PROFILEProvider();
return(sqlSQLPLUS_PRODUCT_PROFILEProvider.UpdateSQLPLUS_PRODUCT_PROFILE(sQLPLUS_PRODUCT_PROFILE));
}
public static int InsertSQLPLUS_PRODUCT_PROFILE(SQLPLUS_PRODUCT_PROFILE sQLPLUS_PRODUCT_PROFILE)
{
SqlSQLPLUS_PRODUCT_PROFILEProvider sqlSQLPLUS_PRODUCT_PROFILEProvider = new SqlSQLPLUS_PRODUCT_PROFILEProvider();
return(sqlSQLPLUS_PRODUCT_PROFILEProvider.InsertSQLPLUS_PRODUCT_PROFILE(sQLPLUS_PRODUCT_PROFILE));
}
