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