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));
}
