public DataSet DALNSSLongcodeReport(LongCodeBLL obj)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
try
{
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "NSSPuneLongCodeReport");
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(ds);
}
public DataSet DALSMSReportByMobile(LongCodeBLL obj)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
try
{
string sql = "select sendSMSstatus.ID,SendFrom,SendTo,sentMessage,sendDateTime,ProjectName,smslength from sendSMSstatus inner join sendercode on sendSMSstatus.sendercode =sendercode.id WHERE SendTo='" + obj.Mobileno + "' and Convert(Date,sendDateTime,103) BETWEEN '" + obj.Frmdate + "' AND '" + obj.Todate + "' order by ID desc";
ds = cc.ExecuteDataset(sql);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(ds);
}
public DataSet DALSMSCode(LongCodeBLL obj)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
try
{
// ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "SendSMSReport");
string sql = "select * from sendercode";
ds = cc.ExecuteDataset(sql);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(ds);
}
public string DALgetsmsbyidCount(LongCodeBLL obj)
{
string count;
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
try
{
//string sql = "select top(500)sendSMSstatus.ID,SendFrom,SendTo,sentMessage,sendDateTime,ProjectName,smslength from sendSMSstatus inner join sendercode on sendSMSstatus.sendercode =sendercode.id where sendercode='"+obj.Sendercode+"' order by sendSMSstatus.ID desc ";
string sql = "select Count(*) from sendSMSstatus WHERE Convert(Date,sendDateTime,103) BETWEEN '" + obj.Frmdate + "' AND '" + obj.Todate + "' and sendercode='" + obj.Sendercode + "'";
count = cc.ExecuteScalar(sql);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(count);
}
public DataSet BLLSMSReportByMobile(LongCodeBLL obj)
{
DataSet dt = objdalLongcode.DALSMSReportByMobile(obj);
return(dt);
}
public DataSet BLLDARLongCodeReport(LongCodeBLL obj)
{
DataSet dt = objdalLongcode.DALDARLongcodeReport(obj);
return(dt);
}
public DataSet BLLNSSLongCodeReportAll(LongCodeBLL obj)
{
DataSet dt = objdalLongcode.DALNSSLongCodeReportAll(obj);
return(dt);
}
public DataSet BLLgetlongcoderecord(LongCodeBLL obj)
{
DataSet ds = objdalLongcode.DALgetlongcoderecord(obj);
return(ds);
}
public string BLLgetsmsbyidcount(LongCodeBLL obj)
{
string count = objdalLongcode.DALgetsmsbyidCount(obj);
return(count);
}
public DataSet BLLgetsmsbyid(LongCodeBLL obj)
{
DataSet dt = objdalLongcode.DALgetsmsbyid(obj);
return(dt);
}
public DataSet BLLSMSCode(LongCodeBLL obj)
{
DataSet dt = objdalLongcode.DALSMSCode(obj);
return(dt);
}
public string BLLSMSReportcount(LongCodeBLL obj)
{
string count = objdalLongcode.DALSMSReportCount(obj);
return(count);
}
