public static BLOBTABLE GetBLOBTABLEByID(int id) { BLOBTABLE bLOBTABLE = new BLOBTABLE(); SqlBLOBTABLEProvider sqlBLOBTABLEProvider = new SqlBLOBTABLEProvider(); bLOBTABLE = sqlBLOBTABLEProvider.GetBLOBTABLEByID(id); return(bLOBTABLE); }
public int InsertBLOBTABLE(BLOBTABLE bLOBTABLE) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_InsertBLOBTABLE", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BLOBTABLEID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@T", SqlDbType.VarChar).Value = bLOBTABLE.T; connection.Open(); int result = cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@BLOBTABLEID"].Value); } }
public bool UpdateBLOBTABLE(BLOBTABLE bLOBTABLE) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateBLOBTABLE", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BLOBTABLEID", SqlDbType.Int).Value = bLOBTABLE.BLOBTABLEID; cmd.Parameters.Add("@T", SqlDbType.VarChar).Value = bLOBTABLE.T; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public BLOBTABLE GetBLOBTABLEFromReader(IDataReader reader) { try { BLOBTABLE bLOBTABLE = new BLOBTABLE ( (int)reader["BLOBTABLEID"], reader["T"].ToString() ); return(bLOBTABLE); } catch (Exception ex) { return(null); } }
public static bool UpdateBLOBTABLE(BLOBTABLE bLOBTABLE) { SqlBLOBTABLEProvider sqlBLOBTABLEProvider = new SqlBLOBTABLEProvider(); return(sqlBLOBTABLEProvider.UpdateBLOBTABLE(bLOBTABLE)); }
public static int InsertBLOBTABLE(BLOBTABLE bLOBTABLE) { SqlBLOBTABLEProvider sqlBLOBTABLEProvider = new SqlBLOBTABLEProvider(); return(sqlBLOBTABLEProvider.InsertBLOBTABLE(bLOBTABLE)); }