public AspNetUserPinModel isValidatePin(string Pin)
{
_logger.LogInformation((int)LoggingEvents.VALIDATE_ITEM, "Validating PIN");
string ConnectionPath1 = _iconfiguration.GetSection("ConnectionStrings").GetSection("DbConnection").Value;
// string ConnectionPath = "Server=identitycoreawsdb.cl28zty7wqij.us-east-1.rds.amazonaws.com;Database=NetCoreIdentitySample;Uid=masterUsername;Pwd=masterPassword";
SqlConnection conn = new SqlConnection(ConnectionPath1);
conn.Open();
AspNetUserPinModel pinmodel = new AspNetUserPinModel();
string sql = "isValidUserPin";
SqlCommand comm = new SqlCommand(sql, conn);
comm.Parameters.AddWithValue("@Pin", Pin);
comm.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = comm.ExecuteReader();
_logger.LogInformation((int)LoggingEvents.VALIDATE_ITEM, "Returned valid pin from database {t}", dr.HasRows);
if (dr.HasRows)
{
while (dr.Read())
{
pinmodel.Message = dr.GetString(0);
if (pinmodel.Message == "Pin Valid")
{
pinmodel.LastName = dr["LastName"].ToString();
pinmodel.FirstName = dr["FirstName"].ToString();
}
}
}
comm.Dispose();
conn.Close();
return(pinmodel);
}
//public APIGatewayProxyResponse Get()
//{
// var response = new APIGatewayProxyResponse
// {
// StatusCode = (int)HttpStatusCode.OK,
// Body = JsonConvert.SerializeObject(GetUsers()),
// Headers = new Dictionary<string, string> { { "Content-Type", "application/json" } }
// };
// return response;
//}
///<Summary>
/// For validate pin
///</Summary>
public AspNetUserPinModel IsValidUserPin(long Pin)
{
//string ConnectionPath = connectionStrings.DbConnection;
//SqlConnection conn = new SqlConnection(ConnectionPath);
//conn.Open();
//AspNetUserPinModel pinmodel = new AspNetUserPinModel();
//string sql = "isValidUserPin";
//SqlCommand comm = new SqlCommand(sql, conn);
//comm.Parameters.AddWithValue("@Pin", Pin.ToString());
//comm.CommandType = CommandType.StoredProcedure;
//SqlDataReader dr = comm.ExecuteReader();
//if (dr.HasRows)
//{
// while (dr.Read())
// {
// pinmodel.LastName = dr["LastName"].ToString();
// pinmodel.FirstName = dr["FirstName"].ToString();
// pinmodel.Message = dr["Message"].ToString();
// }
//}
string ConnectionPath = "Server=identitycoreawsdb.cl28zty7wqij.us-east-1.rds.amazonaws.com;Database=NetCoreIdentitySample;Uid=masterUsername;Pwd=masterPassword";
SqlConnection conn = new SqlConnection(ConnectionPath);
conn.Open();
AspNetUserPinModel pinmodel = new AspNetUserPinModel();
string sql = "isValidUserPin";
SqlCommand comm = new SqlCommand(sql, conn);
comm.Parameters.AddWithValue("@Pin", Pin.ToString());
comm.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = comm.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
string s = dr.GetString(0);
pinmodel.LastName = dr["LastName"].ToString();
pinmodel.FirstName = dr["FirstName"].ToString();
pinmodel.Message = dr["Message"].ToString();
}
}
comm.Dispose();
conn.Close();
return(pinmodel);
}
public List <AspNetUserPinModel> GetFilteredAspNetUserPins(string FirstName, string LastName, string EmailAddress)
{
var test = _iconfiguration;
string ConnectionPath = _iconfiguration.GetSection("ConnectionStrings").GetSection("DbConnection").Value;
// string ConnectionPath = "Server=identitycoreawsdb.cl28zty7wqij.us-east-1.rds.amazonaws.com;Database=NetCoreIdentitySample;Uid=masterUsername;Pwd=masterPassword";
SqlConnection conn = new SqlConnection(ConnectionPath);
conn.Open();
List <AspNetUserPinModel> list = new List <AspNetUserPinModel>();
string sql = "getFilteredAspNetUserPins";
SqlCommand comm = new SqlCommand(sql, conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@FirstName", FirstName);
comm.Parameters.AddWithValue("@LastName", LastName);
comm.Parameters.AddWithValue("@EmailAddress", EmailAddress);
SqlDataReader dr = comm.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
AspNetUserPinModel pinmodel = new AspNetUserPinModel();
pinmodel.Id = dr["Id"].ToString();
pinmodel.LastName = dr["LastName"].ToString();
pinmodel.FirstName = dr["FirstName"].ToString();
pinmodel.Pin = dr["Pin"].ToString();
// pinmodel.CreatedDate = Convert.ToDateTime(dr["CreatedDate"].ToString());
pinmodel.EmailAddress = dr["EmailAddress"].ToString();
list.Add(pinmodel);
}
}
comm.Dispose();
conn.Close();
return(list);
}
public AspNetUserPinModel UpdateAspNetUserPins(AspNetUserPinModel pinmodel)
{
string ConnectionPath = _iconfiguration.GetSection("ConnectionStrings").GetSection("DbConnection").Value;
// string ConnectionPath = "Server=identitycoreawsdb.cl28zty7wqij.us-east-1.rds.amazonaws.com;Database=NetCoreIdentitySample;Uid=masterUsername;Pwd=masterPassword";
SqlConnection conn = new SqlConnection(ConnectionPath);
conn.Open();
string sql = "updateAspNetUserPins";
SqlCommand comm = new SqlCommand(sql, conn);
comm.Parameters.AddWithValue("@Id", pinmodel.Id);
comm.Parameters.AddWithValue("@FirstName", pinmodel.FirstName);
comm.Parameters.AddWithValue("@LastName", pinmodel.LastName);
comm.Parameters.AddWithValue("@EmailAddress", pinmodel.EmailAddress);
comm.CommandType = CommandType.StoredProcedure;
comm.ExecuteNonQuery();
comm.Dispose();
conn.Close();
return(pinmodel);
}
public List <AspNetUserPinModel> GetAspNetUserPins()
{
// string ConnectionPath = _iconfiguration.GetSection("ConnectionStrings").GetSection("DbConnection").Value;
var test = _iconfiguration;
string ConnectionPath = _iconfiguration.GetSection("ConnectionStrings").GetSection("DbConnection").Value;
SqlConnection conn = new SqlConnection(ConnectionPath);
conn.Open();
List <AspNetUserPinModel> list = new List <AspNetUserPinModel>();
string sql = "getAspNetUserPins";
SqlCommand comm = new SqlCommand(sql, conn);
comm.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = comm.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
AspNetUserPinModel pinmodel = new AspNetUserPinModel();
pinmodel.Id = dr["Id"].ToString();
pinmodel.LastName = dr["LastName"].ToString();
pinmodel.FirstName = dr["FirstName"].ToString();
pinmodel.Pin = dr["Pin"].ToString();
// pinmodel.CreatedDate = Convert.ToDateTime(dr["CreatedDate"].ToString());
pinmodel.EmailAddress = dr["EmailAddress"].ToString();
list.Add(pinmodel);
}
}
comm.Dispose();
conn.Close();
return(list);
}
