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