private void addBtn_Click(object sender, EventArgs e) { db.Connect(); string temName = DBUtil.AddQuotes(nameTB.Text); string temDesc = DBUtil.AddQuotes(descTB.Text); string[] evFields = new string[] { "name", "description", "expert_id" }; string[] evValues = new string[] { temName, temDesc, user.ToString() }; int evId = db.InsertToBD("event_template", evFields, evValues); foreach (DataGridViewRow row in materialListGrid.Rows) { Resource res = row.Cells[0].Value as Resource; if (res != null) { string desc = ""; string value = ""; //if (row.Cells[descCol].Value != null) // desc = DBUtil.AddQuotes(row.Cells[descCol].Value.ToString()); //if (row.Cells[valueCol].Value != null) // value = row.Cells[valueCol].Value.ToString(); string[] fields = { "template_id", "resource_id" }; string[] values = { evId.ToString(), res.id.ToString() }; db.InsertToBD("template_resource", fields, values); } } db.Disconnect(); }
private void loginBtn_Click(object sender, EventArgs e) { //db.Connect(); string login = DBUtil.AddQuotes(loginTB.Text); string pass = DBUtil.AddQuotes(passTB.Text); var user = db.GetRows("user", "*", "user_name=" + login + " AND password="******"Користувача знайдено. Id експерта = " + user[0][2].ToString()); // LoginHandler(Int32.Parse(user[0][2].ToString())); // new Main().ShowDialog(); DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Користувача не знайдено"); DialogResult = DialogResult.None; } db.Disconnect(); }
private void addBtn_Click(object sender, EventArgs e) { db.Connect(); string[] fields = { "name", "description" }; string[] values = { DBUtil.AddQuotes(nameTB.Text), DBUtil.AddQuotes(descTB.Text) }; db.InsertToBD("resource", fields, values); db.Disconnect(); this.Close(); }
private void EditCurrentUser(object sender, DataGridViewCellMouseEventArgs e) { int currentRow = this.UsersDGV.CurrentCell.RowIndex; string userName = this.UsersDGV.Rows[currentRow].Cells[0].Value.ToString(); string userPassword = this.UsersDGV.Rows[currentRow].Cells[1].Value.ToString(); string userType = this.UsersDGV.Rows[currentRow].Cells[2].Value.ToString(); this.userName = DBUtil.AddQuotes(userName); this.UsernameTextBox.Text = userName; this.PasswordTextBox.Text = userPassword; this.ExperTypeTextBox.Text = userType; }
private void deleteCurrentUser(object sender, EventArgs e) { string userName = DBUtil.AddQuotes(this.UsernameTextBox.Text); string userPassword = DBUtil.AddQuotes(this.PasswordTextBox.Text); string userType = DBUtil.AddQuotes(this.ExperTypeTextBox.Text); db.Connect(); db.DeleteFromDB("user", "user_name", userName); db.Disconnect(); RefreshDVG(); }
private void UpdateCurrentUser(object sender, EventArgs e) { string userName = DBUtil.AddQuotes(this.UsernameTextBox.Text.Replace('\'', '`')); string userPassword = DBUtil.AddQuotes(this.PasswordTextBox.Text.Replace('\'', '`')); string userType = DBUtil.AddQuotes(this.ExperTypeTextBox.Text.Replace('\'', '`')); string[] updateCols = new string[] { "user_name", "user_name", "password", "id_of_expert" }; string[] updateVals = new string[] { this.userName, userName, userPassword, userType }; db.Connect(); db.UpdateRecord("user", updateCols, updateVals); db.Disconnect(); RefreshDVG(); }
private void addBtn_Click(object sender, EventArgs e) { try { db.Connect(); string[] fields = { "name", "description", "price", "units" }; string[] values = { DBUtil.AddQuotes(nameTB.Text), DBUtil.AddQuotes(descTB.Text), Double.Parse(priceTB.Text).ToString(), DBUtil.AddQuotes(unitsTB.Text) }; db.InsertToBD("resource", fields, values); db.Disconnect(); this.Close(); } catch (Exception) { MessageBox.Show("Неправильно введено ціну."); } }
private void addBtn_Click(object sender, EventArgs e) { item.name = nameTB.Text; item.description = descrTB.Text; db.Connect(); string[] cols = { "issue_id", "name", "description" }; //int calcSeriesId = (seriesCB.SelectedItem as CalculationSeries).id; //string calcSeries = calcSeriesId == -1 ? "null" : calcSeriesId.ToString(); string[] values = { item.id.ToString(), DBUtil.AddQuotes(nameTB.Text), DBUtil.AddQuotes(descrTB.Text) }; db.UpdateRecord("issues", cols, values); db.Disconnect(); this.Close(); }
private void addBtn_Click(object sender, EventArgs e) { db.Connect(); string[] fields = { "name", "description" }; string[] values = { DBUtil.AddQuotes(nameTB.Text), DBUtil.AddQuotes(descrTB.Text) }; int id = db.InsertToBD("issues", fields, values); //Issue issue = new Issue(id, nameTB.Text, descrTB.Text, DateTime.Now, calcSeries); //issuesLB.Items.Add(issue); db.Disconnect(); this.Close(); }
private void addBtn_Click(object sender, EventArgs e) { var ev = templatesLB.SelectedItem as Event; db.Connect(); string[] cols = { "template_id", "name", "description" }; string[] values = { ev.id.ToString(), DBUtil.AddQuotes(nameTB.Text), DBUtil.AddQuotes(descTB.Text) }; ev.name = nameTB.Text; ev.description = descTB.Text; templatesLB.Refresh(); db.UpdateRecord("event_template", cols, values); //Get all resources for thar template var ress = db.GetRows("template_resource", "resource_id", "template_id=" + ev.id); //Update resources for event foreach (DataGridViewRow row in materialListGrid.Rows) { var res = row.Cells[0].Value as Resource; //Remove present resources to delete left ones ress.RemoveAll(o => Int32.Parse(o[0].ToString()) == res.id); string[] resCols = { "template_id" }; string[] resValues = { ev.id + " AND resource_id=" + res.id }; if (db.GetRows("template_resource", "*", "template_id=" + ev.id + " AND resource_id=" + res.id).Count == 0) { string[] resColsIns = { "template_id", "resource_id" }; string[] resValuesIns = { ev.id.ToString(), res.id.ToString() }; db.InsertToBDWithoutId("template_resource", resColsIns, resValuesIns); } } //Delete resources thar are not in grid view foreach (var resId in ress) { string resCols = "template_id"; string resValues = ev.id + " AND resource_id=" + resId[0].ToString(); db.DeleteFromDB("template_resource", resCols, resValues); } db.Disconnect(); }
private void AddNewUser(object sender, EventArgs e) { string userName = DBUtil.AddQuotes(this.UsernameTextBox.Text); string userPassword = DBUtil.AddQuotes(this.PasswordTextBox.Text); string userType = DBUtil.AddQuotes(this.ExperTypeTextBox.Text); string[] fields = new string[] { "user_name", "password", "id_of_expert" }; string[] values = new string[] { userName, userPassword, userType }; db.Connect(); db.InsertToBD("user", fields, values); db.Disconnect(); RefreshDVG(); }
private void saveBtn_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in resDGV.Rows) { if (row.Cells[0].Value is Resource res) { db.Connect(); string[] cols = { "resource_id", "name", "description" }; string[] values = { res.id.ToString(), DBUtil.AddQuotes(res.name), DBUtil.AddQuotes(res.description) }; db.UpdateRecord("resource", cols, values); db.Disconnect(); } } }
private void button1_Click(object sender, EventArgs e) { Event ev = eventsLB.SelectedItem as Event; db.Connect(); string evName = DBUtil.AddQuotes(evNameTB.Text); string evDesc = DBUtil.AddQuotes(descTB.Text); string[] evFields = new string[] { "name", "description", "id_of_user", "issue_id" }; string issueId = (issuesCB.SelectedItem as Issue).id.ToString(); string[] evValues = new string[] { evName, evDesc, user.ToString(), issueId }; int evId = db.InsertToBD("event", evFields, evValues); foreach (DataGridViewRow row in eventListGrid.Rows) { if (row.Cells[0].Value is Resource) { var res = row.Cells[0].Value as Resource; string desc = ""; string value = ""; if (row.Cells[descCol].Value != null) { desc = DBUtil.AddQuotes(row.Cells[descCol].Value.ToString()); } if (row.Cells[valueCol].Value != null) { value = row.Cells[valueCol].Value.ToString(); } string[] fields = { "event_id", "resource_id", "value", "description" }; string[] values = { evId.ToString(), res.id.ToString(), value, desc }; db.InsertToBD("event_resource", fields, values); } } db.Disconnect(); MessageBox.Show("Захід " + evNameTB.Text + " додано."); }
private void loginBtn_Click(object sender, EventArgs e) { db.Connect(); string login = DBUtil.AddQuotes(loginTB.Text); string pass = DBUtil.AddQuotes(passTB.Text); var user = db.GetRows("user", "*", "user_name=" + login + " AND password="******"User found. Expert id is" + user[0][2].ToString()); LoginHandler(Int32.Parse(user[0][2].ToString())); this.Visible = false; } else { MessageBox.Show("No user found"); } db.Disconnect(); }