public int AddToSMSQueue(SMSVo smsVo)
{
EmailSMSDao emailSMSDao = new EmailSMSDao();
int smsId = 0;
try
{
smsId = emailSMSDao.AddToSMSQueue(smsVo);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "EmailSMSBo.cs:AddToSMSQueue(SMSVo smsVo)");
object[] objects = new object[1];
objects[0] = smsVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(smsId);
}
/// <summary>
///
/// </summary>
/// <param name="smsVo"></param>
/// <param name="adviserId"></param>
/// <param name="smsType"></param>
/// <returns>bool Result</returns>
public bool AddToAdviserSMSLog(SMSVo smsVo, int adviserId, string smsType)
{
bool bResult = false;
AdvisorDao adviserDao = new AdvisorDao();
try
{
bResult = adviserDao.AddToAdviserSMSLog(smsVo, adviserId, smsType);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorBo.cs:UpdateAdviserSMSLicence(int adviserId, int smsLincence)");
object[] objects = new object[2];
objects[0] = adviserId;
objects[1] = smsVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
public int AddToSMSQueue(SMSVo smsVo)
{
int smsId = 0;
Database db;
DbCommand addToSMSQueueCmd;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
addToSMSQueueCmd = db.GetStoredProcCommand("AddOutgoingSmsToQueue");
db.AddInParameter(addToSMSQueueCmd, "@number", DbType.String, smsVo.Mobile.ToString());
db.AddInParameter(addToSMSQueueCmd, "@message", DbType.String, smsVo.Message);
db.AddInParameter(addToSMSQueueCmd, "@sent", DbType.Int16, smsVo.IsSent);
db.AddInParameter(addToSMSQueueCmd, "@AdviserId", DbType.Int16, smsVo.AdviserId);
db.AddOutParameter(addToSMSQueueCmd, "@Id", DbType.Int32, 10000);
if (db.ExecuteNonQuery(addToSMSQueueCmd) != 0)
{
smsId = int.Parse(db.GetParameterValue(addToSMSQueueCmd, "Id").ToString());
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorDao.cs:AddToSMSQueue(SMSVo smsVo)");
object[] objects = new object[1];
objects[0] = smsVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(smsId);
}
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);
}
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
int smsCount = 0;
int smsLicence = 0;
SMSVo smsVo = new SMSVo();
EmailSMSBo emailSMSBo = new EmailSMSBo();
List <SMSVo> smsVoList = new List <SMSVo>();
AdvisorBo advisorBo = new AdvisorBo();
int adviserId = 0;
if (Session["advisorVo"] != null)
{
adviserId = ((AdvisorVo)Session["advisorVo"]).advisorId;
}
if (lblLincenceValue.Text != "No SMS Credit Left!!")
{
smsLicence = int.Parse(lblLincenceValue.Text.ToString());
}
foreach (GridViewRow gvRow in gvCustomerSMSAlerts.Rows)
{
if (gvRow.RowType == DataControlRowType.DataRow)
{
if (((CheckBox)gvRow.FindControl("chkCustomerSMSAlert")).Checked)
{
smsVo = new SMSVo();
if (gvRow.Cells[2].Text.Trim().Length <= 10)
{
smsVo.Mobile = Int64.Parse("91" + gvRow.Cells[2].Text.Trim());
}
else
{
smsVo.Mobile = int.Parse(gvRow.Cells[2].Text.Trim());
}
smsVo.Message = txtMessage.Text.ToString();
smsVo.CustomerId = int.Parse(gvCustomerSMSAlerts.DataKeys[gvRow.RowIndex].Values["CustomerId"].ToString());
smsVo.IsSent = 0;
smsVo.AdviserId = adviserId;
smsVoList.Add(smsVo);
smsCount++;
}
}
}
if (smsCount <= smsLicence && smsCount != 0)
{
smsVoList = emailSMSBo.AddToSMSQueue(smsVoList);
//smsLicence = smsLicence - smsCount;
//advisorBo.UpdateAdviserSMSLicence(adviserId, smsCount);
advisorBo.AddToAdviserSMSLog(smsVoList, adviserId, "Manual Message");
if (smsLicence == 0)
{
lblLincenceValue.Text = "No SMS Licence Left!!";
}
else
{
lblLincenceValue.Text = smsLicence.ToString();
}
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('SMS has been Sent to the Selected Customers!!');", true);
}
else if (smsCount == 0)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please select a Customer!!');", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('You dont have enough SMS Credits to process this request');", true);
}
}
