public ActionResult getcntinfo(string inn)
{
dadataINN di = new dadataINN();
string responseText = di.getjson(inn);
return(File(Encoding.UTF8.GetBytes(responseText), "application/json"));
}
private void sendtele(Guid fc_pk)
{
try
{
string cnstr = Program.AppConfig["mscns"];
string sql = "uKnow..p_createTelegram";
string sqlerr = "insert into uKnow..AM_telegramLog(fc_pk, servmessage) values (@fc_pk, @servmessage)";
SqlDataAdapter da = new SqlDataAdapter(sql, cnstr);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@FC_PK", fc_pk);
da.SelectCommand.CommandTimeout = 0;
DataTable res = new DataTable();
da.Fill(res);
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
SqlCommand cmd = new SqlCommand(sqlerr, cn);
dadataINN di = new dadataINN();
foreach (DataRow rw in res.Rows)
{
string channelID = rw["channelID"].ToString();
string UserToken = rw["UserToken"].ToString();
string content = rw["MG_text"].ToString();
Guid PK = (Guid)rw["FC_PK"];
string err = di.sendtele(channelID, UserToken, content);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@fc_pk", PK);
cmd.Parameters.AddWithValue("@servmessage", err);
cmd.ExecuteNonQuery();
}
cn.Close();
}
catch
{; }
}
private void Dadataupdate()
{
string cnstr = Program.AppConfig["mscns"];
string sql0 = "select * from v_not_cntdadata";
SqlDataAdapter da = new SqlDataAdapter(sql0, cnstr);
DataTable resTab = new DataTable();
da.Fill(resTab);
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
try
{
string sql = "insert into cntdadata (contractor_id, ls_inn, ls_status, ls_actuality_date, ls_type, ls_full_with_opf, ls_short_with_opf, ls_load_status) " +
" values (@ls_ld, @ls_inn, @ls_status, @ls_actuality_date, @ls_type, @ls_full_with_opf, @ls_short_with_opf, @ls_load_status) ";
SqlCommand cmd = new SqlCommand(sql, cn);
dadataINN di = new dadataINN();
for (int i = 0; i < resTab.Rows.Count; i++)
{
if (!Program.FlagDadataUpdate)
{
break;
}
string inn = resTab.Rows[i]["contractor_inn"].ToString().Trim();
string ls_load_status = "";
PartyData pdata = null;
try
{
pdata = di.exec(inn);
if (pdata == null)
{
ls_load_status = "Не найдено";
}
}
catch (Exception ee)
{
ls_load_status = ee.Message;
}
string ls_status = "";
string ls_actuality_date = "";
string ls_type = "";
string ls_full_with_opf = "";
string ls_short_with_opf = "";
if (pdata != null)
{
ls_status = pdata.state.status.ToString();
if (pdata.state.actuality_date_fmt != null)
{
ls_actuality_date = pdata.state.actuality_date_fmt;
}
ls_type = pdata.type.ToString();
if (pdata.name.full_with_opf != null)
{
ls_full_with_opf = pdata.name.full_with_opf;
}
if (pdata.name.short_with_opf != null)
{
ls_short_with_opf = pdata.name.short_with_opf;
}
}
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ls_ld", resTab.Rows[i]["contractor_id"]);
cmd.Parameters.AddWithValue("@ls_inn", inn);
cmd.Parameters.AddWithValue("@ls_status", ls_status);
cmd.Parameters.AddWithValue("@ls_actuality_date", ls_actuality_date);
cmd.Parameters.AddWithValue("@ls_type", ls_type);
cmd.Parameters.AddWithValue("@ls_full_with_opf", ls_full_with_opf);
cmd.Parameters.AddWithValue("@ls_short_with_opf", ls_short_with_opf);
cmd.Parameters.AddWithValue("@ls_load_status", ls_load_status);
cmd.ExecuteNonQuery();
Thread.Sleep(2000);
}
Program.FlagDadataUpdate = false;
cn.Close();
}
catch
{
Program.FlagDadataUpdate = false;
cn.Close();
}
}
private void Dadataload(int ld_pk, string restxt)
{
string cnstr = Program.AppConfig["mscns"];
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
string sqlerr = "update cntload set ld_status = @ld_status, stopdate = getdate() where ld_pk = @ld_pk";
SqlCommand cmderr = new SqlCommand(sqlerr, cn);
try
{
string sql = "insert into cntload_detail (ls_ld, ls_inn, ls_status, ls_actuality_date, ls_type, ls_full_with_opf, ls_short_with_opf, ls_load_status) " +
" values (@ls_ld, @ls_inn, @ls_status, @ls_actuality_date, @ls_type, @ls_full_with_opf, @ls_short_with_opf, @ls_load_status) ";
SqlCommand cmd = new SqlCommand(sql, cn);
dadataINN di = new dadataINN();
string[] inns = restxt.Split("\n", StringSplitOptions.None);
for (int i = 1; i < inns.Length; i++)
{
string inn = inns[i].Trim();
string ls_load_status = "";
PartyData pdata = null;
try
{
pdata = di.exec(inn);
if (pdata == null)
{
ls_load_status = "Не найдено";
}
}
catch (Exception ee)
{
ls_load_status = ee.Message;
}
string ls_status = "";
string ls_actuality_date = "";
string ls_type = "";
string ls_full_with_opf = "";
string ls_short_with_opf = "";
if (pdata != null)
{
ls_status = pdata.state.status.ToString();
if (pdata.state.actuality_date_fmt != null)
{
ls_actuality_date = pdata.state.actuality_date_fmt;
}
ls_type = pdata.type.ToString();
if (pdata.name.full_with_opf != null)
{
ls_full_with_opf = pdata.name.full_with_opf;
}
if (pdata.name.short_with_opf != null)
{
ls_short_with_opf = pdata.name.short_with_opf;
}
}
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ls_ld", ld_pk);
cmd.Parameters.AddWithValue("@ls_inn", inn + "/");
cmd.Parameters.AddWithValue("@ls_status", ls_status);
cmd.Parameters.AddWithValue("@ls_actuality_date", ls_actuality_date);
cmd.Parameters.AddWithValue("@ls_type", ls_type);
cmd.Parameters.AddWithValue("@ls_full_with_opf", ls_full_with_opf);
cmd.Parameters.AddWithValue("@ls_short_with_opf", ls_short_with_opf);
cmd.Parameters.AddWithValue("@ls_load_status", ls_load_status);
cmd.ExecuteNonQuery();
//Thread.Sleep(1050);
}
cmderr.Parameters.AddWithValue("ld_pk", ld_pk);
cmderr.Parameters.AddWithValue("ld_status", "OK");
cmderr.ExecuteNonQuery();
cn.Close();
}
catch (Exception ex)
{
cmderr.Parameters.AddWithValue("ld_pk", ld_pk);
cmderr.Parameters.AddWithValue("ld_status", ex.Message);
cmderr.ExecuteNonQuery();
cn.Close();
}
}
public string test(string channelID, string UserToken, string content)
{
dadataINN di = new dadataINN();
return(di.sendtele(channelID, UserToken, content));
}
