private void btnSave_Click(object sender, EventArgs e) { int category_id = AddQuation.getCatId(this.cmbInfoCategory.Text); string answer = this.txtInfoAnswer.Text; string sql = "UPDATE Quations SET answer = '" + answer + "', category_id = " + category_id; if (ofd.FileName != "") { string imageName = DateTime.Now.ToString("yyyyMMddHHssmm") + ofd.SafeFileName; Extentions.ImageUpload(ofd, imageName, "Quations_Images"); Extentions.DeleteFile(this.seleced.Image, "Quations_Images"); sql += ", image = '" + imageName + "' WHERE id = " + this.seleced.Id; } else { sql += " WHERE id = " + this.seleced.Id; } SQLiteCommand com = new SQLiteCommand(sql, con); con.Open(); com.ExecuteNonQuery(); con.Close(); //this.fillPanel(this.getAllQuations()); int id = AddQuation.getCatId(this.cmbCategory.Text); this.fillPanel(this.getAllQuations(null, id)); this.grpInfo.Visible = false; }
private void btnCancel_Click(object sender, EventArgs e) { this.grpInfo.Visible = false; this.selectedNumber = null; int id = AddQuation.getCatId(this.cmbCategory.Text); this.fillPanel(this.getAllQuations(null, id)); //this.fillPanel(this.getAllQuations()); }
void selectQuationForNumber(string number = "") { this.selectedNumber = null; if (this.cmbCategory.SelectedIndex != -1) { int id = AddQuation.getCatId(this.cmbCategory.Text); this.fillPanel(this.getAllQuations(null, id)); } if (number != "") { foreach (var control in this.pnlAllQuations.Controls) { GroupBox grp = control as GroupBox; if (grp.Text == number) { this.selectedNumber = grp.Text; this.fillPanel(this.getAllQuations(Convert.ToInt32(grp.Name))); return; } } } }
private void cmbCategory_SelectedIndexChanged(object sender, EventArgs e) { int id = AddQuation.getCatId(this.cmbCategory.Text); this.fillPanel(this.getAllQuations(null, id)); }