public static int InsertNewResource(WebResource resource, int viewID)
{
using (SqlCommand textCommand = SqlHelper.GetTextCommand("\r\nINSERT INTO Resources (ViewID, ViewColumn, Position, ResourceName, ResourceFile, ResourceTitle, ResourceSubTitle)\r\nSELECT @viewID, @column, ISNULL(MAX(Position),0)+1, @resourceName, @resourceFile, @title, @subtitle\r\nFROM Resources where ViewID=@viewID and ViewColumn=@column\r\nSELECT SCOPE_IDENTITY()\r\n"))
{
textCommand.Parameters.AddWithValue(nameof(viewID), (object)viewID);
textCommand.Parameters.AddWithValue("column", (object)resource.get_Column());
textCommand.Parameters.AddWithValue("resourceName", (object)resource.get_Name());
textCommand.Parameters.AddWithValue("resourceFile", (object)resource.get_File());
textCommand.Parameters.AddWithValue("title", (object)resource.get_Title());
textCommand.Parameters.AddWithValue("subtitle", (object)resource.get_SubTitle());
return(Convert.ToInt32(SqlHelper.ExecuteScalar(textCommand)));
}
}
