public static List <InsuranceType> GetTypes()
{
List <InsuranceType> insuranceTypes = new List <InsuranceType>();
using (var db = new InsuranceDataBaseAccess(GlobalVariables.DATABASE.SERVERNAME,
GlobalVariables.DATABASE.USERNAME, GlobalVariables.DATABASE.PASSWORD))
{
if (db.Open())
{
ListCategoryStatement stmt = new ListCategoryStatement();
stmt.Prepare(db.connection);
using (var reader = db.ExecutePreparedStatementReader(stmt, IsolationLevel.ReadCommitted))
{
if (reader != null && reader.HasRows)
{
int id;
string category;
while (reader.Read())
{
id = reader.GetInt32(0);
category = reader.GetString(1);
insuranceTypes.Add(new InsuranceType(id, category));
}
}
}
}
}
return(insuranceTypes);
}
// TODO: Update database (rating)
private void Rate(object sender, RoutedEventArgs e)
{
// Update with int chosenRating
using (var db = new InsuranceDataBaseAccess(GlobalVariables.DATABASE.SERVERNAME,
GlobalVariables.DATABASE.USERNAME, GlobalVariables.DATABASE.PASSWORD))
{
if (db.Open())
{
// select the provider first
IPreparedStatement provStmt = new GetProviderIDStatement(providerName);
provStmt.Prepare(db.connection);
using (var reader = db.ExecutePreparedStatementReader(provStmt))
{
if (reader != null && reader.HasRows)
{
reader.Read();
providerID = reader.GetInt32(0);
}
}
// now rate the provider
int userID = GlobalVariables.User.Id;
IPreparedStatement stmt = new VendorRatingStatement(userID, providerID, chosenRating);
stmt.Prepare(db.connection);
db.ExecutePreparedStatementNonQuery(stmt);
}
}
Window.Current.Close();
}
private void Send(object sender, RoutedEventArgs e)
{
string question = questionBox.Text;
using (var db = new InsuranceDataBaseAccess(GlobalVariables.DATABASE.SERVERNAME,
GlobalVariables.DATABASE.USERNAME, GlobalVariables.DATABASE.PASSWORD))
{
if (db.Open())
{
int ID = GlobalVariables.User.Id;
IPreparedStatement stmt = new CreateFragenStatement(question, ID);
stmt.Prepare(db.connection);
db.ExecutePreparedStatementNonQuery(stmt);
StatusMessage.Text = "New question was send, you will soon get an answer :-)";
}
}
}
// TODO: Update database
private void Button_Click(object sender, RoutedEventArgs e)
{
username = UsernameBox.Text;
password = pwBox.Password;
birthday = DateBox.Date.Date;
residence = AddressBox.Text;
using (var db = new InsuranceDataBaseAccess(GlobalVariables.DATABASE.SERVERNAME,
GlobalVariables.DATABASE.USERNAME, GlobalVariables.DATABASE.PASSWORD))
{
if (db.Open())
{
IPreparedStatement stmt = new CreateUserStatement(username, password, birthday, residence);
stmt.Prepare(db.connection);
db.ExecutePreparedStatementNonQuery(stmt);
}
else
{
}
}
}
private void Update_Click(object sender, RoutedEventArgs e)
{
using (var db = new InsuranceDataBaseAccess(GlobalVariables.DATABASE.SERVERNAME,
GlobalVariables.DATABASE.USERNAME, GlobalVariables.DATABASE.PASSWORD))
{
if (db.Open())
{
//TODO: pass user data to stmt
IPreparedStatement stmt = new UpdateUserStatement("Max Mustermann", "Password123", DateTime.UtcNow, "Wolfsburg");
stmt.Prepare(db.connection);
if (db.ExecutePreparedStatementNonQuery(stmt) == 1)
{
//TODO: print success
}
else
{
//TODO: print error
}
}
}
}
public List <Insurance> GetInsurances(int type)
{
List <Insurance> insurances = new List <Insurance>();
using (var db = new InsuranceDataBaseAccess(GlobalVariables.DATABASE.SERVERNAME, GlobalVariables.DATABASE.USERNAME, GlobalVariables.DATABASE.PASSWORD))
{
if (db.Open())
{
ListProductStatement stmt = new ListProductStatement(type);
stmt.Prepare(db.connection);
using (var reader = db.ExecutePreparedStatementReader(stmt))
{
if (reader != null && reader.HasRows)
{
SqlParser parser = new SqlParser();
insurances = parser.ReadFromReader(reader);
}
}
}
}
return(insurances);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
string username = userInput.Text;
string password = pwInput.Text;
//if (username.Equals("user") && password.Equals("pw"))
//{
// GlobalVariables.User.Name = username;
// GlobalVariables.User.Birthday = new DateTime(1997, 11, 22);
// GlobalVariables.User.Address = "1150 Wien";
// this.Frame.Navigate(typeof(ChooseOption));
//}
//else if (username.Equals("admin") && password.Equals("pw"))
//{
// //this.Frame
//}
//else if (username.Equals("provider") && password.Equals("pw"))
//{
//}
//else if (username.Equals("adviser") && password.Equals("pw"))
//{
//}
//else
//{
// allertMessage.Text = "Wrong Username or Password";
//}
using (var db = new InsuranceDataBaseAccess(GlobalVariables.DATABASE.SERVERNAME,
GlobalVariables.DATABASE.USERNAME, GlobalVariables.DATABASE.PASSWORD))
{
if (db.Open())
{
IPreparedStatement stmt = new LoginUserStatement(username, password);
stmt.Prepare(db.connection);
using (var reader = db.ExecutePreparedStatementReader(stmt))
{
if (reader != null && reader.HasRows)
{
reader.Read();
int id = reader.GetInt32(0);
string name = reader.GetString(1);
DateTime birthday = reader.GetDateTime(2);
string residence = reader.GetString(3);
bool isConsultant = reader.GetBoolean(4);
bool isAdmin = reader.GetBoolean(5);
if (!isAdmin && !isConsultant)
{
GlobalVariables.User.Name = name;
GlobalVariables.User.Birthday = birthday;
GlobalVariables.User.Address = residence;
GlobalVariables.User.Id = id;
this.Frame.Navigate(typeof(ChooseOption));
}
else if (isAdmin)
{
this.Frame.Navigate(typeof(ChooseOptionAdm));
}
else if (isConsultant)
{
this.Frame.Navigate(typeof(ChooseOptionAdv));
}
}
else
{
allertMessage.Text = "Wrong Username or Password";
}
}
}
else
{
allertMessage.Text = "Wrong Username or Password";
}
}
}
