public static int updateResponseFromNibbs(int refid, string responsecode, string responsetext) { MSQconn cn = new MSQconn(connstringICAD); string sysdate = DateTime.Now.ToString(); string sql = "update icadmain set updated_at=@sysdate ,status='1', responsecode=@respcode, responsetext=@responsedesc where refid=@refid"; cn.SetSQL(sql); cn.AddParam("@sysdate", sysdate); cn.AddParam("@respcode", responsecode); cn.AddParam("@responsedesc", responsetext); cn.AddParam("@refid", refid); int cnt = cn.Update(); return(cnt); }
public static int updateBulkResponseFromNibbs(string refidlist, string responsecode, string responsetext) { string inquerylist = "("; inquerylist += refidlist + "'' )"; MSQconn cn = new MSQconn(connstringICAD); string sysdate = DateTime.Now.ToString(); string sql = "update icadmain set updated_at=@sysdate ,status='1', responsecode=@respcode, responsetext=@responsedesc where refid IN " + "(" + @refidlist + " )"; cn.SetSQL(sql); cn.AddParam("@sysdate", sysdate); cn.AddParam("@respcode", responsecode); cn.AddParam("@responsedesc", responsetext); cn.AddParam("@refidlist", refidlist); Console.WriteLine("Response Text for " + inquerylist + " Response code:" + responsecode); int cnt = cn.Update(); return(cnt); }