public async Task <ActionResult <appusers> > Postappusers(appusers appusers) { _context.appusers.Add(appusers); await _context.SaveChangesAsync(); return(CreatedAtAction("Getappusers", new { id = appusers.id }, appusers)); }
public async Task <IActionResult> Putappusers(int id, appusers appusers) { if (id != appusers.id) { return(BadRequest()); } _context.Entry(appusers).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!appusersExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public appusers Get(string username, string password) { //return listEmp.First(e => e.ID == id); SqlDataReader reader = null; SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["JSWebAPIContext"].ConnectionString; SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = "Select id,username,userpassword,useremail from app_users where username ='******' and userpassword ='******' "; sqlCmd.Connection = myConnection; myConnection.Open(); reader = sqlCmd.ExecuteReader(); appusers users = null; while (reader.Read()) { users = new appusers(); users.UserId = Convert.ToInt32(reader.GetValue(0)); users.UserName = reader.GetValue(1).ToString(); users.UserPassword = reader.GetValue(2).ToString(); users.UserMail = reader.GetValue(3).ToString(); } return(users); }
public void UpdateUserByID(int id, appusers appuser) { SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["JSWebAPIContext"].ConnectionString; SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = "update app_users set userpassword=@UserPassword, useremail=@UserMail, updatedate=convert(date,GETDATE()) where id=" + id + ""; sqlCmd.Connection = myConnection; sqlCmd.Parameters.AddWithValue("@UserPassword", appuser.UserPassword); sqlCmd.Parameters.AddWithValue("@UserMail", appuser.UserMail); myConnection.Open(); int rowInserted = sqlCmd.ExecuteNonQuery(); myConnection.Close(); }
public void AddUser(appusers appuser) { SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["JSWebAPIContext"].ConnectionString; SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = "INSERT INTO app_users(username,userpassword,useremail,valid_flag,createdate) Values (@UserName,@UserPassword,@UserMail,'Y', convert(date,GETDATE()))"; sqlCmd.Connection = myConnection; sqlCmd.Parameters.AddWithValue("@UserName", appuser.UserName); sqlCmd.Parameters.AddWithValue("@UserPassword", appuser.UserPassword); sqlCmd.Parameters.AddWithValue("@UserMail", appuser.UserMail); myConnection.Open(); int rowInserted = sqlCmd.ExecuteNonQuery(); myConnection.Close(); }