// PUT api/Authorization_user/5
public HttpResponseMessage PutAuthorization_user(int id, Authorization_user authorization_user)
{
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
if (id != authorization_user.Id)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
db.Entry(authorization_user).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
}
return Request.CreateResponse(HttpStatusCode.OK);
}
// POST api/Authorization_user
public HttpResponseMessage PostAuthorization_user(Authorization_user authorization_user)
{
if (ModelState.IsValid)
{
//db.Аuthorizations.Add(аuthorization);
// db.SaveChanges();
String res = db.Cheked_Login(authorization_user);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, res);
// response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = аuthorization.Id }));
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}
public String Cheked_Login(Authorization_user obj)
{
String info = "0";
using (var connection1 = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSQL"].ToString()))
{
connection1.Open();
using (var command1 = new SqlCommand(String.Format(@"Select ID_USER_proect
From Registration
Where Login = '******' AND Password = '******'")))
{
command1.Connection = connection1;
using (var reader = command1.ExecuteReader())
{
if (reader.Read())
{
info = (reader["ID_USER_proect"].ToString());
}
}
}
}
return info;
}
