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); }