private void RequestDetails_Load(object sender, EventArgs e) { // TODO: Ten wiersz kodu wczytuje dane do tabeli 'rSSDataSet.ACTIVITY' . Możesz go przenieść lub usunąć. //this.aCTIVITYTableAdapter.Fill(this.rSSDataSet.ACTIVITY); var dataSource = new List <string>(); if (_status == "ACT") { dataSource.Add("ACT"); dataSource.Add("CAN"); dataSource.Add("EXP"); } else if (_status == "CAN") { dataSource.Add("CAN"); dataSource.Add("ACT"); dataSource.Add("EXP"); } else { dataSource.Add("EXP"); dataSource.Add("ACT"); dataSource.Add("CAN"); } comboBox1.DataSource = dataSource; var result = SQLmanager.SearchActivity(this.textBox1.Text.ToString()); dataGridView1.DataSource = result; }
private void AddVehicle_Load(object sender, EventArgs e) { // TODO: Ten wiersz kodu wczytuje dane do tabeli 'rSSDataSet.OBJECT' . Możesz go przenieść lub usunąć. //this.oBJECTTableAdapter.Fill(this.rSSDataSet.OBJECT); // TODO: Ten wiersz kodu wczytuje dane do tabeli 'rSSDataSet.OBJ_TYPE' . Możesz go przenieść lub usunąć. //this.oBJ_TYPETableAdapter.Fill(this.rSSDataSet.OBJ_TYPE); if (_ifRequest == true) { var result0 = Baza.SQLmanager.SearchCustomers(_id); dataGridView1.DataSource = result0; } else { var result0 = Baza.SQLmanager.SearchCustomers("", "", ""); dataGridView1.DataSource = result0; } var types = SQLmanager.GetAllObjectTypes().ToList(); comboBox1.DataSource = types; var clients = SQLmanager.GetAllClients().ToList(); //comboBox2.DataSource = clients; }
private void button1_Click(object sender, EventArgs e) { var nr_object = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); //var obj = SQLmanager.GetSingleObjectFull(nr_object); VehicleDetails a1 = new VehicleDetails(); a1.textBox6.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); //reg a1.textBox10.Text = this.dataGridView1.CurrentRow.Cells[1].Value.ToString(); //name a1.textBox9.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString(); //obj type var client = SQLmanager.SearchCustomerFromID(this.dataGridView1.CurrentRow.Cells[2].Value.ToString()); //client id a1.textBox5.Text = client.First().id_client.ToString(); //client id a1.textBox1.Text = client.First().first_name; //fname a1.textBox2.Text = client.First().last_name; //lname a1.textBox3.Text = client.First().name;; //name a1.textBox4.Text = client.First().tel;; //tel var obj_type = SQLmanager.SearchObjType(this.dataGridView1.CurrentRow.Cells[3].Value.ToString()); a1.textBox8.Text = obj_type.First().name; //obj_type name a1.ShowDialog(); }
public void initial() { market = new RequestManager(); rq = new RequestAgent(); userInfo = (MarketUserData)market.SendQueryUserRequest(); sql = new SQLmanager(); ama = new AutonomousMarketAgent(); }
public AutonomousMarketAgent()//This function responsible on the timer, to restart him and call the necessary function { aTimer = new Timer(); myManager = new SQLmanager(); aTimer.Interval = 10000; aTimer.Elapsed += new ElapsedEventHandler(OnTimedEvent); aTimer.AutoReset = true; }
//private void button3_Click(object sender, EventArgs e) //{ // AddVehicle a1 = new AddVehicle(); // a1.ShowDialog(); //} private void ShowCustomerDetails_Load(object sender, EventArgs e) { // TODO: Ten wiersz kodu wczytuje dane do tabeli 'rSSDataSet.OBJECT' . Możesz go przenieść lub usunąć. //this.oBJECTTableAdapter.Fill(this.rSSDataSet.OBJECT); var result = SQLmanager.SearchObjects2(this.textBox5.Text.ToString()); dataGridView1.DataSource = result; }
private void addButton1_Click(object sender, EventArgs e) { AddVehicle a1 = new AddVehicle(false, 0); a1.ShowDialog(); var result = SQLmanager.SearchObjects("", "", ""); dataGridView1.DataSource = result; }
private void button1_Click(object sender, EventArgs e) { var act = SQLmanager.SearchActivityDictionary(textBox2.Text); string act_ = act.First().ToString(); Baza.SQLmanager.UpdateActivity(_id_act, _seqNumber, richTextBox1.Text, comboBox2.SelectedItem.ToString(), comboBox1.Text, dateTimePicker2.Value, dateTimePicker1.Value, act_); MessageBox.Show("The activity has been updated"); this.Close(); }
private void addButton1_Click(object sender, EventArgs e) { AddCustomer a1 = new AddCustomer(); a1.ShowDialog(); UsersDataLoad(); var result = SQLmanager.SearchCustomers("", "", ""); dataGridView1.DataSource = result; }
//public string _actDic; public Activity(int act_id, int req_id, int seqNumber, string actDic, string desc, string status, DateTime dreg, DateTime dfc) { InitializeComponent(); _id_act = act_id; _id_req = req_id; _seqNumber = seqNumber; //_actDic = actDic; textBox3.Text = _id_act.ToString(); textBox3.Enabled = false; textBox1.Text = _id_req.ToString(); textBox1.Enabled = false; textBox5.Text = _seqNumber.ToString(); textBox5.Enabled = false; var act_type = SQLmanager.SearchActivityDictionaryType(actDic); textBox2.Text = act_type.First().ToString(); //textBox4.Text = result; richTextBox1.Text = desc; dateTimePicker1.Value = dfc; //data fin/can dateTimePicker2.Value = dreg; //data rejestracji //comboBox1.DataSource = Baza.SQLmanager.GetAvailableActivity().ToList(); comboBox2.DataSource = Baza.SQLmanager.GetAvailableWorkers().ToList(); var dataSource = new List <string>(); if (status == "ACT") { dataSource.Add("ACT"); dataSource.Add("CAN"); dataSource.Add("EXP"); } else if (status == "CAN") { dataSource.Add("CAN"); dataSource.Add("ACT"); dataSource.Add("EXP"); } else { dataSource.Add("EXP"); dataSource.Add("ACT"); dataSource.Add("CAN"); } comboBox1.DataSource = dataSource; }
private void button1_Click(object sender, EventArgs e) { //int.TryParse(comboBox2.SelectedValue.ToString(), out int id_client); //SQLmanager.AddVehicle(textBox1.Text,textBox2.Text, comboBox1.SelectedValue.ToString(), id_client); Int32 id = Int32.Parse(this.dataGridView1.CurrentRow.Cells[0].Value.ToString()); string reg = this.textBox1.Text; string model = this.textBox2.Text; var type = SQLmanager.SearchObjectTypeFromName(this.comboBox1.Text); string type_ = type.First().ToString(); SQLmanager.AddVehicle(reg, model, type_, id); //MessageBox.Show("The vehicle has been added to database"); this.Close(); MessageBox.Show("The vehicle has been added to database"); }
private void searchBox_Click(object sender, EventArgs e) { string d; if (dateTimePicker2.Checked == true) { d = dateTimePicker2.Text.ToString(); } else { d = ""; } var request = SQLmanager.SearchRequests(comboBox1.Text.ToString(), d, objectBox.Text.ToString()); dataGridView1.DataSource = request; }
private void button1_Click(object sender, EventArgs e) { if (this.dataGridView1.CurrentRow == null) { MessageBox.Show("The chosen activity does not exist, please create new avtivity or choose another"); var result1 = SQLmanager.SearchActivity(this.textBox1.Text.ToString()); dataGridView1.DataSource = result1; } else if (this.dataGridView1.CurrentRow.Cells[4].Value.ToString() == null && this.dataGridView1.CurrentRow.Cells[5].Value.ToString() == null) { Activity a1 = new Activity(Int32.Parse(this.dataGridView1.CurrentRow.Cells[0].Value.ToString()), Int32.Parse(this.dataGridView1.CurrentRow.Cells[6].Value.ToString()), Int32.Parse(this.dataGridView1.CurrentRow.Cells[9].Value.ToString()), this.dataGridView1.CurrentRow.Cells[8].Value.ToString(), this.dataGridView1.CurrentRow.Cells[1].Value.ToString(), this.dataGridView1.CurrentRow.Cells[3].Value.ToString(), DateTime.Parse("10.10.1999 00:00:00"), DateTime.Parse("10.10.1999 00:00:00")); a1.ShowDialog(); } else if (this.dataGridView1.CurrentRow.Cells[4].Value.ToString() == null && this.dataGridView1.CurrentRow.Cells[5].Value.ToString() != null) { Activity a1 = new Activity(Int32.Parse(this.dataGridView1.CurrentRow.Cells[0].Value.ToString()), Int32.Parse(this.dataGridView1.CurrentRow.Cells[6].Value.ToString()), Int32.Parse(this.dataGridView1.CurrentRow.Cells[9].Value.ToString()), this.dataGridView1.CurrentRow.Cells[8].Value.ToString(), this.dataGridView1.CurrentRow.Cells[1].Value.ToString(), this.dataGridView1.CurrentRow.Cells[3].Value.ToString(), DateTime.Parse("10.10.1999 00:00:00"), DateTime.Parse(this.dataGridView1.CurrentRow.Cells[5].Value.ToString())); a1.ShowDialog(); } else if (this.dataGridView1.CurrentRow.Cells[4].Value != null && this.dataGridView1.CurrentRow.Cells[5].Value == null) { Activity a1 = new Activity(Int32.Parse(this.dataGridView1.CurrentRow.Cells[0].Value.ToString()), Int32.Parse(this.dataGridView1.CurrentRow.Cells[6].Value.ToString()), Int32.Parse(this.dataGridView1.CurrentRow.Cells[9].Value.ToString()), this.dataGridView1.CurrentRow.Cells[8].Value.ToString(), this.dataGridView1.CurrentRow.Cells[1].Value.ToString(), this.dataGridView1.CurrentRow.Cells[3].Value.ToString(), DateTime.Parse(this.dataGridView1.CurrentRow.Cells[4].Value.ToString()), DateTime.Parse("10.10.1999 00:00:00")); a1.ShowDialog(); } else { Activity a1 = new Activity(Int32.Parse(this.dataGridView1.CurrentRow.Cells[0].Value.ToString()), Int32.Parse(this.dataGridView1.CurrentRow.Cells[6].Value.ToString()), Int32.Parse(this.dataGridView1.CurrentRow.Cells[9].Value.ToString()), this.dataGridView1.CurrentRow.Cells[8].Value.ToString(), this.dataGridView1.CurrentRow.Cells[1].Value.ToString(), this.dataGridView1.CurrentRow.Cells[3].Value.ToString(), DateTime.Parse(this.dataGridView1.CurrentRow.Cells[4].Value.ToString()), DateTime.Parse(this.dataGridView1.CurrentRow.Cells[5].Value.ToString())); a1.ShowDialog(); } var result = SQLmanager.SearchActivity(this.textBox1.Text.ToString()); dataGridView1.DataSource = result; }
private void button1_Click(object sender, EventArgs e) { EditCustomerDetails a1 = new EditCustomerDetails(); a1.textBox5.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); //id a1.textBox5.Enabled = false; a1.textBox1.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString(); //fname a1.textBox2.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString(); //lname a1.textBox3.Text = this.dataGridView1.CurrentRow.Cells[1].Value.ToString(); //name a1.textBox4.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString(); //tel a1.ShowDialog(); var result = SQLmanager.SearchCustomers("", "", ""); dataGridView1.DataSource = result; }
private void button3_Click(object sender, EventArgs e) { AddActivity add = new AddActivity(Int32.Parse(textBox1.Text), dateTimePicker2.Value, dateTimePicker1.Value); add.Show(); var result = SQLmanager.SearchActivity(this.textBox1.Text.ToString()); dataGridView1.DataSource = result; var result1 = SQLmanager.SearchActivity(this.textBox1.Text.ToString()); dataGridView1.DataSource = result1; /*dataGridView1.Update(); * dataGridView1.Refresh(); * var result = SQLmanager.SearchActivity(this.textBox1.Text.ToString()); * dataGridView1.DataSource = result;*/ }
private void button2_Click(object sender, EventArgs e) { var obj = SQLmanager.SearchObjects3(this.dataGridView1.CurrentRow.Cells[7].Value.ToString()); var customer = SQLmanager.SearchCustomerFromID(obj.First().id_client.ToString()); string customer2 = customer.First().first_name.ToString() + " " + customer.First().last_name.ToString() + " " + customer.First().name.ToString(); RequestDetails a1 = new RequestDetails(this.dataGridView1.CurrentRow.Cells[2].Value.ToString()); a1.textBox1.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); //id a1.richTextBox1.Text = this.dataGridView1.CurrentRow.Cells[1].Value.ToString(); //description if (this.dataGridView1.CurrentRow.Cells[3].Value == null) { a1.richTextBox2.Text = ""; } else { a1.richTextBox2.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString(); //result } //a1.comboBox1.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString(); //status a1.textBox2.Text = customer2; //customer data a1.textBox3.Text = this.dataGridView1.CurrentRow.Cells[7].Value.ToString(); //vehicle data a1.dateTimePicker1.Value = Convert.ToDateTime(this.dataGridView1.CurrentRow.Cells[4].Value.ToString()); //start date if (this.dataGridView1.CurrentRow.Cells[5].Value == null) { a1.richTextBox2.Text = ""; } else { a1.dateTimePicker2.Value = Convert.ToDateTime(this.dataGridView1.CurrentRow.Cells[5].Value.ToString()); //final date } a1.ShowDialog(); var result = SQLmanager.SearchRequests(); dataGridView1.DataSource = result; }
private void searchBox_Click(object sender, EventArgs e) { var result = SQLmanager.SearchObjects(textBox4.Text.ToString(), textBox3.Text.ToString(), textBox2.Text.ToString()); dataGridView1.DataSource = result; }
private void button1_Click(object sender, EventArgs e) { SQLmanager.EditCustomer(textBox5.Text.ToString(), textBox3.Text.ToString(), textBox1.Text.ToString(), textBox2.Text.ToString(), textBox4.Text.ToString()); this.Close(); MessageBox.Show("User updated successfully"); }
public StatsManager() { RA = new RequestAgent(); SM = new SQLmanager(); }
private void Requests_Load(object sender, EventArgs e) { var result = SQLmanager.SearchRequests(); dataGridView1.DataSource = result; }
private void searchBox_Click(object sender, EventArgs e) { var result = SQLmanager.SearchCustomers(nameBox.Text.ToString(), fnameBox.Text.ToString(), textBox1.Text.ToString()); dataGridView1.DataSource = result; }
private void button4_Click(object sender, EventArgs e) { var result = SQLmanager.SearchActivity(this.textBox1.Text.ToString()); dataGridView1.DataSource = result; }
private void UsersDataLoad(string name = "", string fname = "", string lname = "") { var result = SQLmanager.SearchCustomers(name, fname, lname); dataGridView1.DataSource = result; }
private void Vehicle_Load(object sender, EventArgs e) { var result = SQLmanager.SearchObjects("", "", ""); dataGridView1.DataSource = result; }