public async Task <ActionResult <UserDTOs> > post(RegisterDTOs afreet) { if (await UserExist(afreet.username)) { return(BadRequest("Username already used")); } using var hash = new HMACSHA512(); var user = new Appusers { Username = afreet.username, PasswordHash = hash.ComputeHash(Encoding.UTF8.GetBytes(afreet.password)), PasswordSalt = hash.Key, // DateOfBirth=afreet.DateOfBirth, KnownAs = afreet.KnownAs, Gender = afreet.Gender, Introduction = afreet.Introduction, LookingFor = afreet.LookingFor, Interests = afreet.Interests, City = afreet.City, Country = afreet.Country }; data.users.Add(user); await data.SaveChangesAsync(); return(new UserDTOs { Username = user.Username, Token = itok.CreateToken(user) }); }
public DataTable WalletBalance(Appusers A) { SqlCommand cmd = new SqlCommand(); LogTraceWriter traceWriter = new LogTraceWriter(); SqlConnection conn = new SqlConnection(); DataTable dt = new DataTable(); try { traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "WalletBalance...."); conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PSInsUpdBalance"; cmd.Connection = conn; SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar); f.Value = A.flag; cmd.Parameters.Add(f); SqlParameter mn = new SqlParameter("@Mobilenumber", SqlDbType.VarChar, 20); mn.Value = A.Mobilenumber; cmd.Parameters.Add(mn); SqlParameter em = new SqlParameter("@Amount", SqlDbType.Decimal); em.Value = A.Amount; cmd.Parameters.Add(em); SqlParameter St = new SqlParameter("@StatusId", SqlDbType.Int); St.Value = A.Status; cmd.Parameters.Add(St); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "WalletBalance successful...."); } catch (Exception ex) { traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "WalletBalance...." + ex.Message.ToString()); throw ex; } finally { conn.Close(); conn.Dispose(); SqlConnection.ClearPool(conn); } return(dt); }
public int SavePostlist(Appusers ocr) { SqlConnection conn = new SqlConnection(); conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "POInsUpdDelMOTPverification"; cmd.Connection = conn; SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar); f.Value = ocr.flag; cmd.Parameters.Add(f); SqlParameter i = new SqlParameter("@id", SqlDbType.Int); i.Value = ocr.id; cmd.Parameters.Add(i); SqlParameter q1 = new SqlParameter("@Mobilenumber", SqlDbType.VarChar, 20); q1.Value = ocr.Mobilenumber; cmd.Parameters.Add(q1); SqlParameter e = new SqlParameter("@Mobileotp", SqlDbType.VarChar, 10); e.Value = ocr.Mobileotp; cmd.Parameters.Add(e); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); return(1); }
public string CreateToken(Appusers user) { var claims = new List <Claim> { new Claim(JwtRegisteredClaimNames.NameId, user.Username) }; var Creds = new SigningCredentials(key, SecurityAlgorithms.HmacSha512Signature); var tokenDescribtion = new SecurityTokenDescriptor { Subject = new ClaimsIdentity(claims), Expires = DateTime.Now.AddDays(7), SigningCredentials = Creds }; var tokenhandler = new JwtSecurityTokenHandler(); var token = tokenhandler.CreateToken(tokenDescribtion); return(tokenhandler.WriteToken(token)); }
public int SavePostlist1(Appusers ocr) { int status = 0; DataTable dt = new DataTable(); LogTraceWriter traceWriter = new LogTraceWriter(); SqlConnection conn = new SqlConnection(); StringBuilder str = new StringBuilder(); try { traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SavePostlist1...."); str.Append("@Email" + ocr.Email + ","); str.Append("@Emailotp" + ocr.Emailotp + ","); str.Append("@Mobilenumber" + ocr.Mobilenumber + ","); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString()); conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PSInsUpdDelEOTPverification"; cmd.Connection = conn; SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar); f.Value = ocr.flag; cmd.Parameters.Add(f); SqlParameter i = new SqlParameter("@id", SqlDbType.Int); i.Value = ocr.id; cmd.Parameters.Add(i); SqlParameter q1 = new SqlParameter("@Email", SqlDbType.VarChar, 50); q1.Value = ocr.Email; cmd.Parameters.Add(q1); SqlParameter e = new SqlParameter("@Emailotp", SqlDbType.VarChar, 10); e.Value = ocr.Emailotp; cmd.Parameters.Add(e); SqlParameter c = new SqlParameter("@Mobilenumber", SqlDbType.VarChar, 20); c.Value = ocr.Mobilenumber; cmd.Parameters.Add(c); conn.Open(); status = cmd.ExecuteNonQuery(); conn.Close(); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SavePostlist1 successful...."); } catch (Exception ex) { traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "SavePostlist1...." + ex.Message.ToString()); throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.OK, ex.Message)); } finally { conn.Close(); conn.Dispose(); SqlConnection.ClearPool(conn); } return(status); }
public void Update(Appusers users) { _data.Entry(users).State = EntityState.Modified; }
public DataTable DriverWalletBalance(Appusers A) { DataTable dt = new DataTable(); LogTraceWriter traceWriter = new LogTraceWriter(); SqlConnection conn = new SqlConnection(); StringBuilder str = new StringBuilder(); SqlCommand cmd = new SqlCommand(); try { traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "WalletBalance...."); str.Append("Mobilenumber:" + A.Mobilenumber + ","); str.Append("Amount:" + A.Amount + ","); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString()); conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DriverEWInsUpdWalletBalance"; cmd.Connection = conn; SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar); f.Value = A.flag; cmd.Parameters.Add(f); SqlParameter mn = new SqlParameter("@Mobilenumber", SqlDbType.VarChar, 20); mn.Value = A.Mobilenumber; cmd.Parameters.Add(mn); SqlParameter em = new SqlParameter("@Amount", SqlDbType.Decimal); em.Value = A.Amount; cmd.Parameters.Add(em); SqlParameter St = new SqlParameter("@StatusId", SqlDbType.Int); St.Value = A.Status; cmd.Parameters.Add(St); Payengine.Controllers.Payengine e = new Payengine.Controllers.Payengine(); string transId = e.ProcessPayment(); SqlParameter St1 = new SqlParameter("@GatewayTransId", SqlDbType.VarChar); St1.Value = transId; cmd.Parameters.Add(St1); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); #region Email OTP string eotp = dt.Rows[0]["Amount"].ToString(); if (eotp != null) { try { MailMessage mail = new MailMessage(); string emailserver = System.Configuration.ConfigurationManager.AppSettings["emailserver"].ToString(); string username = System.Configuration.ConfigurationManager.AppSettings["username"].ToString(); string pwd = System.Configuration.ConfigurationManager.AppSettings["password"].ToString(); string fromaddress = System.Configuration.ConfigurationManager.AppSettings["fromaddress"].ToString(); string port = System.Configuration.ConfigurationManager.AppSettings["port"].ToString(); SmtpClient SmtpServer = new SmtpClient(emailserver); mail.From = new MailAddress(fromaddress); mail.To.Add(fromaddress); mail.Subject = "Balance"; mail.IsBodyHtml = true; string verifcodeMail = @"<table> <tr> <td> <h2>Thank you for registering with PaySmart APP</h2> <table width=\""760\"" align=\""center\""> <tbody style='background-color:#F0F8FF;'> <tr> <td style=\""font-family:'Zurich BT',Arial,Helvetica,sans-serif;font-size:15px;text-align:left;line-height:normal;background-color:#F0F8FF;\"" > <div style='padding:10px;border:#0000FF solid 2px;'> <br /><br /> Your Balance:<h3>" + eotp + @" </h3> If you didn't make this request, <a href='http://154.120.237.198:52800'>click here</a> to cancel. <br/> <br/> Warm regards,<br> PAYSMART Customer Service Team<br/><br /> </div> </td> </tr> </tbody> </table> </td> </tr> </table>"; mail.Body = verifcodeMail; //SmtpServer.Port = 465; //SmtpServer.Port = 587; SmtpServer.Port = Convert.ToInt32(port); SmtpServer.UseDefaultCredentials = false; SmtpServer.Credentials = new System.Net.NetworkCredential(username, pwd); SmtpServer.EnableSsl = true; //SmtpServer.TargetName = "STARTTLS/smtp.gmail.com"; SmtpServer.Send(mail); } catch (Exception ex) { //throw ex; //throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); dt.Columns.Add("Code"); dt.Columns.Add("description"); DataRow dr = dt.NewRow(); dr[0] = "ERR001"; dr[1] = ex.Message; dt.Rows.Add(dr); } } #endregion Email OTP traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "WalletBalance successful...."); } catch (Exception ex) { traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "WalletBalance...." + ex.Message.ToString()); //throw ex; //throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); dt.Columns.Add("Code"); dt.Columns.Add("description"); DataRow dr = dt.NewRow(); dr[0] = "ERR001"; dr[1] = ex.Message; dt.Rows.Add(dr); } finally { conn.Close(); conn.Dispose(); SqlConnection.ClearPool(conn); } return(dt); }