public void hashtestSHA2()
{
string[] list = { "ca978112ca1bbdcafac231b39a23dc4da786eff8147c4e72b9807785afee48bb" };
IHashFunction hashfunction = new sha256();
Assert.IsTrue(hashfunction.hash("a").Equals(list[0]));
}
private string CreateHash()
{
using (var hash = new sha256())
{
var srcString = new StringBuilder();
foreach (var pair in _inlineContents.OrderBy(x => x.Key))
{
srcString.Append(pair.Key).Append(':').Append(pair.Value.Length).Append(':');
}
return(hash.Compute(srcString.ToString()));
}
}
public sSiteModels GetTransferModels(sFileData sFileData, string cuurip)
{
database database = new database();
string foldPath = new database().connectionString("folderFiles"), encryption = new sha256().new256("mssql", "flyfnstring"), extension = "pdf";
switch (File.Exists($"{foldPath}{sFileData.original.TrimEnd()}({sFileData.encryption.TrimEnd()}){sFileData.extension.TrimEnd()}"))
{
case false:
return(new sSiteModels()
{
status = "nodata"
});
}
DataTable mainRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@value", extension));
dbparamlist.Add(new dbparam("@needed", "1"));
mainRows = database.checkSelectSql("mssql", "flyfnstring", "exec web.uploadfileform @value,@needed;", dbparamlist);
switch (mainRows.Rows.Count)
{
case 0:
return(new sSiteModels()
{
status = "nodata"
});
}
if (mainRows.Rows[0]["flImages"].ToString().TrimEnd() == "0" && mainRows.Rows[0]["flVideos"].ToString().TrimEnd() == "0" && mainRows.Rows[0]["flAudios"].ToString().TrimEnd() == "0")
{
return(new sSiteModels()
{
status = "nodata"
});
}
switch (transFileToPDF(sFileData.extension.TrimEnd(), $"{foldPath}{sFileData.original.TrimEnd()}({sFileData.encryption.TrimEnd()}){sFileData.extension.TrimEnd()}", $"{foldPath}{sFileData.original.TrimEnd()}({encryption}).{extension}"))
{
case false:
return(new sSiteModels()
{
status = "nodata"
});
}
return(new sSiteModels()
{
images = mainRows.Rows[0]["flImages"].ToString().TrimEnd() == "1", videos = mainRows.Rows[0]["flVideos"].ToString().TrimEnd() == "1", audios = mainRows.Rows[0]["flAudios"].ToString().TrimEnd() == "1", src = mainRows.Rows[0]["flImages"].ToString().TrimEnd() == "1" && mainRows.Rows[0]["flShowed"].ToString().TrimEnd() == "0" ? $"{mainRows.Rows[0]["original"].ToString().TrimEnd()}({mainRows.Rows[0]["encryption"].ToString().TrimEnd()}){mainRows.Rows[0]["extension"].ToString().TrimEnd()}" : $"{sFileData.original.TrimEnd()}({encryption}).{extension}", imagePath = "http://221.222.222.16:4500/folderfile/", original = sFileData.original.TrimEnd(), encryption = encryption, extension = $".{extension}", date = new datetime().sqldate("mssql", "flyfnstring"), status = "istrue"
});
}
public JsonResult reviewData([FromBody] dFormData dFormData)
{
//string clientip = Request.HttpContext.Connection.RemoteIpAddress.ToString().TrimEnd() == "::1" ? "127.0.0.1" : Request.HttpContext.Connection.RemoteIpAddress.ToString().TrimEnd();
database database = new database();
DataTable mainRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@id", dFormData.formId.TrimEnd()));
mainRows = database.checkSelectSql("mssql", "flyfnstring", "exec web.searchreportdeta @id;", dbparamlist);
switch (mainRows.Rows.Count)
{
case 0:
return(Json(new sDataModels()
{
status = "nodata"
}));
}
sha256 sha256 = new sha256();
string folder = sha256.new256("mssql", "flyfnstring"), name = sha256.new256("mssql", "flyfnstring");
dbparamlist.Add(new dbparam("@inoper", dFormData.newid.TrimEnd()));
dbparamlist.Add(new dbparam("@folder", folder));
dbparamlist.Add(new dbparam("@name", name));
if (database.checkActiveSql("mssql", "flyfnstring", "exec web.insertreviewlog @id,@inoper,@folder,@name;", dbparamlist) != "istrue")
{
return(Json(new sDataModels()
{
status = "error"
}));
}
string folderFile = $"{new database().connectionString("folderFiles")}\\html\\{folder}\\", htmlFile = $"{name}.html";
Directory.CreateDirectory(folderFile);
using (var fileStream = new FileStream($"{folderFile}{htmlFile}", FileMode.Create))
{
using (StreamWriter streamWriter = new StreamWriter(fileStream, Encoding.UTF8))
{
streamWriter.WriteLine($"{reviewHtmlHead()}<body><div style='margin:0 auto;' class='outside'><div class='together tile'><h1>編輯 品異單/5C Report</h1></div><div class='together subtile'><h3>【Characterize】問題描述</h3></div><div class='together subfield'><div class='datefield inlineDiv'><h4>提出日期</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["postdate"].ToString().TrimEnd())}</div></div><div class='departfield inlineDiv'><h4>提出部門 / 提出者</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["post_group"].ToString().TrimEnd())} / {reviewHtmlBody(mainRows.Rows[0]["postname"].ToString().TrimEnd())}</div></div><div class='floorfield inlineDiv'><h4>生產樓層</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["floor"].ToString().TrimEnd())}</div></div><div class='numfield inlineDiv'><h4>文件編號</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["number"].ToString().TrimEnd())}-{reviewHtmlBody(mainRows.Rows[0]["version"].ToString().TrimEnd())}</div></div></div><div class='together subfield'><div class='datefield inlineDiv'><h4>客戶 / 廠商</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["homepage1"].ToString().TrimEnd())}</div></div><div class='departfield inlineDiv'><div style='width:160px;' class='inlineDiv'><h4>產品規格單/總數量</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["pnumber"].ToString().TrimEnd())}</div></div><div class='inlineDiv'><h4>機種</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["homepage_momo"].ToString().TrimEnd())}</div></div></div><div class='floorfield inlineDiv'><h4>M/B</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["mb"].ToString().TrimEnd())}</div></div><div class='numfield inlineDiv'><h4>品異來源</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["obj"].ToString().TrimEnd())}</div></div></div><div class='together subfield'><div class='datefield inlineDiv'><h4>來源單號/工單</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["worknumber"].ToString().TrimEnd())}</div></div><div class='departfield inlineDiv'><div style='width:160px;' class='inlineDiv'><h4>不良料號</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["pn"].ToString().TrimEnd())}</div></div><div class='inlineDiv'><h4>生產/檢驗數量</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["amount"].ToString().TrimEnd())}</div></div></div><div class='floorfield inlineDiv'><h4>不良數量</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["fail"].ToString().TrimEnd())}</div></div><div class='numfield inlineDiv'><h4>不良率</h4><div class='subcontent'>100%</div></div></div><div class='together differfield'><div class='datefield inlineDiv'><h4>異常內容</h4></div><div class='inlineDiv'><div>{reviewHtmlBody(mainRows.Rows[0]["subject"].ToString().TrimEnd())}</div></div></div><div class='linefield'><hr /></div><div style='height:300px;padding:1px;' class='together'><div style='width:465px;float:left;' class='inlineDiv'><div class='together subtile'><h3>【Containment】緊急處置</h3></div><div style='height:116px;padding:1px 6px;'>{reviewHtmlBody(mainRows.Rows[0]["containment"].ToString().TrimEnd())}</div><div class='together subtile'><h3>【Cause】真因調查</h3></div><div style='height:116px;padding:1px 6px;'>{reviewHtmlBody(mainRows.Rows[0]["cause"].ToString().TrimEnd())}</div></div><div style='width:384px;' class='inlineDiv'><div class='together subtile'><h3>【Image】顯示圖</h3></div><div style='padding:0px 12px;'>image<!--image information--></div></div></div><div class='together subfield'><div class='datefield inlineDiv'><h4>處理人(中文全名)</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["replier"].ToString().TrimEnd())}</div></div><div class='departfield inlineDiv'><h4>原因分類</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["issuesort"].ToString().TrimEnd())} {reviewHtmlBody(mainRows.Rows[0]["causeclass"].ToString().TrimEnd())}</div></div><div class='floorfield inlineDiv'><h4>直接損耗工時</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["direct_pt"].ToString().TrimEnd())} mins</div></div><div class='numfield inlineDiv'><h4>間接損耗工時</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["indirect_pt"].ToString().TrimEnd())} mins</div></div></div><div class='linefield'><hr /></div><div class='together subtile'><h3>【Corrective Action】改善對策</h3></div><div style='height:134px;padding:1px 6px;' class='together'><h4>Short Term：</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["correctiveaction1"].ToString().TrimEnd())}</div></div><div style='height:134px;padding:1px 6px;' class='together'><h4>Long Term：</h4><div class='subcontent'>{reviewHtmlBody(mainRows.Rows[0]["correctiveaction2"].ToString().TrimEnd())}</div></div><div class='linefield'><hr /></div><div class='together subtile'><h3>【Closure】成效驗證</h3></div><div style='height:125px;padding:1px 12px;' class='together'><div style='width:453px;float:left;' class='inlineDiv'>{reviewHtmlBody(mainRows.Rows[0]["closure"].ToString().TrimEnd())}</div><div style='width:372px;' class='inlineDiv'>{reviewHtmlBody(mainRows.Rows[0]["body"].ToString().TrimEnd())}</div></div><div style='height:26px;padding:0px 12px;' class='together'><div style='width:277px;' class='inlineDiv'><div class='inlineDiv'>責任單位/人員：</div><div class='inlineDiv'>{reviewHtmlBody(mainRows.Rows[0]["belong"].ToString().TrimEnd())}/{reviewHtmlBody(mainRows.Rows[0]["belonger"].ToString().TrimEnd())} (中文全名)</div></div><div style='width:277px;' class='inlineDiv'><div class='inlineDiv'>處理狀態：</div><div class='inlineDiv'>{reviewHtmlBody(mainRows.Rows[0]["stage"].ToString().TrimEnd())}</div></div><div style='width:277px;' class='inlineDiv'><div class='inlineDiv'>結案日期：</div><div class='inlineDiv'>{reviewHtmlBody(mainRows.Rows[0]["releasedate"].ToString().TrimEnd())}</div></div></div></div></body>{reviewHtmlFoot()}");
}
}
return(Json(new sDataModels()
{
value = $"http://221.222.222.16:4500/folderFile/html/{folder}/{htmlFile}", status = "istrue"
}));
}
public void Save()
{
if (File.Exists(FilePath))
{
File.Delete(FilePath);
}
using (var hash = new sha256())
Id = CreateHash();
using (var fs = new FileStream(FilePath, FileMode.Create, FileAccess.Write))
{
var contents = _inlineContents.ToDictionary(x => x.Key, v => new MemoryStream(v.Value) as Stream);
var id = Ziplib.Instance.Zip(Encoding.UTF8.GetBytes(Id)).AsSpan();
var idSize = BitConverter.GetBytes(id.Length);
fs.Write(idSize, 0, 4);
fs.Write(id);
AlibCompressor.Instance.Compress(contents, fs, Id);
}
}
public async Task <JsonResult> uploadData()
{
if (Request.Form.Files.Count > 0)
{
string original = Request.Form.Files[0].FileName.Substring(0, Request.Form.Files[0].FileName.LastIndexOf('.')), encryption = new sha256().new256("mssql", "flyfnstring"), extension = Path.GetExtension(Request.Form.Files[0].FileName);
database database = new database();
DataTable mainRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@value", extension.Replace(".", "").Trim().ToLower()));
dbparamlist.Add(new dbparam("@needed", "1"));
mainRows = database.checkSelectSql("mssql", "flyfnstring", "exec web.uploadfileform @value,@needed;", dbparamlist);
switch (mainRows.Rows.Count)
{
case 0:
return(Json(new sSiteModels()
{
status = "nodata"
}));
}
if (mainRows.Rows[0]["flImages"].ToString().TrimEnd() == "0" && mainRows.Rows[0]["flVideos"].ToString().TrimEnd() == "0" && mainRows.Rows[0]["flAudios"].ToString().TrimEnd() == "0")
{
return(Json(new sSiteModels()
{
status = "nodata"
}));
}
using (var fileStream = new FileStream($"{database.connectionString("formFiles")}{original}({encryption}){extension}", FileMode.Create))
{
await Request.Form.Files[0].CopyToAsync(fileStream);
return(Json(new sSiteModels()
{
images = mainRows.Rows[0]["flImages"].ToString().TrimEnd() == "1", videos = mainRows.Rows[0]["flVideos"].ToString().TrimEnd() == "1", audios = mainRows.Rows[0]["flAudios"].ToString().TrimEnd() == "1", src = mainRows.Rows[0]["flImages"].ToString().TrimEnd() == "1" && mainRows.Rows[0]["flShowed"].ToString().TrimEnd() == "0" ? $"{mainRows.Rows[0]["original"].ToString().TrimEnd()}({mainRows.Rows[0]["encryption"].ToString().TrimEnd()}){mainRows.Rows[0]["extension"].ToString().TrimEnd()}" : $"{original}({encryption}){extension}", imagePath = "http://221.222.222.16:4500/folderfile/", original = original, encryption = encryption, extension = extension, date = new datetime().sqldate("mssql", "flyfnstring"), status = "istrue"
}));
}
}
return(Json(new sSiteModels()
{
status = "nodata"
}));
}
public statusModels GetInsertModels(iFormsData iFormsData, string cuurip)
{
database database = new database();
datetime datetime = new datetime();
string formId = new sha256().new256("mssql", "flyformstring"), date = datetime.sqldate("mssql", "flyformstring"), time = datetime.sqltime("mssql", "flyformstring");
foreach (var item in iFormsData.items)
{
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@formId", formId));
dbparamlist.Add(new dbparam("@iid", item["iid"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@inoper", iFormsData.newid.TrimEnd()));
dbparamlist.Add(new dbparam("@tile", item["title"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@outValue", item["outValue"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@verified", bool.Parse(item["showVeri"].ToString().TrimEnd()) ? "1" : "0"));
dbparamlist.Add(new dbparam("@type", item["type_"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@operation", item["operation"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@area", item["area"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@eror", item["eror"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@checked", bool.Parse(item["showCheck"].ToString().TrimEnd()) ? "1" : "0"));
dbparamlist.Add(new dbparam("@indate", date));
dbparamlist.Add(new dbparam("@intime", time));
if (database.checkActiveSql("mssql", "flyformstring", "insert into web.subform (formId,iid,inoper,tile,outValue,verified,type,operation,area,eror,checked,indate,intime) values (@formId,@iid,@inoper,@tile,@outValue,@verified,@type,@operation,@area,@eror,@checked,@indate,@intime);", dbparamlist) != "istrue")
{
return(new statusModels()
{
status = "error"
});
}
switch (item["outValue"].ToString().TrimEnd())
{
case "radio":
case "checkbox":
case "droplist":
foreach (var answeritem in JsonSerializer.Deserialize <List <Dictionary <string, object> > >(item["answeritems"].ToString().TrimEnd()))
{
switch (bool.Parse(answeritem["ansrDelete"].ToString().TrimEnd()))
{
case false:
dbparamlist.Clear();
dbparamlist.Add(new dbparam("@formId", formId));
dbparamlist.Add(new dbparam("@iid", item["iid"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@id", answeritem["id"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@inoper", iFormsData.newid.TrimEnd()));
dbparamlist.Add(new dbparam("@value", answeritem["value"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@answer", bool.Parse(answeritem["showAnswer"].ToString().TrimEnd()) ? "1" : "0"));
dbparamlist.Add(new dbparam("@indate", date));
dbparamlist.Add(new dbparam("@intime", time));
if (database.checkActiveSql("mssql", "flyformstring", "insert into web.optionform (formId,iid,id,inoper,value,answer,indate,intime) values (@formId,@iid,@id,@inoper,@value,@answer,@indate,@intime);", dbparamlist) != "istrue")
{
return(new statusModels()
{
status = "error"
});
}
break;
}
}
break;
}
}
foreach (var settitem in iFormsData.settitems)
{
string number = settitem["number"].ToString().TrimEnd() == "" || settitem["number"].ToString().TrimEnd() == "0" ? iFormsData.items.Count.ToString().TrimEnd() : settitem["number"].ToString().TrimEnd();
if (!bool.Parse(settitem["showExam"].ToString().TrimEnd()))
{
number = iFormsData.items.Count.ToString().TrimEnd();
}
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@formId", formId));
dbparamlist.Add(new dbparam("@inoper", iFormsData.newid.TrimEnd()));
dbparamlist.Add(new dbparam("@tile", iFormsData.tile.TrimEnd()));
dbparamlist.Add(new dbparam("@desc", iFormsData.desc.TrimEnd()));
dbparamlist.Add(new dbparam("@stdate", settitem["stdate"].ToString().TrimEnd().Replace("-", "/")));
dbparamlist.Add(new dbparam("@sttime", settitem["sttime"].ToString().TrimEnd().Replace("-", "/")));
dbparamlist.Add(new dbparam("@endate", settitem["endate"].ToString().TrimEnd().Replace("-", "/")));
dbparamlist.Add(new dbparam("@entime", settitem["entime"].ToString().TrimEnd().Replace("-", "/")));
dbparamlist.Add(new dbparam("@examed", bool.Parse(settitem["showExam"].ToString().TrimEnd()) ? "1" : "0"));
dbparamlist.Add(new dbparam("@restarted", bool.Parse(settitem["showRestart"].ToString().TrimEnd()) ? "1" : "0"));
dbparamlist.Add(new dbparam("@limited", bool.Parse(settitem["showLimit"].ToString().TrimEnd()) ? "1" : "0"));
dbparamlist.Add(new dbparam("@randopt", bool.Parse(settitem["randOption"].ToString().TrimEnd()) ? "1" : "0"));
dbparamlist.Add(new dbparam("@randsub", bool.Parse(settitem["randSubtile"].ToString().TrimEnd()) ? "1" : "0"));
dbparamlist.Add(new dbparam("@number", number));
dbparamlist.Add(new dbparam("@indate", date));
dbparamlist.Add(new dbparam("@intime", time));
if (database.checkActiveSql("mssql", "flyformstring", "insert into web.mainform (formId,inoper,tile,[desc],stdate,sttime,endate,entime,examed,restarted,limited,randopt,randsub,number,indate,intime) values (@formId,@inoper,@tile,@desc,@stdate,@sttime,@endate,@entime,@examed,@restarted,@limited,@randopt,@randsub,@number,@indate,@intime);", dbparamlist) != "istrue")
{
return(new statusModels()
{
status = "error"
});
}
}
foreach (var dertitem in iFormsData.dertitems)
{
foreach (var operitem in JsonSerializer.Deserialize <List <Dictionary <string, object> > >(dertitem["operitems"].ToString().TrimEnd()))
{
switch (bool.Parse(operitem["showOper"].ToString().TrimEnd()))
{
case true:
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@formId", formId));
dbparamlist.Add(new dbparam("@inoper", iFormsData.newid.TrimEnd()));
dbparamlist.Add(new dbparam("@newid", operitem["newid"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@indate", date));
dbparamlist.Add(new dbparam("@intime", time));
if (database.checkActiveSql("mssql", "flyformstring", "insert into web.operform (formId,inoper,newid,indate,intime) values (@formId,@inoper,@newid,@indate,@intime);", dbparamlist) != "istrue")
{
return(new statusModels()
{
status = "error"
});
}
break;
}
}
}
return(new statusModels()
{
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 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 sSiteModels GetTransferModels(sFileData sFileData, string cuurip)
{
database database = new database();
DataTable mainRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@newid", sFileData.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()}\\", encryption = new sha256().new256("mssql", "sysstring"), extension = "pdf";
switch (File.Exists($"{filePath}{sFileData.original.TrimEnd()}({sFileData.encryption.TrimEnd()}){sFileData.extension.TrimEnd()}"))
{
case false:
return(new sSiteModels()
{
status = "nodata"
});
}
dbparamlist.Clear();
DataTable subRows = new DataTable();
dbparamlist.Add(new dbparam("@value", extension));
dbparamlist.Add(new dbparam("@needed", "1"));
subRows = database.checkSelectSql("mssql", "sysstring", "exec web.uploadfileform @value,@needed;", dbparamlist);
switch (subRows.Rows.Count)
{
case 0:
return(new sSiteModels()
{
status = "nodata"
});
}
if (subRows.Rows[0]["flImages"].ToString().TrimEnd() == "0" && subRows.Rows[0]["flVideos"].ToString().TrimEnd() == "0" && subRows.Rows[0]["flAudios"].ToString().TrimEnd() == "0")
{
return(new sSiteModels()
{
status = "nodata"
});
}
switch (transFileToPDF(sFileData.extension.TrimEnd(), $"{filePath}{sFileData.original.TrimEnd()}({sFileData.encryption.TrimEnd()}){sFileData.extension.TrimEnd()}", $"{filePath}{sFileData.original.TrimEnd()}({encryption}).{extension}"))
{
case false:
return(new sSiteModels()
{
status = "nodata"
});
}
return(new sSiteModels()
{
images = subRows.Rows[0]["flImages"].ToString().TrimEnd() == "1", videos = subRows.Rows[0]["flVideos"].ToString().TrimEnd() == "1", audios = subRows.Rows[0]["flAudios"].ToString().TrimEnd() == "1", src = subRows.Rows[0]["flImages"].ToString().TrimEnd() == "1" && subRows.Rows[0]["flShowed"].ToString().TrimEnd() == "0" ? $"{subRows.Rows[0]["original"].ToString().TrimEnd()}({subRows.Rows[0]["encryption"].ToString().TrimEnd()}){subRows.Rows[0]["extension"].ToString().TrimEnd()}" : $"{sFileData.original.TrimEnd()}({encryption}).{extension}", imagePath = $"{database.connectionString("sysHttps")}{mainRows.Rows[0]["formId"].ToString().TrimEnd()}/", original = sFileData.original.TrimEnd(), encryption = encryption, extension = $".{extension}", date = new datetime().sqldate("mssql", "sysstring"), status = "istrue"
});
}
private static string TestSHAHash(string input)
{
sha256 SHA = new sha256(input, "salt-test");
return(SHA.Hash);
}
