public long SaveEnquiry(ParcelEnquiry parcelEnquiry)
{
// bool result = false;
long result = 0;
//Dictionary<bool, int> result = new Dictionary<bool, int>();
try {
string query = @"INSERT INTO ParcelEnquiries
(`FromCountry`,
`FromAddress`,
`ToCountry`,
`ToAddress`,
`Phone`,
`NumberOfParcels`,
`ParcelDescription`,
`CreateDateTime`
)
VALUES(@FromCountry, @FromAddress, @ToCountry, @ToAddress, @Phone, @NumberOfParcels, @ParcelDescription, @createDatetime); SELECT LAST_INSERT_ID();";
using (MySqlConnection mysqlconnection = new MySqlConnection(connectionString)) {
mysqlconnection.Open();
MySqlCommand command = new MySqlCommand(query, mysqlconnection);
command.Parameters.AddWithValue("@FromCountry", parcelEnquiry.fromCountry);
command.Parameters.AddWithValue("@FromAddress", parcelEnquiry.fromAddress);
command.Parameters.AddWithValue("@ToCountry", parcelEnquiry.toCountry);
command.Parameters.AddWithValue("@ToAddress", parcelEnquiry.toAddress);
command.Parameters.AddWithValue("@Phone", parcelEnquiry.contactNumber);
command.Parameters.AddWithValue("@NumberOfParcels", parcelEnquiry.parcelQuantity);
command.Parameters.AddWithValue("@ParcelDescription", parcelEnquiry.parcelDescription);
command.Parameters.AddWithValue("@createDatetime", DateTime.Now);
int indictor = command.ExecuteNonQuery();
result = command.LastInsertedId;
}
} catch (Exception e) {
Error error = new Error()
{
Class = "DataManager", Message = e.Message, Method = "SaveEnquiry"
};
InsertErrorMessage(error);
Console.WriteLine(e.Message);
}
return(result);
} // End method
protected string ParcelEnquiry([FromBody] ParcelEnquiry parcelEnquiry)
{
long parcelEnquiryId = dataManager.SaveEnquiry(parcelEnquiry);
for (int i = 0; i < parcelEnquiry.AllParcels.Count(); i++)
{
dataManager.InsertParcels(parcelEnquiry.AllParcels[i], parcelEnquiryId);
}
// Send Email
StringBuilder emailBody = new StringBuilder();
emailBody.Append(parcelEnquiry.fromCountry);
emailBody.Append("<br />");
emailBody.Append(parcelEnquiry.fromAddress);
emailBody.Append("<br />");
emailBody.Append(parcelEnquiry.toCountry);
emailBody.Append("<br />");
emailBody.Append(parcelEnquiry.toAddress);
emailBody.Append("<br />");
emailBody.Append(parcelEnquiry.contactNumber);
emailBody.Append("<br />");
emailBody.Append(parcelEnquiry.parcelDescription);
emailBody.Append("<br />");
emailBody.Append(parcelEnquiry.parcelQuantity);
for (int q = 0; q < parcelEnquiry.AllParcels.Count(); q++)
{
ParcelDetails parcela = parcelEnquiry.AllParcels[q];
emailBody.AppendFormat("Height:{0}", parcela.height);
emailBody.AppendFormat("Length:{0}", parcela.length);
emailBody.AppendFormat("Width:{0}", parcela.width);
emailBody.AppendFormat("Weight:{0}", parcela.weight);
emailBody.Append("<br />");
emailBody.Append("<br />");
emailBody.Append("<br />");
}
MailMessage mailMessage = new MailMessage("*****@*****.**", "*****@*****.**");
mailMessage.Subject = "Booking";
mailMessage.Body = emailBody.ToString();
mailMessage.AlternateViews.Add(AlternateView.CreateAlternateViewFromString(emailBody.ToString(), new System.Net.Mime.ContentType("text/html")));
var client = new SmtpClient("smtp.gmail.com", 587);
client.Credentials = new System.Net.NetworkCredential()
{
//Credentials = new NetworkCredential("*****@*****.**", "Mad2behere"),
//EnableSsl = true
UserName = "******",
Password = "******"
};
try {
client.EnableSsl = true;
client.Send(mailMessage);
} catch (Exception e) {
string error = e.Message;
}
return(JsonConvert.SerializeObject(parcelEnquiry.contactNumber));
} // End Method
