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