public string BodyMessage(BodyMessageEntity bodyMessageEntity)
{
try
{
string messageBody = "<font>Hi Team, </font><br><br>";
string htmlTableStart = "<table style=\"border-collapse:collapse; text-align:center;\" >";
string htmlTableEnd = "</table>";
string htmlHeaderRowStart = "<tr style=\"background-color:#6FA1D2; color:#ffffff;\">";
string htmlHeaderRowEnd = "</tr>";
string htmlTrStart = "<tr style=\"color:#555555;\">";
string htmlTrEnd = "</tr>";
string htmlTdStart = "<td style=\" border-color:#5c87b2; border-style:solid; border-width:thin; padding: 5px;\">";
string htmlTdEnd = "</td>";
messageBody += "Please provide the quotation for below mentioned products. <br><br>";
messageBody += htmlTableStart;
messageBody += htmlHeaderRowStart;
messageBody += htmlTdStart + "Region" + htmlTdEnd;
messageBody += htmlTdStart + "Godown" + htmlTdEnd;
messageBody += htmlTdStart + "Email id" + htmlTdEnd;
messageBody += htmlTdStart + "Phone Number" + htmlTdEnd;
messageBody += htmlTdStart + "Products" + htmlTdEnd;
messageBody += htmlTdStart + "Remarks" + htmlTdEnd;
messageBody += htmlHeaderRowEnd;
//Loop all the rows from grid vew and added to html td
messageBody = messageBody + htmlTrStart;
messageBody += htmlTdStart + bodyMessageEntity.RName + htmlTdEnd;
messageBody += htmlTdStart + bodyMessageEntity.GName + htmlTdEnd;
messageBody += htmlTdStart + bodyMessageEntity.Mailid + htmlTdEnd;
messageBody += htmlTdStart + bodyMessageEntity.PhoneNumber + htmlTdEnd;
messageBody += htmlTdStart + bodyMessageEntity.Products + htmlTdEnd;
messageBody += htmlTdStart + bodyMessageEntity.Remarks + htmlTdEnd;
messageBody += htmlTrEnd + htmlTableEnd + "<br><br>";
messageBody += "Thanks & Regads <br>";
messageBody += " SI Support Team";
return(messageBody);
}
catch (Exception ex)
{
Console.WriteLine(ex);
throw;
}
}
public Tuple <bool, string> Post(QuotationEntity entity)
{
string QId = string.Empty;
SqlTransaction objTrans = null;
using (sqlConnection = new SqlConnection(GlobalVariable.ConnectionString))
{
DataSet ds = new DataSet();
sqlCommand = new SqlCommand();
try
{
if (sqlConnection.State == 0)
{
sqlConnection.Open();
}
objTrans = sqlConnection.BeginTransaction();
sqlCommand = new SqlCommand();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "InsertQuotationDetails";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@EmailID", entity.EmailID);
sqlCommand.Parameters.AddWithValue("@PhoneNo", entity.PhoneNo);
sqlCommand.Parameters.AddWithValue("@Remarks", entity.Remarks);
sqlCommand.Parameters.AddWithValue("@GCode", entity.GCode);
sqlCommand.Parameters.AddWithValue("@RCode", entity.RCode);
sqlCommand.Parameters.Add("@Q_ID", SqlDbType.Int, 8);
sqlCommand.Parameters["@Q_ID"].Direction = ParameterDirection.Output;
sqlCommand.ExecuteNonQuery();
QId = Convert.ToString(sqlCommand.Parameters["@Q_ID"].Value);
foreach (var item in entity.ProductID)
{
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
sqlCommand = new SqlCommand();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "InsertQuotationProductDeatils";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@Q_Id", QId);
sqlCommand.Parameters.AddWithValue("@P_Id", item);
sqlCommand.ExecuteNonQuery();
}
objTrans.Commit();
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
///MailSending
///sqlCommand = new SqlCommand();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "GetMailDetails";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.ExecuteNonQuery();
SendMail sendMail = new SendMail();
BodyMessageEntity bodyMessageEntity = new BodyMessageEntity
{
Mailid = entity.EmailID,
PhoneNumber = entity.PhoneNo,
Products = entity.Products,
Remarks = entity.Remarks,
RName = entity.RNname,
GName = entity.GName
};
using (SqlDataReader oReader = sqlCommand.ExecuteReader())
{
while (oReader.Read())
{
MailEntity mailEntity = new MailEntity
{
FromMailid = oReader["FromMailId"].ToString(),
ToMailid = oReader["ToId"].ToString(),
FromPassword = oReader["FromPassword"].ToString(),
ToCC = oReader["ToCC"].ToString(),
SMTP = oReader["Host"].ToString(),
Port = Convert.ToInt16(oReader["Port"]),
Subject = oReader["MailSubject"].ToString(),
BodyMessage = sendMail.BodyMessage(bodyMessageEntity)
};
Task.Run(() => sendMail.MailSending(mailEntity));
}
}
objTrans.Commit();
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
return(new Tuple <bool, string>(true, GlobalVariable.SavedMessage));
}
catch (Exception ex)
{
objTrans.Rollback();
AuditLog.WriteError(ex.Message + " : " + ex.StackTrace);
return(new Tuple <bool, string>(false, GlobalVariable.ErrorMessage));
}
finally
{
sqlConnection.Close();
sqlCommand.Dispose();
ds.Dispose();
}
}
}
