// update lists (1) insert, (2) update, (3) delete
public static void SaveComboBoxList(ComboBoxItem item, IList list, ref bool in_use)
{
User user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
IDBManager dbmgr = new DBManager(user.plantDBStr);
dbmgr.ConnectionString = user.plantDBStr;
try
{
dbmgr.Open();
dbmgr.BeginTransaction();
switch (item.update_type)
{
// insert item to list
case 1:
dbmgr.CreateParameters(2);
dbmgr.AddParameters(0, "@name", item.name);
dbmgr.AddParameters(1, "@desc", item.desc);
dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, item.query + "_u");
break;
// update item in list
case 2:
dbmgr.CreateParameters(3);
dbmgr.AddParameters(0, "@value", item.value);
dbmgr.AddParameters(1, "@name", item.name);
dbmgr.AddParameters(2, "@desc", item.desc);
dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, item.query + "_u");
break;
// delete item from list
case 3:
dbmgr.CreateParameters(2);
dbmgr.AddParameters(0, "@value", item.value);
dbmgr.AddParameters(1, "@in_use", in_use, true);
dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, item.query + "_d");
in_use = Convert.ToBoolean(((System.Data.Common.DbParameter)dbmgr.Parameters.GetValue(1)).Value);
break;
}
dbmgr.CommitTransaction();
}
catch (Exception ex)
{
dbmgr.RollbackTransaction();
throw (ex);
}
finally
{
dbmgr.Dispose();
}
}
