public sSiteModels GetWebsiteModels(sRowsData sRowsData, string cuurip, string userAgent)
{
database database = new database();
DataTable mainRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@newid", sRowsData.newid.TrimEnd()));
mainRows = database.checkSelectSql("mssql", "sysstring", "exec web.searchformber @newid;", dbparamlist);
switch (mainRows.Rows.Count)
{
case 0:
return(new sSiteModels()
{
status = "nodata"
});
}
string filePath = $"{database.connectionString("sysFiles")}{mainRows.Rows[0]["formId"].ToString().TrimEnd()}\\";
Directory.CreateDirectory(filePath);
datetime datetime = new datetime();
string stdate = datetime.sqldate("mssql", "sysstring"), sttime = datetime.sqltime("mssql", "sysstring"), cuname = Dns.GetHostEntry(cuurip).HostName.IndexOf('.') == -1 ? Dns.GetHostEntry(cuurip).HostName : Dns.GetHostEntry(cuurip).HostName.Split('.')[0], original = "", encryption = new sha256().new256("mssql", "sysstring"), extension = ".jpg";
new WebClient().DownloadFile(sRowsData.value.TrimEnd(), $"{filePath}{original}({encryption}){extension}");
dbparamlist.Clear();
dbparamlist.Add(new dbparam("@formId", mainRows.Rows[0]["formId"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@siteId", 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("@inoper", sRowsData.newid.TrimEnd()));
if (database.checkActiveSql("mssql", "sysstring", "exec web.insertwebsiteform @formId,@siteId,@website,@externip,@hostname,@browser,@stdate,@sttime,@inoper;", dbparamlist) != "istrue")
{
return(new sSiteModels()
{
status = "error"
});
}
switch (File.Exists($"{filePath}{original}({encryption}){extension}"))
{
case false:
return(new sSiteModels()
{
status = "nodata"
});
}
return(new sSiteModels()
{
images = true, videos = false, audios = false, src = $"{original}({encryption}){extension}", imagePath = $"{database.connectionString("sysHttps")}{mainRows.Rows[0]["formId"].ToString().TrimEnd()}/", original = original, encryption = encryption, extension = extension, status = "istrue"
});
}
public statusModels GetDownloadModels(sRowsData sRowsData, string cuurip, string userAgent)
{
database database = new database();
DataTable mainRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@newid", sRowsData.newid.TrimEnd()));
mainRows = database.checkSelectSql("mssql", "sysstring", "exec web.searchformber @newid;", dbparamlist);
switch (mainRows.Rows.Count)
{
case 0:
return(new statusModels()
{
status = "nodata"
});
}
datetime datetime = new datetime();
string stdate = datetime.sqldate("mssql", "sysstring"), sttime = datetime.sqltime("mssql", "sysstring");
switch (File.Exists($"{database.connectionString("sysFiles")}{mainRows.Rows[0]["formId"].ToString().TrimEnd()}\\{sRowsData.value.TrimEnd()}"))
{
case false:
return(new statusModels()
{
status = "nodata"
});
}
string cuname = Dns.GetHostEntry(cuurip).HostName.IndexOf('.') == -1 ? Dns.GetHostEntry(cuurip).HostName : Dns.GetHostEntry(cuurip).HostName.Split('.')[0];
dbparamlist.Clear();
dbparamlist.Add(new dbparam("@formId", mainRows.Rows[0]["formId"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@fileId", 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("@inoper", sRowsData.newid.TrimEnd()));
if (database.checkActiveSql("mssql", "sysstring", "exec web.insertdownloadform @formId,@fileId,@files,@externip,@hostname,@browser,@stdate,@sttime,@inoper;", dbparamlist) != "istrue")
{
return(new statusModels()
{
status = "error"
});
}
return(new statusModels()
{
status = "istrue"
});
}
