private void Loginbtn_Click_1(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtUserName.Text))
{
MessageBox.Show("Please Enter your username.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtUserName.Focus();
return;
}
try
{
Database1DataSetTableAdapters.UsersTableAdapter user = new Database1DataSetTableAdapters.UsersTableAdapter();
Database1DataSet.UsersDataTable dt = user.GetDataByUserNameAndPassword(txtUserName.Text, txtPass.Text);
if (dt.Rows.Count > 0)
{
MessageBox.Show("You have been succesfully logged in.");
if (dt.Rows[0][2].ToString() == "1")
{
Form2 f = new Form2();
f.ShowDialog();
}
else if (dt.Rows[0][2].ToString() == "2")
{
Form3 f = new Form3();
f.ShowDialog();
}
else if (dt.Rows[0][2].ToString() == "3")
{
Form4 f = new Form4();
f.ShowDialog();
}
}
else
{
MessageBox.Show("Your username or password is incorrect");
}
}
catch
{
MessageBox.Show("Message");
}
}
private void propertiesBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this.propertiesBindingSource.MoveLast();
try
{
this.propertiesBindingSource.EndEdit();
}
catch(NoNullAllowedException exception)
{
MessageBox.Show("Please fill in all fields ");
}
DataTable recentChanges = ((Database1DataSet)this.propertiesBindingSource.DataSource).Properties.GetChanges(DataRowState.Added);
String imageUrl = "";
String city = "";
String price = "";
if (recentChanges != null)
{
for (int i = 0; i < recentChanges.Rows.Count; i++)
{
String propType = recentChanges.Rows[i]["type"].ToString();
if (propType.Equals("Castle"))
{
imageUrl = "castle.png";
}
else if (propType.Equals("Flat"))
{
imageUrl = "flat.png";
}
else if (propType.Equals("House"))
{
imageUrl = "house.png";
}
city = recentChanges.Rows[i]["city"].ToString();
price = recentChanges.Rows[i]["price"].ToString();
}
}
int changes = this.tableAdapterManager.UpdateAll(this.database1DataSet);
if (changes != 0 && recentChanges != null)
{
Database1DataSetTableAdapters.UsersTableAdapter uta = new Database1DataSetTableAdapters.UsersTableAdapter();
this.usersTableAdapter = new Database1DataSetTableAdapters.UsersTableAdapter();
this.usersTableAdapter.ClearBeforeFill = false;
this.usersTableAdapter.Fill(database1DataSet.Users);
foreach (DataRow row in database1DataSet.Users.Rows)
{
foreach (DataRow newHouse in recentChanges.Rows)
{
int relInserted = users_PropertiesTableAdapter.Insert(Convert.ToInt32(row["id"]), Convert.ToInt32(newHouse["id"]));
this.database1DataSet.AcceptChanges();
this.users_PropertiesTableAdapter.Update(this.database1DataSet.Users_Properties);
}
}
this.users_PropertiesTableAdapter = new Database1DataSetTableAdapters.Users_PropertiesTableAdapter();
this.users_PropertiesTableAdapter.Fill(database1DataSet.Users_Properties);
byte[] tile = imgserv.PrepareTile(changes, city + " " + price + "€", imageUrl);
byte[] toast = imgserv.PrepareToast(city, price + "€");
imgserv.SendNotfication(1, tile);
imgserv.SendNotfication(2, toast);
Console.WriteLine("Changes made: " + changes);
}
}
