private void btnCottageSearch_Click(object sender, EventArgs e)
{
try
{
//Get's data from form components, and does a query to the DB. Updates CottageDataGridView-component to show search results
string query = "SELECT * FROM mokki " +
"WHERE toimintaalue_id = " + RegionUtils.RegionNameToIndex(cbCottageRegions.Text) + " " +
"AND postinro LIKE '%" + TextBoxUtils.ModifyInput(tbCottagePostNum.Text, 5) + "%' " +
"AND mokkinimi LIKE '%" + TextBoxUtils.ModifyInput(tbCottageName.Text, 45) + "%' " +
"AND katuosoite LIKE '%" + TextBoxUtils.ModifyInput(tbCottageStreetAddress.Text, 45) + "%' " +
"AND kuvaus LIKE '%" + TextBoxUtils.ModifyInput(tbCottageDescription.Text, 500) + "%' " +
"AND henkilomaara > '" + (nudCottageCapacity.Value - 1) + "' " +
"AND varustelu LIKE '%" + cbCottageEqupment.Text + "%' " +
"AND hinta <(" + Convert.ToDouble(nudCottagePrice.Value + 1) + ");";
try
{
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter(query, ConnectionUtils.connection);
adapter.Fill(table);
dgvCottage.DataSource = table;
}
catch (Exception ex)
{
MessageBox.Show("Virhe tietojen hakemisessa. Tarkista tiedot ja yritä uudelleen. Lisätietoja: " + ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show("Virhe haun tekemisessä. Tarkista tiedot ja yritä uudelleen. Lisätietoja: " + ex.Message);
}
}
private void tcMain_SelectedIndexChanged(object sender, EventArgs e)
{
//Update each tabs components when switching to the tab
if (tcMain.SelectedTab.Name == "tSearch")
{
RegionUtils.PopulateCBRegion(cbSearchAluet);
}
else if (tcMain.SelectedTab.Name == "tRentControl")
{
PopulateDGVOrder();
}
else if (tcMain.SelectedTab.Name == "tAreaControl")
{
PopulateDGVRegion();
}
else if (tcMain.SelectedTab.Name == "tCustomerControl")
{
PopulateDGVCustomer();
}
else if (tcMain.SelectedTab.Name == "tServiceControl")
{
PopulateDGVCottage();
PopulateDGVService();
RegionUtils.PopulateCBRegion(cbCottageRegions);
RegionUtils.PopulateCBRegion(cbServiceRegion);
}
else if (tcMain.SelectedTab.Name == "tBilling")
{
PopulateDGVBilling();
}
}
private void btnServiceSearch_Click(object sender, EventArgs e)
{
try
{
//Get's data from form components, and does a query to the DB. Updates ServiceDataGridView-component to show search results
string query = "SELECT * FROM palvelu " +
"WHERE toimintaalue_id = " + RegionUtils.RegionNameToIndex(cbServiceRegion.Text) + " " +
"AND nimi LIKE '%" + TextBoxUtils.ModifyInput(tbServiceName.Text, 40) + "%' " +
"AND tyyppi LIKE '%" + tbServiceType.Text + "%' " +
"AND kuvaus LIKE '%" + TextBoxUtils.ModifyInput(tbServiceDescription.Text, 500) + "%' " +
"AND hinta <(" + (nudServicePrice.Value + 1) + ");";
try
{
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter(query, ConnectionUtils.connection);
adapter.Fill(table);
dgvService.DataSource = table;
dgvService.Columns[0].HeaderText = "Palvelu ID";
dgvService.Columns[1].HeaderText = "Toiminta-alue ID";
dgvService.Columns[2].HeaderText = "Nimi";
dgvService.Columns[3].HeaderText = "Tyyppi";
dgvService.Columns[4].HeaderText = "Kuvaus";
dgvService.Columns[5].HeaderText = "Hinta (€)";
dgvService.Columns[6].HeaderText = "Alv (%)";
}
catch (Exception ex)
{
MessageBox.Show("Virhe tietojen hakemisessa. Tarkista tiedot ja yritä uudelleen. Lisätietoja: " + ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show("Virhe haun tekemisessä. Tarkista tiedot ja yritä uudelleen. Lisätietoja: " + ex.Message);
}
}
float ComputeDotPosY(Beacon foundBeacon)
{
// Put the dot at the end of the scale when it's further than 6m.
double x = RegionUtils.ComputeAccuracy(foundBeacon);
Log.Debug(Tag, "Beacon is approx. {0:N1} metres away", x);
double distance = Math.Min(x, 6.0);
return(_startY + (int)(_segmentLength * (distance / 6.0)));
}
public ModifyServiceForm(Service s)
{
//Used to import services data to from
InitializeComponent();
RegionUtils.PopulateCBRegion(cbModifyServiceRegion);
lblModifyServiceID.Text = s.ServiceID.ToString();
cbModifyServiceRegion.Text = RegionUtils.RegionIndexToName(s.RegionID);
tbModifyServiceName.Text = s.Name;
tbModifyServiceType.Text = s.Type.ToString();
nudModifyServicePrice.Value = (int)s.Price;
nudModifyServiceVAT.Value = (int)s.Vat;
tbModifyServiceDescription.Text = s.Description;
}
private void btnModifyCottageModify_Click(object sender, EventArgs e)
{
//Make sure the data should be modified
DialogResult result = MessageBox.Show("Haluatko varmasti muuttaa valitun mökin tietoja?", "Muuta mökin tietoja",
MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
try
{
//Updates cottages information in the database. Gets data from form components, cottage is uniquely identified by cottageID, which can't be modified
string query = "START TRANSACTION; " +
"UPDATE mokki " +
"SET toimintaalue_id=" + RegionUtils.RegionNameToIndex(cbModifyCottageRegion.Text) +
",postinro='" + TextBoxUtils.ModifyInput(tbModifyCottagePostNum.Text, 5) +
"',mokkinimi='" + TextBoxUtils.ModifyInput(tbModifyCottageName.Text, 45) +
"',katuosoite='" + TextBoxUtils.ModifyInput(tbModifyCottageStreet.Text, 45) + "'," +
"kuvaus='" + TextBoxUtils.ModifyInput(tbModifyCottageDescription.Text, 500) +
"',henkilomaara=" + nudModifyCottageCapacity.Value +
" ,varustelu='" + TextBoxUtils.ModifyInput(cbModifyCottageEquipment.Text, 100) +
"', hinta=" + Convert.ToDouble(nudModifyCottagePrice.Value) + " " +
"WHERE mokki_id=" + Convert.ToInt32(lblModifyCottageID.Text) + "; " +
"COMMIT;";
try
{
ConnectionUtils.OpenConnection();
MySqlCommand command = new MySqlCommand(query, ConnectionUtils.connection);
command.ExecuteNonQuery();
ConnectionUtils.CloseConnection();
this.Close();
}
catch (Exception ex)
{
//Incase of database-connection problems
ConnectionUtils.CloseConnection();
MessageBox.Show("Virhe tietojen syöttämisessä tietokantaan. Tarkista kenttien tiedot, ja yritä uudelleen myöhemmin. Lisätietoja virheestä: "
+ ex.Message.ToString());
}
}
catch (Exception ex)
{
//Incase of variable conversion problems
ConnectionUtils.CloseConnection();
MessageBox.Show("Virhe tietojen muuntamisessa. Onhan kaikkien kenttien syötteet oikein? Lisätietoja virheestä: " + ex.Message.ToString());
}
}
}
public ModifyCottageForm(Cottage c)
{
//Used to import cottage data to form
InitializeComponent();
RegionUtils.PopulateCBRegion(cbModifyCottageRegion);
lblModifyCottageID.Text = c.CottageID.ToString();
cbModifyCottageRegion.Text = RegionUtils.RegionIndexToName(c.RegionID);
tbModifyCottagePostNum.Text = c.Postal;
tbModifyCottageName.Text = c.Name;
tbModifyCottageStreet.Text = c.Address;
nudModifyCottageCapacity.Value = c.Capacity;
cbModifyCottageEquipment.Text = c.Equipment;
nudModifyCottagePrice.Value = (int)c.Price;
tbModifyCottageDescription.Text = c.Description;
}
private void btnModifyServiceModify_Click(object sender, EventArgs e)
{
//Make sure the data should be modified
DialogResult result = MessageBox.Show("Haluatko varmasti muuttaa valitun palvelun tietoja?", "Muuta palvelun tietoja",
MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
try
{
//Updates services information in the database. Gets data from form components, service is uniquely identified by serviceID, which can't be modified
string query = "START TRANSACTION; " +
"UPDATE palvelu " +
"SET toimintaalue_id=" + RegionUtils.RegionNameToIndex(cbModifyServiceRegion.Text) +
",nimi='" + TextBoxUtils.ModifyInput(tbModifyServiceName.Text, 40) +
"',tyyppi=" + Convert.ToInt32(tbModifyServiceType.Text) +
",kuvaus='" + TextBoxUtils.ModifyInput(tbModifyServiceDescription.Text, 40) + "'," +
"hinta=" + Convert.ToDouble(nudModifyServicePrice.Value) +
",alv=" + Convert.ToDouble(nudModifyServiceVAT.Value) + " " +
"WHERE palvelu_id=" + Convert.ToInt32(lblModifyServiceID.Text) + "; " +
"COMMIT;";
try
{
ConnectionUtils.OpenConnection();
MySqlCommand command = new MySqlCommand(query, ConnectionUtils.connection);
command.ExecuteNonQuery();
ConnectionUtils.CloseConnection();
this.Close();
}
catch (Exception ex)
{
//Incase of database-connection problems
ConnectionUtils.CloseConnection();
MessageBox.Show("Virhe tietojen syöttämisessä tietokantaan. Tarkista kenttien tiedot, ja yritä uudelleen myöhemmin. Lisätietoja virheestä: "
+ ex.Message.ToString());
}
}
catch (Exception ex)
{
//Incase of variable conversion problems
ConnectionUtils.CloseConnection();
MessageBox.Show("Virhe tietojen muuntamisessa. Onhan kaikkien kenttien syötteet oikein? Lisätietoja virheestä: " + ex.Message.ToString());
}
}
}
private void RentCottage_Load(object sender, EventArgs e)
{
PopulateDGVRegion();
PopulateDGVOrder();
PopulateDGVCustomer();
PopulateDGVService();
PopulateDGVCottage();
PopulateDGVBilling();
RegionUtils.PopulateCBRegion(cbSearchAluet);
RegionUtils.PopulateCBRegion(cbCottageRegions);
RegionUtils.PopulateCBRegion(cbServiceRegion);
cbSearchAluet.SelectedIndex = 0;
cbSearchVarustelu.SelectedIndex = 0;
cbBillingPaid.SelectedIndex = 2;
tbOrderSearch.Tag = tbOrderSearch.Text = "Kirjoita hakusana...";
tbOrderSearch.ForeColor = Color.Gray;
tbOrderSearch.Font = new Font("Microsoft Sans Serif", 8, FontStyle.Italic);
BillingUtils.rentCottage = this;
}
private void btnAddCottageAdd_Click(object sender, EventArgs e)
{
//Add a cottage to the database, gets data from form components
try
{
PostUtils.CheckPostal(tbAddCottagePostNum.Text, tbAddCottagePostRegion.Text);
string query = "START TRANSACTION; " +
"INSERT INTO mokki(mokki_id,toimintaalue_id,postinro,mokkinimi,katuosoite,kuvaus,henkilomaara,varustelu,hinta) " +
"VALUES(default," +
RegionUtils.RegionNameToIndex(cbAddCottageRegion.Text) + ",'" +
TextBoxUtils.ModifyInput(tbAddCottagePostNum.Text, 5) + "','" +
TextBoxUtils.ModifyInput(tbAddCottageName.Text, 45) + "','" +
TextBoxUtils.ModifyInput(tbAddCottageStreet.Text, 45) + "','" +
TextBoxUtils.ModifyInput(tbAddCottageDescription.Text, 500) + "'," +
(int)nudAddCottageCapacity.Value + ",'" +
TextBoxUtils.ModifyInput(cbAddCottageEquipment.Text, 100) + "'," +
(double)nudAddCottagePrice.Value + "); " +
"COMMIT;";
try
{
ConnectionUtils.OpenConnection();
MySqlCommand command = new MySqlCommand(query, ConnectionUtils.connection);
command.ExecuteNonQuery();
ConnectionUtils.CloseConnection();
this.Close();
}
catch (Exception ex)
{
//Incase of connction problems
ConnectionUtils.CloseConnection();
MessageBox.Show("Virhe tietojen syöttämisessä tietokantaan. Tarkista kenttien tiedot. Lisätietoja: " + ex.Message.ToString());
}
}
catch (Exception ex)
{
//Incase of exceptions in variable conversion
ConnectionUtils.CloseConnection();
MessageBox.Show("Virhe tietojen muuntamisessa. Tarkista kenttien tiedot. Lisätietoja: " + ex.Message.ToString());
}
}
private void btnAddServiceAdd_Click(object sender, EventArgs e)
{
try
{
//Add a service to the database, gets data from form components
string query = "START TRANSACTION; " +
"INSERT INTO palvelu(palvelu_id,toimintaalue_id,nimi,tyyppi,kuvaus,hinta,alv) " +
"VALUES(default," +
RegionUtils.RegionNameToIndex(cbAddServiceRegion.Text) + ",'" +
TextBoxUtils.ModifyInput(tbAddServiceName.Text, 40) + "'," +
Convert.ToInt32(tbAddServiceType.Text) + ",'" +
TextBoxUtils.ModifyInput(tbAddServiceDescription.Text, 500) + "'," +
(double)nudAddServicePrice.Value + "," +
(double)nudAddServiceVAT.Value + "); " +
"COMMIT;";
try
{
ConnectionUtils.OpenConnection();
MySqlCommand command = new MySqlCommand(query, ConnectionUtils.connection);
command.ExecuteNonQuery();
ConnectionUtils.CloseConnection();
this.Close();
}
catch (Exception ex)
{
//Incase of database-connection problems
ConnectionUtils.CloseConnection();
MessageBox.Show("Virhe tietojen syöttämisessä tietokantaan. Tarkista kenttien tiedot. Lisätietoja: " + ex.Message.ToString());
}
}
catch (Exception ex)
{
//Incase of variable conversion problems
ConnectionUtils.CloseConnection();
MessageBox.Show("Virhe tietojen muuntamisessa. Tarkista kenttien tiedot. Lisätietoja: " + ex.Message.ToString());
}
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
// Create your application here
beaconManager = new BeaconManager(this);
beaconManager.Nearable += (sender, e) =>
{
if (e.Nearables.Count == 0)
{
return;
}
RunOnUiThread(() =>
{
var items = e.Nearables.Select(n => "Id: " + n.Identifier + "Proximity: " + RegionUtils.ComputeProximity(n));
ListAdapter = new ArrayAdapter <string>(this,
Android.Resource.Layout.SimpleListItem1,
Android.Resource.Id.Text1,
items.ToArray());
ActionBar.Subtitle = string.Format("Found {0} nearables.", items.Count());
});
};
}
public ModifyServiceForm()
{
InitializeComponent();
RegionUtils.PopulateCBRegion(cbModifyServiceRegion);
}
public ModifyCottageForm()
{
InitializeComponent();
RegionUtils.PopulateCBRegion(cbModifyCottageRegion);
}
public void Display(Beacon beacon)
{
_macTextView.Text = string.Format("MAC: {0} ({1:N2})", beacon.MacAddress, RegionUtils.ComputeAccuracy(beacon));
_majorTextView.Text = string.Format("Major: {0}", beacon.Major);
_minorTextView.Text = string.Format("Minor: {0}", beacon.Minor);
_measuredPowerTextView.Text = string.Format("MPower: {0}", beacon.MeasuredPower);
_rssiTextView.Text = string.Format("RSSI: {0}", beacon.Rssi);
}
public AddCottageForm()
{
InitializeComponent();
RegionUtils.PopulateCBRegion(cbAddCottageRegion);
cbAddCottageEquipment.Text = "Hyvä";
}
