public int Add(Photo entity)
{
try
{
int result = 0;
string strSQL = @"INSERT INTO tb_photo (ArticleID,BigImage,SmallImage) VALUES (@ArticleID,@BigImage,@SmallImage);";
DbCommand dbCommand = DB.DB.Db().GetSqlStringCommand(strSQL);
DB.DB.Db().AddInParameter(dbCommand, "@ArticleID", DbType.Int32, entity.ArticleID);
DB.DB.Db().AddInParameter(dbCommand, "@BigImage", DbType.String, entity.BigImage);
DB.DB.Db().AddInParameter(dbCommand, "@SmallImage", DbType.String, entity.SmallImage);
result = DB.DB.Db().ExecuteNonQuery(dbCommand);
return result;
}
catch (Exception ex)
{
Log.Log.logError(ex.Message);
throw;
}
}
private Photo FillEntity(DataRow dr)
{
Photo entity = new Photo()
{
ArticleID = DataTypeHelper.Convert<Int32>(dr["ArticleID"]),
BigImage = DataTypeHelper.Convert<String>(dr["BigImage"]),
SmallImage = DataTypeHelper.Convert<String>(dr["SmallImage"])
};
return entity;
}