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