protected String getHTMLCode()
{
try
{
int eventId = int.Parse(Session["eventId"].ToString());
int groupId = int.Parse(Session["GroupId"].ToString());
int UserID = getUserLogin().UserId;
string requireTime = Session["RequireTime"]+"";
eventBus = new EventBUS();
DataTable tblEvent = eventBus.GetByID(eventId);
String visibleField = "";
String rowVisible = "";
Hashtable htVisibleField = getVisibleField();
foreach (DictionaryEntry entry in htVisibleField)
{
visibleField += entry.Key+" ";
rowVisible += "<tr>\n";
rowVisible += String.Format("<td>{0}</td>\n", entry.Value);
rowVisible +="</tr>";
rowVisible += "<tr>\n";
rowVisible += String.Format("<td><input name=\"{0}\" id=\"{0}\" type=\"text\" size=\"40\" /></td>\n", entry.Key);
rowVisible += "</tr>";
}
rowVisible += "<tr align=\"center\">\n";
rowVisible += "<td><input name=\"btnSubmit\" id=\"btnSubmit\" type=\"submit\" value=\"Đăng ký\" /></td>\n";
rowVisible += "</tr>\n";
String rs = "";
rs += "<form id=\"form1\" method=\"post\" action=\"http://emailmarketing.1onlinebusinesssystem.com/webapp/page/backend/register-event.aspx\" accept-charset=\"UTF-8\">\n";
//rs += "<form id=\"form1\" method=\"post\" action=\"http://localhost:40025/FAMail_Back/webapp/page/backend/register-event.aspx\" accept-charset=\"UTF-8\">\n";
rs += String.Format("<input name=\"UserId\" id=\"UserId\" type=\"hidden\" value=\"{0}\" />\n", UserID);
rs += String.Format("<input name=\"eventId\" id=\"eventId\" type=\"hidden\" value=\"{0}\" />\n", eventId);
rs += String.Format("<input name=\"visibleField\" id=\"visibleField\" type=\"hidden\" value=\"{0}\" />\n", visibleField.Trim());
rs += String.Format("<input name=\"groupId\" id=\"groupId\" type=\"hidden\" value=\"{0}\" />\n", groupId);
rs += String.Format("<input name=\"startDate\" id=\"startDate\" type=\"hidden\" value=\"{0}\" />\n", tblEvent.Rows[0]["StartDate"]);
rs += String.Format("<input name=\"endDate\" id=\"endDate\" type=\"hidden\" value=\"{0}\" />\n", tblEvent.Rows[0]["EndDate"]);
rs += String.Format("<input name=\"requireTime\" id=\"requireTime\" type=\"hidden\" value=\"{0}\" />\n", requireTime.Trim());
rs += "<table>\n";
rs += rowVisible;
rs += "</table>\n";
rs += "</form>\n";
return rs;
}
catch (Exception)
{
return null;
}
}
private void loadData()
{
eventDetailBus = new EventDetailBUS();
eventBus = new EventBUS();
try
{
DataTable dtEvent = new DataTable();
if (Session["us-login"] != null)
{
//if (getUserLogin().DepartmentId == 1)
//{
// dtEvent = eventBus.GetAll();
//}
//else
//{
dtEvent = eventBus.GetByUserId(getUserLogin().UserId);
//}
if (dtEvent.Rows.Count > 0)
{
createTableMail();
DataRow rowE = null;
if (getUserLogin().DepartmentId == 1)
{
rowE = group.NewRow();
rowE["EventId"] = 0;
rowE["Subject"] = "Tất cả";
group.Rows.Add(rowE);
}
foreach (DataRow rowItem in dtEvent.Rows)
{
rowE = group.NewRow();
rowE["EventId"] = rowItem["EventId"];
rowE["Subject"] = rowItem["Subject"];
group.Rows.Add(rowE);
}
} //DataRow dr = group.NewRow();
//dr["Subject"] = "---------------[Tất cả]-----------------";
//dr["EventId"] = "-1";
//group.Rows.InsertAt(dr, 0);
this.drlNhomMail.DataSource = group;
this.drlNhomMail.DataTextField = "Subject";
this.drlNhomMail.DataValueField = "EventId";
this.drlNhomMail.DataBind();
object obj = Request.QueryString["id"];
int eventId = 0;
if (int.TryParse(obj + "", out eventId))
{
if (group.Select("eventid=" + eventId).Count() > 0)
drlNhomMail.SelectedValue = eventId + "";
}
}
}
catch (Exception ex)
{
logs.Error(userLogin.Username + "-eventreport - LoadData", ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string eventId, name, email, company, phone, secondPhone, address1,
address2, city, province, country, zipcode, fax, groupId,
visibleField, gender, requireTime, UserID, Job;
eventId = Request.Params["eventId"];
name = Request.Params["Name"];
if (name == null || name == "")
{
name = "";
}
email = Request.Params["Email"];
if (email == null || email == "")
{
Session["Error"] = "Vui lòng kiểm tra lại thông tin đăng ký !";
Response.Redirect("event-register-error.aspx", false);
return;
}
gender = Request.Params["Gender"];
if (gender == null || gender == "")
{
gender = "Nam";
}
Job = Request.Params["Job"];
if (Job == null || Job == "")
{
Job = "";
}
company = Request.Params["Company"];
if (company == null || company == "")
{
company = "";
}
phone = Request.Params["Phone"];
if (phone == null || phone == "")
{
phone = "";
}
secondPhone = Request.Params["SecondPhone"];
if (secondPhone == null || secondPhone == "")
{
secondPhone = "";
}
address1 = Request.Params["Address1"];
if (address1 == null || address1 == "")
{
address1 = "";
}
address2 = Request.Params["Address2"];
if (address2 == null || address2 == "")
{
address2 = "";
}
city = Request.Params["City"];
if (city == null || city == "")
{
city = "";
}
province = Request.Params["Province"];
if (province == null || province == "")
{
province = "";
}
country = Request.Params["Country"];
if (country == null || country == "")
{
country = "";
}
zipcode = Request.Params["ZipCode"];
if (zipcode == null || zipcode == "")
{
zipcode = "";
}
fax = Request.Params["Fax"];
if (fax == null || fax == "")
{
fax = "";
}
requireTime = Request.Params["requireTime"];
groupId = Request.Params["groupId"];
UserID = Request.Params["UserID"];
//startDate = Request.Params["startDate"];
//endDate = Request.Params["endDate"];
visibleField = Request.Params["visibleField"];
string[] arrVisible = visibleField.Trim().Split(' ');
eventDetailBus = new EventDetailBUS();
eventBus = new EventBUS();
EventDetailDTO eventDetailDto = new EventDetailDTO();
eventDetailDto.EventId = int.Parse(eventId);
eventDetailDto.FullName = name;
eventDetailDto.EmailID = email;
eventDetailDto.Job = Job;
eventDetailDto.Company = company;
eventDetailDto.Phone = phone;
eventDetailDto.SecondPhone = secondPhone;
eventDetailDto.Address = address1;
eventDetailDto.Address2 = address2;
eventDetailDto.City = city;
eventDetailDto.Province = province;
eventDetailDto.Country = country;
eventDetailDto.ZipCode = zipcode;
eventDetailDto.Fax = fax;
eventDetailDto.CreateDate = DateTime.Now;
eventDetailDto.GroupId = int.Parse(groupId);
eventDetailDto.CountReceivedMail = 0;
eventDetailDto.LastReceivedMail = DateTime.Now;
// Kiem tra dieu kien
// Check thời gian của sự kiện
DataTable tblEvent = eventBus.GetByID(int.Parse(eventId));
if (tblEvent.Rows.Count > 0)
{
if (requireTime.Equals("true"))
{
if (DateTime.Parse(tblEvent.Rows[0]["StartDate"].ToString()) <= DateTime.Now
&& DateTime.Now <= DateTime.Parse(tblEvent.Rows[0]["EndDate"].ToString()))
{
}
else
{
Session["Error"] = "Thời hạn đăng ký đã hết, vui lòng chờ sự kiện kế tiếp. Cảm ơn !";
Response.Redirect("event-register-error.aspx", false);
return;
}
}
}
// Mot email chi dang ky duoc mot event
DataTable checkEmail = eventDetailBus.GetByIdAndEmail(int.Parse(eventId), email);
if (checkEmail.Rows.Count > 0)
{
Session["Error"] = "Email đã được sử dụng. Vui lòng chọn email khác !";
Response.Redirect("event-register-error.aspx", false);
return;
}
// Gui mail
// Lay thong tin event
eventBus = new EventBUS();
DataTable tbEvent = eventBus.GetByID(int.Parse(eventId));
//get mail config
if (tbEvent.Rows.Count > 0)
{
DataRow rEvent = tbEvent.Rows[0];
mailConfigBus = new MailConfigBUS();
DataTable tbMailConfig = mailConfigBus.GetByID(int.Parse(tbEvent.Rows[0]["ConfigId"].ToString()));
// Them khach hang vao bang event detail
eventDetailBus.tblEventDetail_insert(eventDetailDto);
try
{
// Them khach hang vao danh sach khach hang
customerBus = new CustomerBUS();
DataTable tblCustomer = customerBus.GetByEmail(email, int.Parse(UserID));
int customerId = 0;
if (tblCustomer.Rows.Count == 0)
{
CustomerDTO customerDto = new CustomerDTO();
customerDto.Name = name;
customerDto.Gender = gender;
customerDto.BirthDay = DateTime.Now;
customerDto.Email = email;
customerDto.Phone = phone;
customerDto.SecondPhone = secondPhone;
customerDto.Address = address1;
customerDto.Fax = fax;
customerDto.Company = company;
customerDto.Job = Job;
customerDto.City = city;
customerDto.Province = province;
customerDto.Country = country;
customerDto.Type = "0";
customerDto.UserID = int.Parse(UserID);
customerDto.createBy = int.Parse(UserID);
customerDto.AssignTo = int.Parse(UserID);
customerId = customerBus.tblCustomer_insert(customerDto);
this.SendMail(customerDto);
logs_info.Info("Email Register: " + email);
}
else
{
customerId = int.Parse(tblCustomer.Rows[0]["Id"].ToString());
}
// Them khach hang vao detail group.
dgBus = new DetailGroupBUS();
DataTable tblDetailGroup = dgBus.GetByID(int.Parse(groupId), customerId);
if (tblDetailGroup.Rows.Count <= 0)
{
DetailGroupDTO dgDto = new DetailGroupDTO();
dgDto.GroupID = int.Parse(groupId);
dgDto.CustomerID = customerId;
dgDto.CountReceivedMail = 0;
dgDto.LastReceivedMail = DateTime.Now;
dgBus.tblDetailGroup_insert(dgDto);
}
eventBus.tblEventCustomer_Insert(customerId, eventId);
}
catch (Exception)
{
}
if (tbMailConfig.Rows.Count > 0)
{
DataRow rConfig = tbMailConfig.Rows[0];
ProcessSendEmail process = new ProcessSendEmail();
// Xu ly them loi chao trong noi dung mail
string body = rEvent["Body"].ToString();
string welcome = (name == "" || name == null) ? email : name;
// Replace with [khachhang] or [email]
body = body.Replace("[khachhang]", welcome);
body = body.Replace("[email]", email);
bool rsSend = true;
//rsSend = process.SendMail(rEvent["Subject"].ToString(),
// body, rConfig["Server"].ToString(), int.Parse(rConfig["Port"].ToString()),
// rConfig["Email"].ToString(), rConfig["Password"].ToString(), rConfig["Name"].ToString(),
// email, rConfig["username"].ToString(),bool.Parse(rConfig["isSSL"].ToString()));
if (rsSend)
{
// chuyen den trang success
string url = rEvent["ResponeUrl"].ToString();
if (url.Equals("Default"))
{
Response.Redirect("event-register-success.aspx", false);
}
else
{
Response.Redirect(url, false);
}
}
else
{
Session["Error"] = "Bạn đã đăng ký không thành công.";
Response.Redirect("event-register-error.aspx", false);
}
}
else
{
Session["Error"] = "Bạn đã đăng ký không thành công.";
Response.Redirect("event-register-error.aspx", false);
}
}
}
catch (Exception ex)
{
Session["Error"] = "Một số lỗi hệ thống đã xảy ra. Vui lòng kiểm tra lại thông tin !\n" + ex.Message;
Response.Redirect("event-register-error.aspx");
}
}
private void SendMail(CustomerDTO customerDto)
{
string eventId = Request.Params["eventId"];
DataTable T = new EventBUS().GetByID(Convert.ToInt32(eventId));
if (T != null && T.Rows.Count > 0)
{
DataTable user = new UserLoginBUS().GetByUserId(Convert.ToInt32(T.Rows[0]["userid"] + ""));
SmtpClient SmtpServer = new SmtpClient();
SmtpServer.Credentials = new System.Net.NetworkCredential("AKIAIGXHHO72FHXGCPFQ", "Ara8HV/kcfjNU+rqrTpJBAAjs/OsD1xEykLsuguqpe1Z");
SmtpServer.Port = 25;
SmtpServer.Host = "email-smtp.us-east-1.amazonaws.com";
SmtpServer.EnableSsl = true;
MailMessage mail = new MailMessage();
//String[] addr = user.Rows[0]["username"].Split(' ');
mail.From = new MailAddress("*****@*****.**",
" Hệ Thống eMailMaketing ", System.Text.Encoding.UTF8);
//Byte i;
//for (i = 0; i < addr.Length; i++)
mail.To.Add(user.Rows[0]["username"]+"");
mail.Subject = "Thư xác nhận";
mail.IsBodyHtml = true;
mail.Body = @"<html>
<head>
<title></title>
</head>
<body style=margin: 0px 0px 0px 0px>
<h3>Chào {0} thân mến!</h3>
Đã có khách hàng đăng ký nhận mail cho sự kiện '{6}' với thông tin như sau:
<br />
Họ tên: {1}
<br />
Địa chỉ email: {2}
<br />
Giới tính: {3}
<br />
Địa chỉ: {4}
<br />
Công ty: {5}
</body>
</html>
";
mail.Body = string.Format(mail.Body, user.Rows[0]["username"] + "", customerDto.Name, customerDto.Email, customerDto.Gender, customerDto.Address, customerDto.Country,T.Rows[0]["subject"]);
mail.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
mail.ReplyTo = new MailAddress(user.Rows[0]["username"] + "");
SmtpServer.Send(mail);
}
}
private void InitialBUS()
{
mailConfigBus = new MailConfigBUS();
mailGroupBus = new MailGroupBUS();
eventBus = new EventBUS();
}
private void event_worker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
EmailSend mailSend = new EmailSend();
DetailGroupBUS dgBus = new DetailGroupBUS();
ContentSendEventBUS cseBus = new ContentSendEventBUS();
SendContentBUS scBus = new SendContentBUS();
EventBUS eventBUS = new EventBUS();
DataTable tblSendList = dgBus.getGroupListByEventList();
if (tblSendList.Rows.Count > 0)
{
List<SendMailDTO> sendList = mailSend.convetToSendMail(tblSendList);
int totalCnt = sendList.Count;
foreach (SendMailDTO sendItem in sendList)
{
int eventId = sendItem.eventId;
DataTable dtContentSendEvent = cseBus.GetByEventId(eventId);
if (dtContentSendEvent.Rows.Count > 0)
{
if (sendItem.countReceivedMail == 0
&& sendItem.lastReceivedMail == "") // Gui lan dau
{
int id = int.Parse(dtContentSendEvent.Rows[0]["id"].ToString());
int contentId = int.Parse(dtContentSendEvent.Rows[0]["ContentId"].ToString());
int hourSend = int.Parse(dtContentSendEvent.Rows[0]["HourSend"].ToString());
DataTable dtSendContent = scBus.GetByID(contentId);
subject = dtContentSendEvent.Rows[0]["Subject"].ToString();
body = dtContentSendEvent.Rows[0]["Body"].ToString();
bool sendRs = false;
// Send normal.
bool send = sendMail(sendRs, sendItem.port, sendItem.hostName, sendItem.userSmtp, sendItem.passSmtp, sendItem.mailFrom, sendItem.senderName,
subject, body, sendItem.recieveName, sendItem.mailTo, 0, id);
logs_info.Info("Status: " + send + ", sendRegisterId:" + sendRegisterId + ", MailTo: " + sendItem.mailTo + ", mailFrom: " + mailFrom + ", Name: " + sendItem.recieveName);
// Update tblDetailGroup.
DetailGroupDTO dgDto = new DetailGroupDTO();
dgDto.CustomerID = sendItem.customerId;
dgDto.GroupID = sendItem.groupId;
dgDto.CountReceivedMail = sendItem.countReceivedMail + 1;
dgDto.LastReceivedMail = DateTime.Now;
dgBus.tblDetailGroup_Update(dgDto);
eventBUS.tblEventCustomer_Update(eventId, sendItem.customerId, sendItem.countReceivedMail + 1);
logHistoryForSendEvent(id, sendItem.mailTo, mailFrom, sendItem.recieveName, send);
}
else if (sendItem.countReceivedMail < dtContentSendEvent.Rows.Count)
{
string strReceivedMail = sendItem.lastReceivedMail;
DateTime lastReceivedMail = DateTime.Now;
if (strReceivedMail != "")
{
lastReceivedMail = DateTime.Parse(strReceivedMail);
}
int hourSend = int.Parse(dtContentSendEvent.Rows[sendItem.countReceivedMail]["HourSend"].ToString());
DateTime currentTime = lastReceivedMail.AddHours(hourSend);
TimeSpan time = currentTime - DateTime.Now;
/*if (DateTime.Now.Year == currentTime.Year
&& DateTime.Now.Month == currentTime.Month
&& DateTime.Now.Day == currentTime.Day
&& DateTime.Now.Hour == currentTime.Hour
&& DateTime.Now.Minute == currentTime.Minute)*/
if (time.Days < 0 || time.Hours < 0 || time.Minutes < 0 || time.Seconds < 0)
{
int contentId = int.Parse(dtContentSendEvent.Rows[sendItem.countReceivedMail]["ContentId"].ToString());
//DataTable dtSendContent = scBus.GetByID(contentId);
//if (dtSendContent.Rows.Count > 0)
//{
// subject = dtSendContent.Rows[0]["Subject"].ToString();
// body = dtSendContent.Rows[0]["Body"].ToString();
//}
subject = dtContentSendEvent.Select("hoursend=" + hourSend)[0]["Subject"].ToString();
body = dtContentSendEvent.Select("hoursend=" + hourSend)[0]["Body"].ToString();
int id = Convert.ToInt32(dtContentSendEvent.Select("hoursend=" + hourSend)[0]["id"] + "");
bool sendRs = false;
// Send normal.
bool send = sendMail(sendRs, sendItem.port, sendItem.hostName, sendItem.userSmtp, sendItem.passSmtp, sendItem.mailFrom, sendItem.senderName,
subject, body, sendItem.recieveName, sendItem.mailTo, 0, id);
logHistoryForSendEvent(id, sendItem.mailTo, mailFrom, sendItem.recieveName, send);
logs_info.Info("Status: " + send + ", sendRegisterId:" + sendRegisterId + ", MailTo: " + sendItem.mailTo + ", mailFrom: " + mailFrom + ", Name: " + sendItem.recieveName);
// Update tblDetailGroup.
DetailGroupDTO dgDto = new DetailGroupDTO();
dgDto.CustomerID = sendItem.customerId;
dgDto.GroupID = sendItem.groupId;
dgDto.CountReceivedMail = sendItem.countReceivedMail + 1;
dgDto.LastReceivedMail = DateTime.Now;
dgBus.tblDetailGroup_Update(dgDto);
eventBUS.tblEventCustomer_Update(eventId, sendItem.customerId, sendItem.countReceivedMail + 1);
}
}
}
}// End forEach.
}
}
catch (Exception ex)
{
logs.Error("timer2_tick", ex);
}
}