public sTypeModels GetSTypeModels(sRowsData sRowsData, string cuurip)
{
database database = new database();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@formId", sRowsData.formId.TrimEnd()));
dbparamlist.Add(new dbparam("@inoper", sRowsData.newid.TrimEnd()));
switch (database.checkSelectSql("mssql", "flyformstring", "exec web.searchclimainform @formId,@inoper;", dbparamlist).Rows.Count)
{
case 0:
return(new sTypeModels()
{
status = "nodata"
});
}
dbparamlist.Add(new dbparam("@value", sRowsData.value.TrimEnd()));
List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); string value = "";
foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchoperationform @value;", dbparamlist).Rows)
{
value = dr["operationValue"].ToString().TrimEnd();
items.Add(new Dictionary <string, object>()
{
{ "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["operationValue"].ToString().TrimEnd() }
});
}
return(new sTypeModels()
{
value = value, items = items, status = "istrue"
});
}
public sSiteModels GetWebsiteModels(sRowsData sRowsData, string cuurip, string userAgent)
{
database database = new database();
datetime datetime = new datetime();
string stdate = datetime.sqldate("mssql", "flyformstring"), sttime = datetime.sqltime("mssql", "flyformstring"), original = "", encryption = new sha256().new256("mssql", "flyformstring"), extension = ".jpg";
new WebClient().DownloadFile(sRowsData.value.TrimEnd(), $"{database.connectionString("formFiles")}{original}({encryption}){extension}");
List <dbparam> dbparamlist = new List <dbparam>();
string date = datetime.sqldate("mssql", "flyformstring"), time = datetime.sqltime("mssql", "flyformstring"), cuname = Dns.GetHostEntry(cuurip).HostName.IndexOf('.') == -1 ? Dns.GetHostEntry(cuurip).HostName : Dns.GetHostEntry(cuurip).HostName.Split('.')[0];
dbparamlist.Add(new dbparam("@formId", sRowsData.formId.TrimEnd()));
dbparamlist.Add(new dbparam("@website", sRowsData.value.TrimEnd()));
dbparamlist.Add(new dbparam("@externip", cuurip));
dbparamlist.Add(new dbparam("@hostname", cuname));
dbparamlist.Add(new dbparam("@browser", new information().browser(userAgent)));
dbparamlist.Add(new dbparam("@stdate", stdate));
dbparamlist.Add(new dbparam("@sttime", sttime));
dbparamlist.Add(new dbparam("@eddate", date));
dbparamlist.Add(new dbparam("@edtime", time));
dbparamlist.Add(new dbparam("@indate", date));
dbparamlist.Add(new dbparam("@intime", time));
dbparamlist.Add(new dbparam("@inoper", sRowsData.newid.TrimEnd()));
if (database.checkActiveSql("mssql", "flyformstring", "insert into web.websitelog (formId,website,externip,hostname,browser,stdate,sttime,eddate,edtime,indate,intime,inoper) values (@formId,@website,@externip,@hostname,@browser,@stdate,@sttime,@eddate,@edtime,@indate,@intime,@inoper);", dbparamlist) != "istrue")
{
return(new sSiteModels()
{
status = "error"
});
}
switch (File.Exists($"{database.connectionString("formFiles")}{original}({encryption}){extension}"))
{
case false:
return(new sSiteModels()
{
status = "nodata"
});
}
return(new sSiteModels()
{
images = true, videos = false, audios = false, src = $"{original}({encryption}){extension}", imagePath = "http://221.222.222.16:4500/bugimage/", original = original, encryption = encryption, extension = extension, status = "istrue"
});
}
public statusModels GetDownloadModels(sRowsData sRowsData, string cuurip, string userAgent)
{
database database = new database();
datetime datetime = new datetime();
string stdate = datetime.sqldate("mssql", "flyformstring"), sttime = datetime.sqltime("mssql", "flyformstring");
switch (File.Exists(database.connectionString("formFiles") + sRowsData.value.TrimEnd()))
{
case false:
return(new statusModels()
{
status = "nodata"
});
}
string date = datetime.sqldate("mssql", "flyformstring"), time = datetime.sqltime("mssql", "flyformstring"), cuname = Dns.GetHostEntry(cuurip).HostName.IndexOf('.') == -1 ? Dns.GetHostEntry(cuurip).HostName : Dns.GetHostEntry(cuurip).HostName.Split('.')[0];
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@formId", sRowsData.formId.TrimEnd()));
dbparamlist.Add(new dbparam("@files", sRowsData.value.TrimEnd()));
dbparamlist.Add(new dbparam("@externip", cuurip));
dbparamlist.Add(new dbparam("@hostname", cuname));
dbparamlist.Add(new dbparam("@browser", new information().browser(userAgent)));
dbparamlist.Add(new dbparam("@stdate", stdate));
dbparamlist.Add(new dbparam("@sttime", sttime));
dbparamlist.Add(new dbparam("@eddate", date));
dbparamlist.Add(new dbparam("@edtime", time));
dbparamlist.Add(new dbparam("@indate", date));
dbparamlist.Add(new dbparam("@intime", time));
dbparamlist.Add(new dbparam("@inoper", sRowsData.newid.TrimEnd()));
if (database.checkActiveSql("mssql", "flyformstring", "insert into web.downloadlog (formId,files,externip,hostname,browser,stdate,sttime,eddate,edtime,indate,intime,inoper) values (@formId,@files,@externip,@hostname,@browser,@stdate,@sttime,@eddate,@edtime,@indate,@intime,@inoper);", dbparamlist) != "istrue")
{
return(new statusModels()
{
status = "error"
});
}
return(new statusModels()
{
status = "istrue"
});
}
public sOptonModels GetSoperModels(sRowsData sRowsData, string cuurip)
{
database database = new database();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@department", sRowsData.value.TrimEnd()));
List <Dictionary <string, object> > items = new List <Dictionary <string, object> >();
foreach (DataRow dr in database.checkSelectSql("mssql", "epaperstring", "exec web.searchdertoper @department;", dbparamlist).Rows)
{
dbparamlist.Clear();
dbparamlist.Add(new dbparam("@formId", sRowsData.formId.TrimEnd()));
dbparamlist.Add(new dbparam("@inoper", sRowsData.newid.TrimEnd()));
dbparamlist.Add(new dbparam("@newid", dr["newid"].ToString().TrimEnd()));
items.Add(new Dictionary <string, object>()
{
{ "newid", dr["newid"].ToString().TrimEnd() }, { "userid", dr["userid"].ToString().TrimEnd() }, { "name", dr["username"].ToString().TrimEnd() }, { "showOper", database.checkSelectSql("mssql", "flyformstring", "exec web.searchoperform @formId,@inoper,@newid;", dbparamlist).Rows.Count > 0 }
});
}
return(new sOptonModels()
{
items = items
});
}
public sVeriModels GetSVeriModels(sRowsData sRowsData, string cuurip)
{
database database = new database();
DataTable mainRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@formId", sRowsData.formId.TrimEnd()));
dbparamlist.Add(new dbparam("@iid", sRowsData.value.TrimEnd()));
dbparamlist.Add(new dbparam("@inoper", sRowsData.newid.TrimEnd()));
mainRows = database.checkSelectSql("mssql", "flyformstring", "exec web.searchclisubdeta @formId,@iid,@inoper;", dbparamlist);
List <Dictionary <string, object> > typeitems = new List <Dictionary <string, object> >(), operationitems = new List <Dictionary <string, object> >();
switch (mainRows.Rows.Count)
{
case 0:
string type_ = "";
foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchtypeform;", dbparamlist).Rows)
{
type_ = dr["value"].ToString().TrimEnd();
typeitems.Add(new Dictionary <string, object>()
{
{ "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["value"].ToString().TrimEnd() }
});
}
string operation = "";
dbparamlist.Add(new dbparam("@value", type_));
foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchoperationform @value;", dbparamlist).Rows)
{
operation = dr["operationValue"].ToString().TrimEnd();
operationitems.Add(new Dictionary <string, object>()
{
{ "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["operationValue"].ToString().TrimEnd() }
});
}
return(new sVeriModels()
{
type_ = type_, typeitems = typeitems, operation = operation, operationitems = operationitems, status = "istrue"
});
}
switch (mainRows.Rows[0]["verified"].ToString().TrimEnd())
{
case "0":
return(new sVeriModels()
{
status = "nodata"
});
}
dbparamlist.Clear();
foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchtypeform;", dbparamlist).Rows)
{
typeitems.Add(new Dictionary <string, object>()
{
{ "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["value"].ToString().TrimEnd() }
});
}
dbparamlist.Add(new dbparam("@value", mainRows.Rows[0]["type"].ToString().TrimEnd()));
foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchoperationform @value;", dbparamlist).Rows)
{
operationitems.Add(new Dictionary <string, object>()
{
{ "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["operationValue"].ToString().TrimEnd() }
});
}
return(new sVeriModels()
{
type_ = mainRows.Rows[0]["type"].ToString().TrimEnd(), typeitems = typeitems, operation = mainRows.Rows[0]["operation"].ToString().TrimEnd(), operationitems = operationitems, status = "istrue"
});
}
