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