protected void BindCustomerNotification() { int adviserId = 0; int id = 0; int Count = 0; string usertype = null; hdnCustomerIdWithoutMobileNumber.Value = ""; hdnCustomerNameWithoutMobileNumber.Value = ""; if (hdnCurrentPage.Value.ToString() != "") { // mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString()); hdnCurrentPage.Value = ""; } // DataRow drAdviserCustomerAlert = null; if (Session["UserType"] == "rm") { if (Session["rmVo"] != null) { id = ((RMVo)Session["rmVo"]).RMId; usertype = "rm"; //Session["UserType"] = null; } } else { if (Session["advisorVo"] != null) { id = ((AdvisorVo)Session["advisorVo"]).advisorId; usertype = "adviser"; } } AlertsBo alertsBo = new AlertsBo(); DataTable dtAdviserCustomerAlerts; dsAdviserCustomerAlerts = alertsBo.GetAdviserCustomerSMSAlerts(id, usertype); dtAdviserCustomerAlerts = dsAdviserCustomerAlerts.Tables[0]; if (dtAdviserCustomerAlerts.Rows.Count > 0) { if (Cache["CustomerSIPAlert" + advisorVo.advisorId] == null) { Cache.Insert("CustomerSIPAlert" + advisorVo.advisorId, dtAdviserCustomerAlerts); } else { Cache.Remove("CustomerSIPAlert" + advisorVo.advisorId); Cache.Insert("CustomerSIPAlert" + advisorVo.advisorId, dtAdviserCustomerAlerts); } gvAlertNotification.DataSource = dtAdviserCustomerAlerts; gvAlertNotification.DataBind(); } else { gvAlertNotification.DataSource = dtAdviserCustomerAlerts; gvAlertNotification.DataBind(); } }
public override JobStatus Start(JobParams JP, out string ErrorMsg) { AlertsBo alertBo = new AlertsBo(); alertBo.ExecuteReminderAlert(); alertBo.ExecuteConfirmationAlert(); //alertBo.ExecuteOccurrenceAlert(); //alertBo.ExecuteProcessAlertstoEmailQueue(); ErrorMsg = ""; return(JobStatus.SuccessFull); }
protected void btnUpdateMobileNo_Click(object sender, EventArgs e) { //List<TextBox> txtMobileNoList=(TextBox)gvCustomerSMSAlerts.FindControl("txtMobileNo"); hdnCustomerIdWithoutMobileNumber.Value = ""; AlertsBo alertsBo = new AlertsBo(); string customerId = ""; foreach (GridViewRow gvr in gvCustomerSMSAlerts.Rows) { TextBox txtMobileNo = (TextBox)gvr.FindControl("txtMobileNo"); if (txtMobileNo.Text != "0" && txtMobileNo.Text != null) { customerId = gvCustomerSMSAlerts.DataKeys[gvr.RowIndex].Value.ToString(); alertsBo.UpdateCustomerMobileNumber(int.Parse(customerId), Int64.Parse(txtMobileNo.Text)); hdnCustomerIdWithoutMobileNumber.Value += "1,"; } } }
protected void btnSend_Click(object sender, EventArgs e) { //System.Threading.Thread.Sleep(2000); int smsCount = 0; int smsLicence = 0; SMSVo smsVo = new SMSVo(); List <int> alertIdList = new List <int>(); EmailSMSBo emailSMSBo = new EmailSMSBo(); List <SMSVo> smsVoList = new List <SMSVo>(); AdvisorBo advisorBo = new AdvisorBo(); AlertsBo alertsBo = new AlertsBo(); string mobileNo; int adviserId = 0; dsAdviserCustomerAlerts = (DataSet)ViewState["vsDsAdviserCustomerAlert"]; if (Session["advisorVo"] != null) { adviserId = ((AdvisorVo)Session["advisorVo"]).advisorId; } if (lblLincenceValue.Text != "No SMS Licence Left!!") { smsLicence = int.Parse(lblLincenceValue.Text.ToString()); } int i = 0; if (dsAdviserCustomerAlerts != null) { foreach (GridViewRow gvRow in gvCustomerSMSAlerts.Rows) { if (gvRow.RowType == DataControlRowType.DataRow) { if (((CheckBox)gvRow.FindControl("chkCustomerSMSAlert")).Checked) { smsVo = new SMSVo(); if (dsAdviserCustomerAlerts != null) { mobileNo = dsAdviserCustomerAlerts.Tables[0].Rows[i]["Mobile"].ToString(); if (mobileNo != "0") { if (mobileNo.Length <= 10) { smsVo.Mobile = Int64.Parse("91" + dsAdviserCustomerAlerts.Tables[0].Rows[i]["Mobile"].ToString()); } else { smsVo.Mobile = Int64.Parse(mobileNo); } } } smsVo.Message = CreateSMSMessage(dsAdviserCustomerAlerts.Tables[0].Rows[i]["CustomerName"].ToString(), dsAdviserCustomerAlerts.Tables[0].Rows[i]["Name"].ToString(), dsAdviserCustomerAlerts.Tables[0].Rows[i]["AEL_EventCode"].ToString(), dsAdviserCustomerAlerts.Tables[0].Rows[i]["AEN_EventMessage"].ToString(), advisorVo.OrganizationName); smsVo.CustomerId = int.Parse(gvCustomerSMSAlerts.DataKeys[gvRow.RowIndex].Values["CustomerId"].ToString()); smsVo.IsSent = 0; if (dsAdviserCustomerAlerts.Tables[0].Rows[i]["AlertId"].ToString() != null) { smsVo.AlertId = int.Parse(dsAdviserCustomerAlerts.Tables[0].Rows[i]["AlertId"].ToString()); } else { smsVo.AlertId = 0; } smsVoList.Add(smsVo); alertIdList.Add(int.Parse(gvCustomerSMSAlerts.DataKeys[gvRow.RowIndex].Values["AlertId"].ToString())); smsCount++; } } i++; } if (smsCount <= smsLicence && smsCount != 0) { smsVoList = emailSMSBo.AddToSMSQueue(smsVoList); smsLicence = smsLicence - smsCount; advisorBo.UpdateAdviserSMSLicence(adviserId, smsLicence); advisorBo.AddToAdviserSMSLog(smsVoList, adviserId, "Alert"); alertsBo.UpdateAlertStatus(alertIdList, 1); if (smsLicence == 0) { lblLincenceValue.Text = "No SMS Licence Left!!"; } else { lblLincenceValue.Text = smsLicence.ToString(); GetAdviserCustomerAlerts(out dsAdviserCustomerAlerts); SuccessMessage.Visible = true; } } else if (smsCount == 0) { ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please select an Alert!!');", true); } else { ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('You dont have enough SMS Credits to process this request');", true); } } }
public void GetAdviserCustomerAlerts(out DataSet dsAdviserCustomerAlerts) { int adviserId = 0; int id = 0; int Count = 0; string usertype = null; hdnCustomerIdWithoutMobileNumber.Value = ""; hdnCustomerNameWithoutMobileNumber.Value = ""; if (hdnCurrentPage.Value.ToString() != "") { mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString()); hdnCurrentPage.Value = ""; } DataRow drAdviserCustomerAlert = null; if (Session["UserType"] == "rm") { if (Session["rmVo"] != null) { id = ((RMVo)Session["rmVo"]).RMId; usertype = "rm"; //Session["UserType"] = null; } } else { if (Session["advisorVo"] != null) { id = ((AdvisorVo)Session["advisorVo"]).advisorId; usertype = "adviser"; } } AlertsBo alertsBo = new AlertsBo(); dsAdviserCustomerAlerts = alertsBo.GetAdviserCustomerSMSAlerts(id, usertype, mypager.CurrentPage, hdnNameFilter.Value.Trim(), out Count); ViewState["vsDsAdviserCustomerAlert"] = dsAdviserCustomerAlerts; lblTotalRows.Text = hdnCount.Value = Count.ToString(); if (dsAdviserCustomerAlerts.Tables[0].Rows.Count > 0) { DataTable dtAdviserCustomerAlerts = new DataTable(); dtAdviserCustomerAlerts.Columns.Add("CustomerId"); dtAdviserCustomerAlerts.Columns.Add("AlertId"); dtAdviserCustomerAlerts.Columns.Add("CustomerName"); dtAdviserCustomerAlerts.Columns.Add("Name"); dtAdviserCustomerAlerts.Columns.Add("AlertMessage"); dtAdviserCustomerAlerts.Columns.Add("TimesSMSSent"); dtAdviserCustomerAlerts.Columns.Add("LastSMSDate"); dtAdviserCustomerAlerts.Columns.Add("AlertDate"); dtAdviserCustomerAlerts.Columns.Add("Mobile"); for (int i = 0; i < dsAdviserCustomerAlerts.Tables[0].Rows.Count; i++) { drAdviserCustomerAlert = dtAdviserCustomerAlerts.NewRow(); if (dsAdviserCustomerAlerts.Tables[0].Rows[i]["CustomerId"] != null && dsAdviserCustomerAlerts.Tables[0].Rows[i]["AlertId"] != null) { drAdviserCustomerAlert["CustomerId"] = dsAdviserCustomerAlerts.Tables[0].Rows[i]["CustomerId"].ToString(); drAdviserCustomerAlert["AlertId"] = dsAdviserCustomerAlerts.Tables[0].Rows[i]["AlertId"].ToString(); if (dsAdviserCustomerAlerts.Tables[0].Rows[i]["CustomerName"] != null) { drAdviserCustomerAlert["CustomerName"] = dsAdviserCustomerAlerts.Tables[0].Rows[i]["CustomerName"].ToString(); } else { drAdviserCustomerAlert["CustomerName"] = ""; } if (dsAdviserCustomerAlerts.Tables[0].Rows[i]["Name"].ToString() != null) { drAdviserCustomerAlert["Name"] = dsAdviserCustomerAlerts.Tables[0].Rows[i]["Name"].ToString(); } else { drAdviserCustomerAlert["Name"] = ""; } if (dsAdviserCustomerAlerts.Tables[0].Rows[i]["AlertMessage"].ToString() != null) { drAdviserCustomerAlert["AlertMessage"] = dsAdviserCustomerAlerts.Tables[0].Rows[i]["AlertMessage"].ToString(); } else { drAdviserCustomerAlert["AlertMessage"] = ""; } if (dsAdviserCustomerAlerts.Tables[0].Rows[i]["TimesSMSSent"].ToString() != null && dsAdviserCustomerAlerts.Tables[0].Rows[i]["TimesSMSSent"].ToString() != "") { drAdviserCustomerAlert["TimesSMSSent"] = dsAdviserCustomerAlerts.Tables[0].Rows[i]["TimesSMSSent"].ToString(); } else { drAdviserCustomerAlert["TimesSMSSent"] = ""; } if (dsAdviserCustomerAlerts.Tables[0].Rows[i]["LastSMSDate"].ToString() != null && dsAdviserCustomerAlerts.Tables[0].Rows[i]["LastSMSDate"].ToString() != "") { DateTime lastSMSDate = DateTime.Parse(dsAdviserCustomerAlerts.Tables[0].Rows[i]["LastSMSDate"].ToString()); drAdviserCustomerAlert["LastSMSDate"] = lastSMSDate.ToShortDateString(); } else { drAdviserCustomerAlert["LastSMSDate"] = ""; } if (dsAdviserCustomerAlerts.Tables[0].Rows[i]["AlertDate"].ToString() != null && dsAdviserCustomerAlerts.Tables[0].Rows[i]["AlertDate"].ToString() != "") { DateTime alertDate = DateTime.Parse(dsAdviserCustomerAlerts.Tables[0].Rows[i]["AlertDate"].ToString()); drAdviserCustomerAlert["AlertDate"] = alertDate.ToShortDateString(); } else { drAdviserCustomerAlert["AlertDate"] = ""; } drAdviserCustomerAlert["Mobile"] = dsAdviserCustomerAlerts.Tables[0].Rows[i]["Mobile"].ToString(); if (Int64.Parse(dsAdviserCustomerAlerts.Tables[0].Rows[i]["Mobile"].ToString()) != 0) { hdnCustomerIdWithoutMobileNumber.Value += dsAdviserCustomerAlerts.Tables[0].Rows[i]["CustomerId"].ToString() + ","; } if (drAdviserCustomerAlert != null) { dtAdviserCustomerAlerts.Rows.Add(drAdviserCustomerAlert); } } } gvCustomerSMSAlerts.DataSource = dtAdviserCustomerAlerts; gvCustomerSMSAlerts.DataBind(); gvCustomerSMSAlerts.Visible = true; pnlCustomerSMSAlerts.Visible = true; //lblNoRecords.Visible = false; divNoRecords.Visible = false; btnSend.Visible = true; this.GetPageCount(); TextBox txtName = GetCustNameTextBox(); if (txtName != null) { if (hdnNameFilter.Value != "") { txtName.Text = hdnNameFilter.Value.ToString(); } } } else { //lblNoRecords.Visible = true; divNoRecords.Visible = true; lblDisclaimer.Visible = false; gvCustomerSMSAlerts.Visible = false; pnlCustomerSMSAlerts.Visible = false; btnSend.Visible = false; DivPager.Visible = false; trPageCount.Visible = false; } }