public IHttpActionResult OilSamplingSave(OilSampling os)
{
if (os != null)
{
StringBuilder sb = new StringBuilder();
sb.Append("DECLARE @Id int;");
sb.Append("\n INSERT INTO [Services-Aydas-OilSampling] (RecordDate, Client, SubstationName, Country, ProjectName, CompanyName, ContactPersonName, Phone, Email, CompanyAddress) ");
sb.Append("\n VALUES (GETDATE(),'" + h.Clean(os.Client) + "', '" + h.Clean(os.SubstationName) + "', '" + h.Clean(os.Country) + "', '" + h.Clean(os.ProjectName) + "', '" + h.Clean(os.CompanyName) + "', '" + h.Clean(os.ContactPersonName) + "', '" + h.Clean(os.Phone) + "', '" + h.Clean(os.Email) + "', '" + h.Clean(os.CompanyAddress) + "')");
sb.Append("\n SET @Id=@@IDENTITY; ");
for (int i = 0; i < os.samples.Count; i++)
{
sb.Append("\n INSERT INTO [Services-Aydas-OilSampling-Detail] (SampleId,EquipmentManufacturer, SampleNr, OilTemp, AmbientTemp, OilName, Language, LanguageOther, OilReportStandard, PlaceOfSampling, Rating, PrimaryVoltage, SecondaryVoltage, Frequency, SerialNumber, YearOfManufacture, TapChangerType, CoolingType, OilType, EquipmentType,Humidity,RequestedTests,ReasonForSampling,SamplingDate) ");
sb.Append("\n VALUES (@Id,'" + h.Clean(os.samples[i].EquipmentManufacturer) + "','" + h.Clean(os.samples[i].SampleNr) + "', '" + h.Clean(os.samples[i].OilTemp) + "', '" + h.Clean(os.samples[i].AmbientTemp) + "', '" + h.Clean(os.samples[i].OilName) + "', '" + h.Clean(os.samples[i].Language) + "', '" + h.Clean(os.samples[i].LanguageOther) + "', '" + h.Clean(os.samples[i].OilReportStandard) + "', '" + h.Clean(os.samples[i].PlaceOfSampling) + "', '" + h.Clean(os.samples[i].Rating) + "', '" + h.Clean(os.samples[i].PrimaryVoltage) + "', '" + h.Clean(os.samples[i].SecondaryVoltage) + "', '" + h.Clean(os.samples[i].Frequency) + "', '" + h.Clean(os.samples[i].SerialNumber) + "', '" + h.Clean(os.samples[i].YearOfManufacture) + "', '" + h.Clean(os.samples[i].TapChangerType) + "', '" + h.Clean(os.samples[i].CoolingType) + "', '" + h.Clean(os.samples[i].OilType) + "', '" + h.Clean(os.samples[i].EquipmentType) + "', '" + h.Clean(os.samples[i].Humidity) + "', '" + h.Clean(os.samples[i].RequestedTests) + "', '" + h.Clean(os.samples[i].ReasonForSampling) + "', '" + h.Clean(os.samples[i].SamplingDate) + "')");
}
sb.Append("\n SELECT @Id as Id ");
int newId = Convert.ToInt32(db.ExecuteScalar(sb.ToString()));
StringBuilder body = new StringBuilder();
body.Append("<h3>" + os.CompanyName + "</h3>");
body.Append("<p>Project Name: <b>" + os.ProjectName + "</b></p>");
body.Append("<p><a href='https://aydas.co.uk/samplingform/ViewForm.html?FormId=" + newId.ToString() + "'>Click here</a> to view form...</p>");
h.SendMail("*****@*****.**", "Oil Sampling Form", body.ToString());
h.SendMail("*****@*****.**", "Oil Sampling Form", body.ToString());
return(Ok("OK"));
}
else
{
return(Ok(0));
}
}
public IHttpActionResult ViewForm(string FormId)
{
OilSampling os = db.QuerySingle <OilSampling>("SELECT * FROM [Services-Aydas-OilSampling] WHERE Id=" + FormId);
os.samples = db.Query <OilSample>("SELECT * FROM [Services-Aydas-OilSampling-Detail] WHERE SampleId = " + FormId + " ORDER BY Id").ToList();
return(Ok(os));
}
