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