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