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