private ComboBox Populatecbo(ComboBox cboBox, Combo.ComboName comboname, string headertext, int ordercolumn) { OleDbDataReader dr; dr = GetCombo(comboname, ordercolumn); List <select> sl = new List <select>(); if (headertext != string.Empty) { sl.Add(new select() { Text = headertext, Value = -1 }); } while (dr.Read()) { sl.Add(new select() { Text = dr.GetValue(1).ToString(), Value = dr.GetInt32(0) }); } cboBox.DataSource = sl; cboBox.DisplayMember = "Text"; cboBox.ValueMember = "Value"; return(cboBox); }
public string RemoveItem(int itemid, Combo.ComboName comboname) { OleDbCommand cmd = new OleDbCommand(); OleDbConnection connCombo = new OleDbConnection(ConfigurationManager.ConnectionStrings["TransManager"].ToString()); using (connCombo) { connCombo.Open(); cmd.Connection = connCombo; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "DELETE FROM " + GetTableName(comboname) + " WHERE id = @var1"; cmd.Parameters.Add(new OleDbParameter("@var1", itemid)); Log.WriteCommand(cmd); try { cmd.ExecuteNonQuery(); } catch (OleDbException e) { if (e.Errors[0].SQLState == "3200") { return("This record cannot be deleted as there are related entries with this value. Remove/reassign these records and then try again."); } else { return("Delete failed : " + e.Message); } } connCombo.Close(); } return("Item has been successfully deleted"); }
public bool UpdateComboItem(Combo.ComboName comboname, int ID, string Description) { OleDbCommand cmd = new OleDbCommand(); OleDbConnection connCombo = new OleDbConnection(ConfigurationManager.ConnectionStrings["TransManager"].ToString()); using (connCombo) { _enteredat = System.DateTime.Now; connCombo.Open(); cmd.Connection = connCombo; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "UPDATE " + GetTableName(comboname) + " SET [Description] = @var1, [EnteredAt] = @var2, [EnteredBy] = @var3 WHERE ID = @var4"; //cmd.CommandText = "UPDATE " + GetTableName(comboname) + " SET [Description] = @var1, [EnteredBy] = @var3 WHERE ID = @var4"; cmd.Parameters.Add(new OleDbParameter("@var1", Description)); cmd.Parameters.Add(new OleDbParameter("@var2", System.DateTime.Now.Date)); cmd.Parameters.Add(new OleDbParameter("@var3", (User.CurrentUserName == null ? "Unknown" : User.CurrentUserName))); cmd.Parameters.Add(new OleDbParameter("@var4", ID)); Log.WriteCommand(cmd); cmd.ExecuteNonQuery(); connCombo.Close(); } return(true); }
public string AddItemToCombo(Combo.ComboName comboname, string description, string additionalcolumn) { OleDbCommand cmd = new OleDbCommand(); OleDbConnection connCombo = new OleDbConnection(ConfigurationManager.ConnectionStrings["TransManager"].ToString()); using (connCombo) { _enteredat = System.DateTime.Now; connCombo.Open(); cmd.Connection = connCombo; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "INSERT INTO " + GetTableName(comboname) + "(Description, EnteredBy) SELECT @var1, @var2"; cmd.Parameters.Add(new OleDbParameter("@var1", description)); cmd.Parameters.Add(new OleDbParameter("@var2", (User.CurrentUserName == null ? "Unknown" : User.CurrentUserName))); if (additionalcolumn != string.Empty) { cmd.Parameters.Add(new OleDbParameter("@var3", additionalcolumn)); cmd.CommandText.Replace(")", "," + additionalcolumn + ")"); } Log.WriteCommand(cmd); try { cmd.ExecuteNonQuery(); } catch (OleDbException err) { return(err.Message); } connCombo.Close(); } return("Successfully added item"); }
private void LoadTitleCombo(Combo.ComboName comboname) { Combo objCombo = new Combo(); objCombo.PopulateCombo(this.cboChooser, comboname, true); }
public frmMaintenance(Combo.ComboName comboname) { InitializeComponent(); LoadTitleCombo(comboname); _comboname = comboname; }
public ComboBox PopulateCombo(ComboBox cboBox, Combo.ComboName comboname, string headerrow, int ordercolumn) { Populatecbo(cboBox, comboname, headerrow, ordercolumn); return(cboBox); }
public ComboBox PopulateCombo(ComboBox cboBox, Combo.ComboName comboname, string headerrow) { Populatecbo(cboBox, comboname, headerrow, 0); return(cboBox); }
public ComboBox PopulateCombo(ComboBox cboBox, Combo.ComboName comboname, bool AddHeaderRow) { Populatecbo(cboBox, comboname, AddHeaderRow ? "<Choose Item to Edit or Delete>" : string.Empty, 2); return(cboBox); }
public ComboBox PopulateCombo(ComboBox cboBox, Combo.ComboName comboname) { Populatecbo(cboBox, comboname, string.Empty, 2); return(cboBox); }
public string AddItemToCombo(Combo.ComboName comboname, string description) { return(AddItemToCombo(comboname, description, string.Empty)); }