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