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