I was playing with Google Gadgets a bit lately, and wanted to see what I could do with creating a gadget for Clarify / Amdocs / Dovetail.Gadgets are simple HTML and JavaScript applications that can be embedded in webpages and other apps.Google has good details on gadgets - how to use them, how to create them, etc.Here's what I came up with: What can we do with this gadget?Review my open cases:Review recent activity for your workgroup (in this case, the user belongs to the Administration workgroup):Work a case, including workflow (assign, dispatch, etc.) log phone notes, send email, review the case history, change status, close the case, etc. : Search the knowledgebase (solutions), cases, or both:access the knowledgebase (solutions):There's a few other things you can do as well, but you get the point. How is this done?In all honesty, it's actually…
In the Dovetail SDK, there is a very useful SqlHelper class. SqlHelper provides a convenience and data provider-agnostic wrapper around ADO.NET. This allows an application to execute SQL commands in a database. SqlHelper has various ways of being initialized, which all depend on a DbProvider instance to make a connection to the database. In most applications the DbProvider is separately instantiated based on configuration, so the examples here will not detail that process. SqlHelper can execute a variety of SQL commands. SQL SELECT statements are usually performed by the ExecuteDataSet method. The ExecuteNonQuery method can be used to perform other SQL commands such as UPDATE or DELETE statements. ExecuteScalar is used frequently to get a value returned from a SQL statement for use later in the application. public void SqlHelper_example() { var sqlCommand = "select title, id_number from table_subcase"; …
April 27, 2009
Update: I’ve modified this post as what were called DataMaps are now called ModelMaps. You can download the source from the Dovetail Bootstrap project. I want to introduce a handy library called ModelMap we created during the development of Dovetail Mobile. ModelMap makes it easy to populate model objects from a Clarify/Dovetail CRM database. It is a sort of one-way Clarify specific object relational mapper tool. Your CRM data to Objects It is very common to need a way to pull data out of your CRM for creation of a user interface. What if you could define a plain old C# object as your model and a map which defines how data in your Clarify database should populate that .Net model class? Does this sound better than hand rolling your own code every time? I hope it does. Let’s take…