public List <VerifySMSBLL> getSendSMSHistory_CurrentDate(VerifySMSBLL obj)
{
using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]))
{
List <VerifySMSBLL> objBllVar = new List <VerifySMSBLL>();
try
{
SqlParameter[] par = new SqlParameter[1];
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "GetSMSHistory_ByCurrentDate");
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
VerifySMSBLL obj1 = new VerifySMSBLL();
obj1.pk = Convert.ToInt32(dr1["PK"]);
obj1.mobileNo = Convert.ToString(dr1["mobile"]);
obj1.message = Convert.ToString(dr1["Message"]);
obj1.date = Convert.ToString(dr1["shortcode"]);
obj1.flag = Convert.ToInt32(dr1["FlagStatus"]);
objBllVar.Add(obj1);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(objBllVar);
}
}
public DataSet getSMSHistoryCurrentdate(VerifySMSBLL obj)
{
DataSet ds1 = new DataSet();
using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]))
{
try
{
SqlParameter [] par = new SqlParameter[7];
par[1] = new SqlParameter("@pk", obj.pk);
par[2] = new SqlParameter("@mobile", obj.mobileNo);
par[3] = new SqlParameter("@shortcode", obj.date);
par[4] = new SqlParameter("@FlagStatus", obj.flag);
par[5] = new SqlParameter("@Message", obj.message);
par[6] = new SqlParameter("@Status", 7);
par[6].Direction = ParameterDirection.Output;
ds1 = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "spGetSMSHistoryByCurrentDate", par);
status = Convert.ToInt32(par[6].Value);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(ds1);
}
public List <VerifySMSBLL> getSMSHistory(VerifySMSBLL obj)
{
List <VerifySMSBLL> objBllVar = new List <VerifySMSBLL>();
DataSet ds = new DataSet();
string sql = "select * from test order by PK desc";
ds = cc.ExecuteDataset(sql);
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
VerifySMSBLL obj1 = new VerifySMSBLL();
obj1.pk = Convert.ToInt32(dr1["PK"]);
obj1.mobileNo = Convert.ToString(dr1["mobile"]);
obj1.message = Convert.ToString(dr1["Message"]);
obj1.date = Convert.ToString(dr1["shortcode"]);
obj1.flag = Convert.ToInt32(dr1["FlagStatus"]);
objBllVar.Add(obj1);
}
return(objBllVar);
}
public List <VerifySMSBLL> getSendSMSHistory(VerifySMSBLL obj)
{
List <VerifySMSBLL> objBllVar = new List <VerifySMSBLL>();
DataSet ds = new DataSet();
string sql = "select * from sendSMSstatus";
ds = cc.ExecuteDataset(sql);
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
VerifySMSBLL obj1 = new VerifySMSBLL();
obj1.ID = Convert.ToInt32(dr1["ID"]);
obj1.SendFrom = Convert.ToString(dr1["SendFrom"]);
obj1.SendTo = Convert.ToString(dr1["SendTo"]);
obj1.SendSMS = Convert.ToString(dr1["sentMessage"]);
obj1.FlagCode = Convert.ToString(dr1["Flag"]);
objBllVar.Add(obj1);
}
return(objBllVar);
}
public List <VerifySMSBLL> getSendSMSHistory(VerifySMSBLL obj)
{
return(objDLL.getSendSMSHistory(obj));
}
public List <VerifySMSBLL> getSMSHistory_ByDate(VerifySMSBLL obj)
{
return(objDLL.getSMSHistory_ByDate(obj));
}
public DataSet getSMSHistory1(VerifySMSBLL obj)
{
DataSet ds = objDLL.getSMSHistoryCurrentdate(obj);
return(ds);
}
public List <VerifySMSBLL> getSendSMSHistory_currentDate(VerifySMSBLL obj)
{
return(objDLL.getSendSMSHistory_CurrentDate(obj));
}
