public HttpResponseMessage facultyLogin([FromBody] dynamic fc) { string query = $"SELECT * FROM Employee where Email='{fc.Email}' and EPassword='******'"; using (SqlConnection sqlConnection = new SqlConnection(CONNSTRING)) { SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); try { String email = fc.Email; String password = fc.EPassword; sqlConnection.Open(); SqlDataReader facultyReader = sqlCommand.ExecuteReader(); faculties faclty = null; while (facultyReader.Read()) { faclty = new faculties( facultyReader.GetString(facultyReader.GetOrdinal("EmpName")), facultyReader.GetString(facultyReader.GetOrdinal("Email")), facultyReader.GetString(facultyReader.GetOrdinal("MobileNumber")), facultyReader.GetString(facultyReader.GetOrdinal("EPassword")) ); } return(Request.CreateResponse(HttpStatusCode.OK, faclty)); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, e)); } } }
public EditFacultyDataPage(AdminWindow adminWindow, faculties SelectedFaculty) { InitializeComponent(); this.SelectedFaculty = (faculties)SelectedFaculty.Clone(); this.EditFacultyReference = SelectedFaculty; this.adminWindow = adminWindow; DataContext = this; }
public EditFacultyDataPage(AdminWindow adminWindow) { InitializeComponent(); SelectedFaculty = new faculties { faculty_name = "Какой-то факультет" }; this.adminWindow = adminWindow; DataContext = this; }
public async Task <ActionResult> FacultyPage(FormCollection formCollection) { facultiesVM facultiesVM = new facultiesVM(); faculties faculties = new faculties(); faculties facultiesL = new faculties(); string Email = formCollection[1]; string EPassword = formCollection[2]; faculties.Email = Email; faculties.EPassword = EPassword; var json = JsonConvert.SerializeObject(new facultiesVM { Email = Email, SPassword = EPassword }); var data = new StringContent(json, Encoding.UTF8, "application/json"); using (var client = new HttpClient()) { client.BaseAddress = new Uri(Shared.ServerConfig.GetBaseUrl()); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage result = await client.PostAsync("admin_faculty/FacultyLogin/", data); var response = result.Content.ReadAsStringAsync().Result; Console.WriteLine(response); //facultiesL = JsonConvert.DeserializeObject<faculties>(response); if (response == "null") { //means login credentials were wrong return(View("FacultyLogin")); } else { //facultiesVM.faculties = facultiesL; return(View("Index")); //succeed logging in } } }