public bool Save_ContactUS_And_Send_Email_With_PDF(clsContcts_01 Contact)
{
try
{
string strDownloadPdf_ID = "";
Hashtable Product_Brochure = new Hashtable();
#region Get Client IP Address
string CLIENT_IP = "";
System.Web.HttpContext context = System.Web.HttpContext.Current;
string ipAddress = context.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
//==== Assign Client IP Address
CLIENT_IP = context.Request.ServerVariables["REMOTE_ADDR"];
if (!string.IsNullOrEmpty(ipAddress))
{
string[] addresses = ipAddress.Split(',');
if (addresses.Length != 0)
{
CLIENT_IP = addresses[0];
}
}
#endregion
//==== Assign Default value if null
if (Contact.Name == null) Contact.Name = "";
if (Contact.Contact_Number == null) Contact.Contact_Number = "";
if (Contact.Company_Name == null) Contact.Company_Name = "";
if (Contact.Email == null) Contact.Email = "";
#region Save Data
objHelper.gTransactionHandler(DBHelper.TransactionType.Open);
strSql = @"INSERT INTO INSTA_MST_CONTACT_US(
CONTACT_NAME,
CONTACT_NO,
COMPANY,
EMAIL,
IP)
VALUES( '" + objGen.gReplaceQuotes(Contact.Name.Trim()) + @"',
'" + objGen.gReplaceQuotes(Contact.Contact_Number.Trim()) + @"',
'" + objGen.gReplaceQuotes(Contact.Company_Name.Trim()) + @"',
'" + objGen.gReplaceQuotes(Contact.Email.Trim()).ToLower() + @"',
'" + CLIENT_IP + "')";
if (objHelper.gExecuteNonQuery(true, CommandType.Text, strSql) <= 0)
{
objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback);
}
if (Contact.DownloadPDF.Length != 0)
{
//==== get CONTACT_ID
Int64 intCONTACT_ID = Convert.ToInt32(objHelper.gExecuteScalar(true, CommandType.Text, "SELECT SCOPE_IDENTITY() AS CONTACT_ID"));
strSql = @"INSERT INTO INSTA_MST_PRODUCT_BROCHURE_DOWNLOAD_DETAIL(
CONTACT_ID,
PRODUCT_BROCHURE_ID)";
for (int iCounter = 0; iCounter < Contact.DownloadPDF.Length; iCounter++)
{
if (iCounter == 0)
{
strSql += @"SELECT " + intCONTACT_ID + @",
" + Contact.DownloadPDF[iCounter];
//==== DownloadPdf_ID For get Pdf from table
strDownloadPdf_ID += Contact.DownloadPDF[iCounter];
}
else if (iCounter >= 1)
{
strSql += "UNION SELECT " + intCONTACT_ID + @",
" + Contact.DownloadPDF[iCounter];
//==== DownloadPdf_ID For get Pdf from table
strDownloadPdf_ID += "," + Contact.DownloadPDF[iCounter];
}
}
if (objHelper.gExecuteNonQuery(true, CommandType.Text, strSql) <= 0)
{
objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback);
}
}
//==== End the transaction
objHelper.gTransactionHandler(DBHelper.TransactionType.Commit);
#endregion
StringBuilder htmlString = new StringBuilder();
#region Send Email To submitter
htmlString.Clear();
htmlString.Append(@"<table border='0' cellpadding='0' cellspacing='0'width='600px' style= 'font-family:Trebuchet MS; font-size:10pt'>
<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
Dear " + Contact.Name.Trim() + @",
</td>
</tr>
<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
Thank you for registering for the “Go-Modular Session” at
<b>In-store Asia </b>to be held at <b> Bombay Exhibition Centre, Mumbai on 5th, 6th and 7th February 2015.</b>
</td>
</tr>
<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
<b>Visit us at Stall No. E1A </b>
to attend the “Go-Modular Session” and unlock our latest range of modular, reusable stands for Brand Activation and retail brand promotion spaces.
</td>
</tr>
<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
We look forward to meet you at the show.
</td>
</tr>");
if (strDownloadPdf_ID != "")
{
htmlString.Append(@" <tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
The brochure(s) requested by you can be downloaded from the following link(s):
</td>
</tr>");
strSql = @"SELECT NAME,
LINK
FROM INSTA_PAR_PRODUCT_BROCHURE
WHERE PRODUCT_BROCHURE_ID IN (" + strDownloadPdf_ID + @")
ORDER BY PRODUCT_BROCHURE_ID ";
IDataReader reader = objHelper.gExecuteReader(CommandType.Text, strSql);
while (reader.Read())
{
//==== Assign data in Hashtable For Admin Email
Product_Brochure.Add(Convert.ToString(reader["NAME"]), Convert.ToString(reader["LINK"]));
htmlString.Append(@"<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
<b> " + Convert.ToString(reader["NAME"]) + @" </b>
</td>
</tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
<a href=" + Convert.ToString(reader["LINK"]) + ">" + Convert.ToString(reader["LINK"]) + @"</a>
</td>
</tr>");
}
}
htmlString.Append(@" <tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
In case of any queries, feel free to contact us at our [email protected] or <br/>
call us at 1800 123 7717 (Toll Free) or (91 22) 40649200.
</td>
</tr>
<tr><td colspan='3' style='height:40px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
Regards
</td>
</tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
Team Insta Group
</td>
</tr>
<tr><td colspan='3' style='height:15px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 11px;'>
Disclaimer :
</td>
</tr><tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 11px;'>
This is an auto-generated email in response to the Enquiry that was submitted through www.insta-group.com.<br />
There has been no verification and in case for any reason this mail has been misdirected, please let us know <br />
at [email protected] and do accept our apologies.
</td>
</tr>
<tr><td colspan='3' style='height:10px'> </td></tr>
</table>");
//-------------------------------------------------------------------------
MailMessage mailmsg_01 = new MailMessage();
mailmsg_01.From = new MailAddress("Insta Group <*****@*****.**>");
//==== Send Mail To submitter
mailmsg_01.To.Add(new MailAddress(Contact.Email.ToLower()));
mailmsg_01.Bcc.Add(new MailAddress("*****@*****.**"));
//-------------------------------------------------------------------------
mailmsg_01.Subject = "Pre-registration confirmation for Go-Modular Session";
mailmsg_01.Body = htmlString.ToString();
mailmsg_01.IsBodyHtml = true;
SmtpClient client = new SmtpClient();
client.Send(mailmsg_01);
//-------------------------------------------------------------------------
#endregion
#region Send Email To admin
htmlString.Clear();
htmlString.Append(@"<table border='0' cellpadding='0' cellspacing='0'width='600px' style= 'font-family:Trebuchet MS; font-size:10pt'>
<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
Dear Admin,
</td>
</tr>
<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
Following person has pre-registered for the Go Modular Session at
<b> In-store Asia </b> to be held <br/> at <b> Bombay Exhibition Centre, Mumbai on 5th, 6th and 7th February 2015 </b>
</td>
</tr>
<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td style='width:180px; font-family: Trebuchet MS; font-size: 13px;'>
Name
</td>
<td style='width:30px; font-family: Trebuchet MS; font-size: 13px;'>
:
</td>
<td style='width:390px; font-family: Trebuchet MS; font-size: 13px;'>
" + Contact.Name.Trim() + @"
</td>
</tr>
<tr>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
Company Name
</td>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
:
</td>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
" + Contact.Company_Name.Trim() + @"
</td>
</tr>
<tr>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
Contact No.
</td>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
:
</td>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
" + Contact.Contact_Number.Trim() + @"
</td>
</tr>
<tr>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
Email Id
</td>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
:
</td>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
" + Contact.Email.Trim() + @"
</td>
</tr>
<tr><td colspan='3' style='height:10px'> </td></tr>");
if (strDownloadPdf_ID != "")
{
htmlString.Append(@" <tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
The person requested pdf brochure(s) for the following product(s):
</td>
</tr>
<tr><td colspan='3' style='height:20px'> </td></tr>");
foreach (DictionaryEntry entry in Product_Brochure)
{
htmlString.Append(@" <tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
<b>" + entry.Key + @"</b>
</td>
</tr>");
}
}
htmlString.Append(@"</table>");
//-------------------------------------------------------------------------
MailMessage mailtoadmin_01 = new MailMessage();
mailtoadmin_01.From = new MailAddress(Contact.Email.ToLower());
//==== testing
//mailtoadmin_01.To.Add(new MailAddress("*****@*****.**"));
//==== Send Mail To Admin
mailtoadmin_01.To.Add(new MailAddress("*****@*****.**"));
mailtoadmin_01.To.Add(new MailAddress("*****@*****.**"));
mailtoadmin_01.Bcc.Add(new MailAddress("*****@*****.**"));
//-------------------------------------------------------------------------
mailtoadmin_01.Subject = "Pre-registration for Go-Modular Session";
mailtoadmin_01.Body = htmlString.ToString();
mailtoadmin_01.IsBodyHtml = true;
SmtpClient client_mailtoadmin = new SmtpClient();
client_mailtoadmin.Send(mailtoadmin_01);
//-------------------------------------------------------------------------
#endregion
return true;
}
catch
{
objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback);
return false;
}
}
public bool SaveNameEmailAndSendEmailToAdmin(clsContcts_01 Contact)
{
try
{
#region Get Client IP Address
string CLIENT_IP = "";
System.Web.HttpContext context = System.Web.HttpContext.Current;
string ipAddress = context.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
//==== Assign Client IP Address
CLIENT_IP = context.Request.ServerVariables["REMOTE_ADDR"];
if (!string.IsNullOrEmpty(ipAddress))
{
string[] addresses = ipAddress.Split(',');
if (addresses.Length != 0)
{
CLIENT_IP = addresses[0];
}
}
#endregion
//==== Assign Default value if null
if (Contact.Name == null) Contact.Name = "";
if (Contact.Email == null) Contact.Email = "";
#region Save Data
objHelper.gTransactionHandler(DBHelper.TransactionType.Open);
strSql = @"INSERT INTO INSTA_MST_CONTACT_US(
CONTACT_NAME,
EMAIL,
PATH,
IP)
VALUES( '" + objGen.gReplaceQuotes(Contact.Name.Trim()) + @"',
'" + objGen.gReplaceQuotes(Contact.Email.Trim()).ToLower() + @"',
'" + objGen.gReplaceQuotes(Contact.Path.Trim()) + @"',
'" + CLIENT_IP + "')";
if (objHelper.gExecuteNonQuery(true, CommandType.Text, strSql) <= 0)
{
objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback);
}
//==== get CONTACT_ID
Int64 intCONTACT_ID = Convert.ToInt32(objHelper.gExecuteScalar(true, CommandType.Text, "SELECT SCOPE_IDENTITY() AS CONTACT_ID"));
strSql = @"INSERT INTO INSTA_MST_PRODUCT_BROCHURE_DOWNLOAD_DETAIL(
CONTACT_ID,
PRODUCT_BROCHURE_ID)
VALUES( '" + intCONTACT_ID + @"',
14)";
if (objHelper.gExecuteNonQuery(true, CommandType.Text, strSql) <= 0)
{
objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback);
}
//==== End the transaction
objHelper.gTransactionHandler(DBHelper.TransactionType.Commit);
#endregion
StringBuilder htmlString = new StringBuilder();
#region Send Email To admin
htmlString.Clear();
htmlString.Append(@"<table border='0' cellpadding='0' cellspacing='0'width='600px' style= 'font-family:Trebuchet MS; font-size:10pt'>
<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
Dear Admin,
</td>
</tr>
<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td colspan='3' style='font-family: Trebuchet MS; font-size: 13px;'>
Following person has downloaded the Creeya Infographic:
</td>
</tr>
<tr><td colspan='3' style='height:10px'> </td></tr>
<tr>
<td style='width:180px; font-family: Trebuchet MS; font-size: 13px;'>
Name
</td>
<td style='width:30px; font-family: Trebuchet MS; font-size: 13px;'>
:
</td>
<td style='width:390px; font-family: Trebuchet MS; font-size: 13px;'>
" + Contact.Name.Trim() + @"
</td>
</tr>
<tr>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
Email Id
</td>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
:
</td>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
" + Contact.Email.Trim() + @"
</td>
</tr>
<tr>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
Path
</td>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
:
</td>
<td style='font-family: Trebuchet MS; font-size: 13px;'>
" + Contact.Path + @"
</td>
</tr>
<tr><td colspan='3' style='height:10px'> </td></tr>");
htmlString.Append(@"</table>");
//-------------------------------------------------------------------------
MailMessage mailtoadmin_01 = new MailMessage();
mailtoadmin_01.From = new MailAddress(Contact.Email.ToLower());
//==== testing
//mailtoadmin_01.To.Add(new MailAddress("*****@*****.**"));
//==== Send Mail To Admin
mailtoadmin_01.To.Add(new MailAddress("*****@*****.**"));
mailtoadmin_01.To.Add(new MailAddress("*****@*****.**"));
mailtoadmin_01.Bcc.Add(new MailAddress("*****@*****.**"));
//-------------------------------------------------------------------------
mailtoadmin_01.Subject = "Creeya Infographic downloaded";
mailtoadmin_01.Body = htmlString.ToString();
mailtoadmin_01.IsBodyHtml = true;
SmtpClient client_mailtoadmin = new SmtpClient();
client_mailtoadmin.Send(mailtoadmin_01);
//-------------------------------------------------------------------------
#endregion
return true;
}
catch
{
objHelper.gTransactionHandler(DBHelper.TransactionType.Rollback);
return false;
}
}
