public List <tbl_OTPG> Getsingledata(string id, string fromdata)
{
try
{
DALBase obj = new DALBase(_config);
List <tbl_OTPG> listObj = new List <tbl_OTPG>();
DataSet dt = obj.GetById(ConstantStoredProcedure.SP_GETMOBILENO, id, fromdata);
var RetunVal = Convert.ToInt32((decimal)(OracleDecimal)(obj.cmd.Parameters["P_RETURNVALUE"].Value));
var tbuser = new tbl_OTPG();
if (RetunVal == 1)
{
tbuser.Returnvalue = RetunVal;
listObj.Add(tbuser);
}
else if (RetunVal == 2)
{
tbuser.Returnvalue = RetunVal;
listObj.Add(tbuser);
}
else if (RetunVal == 0)
{
DataTable Dt1 = dt.Tables[0];
if (Dt1.Rows.Count > 0)
{
string MobileNo = Convert.ToString(Dt1.Rows[0]["PHONENO"]);
if (string.IsNullOrEmpty(MobileNo))
{
tbuser.Returnvalue = 2;
listObj.Add(tbuser);
}
else
{
foreach (var item in Dt1.Rows)
{
var tbOtg = new tbl_OTPG();
tbOtg.MobileNO = Convert.ToInt64(MobileNo);
listObj.Add(tbOtg);
}
}
}
}
return(listObj);
}
catch (Exception ex)
{
throw ex;
}
}
