private void add_new_cage_btn_Click(object sender, EventArgs e) { //Add constrain cage.Update(); StoreInfo.sharedStoreInfo().main.RefreshNameCageList(); this.Close(); }
public void RefreshList() { CageList = new List <Cage>(); DataSet data = StoreInfo.sharedStoreInfo().LoadTable("cage_tb"); foreach (DataTable table in data.Tables) { foreach (DataRow row in table.Rows) { int id = Convert.ToInt32(row.ItemArray[0].ToString()); string name = row.ItemArray[1].ToString(); int height = Convert.ToInt32(row.ItemArray[2].ToString()); int width = Convert.ToInt32(row.ItemArray[3].ToString()); int length = Convert.ToInt32(row.ItemArray[4].ToString()); float latitude = float.Parse(row.ItemArray[5].ToString()); float longitude = float.Parse(row.ItemArray[6].ToString()); int doors = Convert.ToInt32(row.ItemArray[7].ToString()); int animalLimit = Convert.ToInt32(row.ItemArray[8].ToString()); int peopleLimit = Convert.ToInt32(row.ItemArray[9].ToString()); bool open = Convert.ToBoolean(row.ItemArray[10].ToString()); bool humanInside = Convert.ToBoolean(row.ItemArray[11].ToString()); bool exhibitInside = Convert.ToBoolean(row.ItemArray[12].ToString()); Cage cage = new Cage(id, name, height, width, length, latitude, longitude, doors, peopleLimit, animalLimit, open, humanInside, exhibitInside); CageList.Add(cage); } } }
private void logout_btn_Click(object sender, EventArgs e) { StoreInfo.sharedStoreInfo().Global_LoginStatus = false; MessageBox.Show("Log out successfully!!"); this.Hide(); Login_Form lg = new Login_Form(); lg.ShowDialog(); this.Close(); }
public Main_Form() { InitializeComponent(); StoreInfo.sharedStoreInfo().main = this; //show username username_label.Text = StoreInfo.sharedStoreInfo().Global_Username; //Cage manager RefreshNameCageList(); //Animal Manager RefreshNameAnimalList(); CheckInventory(); }
public void RefreshList() { AnimalList = new List <Animal>(); DataSet data = StoreInfo.sharedStoreInfo().LoadTable("animalrecords_tb"); foreach (DataTable table in data.Tables) { foreach (DataRow row in table.Rows) { int id = Convert.ToInt32(row.ItemArray[0].ToString()); string name = row.ItemArray[1].ToString(); Animal animal = new Animal(id, name); AnimalList.Add(animal); } } }
private void login_btn_Click(object sender, EventArgs e) { string user = this.username_input.Text; string pass = this.password_input.Text; if (StoreInfo.sharedStoreInfo().CheckLogin(user, pass)) { this.Hide(); Main_Form mf = new Main_Form(); mf.ShowDialog(); this.Close(); } else { MessageBox.Show("Login failed!!!!\nYour username and password are incorrect"); } }
private string LoadAnimalName(int ID) { string mock = null; DataSet ds = StoreInfo.sharedStoreInfo().LoadTable("animalrecords_tb"); foreach (DataTable table in ds.Tables) { foreach (DataRow row in table.Rows) { if (Convert.ToInt32(row.ItemArray[0]) == ID) { mock = row.ItemArray[1].ToString(); } } } return(mock); }
public void CheckLogin(string username, string password) { MySqlConnection connection = new MySqlConnection(myConnectionString); connection.Open(); try { MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM user"; MySqlDataAdapter adap = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); adap.Fill(ds); foreach (DataTable table in ds.Tables) { foreach (DataRow row in table.Rows) { if (username == row.ItemArray[0].ToString() && password == row.ItemArray[1].ToString()) { StoreInfo.sharedStoreInfo().Global_Username = username; StoreInfo.sharedStoreInfo().Global_Password = password; StoreInfo.sharedStoreInfo().Global_LoginStatus = true; } } } } catch (Exception) { throw; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } }
private void add_new_animal_btn_Click(object sender, EventArgs e) { animal.Update(); StoreInfo.sharedStoreInfo().main.RefreshNameAnimalList(); this.Close(); }