public tbl_OTPG Getotp(string employeeid, string fromdata)
{
DALBase obj = new DALBase(_config);
List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >();
tbl_OTPG listObj = new tbl_OTPG();
obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.Varchar2, 20, employeeid.ToString(), ParameterDirection.Input);
obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_OTP, OracleDbType.RefCursor, 20, null, ParameterDirection.Output);
obj.TupleForOracleParameter(LstTupParameters, "P_DATAFROM", OracleDbType.NVarchar2, 20, fromdata, ParameterDirection.Input);
obj.TupleForOracleParameter(LstTupParameters, "P_RETURNMSG", OracleDbType.NVarchar2, 20, null, ParameterDirection.Output);
DataSet ds = obj.GetDatafromDatabase("BCL_TEST_GETOTP", LstTupParameters);
string RetunMsg = (obj.cmd.Parameters["P_RETURNMSG"].Value.ToString());
if (RetunMsg == "Reset" || RetunMsg == "null" || RetunMsg == "NotExist")
{
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
listObj.OTP = Convert.ToInt32(dt.Rows[0][0]);
listObj.OTPEndtime = Convert.ToDateTime(dt.Rows[0][1]);
listObj.DateOfBirth = Convert.ToDateTime(dt.Rows[0][2]);
listObj.ReturnMsg = RetunMsg;
}
}
else
{
listObj.ReturnMsg = RetunMsg;
}
return(listObj);
}
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;
}
}
public tbl_OTPG GetDOBForKIOSK(string employeeid)
{
DALBase obj = new DALBase(_config);
List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >();
tbl_OTPG listObj = new tbl_OTPG();
obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.Varchar2, 20, employeeid.ToString(), ParameterDirection.Input);
obj.TupleForOracleParameter(LstTupParameters, "P_Empdetails", OracleDbType.RefCursor, 20, null, ParameterDirection.Output);
DataSet ds = obj.GetDatafromDatabase(ConstantStoredProcedure.SP_BCL_GETDOBFORKIOSK, LstTupParameters);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
DateTime dob = Convert.ToDateTime(dt.Rows[0]["DATEOFBIRTH"]);
listObj.DateOfBirth = dob;
}
return(listObj);
}
public long GenerateOtp(string employeeid, long mobileno)
{
LoginViewServiceModel l = new LoginViewServiceModel();
// var responseList = Mapper.Map < LoginViewServiceModel >( _igenerateotprepositary.GetMobileno(employeeid));
// var responseList = _igenerateotprepositary.Getsingledata(employeeid);
//var Mobileno = responseList.Select(x => x.MobileNO).ToList().Distinct().ToList() ;
//OTP generation code
long msgsent = 0;
char[] charArr = "0123456789".ToCharArray();
string strrandom = string.Empty;
Random objran = new Random();
int noofcharacters = 4; //Convert.ToInt32(txtCharacters.Text);
for (int i = 0; i < noofcharacters; i++)
{
int pos = objran.Next(1, charArr.Length);
if (!strrandom.Contains(charArr.GetValue(pos).ToString()))
{
strrandom += charArr.GetValue(pos);
}
else
{
i--;
}
}
var strotp = strrandom;
// var item = responseList.FirstOrDefault();
// msgsent = item.MobileNO;
msgsent = mobileno;
string msgotp = smsd.Otpgeneratesms;
msgotp = msgotp.Replace("+", strotp);
//Code for save otp ,empid,otpstarrttime n endtime in table
var saveotplist = new List <tbl_OTPG>();
var savedata = new tbl_OTPG
{
EmployeeID = Convert.ToString(employeeid),
OTP = Convert.ToInt32(strotp),
};
//uncomment this code for save otp
saveotplist.Add(savedata);
var savetorep = _igenerateotprepositary.SaveOTP(saveotplist);
var ret = savetorep.Item2;
// temperory comment code as sms utility gets error u should uncomment this for sending sms and make m = 0
if (ret == 1)
{
var sms = _SMSUtility.SendSMS(msgsent.ToString(), msgotp);
// var sms = "0";
if (sms != null)
{
msgsent = 1;
}
else
{
msgsent = 0;
}
}
else if (ret == -1)
{
msgsent = -1;
}
else
{
msgsent = 0;
}
//}
return(msgsent);
}
