public DataTable WS_Country()
{
string strCountry = "Select COUNTRY_ID,COUNTRY_NAME From DPS_MT_COUNTRY";
AccessWs ws = new AccessWs();
dt = ws.GetDataTable(strCountry);
return(dt);
}
public void insertLOG(int?WS_APP_ID, string sql, int WS_SERVICES_ID)
{
AccessWs ws = new AccessWs();
DataTable dt = new DataTable();
string str = "Select * From WS_APP_INFORMATION Where WS_APP_ID = " + WS_APP_ID;
dt = ws.GetDataTableService(str);
if (dt.Rows.Count > 0)
{
string ins = "insert into WS_TRANSACTION_LOG(WS_APP_ID,WS_CREATE_DATE,WS_USER_NAME,WS_SERVICES_ID,WS_SQL) VALUES(" + dt.Rows[0]["WS_APP_ID"].ToString() + ",GETDATE(),'" + dt.Rows[0]["WS_APP_NAME"].ToString() + "'," + WS_SERVICES_ID + ",'" + sql + "')";
ws.fn_ExecNonQuery(ins);
}
}