public Boolean Post([FromBody] NewsLetterModel value)
{
var dbCon = DBConnect.Instance();
if (dbCon.IsConnect())
{
if (!isEmailAlreadyExist(value.email, dbCon))
{
string query =
"INSERT INTO NEWSLETTER values (null, '"
+ value.email + "','"
+ value.heardAbout + "','"
+ value.reasonSingup + "')";
try
{
insertIntoDatabase(query, dbCon);
return(true);
} catch (Exception ex)
{
throw (ex);
}
}
else
{
System.Diagnostics.Debug.WriteLine("email already exists: " + value.email);
}
}
return(false);
}
protected void btnsendNewsLetter_Click(object sender, EventArgs e)
{
var PhotoPath = GetPhotoPath();
var Users = GetHiddenValue();
NewsLetterModel model = new NewsLetterModel();
if (Users != null && Users != "")
{
DataTable dt = new DataTable();
string str = "select EmailId from [AdminClient] where ID in(" + Users + ")";
SqlDataAdapter adp = new SqlDataAdapter(str, conn);
adp.Fill(dt);
foreach (DataRow row in dt.Rows)
{
var Email = row["EmailId"].ToString();
model.Email = Email;
model.PropertyPhoto = PhotoPath;
bool status = SendNewsLetter(model);
string message = "Mail send successfully.";
if (status)
{
Session["alertmessage"] = message;
}
else
{
Session["alertmessage"] = "Mail not send properly.";
}
}
}
Response.Redirect("NewsLetterList.aspx?Id=0");
}
public ActionResult SaveItem(NewsLetter model)
{
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
int IdDC = Int32.Parse(MyModels.Decode(model.Ids, API.Models.Settings.SecretId + ControllerName).ToString());
NewsLetterModel data = new NewsLetterModel()
{
Item = model
};
if (ModelState.IsValid)
{
if (model.Id == IdDC)
{
model.CreatedBy = int.Parse(HttpContext.Request.Headers["Id"]);
model.ModifiedBy = int.Parse(HttpContext.Request.Headers["Id"]);
NewsLetterService.SaveItem(model);
if (model.Id > 0)
{
TempData["MessageSuccess"] = "Cập nhật thành công";
}
else
{
TempData["MessageSuccess"] = "Thêm mới thành công";
}
return(RedirectToAction("Index"));
}
}
return(View(data));
}
public ActionResult NewsLetter()
{
Logger.Info(typeof(HomeAController), "NewsLetter Get");
//var articles = Umbraco.ContentAtXPath($"\\{Articles.ModelTypeAlias}").OfType<Articles>();
var model = new NewsLetterModel();
return(PartialView("_NewsLetterForm", model));
}
public ActionResult NewsLetterPost(NewsLetterModel model)
{
if (!ModelState.IsValid)
{
return(CurrentUmbracoPage());
}
return(Content(model.EmailAddress));
}
public void CommonNewsLetterMethod(NewsLetterModel Model)
{
string SelectedIds = GetHiddenValue();
DataTable dt = new DataTable();
string str = "select EmailId from [AdminClient] where ID in(" + SelectedIds + ")";
SqlDataAdapter adp = new SqlDataAdapter(str, conn);
adp.Fill(dt);
foreach (DataRow row in dt.Rows)
{
var Email = row["EmailId"].ToString();
Model.Email = Email;
SendNewsLetter(Model);
}
}
public ActionResult <ResultVM <bool> > Subscribe(NewsLetterVM newsLetterVM)
{
ResultVM <bool> resultVM = new ResultVM <bool>();
try
{
NewsLetterModel newsLetterModel = new NewsLetterModel();
mapper.Map(newsLetterVM, newsLetterModel);
var result = newsLetterBusiness.SubscribeNewsLetter(newsLetterModel);
mapper.Map(result, resultVM);
return(resultVM);
}
catch (Exception ex)
{
resultVM.Message = ex.Message;
resultVM.StatusCode = Convert.ToInt32(Enums.StatusCode.BadRequest);
return(StatusCode(StatusCodes.Status400BadRequest, new { Result = resultVM }));
}
}
public IActionResult Index([FromQuery] SearchNewsLetter dto)
{
int TotalItems = 0;
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
NewsLetterModel data = new NewsLetterModel()
{
SearchData = dto
};
data.ListItems = NewsLetterService.GetListPagination(data.SearchData, API.Models.Settings.SecretId + ControllerName);
if (data.ListItems != null && data.ListItems.Count() > 0)
{
TotalItems = data.ListItems[0].TotalRows;
}
data.Pagination = new Models.Partial.PartialPagination()
{
CurrentPage = data.SearchData.CurrentPage, ItemsPerPage = data.SearchData.ItemsPerPage, TotalItems = TotalItems, QueryString = Request.QueryString.ToString()
};
return(View(data));
}
public ResultModel <bool> SubscribeNewsLetter(NewsLetterModel newsLetterModel)
{
ResultModel <bool> result = new ResultModel <bool>();
var emailExist = unitOfWork.NewsLetterRepository.Get(x => x.Email == newsLetterModel.Email).FirstOrDefault();
if (emailExist == null)
{
NewsLetter newsLetter = new NewsLetter(newsLetterModel.Email);
newsLetter.CreatedBy = 1;
newsLetter.IsSubscribe = true;
unitOfWork.NewsLetterRepository.Insert(newsLetter);
result.StatusCode = Convert.ToInt32(Enums.StatusCode.OK);
result.Data = true;
result.Success = true;
}
else
{
result.Message = Messages.EmailExist;
}
return(result);
}
public string FirstNewsLetterPrint(NewsLetterModel dataValue)
{
string html = "";
string Template = "";
if (dataValue.NewsletterType == "First_nwslettr")
{
Template = "PrintHtmlFiles/FirstNewsletter.html";
}
using (StreamReader reader = new StreamReader(Path.Combine(HttpRuntime.AppDomainAppPath, Template)))
{
html = reader.ReadToEnd();
html = html.Replace("{FirstContent}", dataValue.Logopath);
html = html.Replace("{SecondContent}", dataValue.SecondContent);
html = html.Replace("{ThirdContent}", dataValue.ThirldContent);
}
return(html);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
NewsLetterModel Model = new NewsLetterModel();
Model.NewsletterType = hdnTemplateType.Value;
if (Model.NewsletterType == "First_nwslettr")
{
Firstnewsletter(Model);
}
else
{
CommonNewsLetterMethod(Model);
}
Response.Redirect("~/Admin/NewsLetter.aspx", false);
}
catch (Exception ex)
{
//throw ex;
}
}
public IActionResult SaveItem(string Id = null)
{
NewsLetterModel data = new NewsLetterModel();
string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
int IdDC = Int32.Parse(MyModels.Decode(Id, API.Models.Settings.SecretId + ControllerName).ToString());
data.SearchData = new SearchNewsLetter()
{
CurrentPage = 0, ItemsPerPage = 10, Keyword = ""
};
if (IdDC == 0)
{
data.Item = new NewsLetter();
}
else
{
data.Item = NewsLetterService.GetItem(IdDC, API.Models.Settings.SecretId + ControllerName);
}
return(View(data));
}
public void Firstnewsletter(NewsLetterModel Model)
{
Model.FirstContent = FirstContent.Text;
Model.SecondContent = SecondContent.Text;
Model.ThirldContent = ThirdContent.Text;
string SelectedIds = GetHiddenValue();
if (First_newsletter_Imgfile.PostedFile != null && First_newsletter_Imgfile.PostedFile.FileName != "")
{
var fileExt = Path.GetExtension(First_newsletter_Imgfile.FileName);
string fileName = Guid.NewGuid() + fileExt;
var subPath = Server.MapPath("~/uploadfiles");
//Check SubPath Exist or Not
if (!Directory.Exists(subPath))
{
Directory.CreateDirectory(subPath);
}
//End : Check SubPath Exist or Not
var path = Path.Combine(subPath, fileName);
First_newsletter_Imgfile.SaveAs(path);
var URL = ConfigurationManager.AppSettings["LiveURL"].ToString();
Model.PropertyPhoto = URL + "/uploadfiles/" + fileName;
}
if (First_newsletter_Logo.PostedFile != null && First_newsletter_Logo.PostedFile.FileName != "")
{
//Save the photo in Folder
var fileExt = Path.GetExtension(First_newsletter_Logo.FileName);
string fileName = Guid.NewGuid() + fileExt;
var subPath = Server.MapPath("~/uploadfiles");
//Check SubPath Exist or Not
if (!Directory.Exists(subPath))
{
Directory.CreateDirectory(subPath);
}
//End : Check SubPath Exist or Not
var path = Path.Combine(subPath, fileName);
First_newsletter_Logo.SaveAs(path);
var URL = ConfigurationManager.AppSettings["LiveURL"].ToString();
Model.Logopath = URL + "/uploadfiles/" + fileName;
}
//else
//{
// Model.Logopath = "..http://kamaljitsingh.ca/images/MyLogodd%20-%20Copy.png";
//}
Model.AdminPhoto = "http://kamaljitsingh.ca/images/ajay_shah.jpg";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
DataTable dt = new DataTable();
string str = "select EmailId from [AdminClient] where ID in(" + SelectedIds + ")";
SqlDataAdapter adp = new SqlDataAdapter(str, conn);
adp.Fill(dt);
foreach (DataRow row in dt.Rows)
{
var Email = row["EmailId"].ToString();
Model.Email = Email;
SendNewsLetter(Model);
}
}
public string SendNewsLetter(NewsLetterModel model)
{
if (model.Logopath == null || model.Logopath == "")
{
model.Logopath = "http://kamaljitsingh.ca/images/logo.png";
}
if (model.PropertyPhoto == null || model.PropertyPhoto == "")
{
model.PropertyPhoto = "http://kamaljitsingh.ca/images/img1.png";
}
string Status = "";
// string EmailId = "*****@*****.**";
string msgbody = "";
var Template = "";
if (model.NewsletterType == "First_nwslettr")
{
Template = "Templates/FirstNewsLetter.html";
}
else if (model.NewsletterType == "Second_nwslettr")
{
Template = "Templates/SecondNewsLetter.html";
}
else if (model.NewsletterType == "Thirld_nwslettr")
{
Template = "Templates/ThirldNewsLetter.html";
}
else if (model.NewsletterType == "Fourth_nwslettr")
{
Template = "Templates/FourthNewsLetter.html";
}
else if (model.NewsletterType == "Fifth_nwslettr")
{
Template = "Templates/FifthNewLetter.html";
}
else if (model.NewsletterType == "Sixth_nwslettr")
{
Template = "Templates/SixNewLetter.html";
}
else if (model.NewsletterType == "Seventh_nwslettr")
{
Template = "Templates/SeventhNewsLetter.html";
}
else if (model.NewsletterType == "Eighth_nwslettr")
{
Template = "Templates/EighthNewsLetter.html";
}
else if (model.NewsletterType == "Ninth_nwslettr")
{
Template = "Templates/NinthNewsLetter.html";
}
else if (model.NewsletterType == "Tenth_nwslettr")
{
Template = "Templates/TenthNewsLetter.html";
}
else if (model.NewsletterType == "Eleventh_nwslettr")
{
Template = "Templates/EleventhNewsLetter.html";
}
else if (model.NewsletterType == "Twelveth_nwslettr")
{
Template = "Templates/TwelvethNewsLetter.html";
}
else if (model.NewsletterType == "Thirteenth_nwslettr")
{
Template = "Templates/ThirteenthNewsLetter.html";
}
else if (model.NewsletterType == "Fourteenth_nwslettr")
{
Template = "Templates/FourteenthNewsLetter.html";
}
else if (model.NewsletterType == "Fifteenth_nwslettr")
{
Template = "Templates/FifteenthNewsLetter.html";
}
else if (model.NewsletterType == "Sixteenth_nwslettr")
{
Template = "Templates/SixteenthNewsLetter.html";
}
else if (model.NewsletterType == "Seventeenth_nwslettr")
{
Template = "Templates/SeventeenthNewsLetter.html";
}
else if (model.NewsletterType == "Eightteenth_nwslettr")
{
Template = "Templates/EightteenthNewsLetter.html";
}
else if (model.NewsletterType == "Ninteenth_nwslettr")
{
Template = "Templates/NinteenthNewsLetter.html";
}
else if (model.NewsletterType == "Twentieth_nwslettr")
{
Template = "Templates/TwentiethNewsLetter.html";
}
else if (model.NewsletterType == "TwentyOne_nwslettr")
{
Template = "Templates/TwentyOneNewsLetter.html";
}
using (StreamReader reader = new StreamReader(Path.Combine(HttpRuntime.AppDomainAppPath, Template)))
{
msgbody = reader.ReadToEnd();
//Replace UserName and Other variables available in body Stream
msgbody = msgbody.Replace("{PropertyPhoto}", model.PropertyPhoto);
msgbody = msgbody.Replace("{logopath}", model.Logopath);
msgbody = msgbody.Replace("{FirstContent}", model.FirstContent);
msgbody = msgbody.Replace("{SecondContent}", model.SecondContent);
msgbody = msgbody.Replace("{ThirdContent}", model.ThirldContent);
}
//Send mail
MailMessage mail = new MailMessage();
string FromEmailID = WebConfigurationManager.AppSettings["RegFromMailAddress"];
string FromEmailPassword = WebConfigurationManager.AppSettings["RegPassword"];
SmtpClient smtpClient = new SmtpClient(ConfigurationManager.AppSettings["SmtpServer"]);
int _Port = Convert.ToInt32(WebConfigurationManager.AppSettings["Port"].ToString());
Boolean _UseDefaultCredentials = Convert.ToBoolean(WebConfigurationManager.AppSettings["UseDefaultCredentials"].ToString());
Boolean _EnableSsl = Convert.ToBoolean(WebConfigurationManager.AppSettings["EnableSsl"].ToString());
mail.To.Add(new MailAddress(model.Email));
mail.From = new MailAddress(FromEmailID);
mail.Subject = "News Letter";
mail.BodyEncoding = System.Text.Encoding.UTF8;
mail.SubjectEncoding = System.Text.Encoding.UTF8;
System.Net.Mail.AlternateView plainView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(System.Text.RegularExpressions.Regex.Replace(msgbody, @"<(.|\n)*?>", string.Empty), null, "text/plain");
System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(msgbody, null, "text/html");
mail.AlternateViews.Add(plainView);
mail.AlternateViews.Add(htmlView);
// mail.Body = msgbody;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Host = "smtp.gmail.com"; //_Host;
smtp.Port = _Port;
//smtp.UseDefaultCredentials = _UseDefaultCredentials;
smtp.Credentials = new System.Net.NetworkCredential(FromEmailID, FromEmailPassword);// Enter senders User name and password
smtp.EnableSsl = _EnableSsl;
smtp.Send(mail);
return(Status);
}
public IHttpActionResult EditNewsletter([FromBody] NewsLetterModel NewsLetterModel)
{
var reurnNewsletter = _NewsletterFacade.EditNewsletter(Mapper.Map <NewsLetterDto>(NewsLetterModel), UserId, TenantId);
return(Ok(reurnNewsletter));
}
public bool SendNewsLetter(NewsLetterModel model)
{
bool Status = false;
// string EmailId = "*****@*****.**";
var FirstImage = "";
var SecondImage = "";
var Images = model.PropertyPhoto.Split(',');
if (Images.Count() > 0)
{
FirstImage = Images[0];
if (Images.Count() > 1)
{
SecondImage = Images[1];
}
}
else
{
FirstImage = model.PropertyPhoto;
}
string msgbody = "";
var Template = "";
Template = "Templates/Double_Image_NewsLetter.html";
using (StreamReader reader = new StreamReader(Path.Combine(HttpRuntime.AppDomainAppPath, Template)))
{
msgbody = reader.ReadToEnd();
//Replace UserName and Other variables available in body Stream
msgbody = msgbody.Replace("{firstimage}", FirstImage);
msgbody = msgbody.Replace("{secondimage}", SecondImage);
}
try
{
//Send mail
MailMessage mail = new MailMessage();
string FromEmailID = WebConfigurationManager.AppSettings["RegFromMailAddress"];
string FromEmailPassword = WebConfigurationManager.AppSettings["RegPassword"];
SmtpClient smtpClient = new SmtpClient(ConfigurationManager.AppSettings["SmtpServer"]);
int _Port = Convert.ToInt32(WebConfigurationManager.AppSettings["Port"].ToString());
Boolean _UseDefaultCredentials = Convert.ToBoolean(WebConfigurationManager.AppSettings["UseDefaultCredentials"].ToString());
Boolean _EnableSsl = Convert.ToBoolean(WebConfigurationManager.AppSettings["EnableSsl"].ToString());
mail.To.Add(new MailAddress(model.Email));
mail.From = new MailAddress(FromEmailID);
mail.Subject = "News Letter";
mail.BodyEncoding = System.Text.Encoding.UTF8;
mail.SubjectEncoding = System.Text.Encoding.UTF8;
System.Net.Mail.AlternateView plainView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(System.Text.RegularExpressions.Regex.Replace(msgbody, @"<(.|\n)*?>", string.Empty), null, "text/plain");
System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(msgbody, null, "text/html");
mail.AlternateViews.Add(plainView);
mail.AlternateViews.Add(htmlView);
// mail.Body = msgbody;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Host = "smtp.gmail.com"; //_Host;
smtp.Port = _Port;
//smtp.UseDefaultCredentials = _UseDefaultCredentials;
smtp.Credentials = new System.Net.NetworkCredential(FromEmailID, FromEmailPassword);// Enter senders User name and password
smtp.EnableSsl = _EnableSsl;
smtp.Send(mail);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
NewsLetterModel Model = new NewsLetterModel();
Model.FirstContent = FirstContent.Text;
Model.SecondContent = SecondContent.Text;
Model.ThirldContent = ThirdContent.Text;
string SelectedIds = GetHiddenValue();
if (Imgfile.PostedFile != null && Imgfile.PostedFile.FileName != "")
{
var fileExt = Path.GetExtension(Imgfile.FileName);
string fileName = Guid.NewGuid() + fileExt;
var subPath = Server.MapPath("~/uploadfiles");
//Check SubPath Exist or Not
if (!Directory.Exists(subPath))
{
Directory.CreateDirectory(subPath);
}
//End : Check SubPath Exist or Not
var path = Path.Combine(subPath, fileName);
Imgfile.SaveAs(path);
var URL = ConfigurationManager.AppSettings["LocalURL"].ToString();
Model.PropertyPhoto = URL + "/uploadfiles/" + fileName;
}
//else
//{
// Model.PropertyPhoto = "../NewsLetterImages/img1F.jpg";
//}
if (Logofile.PostedFile != null && Logofile.PostedFile.FileName != "")
{
//Save the photo in Folder
var fileExt = Path.GetExtension(Logofile.FileName);
string fileName = Guid.NewGuid() + fileExt;
var subPath = Server.MapPath("~/uploadfiles");
//Check SubPath Exist or Not
if (!Directory.Exists(subPath))
{
Directory.CreateDirectory(subPath);
}
//End : Check SubPath Exist or Not
var path = Path.Combine(subPath, fileName);
Logofile.SaveAs(path);
var URL = ConfigurationManager.AppSettings["LocalURL"].ToString();
Model.Logopath = URL + "/uploadfiles/" + fileName;
}
//else
//{
// Model.Logopath = "../images/MyLogodd%20-%20Copy.png";
//}
Model.AdminPhoto = "../images/client_img.jpg";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
DataTable dt = new DataTable();
string str = "select EmailId from [AdminClient] where ID in(" + SelectedIds + ")";
SqlDataAdapter adp = new SqlDataAdapter(str, conn);
adp.Fill(dt);
foreach (DataRow row in dt.Rows)
{
var Email = row["EmailId"].ToString();
Model.Email = Email;
SendNewsLetter(Model);
}
// }
Response.Redirect("~/Admin/NewsLetter.aspx", false);
}
catch (Exception ex)
{
//throw ex;
}
}
