protected void drlCampaign_SelectedIndexChanged(object sender, EventArgs e) { int readMail = 0; try { srBUS = new SendRegisterBUS(); srdBus = new SendRegisterDetailBUS(); sendContentBus = new SendContentBUS(); mgBus = new MailGroupBUS(); int sendId = int.Parse(drlCampaign.SelectedValue.ToString()); DataTable campain = srdBus.GetByID(sendId); DataTable errSend = srdBus.GetByStatus(false, sendId); DataTable unreceve = srdBus.GetByNotReceve(sendId); int err = errSend.Rows.Count; this.lblTotalMailSend.Text = campain.Rows.Count.ToString(); int notreceve = unreceve.Rows.Count; lblEmailSend.Text = new MailConfigBUS().GetByID(int.Parse(srBUS.GetByID(sendId).Rows[0]["mailconfigid"]+"")).Rows[0]["eMail"].ToString(); if (campain.Rows.Count > 0) { foreach (DataRow row in campain.Rows) { if (row["isOpenMail"].ToString() == "True") { readMail++; } } lblNotOpen2.Text = (campain.Rows.Count - readMail).ToString(); } lblNotOpen2.Text = "0"; lblOpened.Text = readMail.ToString(); DataTable sendregisteDetail = srBUS.GetByID(sendId); if (sendregisteDetail.Rows.Count > 0) { int contentID = int.Parse(sendregisteDetail.Rows[0]["SendContentId"].ToString()); lblDateStart.Text = sendregisteDetail.Rows[0]["StartDate"].ToString(); lblDateEnd.Text = sendregisteDetail.Rows[0]["EndDate"].ToString(); int groupSend = int.Parse(sendregisteDetail.Rows[0]["GroupTo"].ToString()); if (groupSend == -3) lblGroupEmailTo.Text = "Tất cả"; else lblGroupEmailTo.Text = mgBus.GetByID(groupSend).Rows[0]["Name"].ToString(); if (sendContentBus.GetByID(contentID).Rows.Count > 0) { lblCampianName.Text = sendContentBus.GetByID(contentID).Rows[0]["Subject"].ToString(); } } if (campain.Rows.Count > 0) CreateChart(campain.Rows.Count, err, readMail, 1, notreceve, lblCampianName.Text); else lblChart.Text = ""; LoadOpenEmail(sendId); } catch (Exception ex) { //pnError.Visible = true; //lblError.Text = ex.Message; } }
protected void loadListContentHasSend() { try { int groupId = int.Parse(Request.Params["groupId"]); PartSendBUS psBus = new PartSendBUS(); SendContentBUS scBus = new SendContentBUS(); MailGroupBUS mgBus = new MailGroupBUS(); DataTable tblPartSend = psBus.GetByUserIdAndGroupId(getUserLogin().UserId, groupId); if (tblPartSend.Rows.Count > 0) { string hasContentSend = tblPartSend.Rows[0]["hasContentSend"].ToString(); string[] arrayContentSend = hasContentSend.Split(','); dlContentList.DataSource = arrayContentSend; dlContentList.DataBind(); for (int i = 0; i < arrayContentSend.Length; i++) { Label lblSubject = (Label)dlContentList.Items[i].FindControl("lblSubject"); Label lblContent = (Label)dlContentList.Items[i].FindControl("lblContent"); string contentId = arrayContentSend[i]; DataTable tblContent = scBus.GetByID(int.Parse(contentId)); if (tblContent.Rows.Count > 0) { lblSubject.Text = tblContent.Rows[0]["Subject"].ToString(); lblContent.Text = tblContent.Rows[0]["Body"].ToString(); } } } DataTable tblMailGroup = mgBus.GetByID(groupId); if (tblMailGroup.Rows.Count > 0) { lblGroupName.Text = tblMailGroup.Rows[0]["Name"].ToString(); } } catch (Exception) { throw; } }
protected string LoadChart(object id) { int readMail = 0; try { //int i=0; for (int i = 0; i < dlContentSendEvent.Items.Count; i++) { HiddenField hdfId = (HiddenField)dlContentSendEvent.Items[i].FindControl("hdfId"); if (hdfId.Value + "" == id + "") { SendRegisterBUS srBUS = new SendRegisterBUS(); SendRegisterDetailBUS srdBus = new SendRegisterDetailBUS(); SendContentBUS sendContentBus = new SendContentBUS(); MailGroupBUS mgBus = new MailGroupBUS(); int sendId = int.Parse(id + ""); DataTable campain = srdBus.GetByContentID(sendId); DataTable errSend = srdBus.GetContentSendEventDetailByStatus(false, sendId); DataTable unreceve = srdBus.GetByNotReceve(sendId); int err = errSend.Rows.Count; Label lblTotalMailSend = (Label)dlContentSendEvent.Items[i].FindControl("lblTotalMailSend"); Label lblEmailSend = (Label)dlContentSendEvent.Items[i].FindControl("lblEmailSend"); Label lblNotOpen2 = (Label)dlContentSendEvent.Items[i].FindControl("lblNotOpen2"); Label lblOpened = (Label)dlContentSendEvent.Items[i].FindControl("lblOpened"); Label lblDateStart = (Label)dlContentSendEvent.Items[i].FindControl("lblDateStart"); Label lblDateEnd = (Label)dlContentSendEvent.Items[i].FindControl("lblDateEnd"); Label lblGroupEmailTo = (Label)dlContentSendEvent.Items[i].FindControl("lblGroupEmailTo"); Label lblCampianName = (Label)dlContentSendEvent.Items[i].FindControl("lblCampianName"); Label lblChart = (Label)dlContentSendEvent.Items[i].FindControl("lblChart"); lblTotalMailSend.Text = campain.Rows.Count.ToString(); int notreceve = unreceve.Rows.Count; if (campain.Rows.Count > 0) { lblEmailSend.Text = campain.Rows[0]["MailSend"].ToString(); foreach (DataRow row in campain.Rows) { if (row["isOpenMail"].ToString() == "True") { readMail++; } } lblNotOpen2.Text = (campain.Rows.Count - readMail).ToString(); } lblOpened.Text = readMail.ToString(); DataTable sendregisteDetail = cseBus.GetById(sendId); if (sendregisteDetail.Rows.Count > 0) { int contentID = int.Parse(sendregisteDetail.Rows[0]["id"].ToString()); //lblDateStart.Text = sendregisteDetail.Rows[0]["StartDate"].ToString(); //lblDateEnd.Text = sendregisteDetail.Rows[0]["EndDate"].ToString(); int groupSend = int.Parse(sendregisteDetail.Rows[0]["GroupTo"].ToString()); if (groupSend == -3) lblGroupEmailTo.Text = "Tất cả"; else lblGroupEmailTo.Text = mgBus.GetByID(groupSend).Rows[0]["Name"].ToString(); if (sendContentBus.GetByID(contentID).Rows.Count > 0) { lblCampianName.Text = sendContentBus.GetByID(contentID).Rows[0]["Subject"].ToString(); } } CreateChart(campain.Rows.Count, err, readMail, 1, notreceve, lblCampianName.Text, lblChart); } } } catch (Exception ex) { pnError.Visible = true; lblError.Text = ex.Message; } return ""; }
protected void getRegisterSendList() { try { cateBUs = new CategoryBUS(); srBUS = new SendRegisterBUS(); srdBus = new SendRegisterDetailBUS(); mailConfigBus = new MailConfigBUS(); mailGroupBus = new MailGroupBUS(); sendContentBus = new SendContentBUS(); dsgBus = new DetailGroupBUS(); UserLoginDTO userLogin = getUserLogin(); DataTable tblSendRegister = new DataTable(); if (userLogin.DepartmentId == 1) { tblSendRegister = srBUS.GetAll(); } else { tblSendRegister = srBUS.GetAll(userLogin.UserId); } if (tblSendRegister.Rows.Count > 0) { dlWaitSend.DataSource = tblSendRegister; dlWaitSend.DataBind(); for (int i = 0; i < tblSendRegister.Rows.Count; i++) { try { DataRow row = tblSendRegister.Rows[i]; int Sendtype = int.Parse(row["Sendtype"].ToString()); HiddenField hdfId = (HiddenField)dlWaitSend.Items[i].FindControl("hdfId"); hdfId.Value = row["Id"].ToString(); int contentId = int.Parse(row["SendContentId"].ToString()); //DataTable tblContent = sendContentBus.GetByID(contentId); Label lblSubject = (Label)dlWaitSend.Items[i].FindControl("lblSubject"); //if (tblContent.Rows.Count > 0) //{ // lblSubject.Text = tblContent.Rows[0]["Subject"].ToString(); //} //else lblSubject.Text = row["Subject"] + ""; int mailConfig = int.Parse(row["MailConfigID"].ToString()); DataTable tblMailConfig = mailConfigBus.GetByID(mailConfig); if (tblMailConfig.Rows.Count > 0) { Label lblMailConfig = (Label)dlWaitSend.Items[i].FindControl("lblMailConfig"); lblMailConfig.Text = tblMailConfig.Rows[0]["Email"].ToString(); } int groupTo = int.Parse(row["GroupTo"].ToString()); if (groupTo == -3) { Label lblGroupTo = (Label)dlWaitSend.Items[i].FindControl("lblGroupTo"); lblGroupTo.Text = "Tất cả khách hàng"; } else if (groupTo == -2) { Label lblGroupTo = (Label)dlWaitSend.Items[i].FindControl("lblGroupTo"); lblGroupTo.Text = "Nhóm mua nhiều lần"; } else if (groupTo == -1) { Label lblGroupTo = (Label)dlWaitSend.Items[i].FindControl("lblGroupTo"); lblGroupTo.Text = "Nhóm mua lần đầu"; } else { DataTable tblGroupTo = new DataTable(); if (Sendtype == 1) { tblGroupTo = mailGroupBus.GetByID(groupTo); if (tblGroupTo.Rows.Count > 0) { Label lblGroupTo = (Label)dlWaitSend.Items[i].FindControl("lblGroupTo"); lblGroupTo.Text = tblGroupTo.Rows[0]["Name"].ToString(); } } else { tblGroupTo = cateBUs.GetByID(groupTo); if (tblGroupTo.Rows.Count > 0) { Label lblGroupTo = (Label)dlWaitSend.Items[i].FindControl("lblGroupTo"); lblGroupTo.Text = tblGroupTo.Rows[0]["Title"].ToString(); } } } Label lblStartDate = (Label)dlWaitSend.Items[i].FindControl("lblStartDate"); lblStartDate.Text = row["StartDate"].ToString(); Label lblEndDate = (Label)dlWaitSend.Items[i].FindControl("lblEndDate"); int status = int.Parse(row["Status"].ToString()); Panel panel = (Panel)dlWaitSend.Items[i].FindControl("Panel1"); TextBox progressbar = (TextBox)dlWaitSend.Items[i].FindControl("progressbar"); LinkButton lbtDetail = (LinkButton)dlWaitSend.Items[i].FindControl("lbtDetail"); //get list detail DataTable listDetail = srdBus.GetByID(int.Parse(row["Id"].ToString())); int hasSend = 0, sumSend = dsgBus.GetByID(groupTo).Rows.Count; for (int k = 0; k < listDetail.Rows.Count; k++) { hasSend++; } //calc percent has send int percent = 0; if (sumSend != 0) { percent = (hasSend * 100) / sumSend; } if (status == 0) { //display process bar panel.Visible = true; progressbar.BackColor = System.Drawing.Color.Cornsilk; progressbar.Width = percent + 20; progressbar.Text = percent + "%"; lbtDetail.Visible = false; lbtDetail.Text = ""; lblEndDate.Text = "Chưa xác định "; } else { //hidden process bar panel.Visible = false; lbtDetail.Text = "Xem chi tiết"; lbtDetail.PostBackUrl = "reportSend.aspx?campaign-id=" + row["Id"].ToString(); lblEndDate.Text = row["EndDate"].ToString(); } LinkButton lbtDelete = (LinkButton)dlWaitSend.Items[i].FindControl("lbtDelete"); lbtDelete.CommandArgument = row["Id"].ToString(); } catch (Exception) { continue; } } } } catch (Exception) { } }