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