public DataTable SetSMSStatusR(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
// Getting Data From Dao
return smsdao.GetDaoSetSMSStatusR(smsview);
}
catch
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetQueueTokenGenerationSentSMS(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
DataTable dt1 = new DataTable();
// Getting Data From Dao
dt1 = smsdao.GetDaoQueueTokenGenerationSentSMS(smsview);
return dt1;
}
catch
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable appointmenTranstexpired(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
// Getting Data From Dao
return smsdao.GetAppointmentTransactionDetails(smsview);
}
catch
{
throw;
}
finally
{
smsdao = null;
}
}
public string getInsertAppointmentAlertSms(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
DataTable dt = new DataTable();
string i;
try
{
i = smsdao.InsertAppointmentAlertSMS(smsview);
return i;
}
catch (Exception)
{
throw;
}
}
public DataTable GetCustomerNameMobile(SMSView smsview)
{
DataTable dta = new DataTable();
SMSDAO smsdao = new SMSDAO();
try
{
return dta = smsdao.retrieveNamemobilenoByCustID(smsview);
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetTotalWaitingMissedQueue(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
// Getting Data From Dao
return smsdao.GetDaoTotalWaitingMissedQueue(smsview);
}
catch
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetAlertQMessageExistance(SMSView smsview)
{
DataTable dta = new DataTable();
SMSDAO smsdao = new SMSDAO();
try
{
return dta = smsdao.getAlertMessageExistance(smsview);
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetCustIDByUsingQueueno(SMSView smsview)
{
DataTable dt1 = new DataTable();
SMSDAO smsdao = new SMSDAO();
try
{
dt1 = smsdao.SelectCustIDByUsingQueueno(smsview);
return dt1;
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetIncomingSMS(SMSView smsview)
{
SMSDAO smsdao=new SMSDAO();
try
{
return smsdao.searchIncomingSMS(smsview);
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetAutoQueueSentSMS(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
// Getting Data From Dao
return smsdao.GetDaoAutoQueueSentSMS(smsview);
}
catch
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable AppRemender()
{
SMSDAO smsdao = new SMSDAO();
try
{
// Getting Data From Dao
return smsdao.AppRemender();
}
catch
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetMissedQueue()
{
SMSDAO smsdao = new SMSDAO();
try
{
// Getting Data From Dao
return smsdao.DaoGetMissedQueue();
}
catch
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable appointmentalert()
{
SMSDAO smsdao = new SMSDAO();
try
{
// Getting Data From Dao
return smsdao.GetDaoappointmentalert();
}
catch
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetRetrieveSMSstatusFlag(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
DataTable dt = new DataTable();
dt = smsdao.RetrieveSMSstatusFlag(smsview);
return dt;
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetDeptid(SMSView smsview)
{
DataTable dt4 = new DataTable();
SMSDAO smsdao = new SMSDAO();
try
{
dt4 = smsdao.selectDeptId(smsview);
return dt4;
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetStatusCount123(SMSView smsview)
{
DataTable dt7 = new DataTable();
SMSDAO smsdao = new SMSDAO();
try
{
dt7 = smsdao.SelectQueueStatus123(smsview);
return dt7;
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetQueueStatus(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
return smsdao.serachQueueStatus(smsview);
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public string GetInsertReplySMS(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
return smsdao.InsertReplySMS(smsview);
}
catch (Exception)
{
throw;
}
}
public DataTable GetsmsStatusFlag(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
return smsdao.updateincomingsms(smsview);
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetCustId(SMSView smsview)
{
DataTable dta = new DataTable();
SMSDAO smsdao = new SMSDAO();
try
{
return dta = smsdao.retCustID(smsview);
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetQueuePosition123(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
DataTable dt = new DataTable();
try
{
dt = smsdao.selectQueuePosition123(smsview);
return dt;
}
catch (Exception)
{
return dt;
}
finally
{
smsdao = null;
}
}
public DataTable GetButtonEvent(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
DataTable dt = new DataTable();
try
{
dt = smsdao.SelectButtonEvent(smsview);
return dt;
}
catch (Exception)
{
return dt;
}
finally
{
smsdao = null;
}
}
public DataTable GetpositionbyusingQueueno(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
DataTable dt = new DataTable();
try
{
dt = smsdao.positionretrievebyusingQueueno(smsview);
return dt;
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable getUpdatebuttoneventflag(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
DataTable dt1 = new DataTable();
try
{
dt1 = smsdao.updateButtonFlag(smsview);
return dt1;
}
catch (Exception)
{
return dt1;
}
finally
{
smsdao = null;
}
}
public string GetInsertMissedQSMS(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
string dt2;
dt2 = smsdao.InsertMissedQSMS(smsview);
return dt2;
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public void updatesmsalert(SMSView smsview)
{
DataTable dta = new DataTable();
SMSDAO smsdao = new SMSDAO();
try
{
smsdao.updatesmsalert(smsview);
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable Getvisittnxidbyusingrepliedsms(SMSView smsview)
{
DataTable dt = new DataTable();
SMSDAO smsdao=new SMSDAO();
try
{
dt = smsdao.retrievevisittnxidbyusingrepliedsms(smsview);
return dt;
}
catch (Exception)
{
throw;
}
finally
{
smsdao = null;
}
}
public DataTable GetGeneratedQueue()
{
SMSDAO smsdao = new SMSDAO();
try
{
// Getting Data From Dao
return smsdao.GetDaoQueueGenerationSMS();
}
catch
{
throw;
}
finally
{
smsdao = null;
}
}
public void updatesmsstatusflag(SMSView smsview)
{
SMSDAO smsdao = new SMSDAO();
try
{
// Getting Data From Dao
smsdao.updatesmsstatusflag(smsview);
}
catch
{
throw;
}
finally
{
smsdao = null;
}
}