public List <CaseReport> InsertCaseReport(CaseReport UI, HttpPostedFileBase image1)
{
var result = new List <CaseReport>();
using (IDbConnection con = new SqlConnection(constring))
{
PriorityDictionary M = new PriorityDictionary();
M.myString = M.myString.Select(x => x.ToUpper()).ToArray();
if (UI.Notes == null)
{
UI.Notes = "No description provided";
}
int hits = 0;
foreach (string x in M.myString)
{
if (UI.Notes.ToUpper().Contains(x))
{
Console.Write(x + " ");
hits++;
}
}
if (image1 != null)
{
UI.CaseReportPhoto = new byte[image1.ContentLength];
image1.InputStream.Read(UI.CaseReportPhoto, 0, image1.ContentLength);
}
con.Open();
var param = new DynamicParameters();
param.Add("@UserInformationID", UI.UserInformationID);
param.Add("@EnvironmentalConcernID", UI.EnvironmentalConcernID);
param.Add("@XCoordinates", UI.XCoordinates);
param.Add("@YCoordinates", UI.YCoordinates);
param.Add("@CaseLocation", UI.CaseLocation);
param.Add("@CaseReportPhoto", UI.CaseReportPhoto);
param.Add("@Notes", UI.Notes);
param.Add("@Hits", hits);
param.Add("@SpecificEnvironmentalConcernID", UI.SpecificEnvironmentalConcernID);
// Convert.ToBase64String(UI.CaseReportPhoto);
result = con.Query <CaseReport>(
StoredProcedureEnum.I_CaseReport.ToString(), param, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
//
public List <CaseReport> UpdateCaseReportConcern(CaseReport UI)
{
var result = new List <CaseReport>();
using (IDbConnection con = new SqlConnection(constring))
{
con.Open();
var param = new DynamicParameters();
param.Add("@CaseReportID", UI.CaseReportID);
param.Add("@EnvironmentalConcernID", UI.EnvironmentalConcernID);
param.Add("@SpecificEnvironmentalConcernID", UI.SpecificEnvironmentalConcernID);
result = con.Query <CaseReport>(
StoredProcedureEnum.U_CaseReportConcern.ToString(), param, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public List <CaseReport> UpdateCaseReport_Completed(CaseReport UI, HttpPostedFileBase image1)
{
var result = new List <CaseReport>();
using (IDbConnection con = new SqlConnection(constring))
{
if (image1 != null)
{
UI.CaseReportPhotoCompleted = new byte[image1.ContentLength];
image1.InputStream.Read(UI.CaseReportPhotoCompleted, 0, image1.ContentLength);
}
string imgurId = "785030f668c9715";
string finalURL;
using (var w = new WebClient())
{
string clientID = imgurId;
w.Headers.Add("Authorization", "Client-ID " + clientID);
var values = new NameValueCollection {
{ "image", Convert.ToBase64String(UI.CaseReportPhotoCompleted) }
};
byte[] response = w.UploadValues("https://api.imgur.com/3/upload.xml", values);
var responseXml = XDocument.Load(new MemoryStream(response));
string imageUrl = (string)responseXml.Root.Element("link");
finalURL = imageUrl;
}
con.Open();
var param = new DynamicParameters();
param.Add("@CaseReportID", UI.CaseReportID);
param.Add("@CaseReportPhotoCompleted", UI.CaseReportPhotoCompleted);
param.Add("@CaseReportPhotoLinkCompleted", finalURL);
result = con.Query <CaseReport>(
StoredProcedureEnum.U_CaseReport_C.ToString(), param, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}