public static void Delete(int id)
{
try
{
String query = "DELETE FROM Materialy WHERE ID = " + id + ";";
SQLConnector.ProcessQuery(query);
}
catch (Exception ex)
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
public static void Update(int id, Material material)
{
try
{
String query = "UPDATE Materialy SET CourseID=" + material.getCourseID() + ", Title='" + material.getTitle() + "', FilePath='" + material.getFilePath() + "', Type=" + material.getType() + " WHERE ID=" + id + ";";
SQLConnector.ProcessQuery(query);
}
catch (Exception ex)
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
internal String ProcessQuery(String query, String SuccessMessage)
{
try
{
SQLConnector.ProcessQuery(query);
return(SuccessMessage);
}
catch (System.Data.SqlClient.SqlException ex)
{
throw;
}
}
public static void Create(Material material)
{
String query = "INSERT INTO Materialy (CourseID, Title, FilePath, Type) VALUES (" + material.getCourseID() + ", '" + material.getTitle() + "', '" + material.getFilePath() + "', " + material.getType() + ");";
try
{
SQLConnector.ProcessQuery(query);
}
catch (System.Data.SqlClient.SqlException ex)
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
UserItemToRecover ValidationItem = LoginAndMailValidation(TextBox1.Text, TextBox2.Text);
if (ValidationItem != null)
{
String newPassword = StringGen.GenString();
PasswordSaltAndHash sah = new PasswordSaltAndHash(newPassword);
String query = SendPasswordToDatabase(sah.getPasswordSalt(), sah.getPasswordHash(), ValidationItem);
try
{
SQLConnector.ProcessQuery(query);
Panel1.Visible = false;
Panel2.Visible = true;
Label1.Text = "<p class=\"center\">Hasło zostało zmienione pomyślnie. Nowe hasło brzmi: " + newPassword + "</p>";
}
catch (System.Data.SqlClient.SqlException ex)
{
Panel1.Visible = false;
Panel2.Visible = true;
Label1.Text = "<p class=\"center\">Baza wygenerowała następującego errora: " + ex.Message + "</p>";
}
}
}