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