public static void UpdateEquipItem(EquipTypeTbl objEquipType) { string _connectionStr = ConfigurationManager.ConnectionStrings[QOnT.classes.TrackerDb.CONST_CONSTRING].ConnectionString;; using (OleDbConnection _conn = new OleDbConnection(_connectionStr)) { string _sqlCmd = CONST_SQL_UPDATE; OleDbCommand _cmd = new OleDbCommand(_sqlCmd, _conn); // prepare the qurey we have built #region Parameters // objEquipType.EquipTypeName = (objEquipType.EquipTypeName == null) ? string.Empty : objEquipType.EquipTypeName; // objEquipType.EquipTypeDesc = (objEquipType.EquipTypeDesc == null) ? string.Empty : objEquipType.EquipTypeDesc; _cmd.Parameters.Add(new OleDbParameter { Value = objEquipType.EquipTypeName }); _cmd.Parameters.Add(new OleDbParameter { Value = objEquipType.EquipTypeDesc }); // Where clause _cmd.Parameters.Add(new OleDbParameter { Value = objEquipType.EquipTypeId }); #endregion _conn.Open(); _cmd.ExecuteNonQuery(); _conn.Close(); } }
public List <EquipTypeTbl> GetAll(string SortBy) { List <EquipTypeTbl> _DataItems = new List <EquipTypeTbl>(); string _connectionStr = ConfigurationManager.ConnectionStrings[QOnT.classes.TrackerDb.CONST_CONSTRING].ConnectionString; using (OleDbConnection _conn = new OleDbConnection(_connectionStr)) { string _sqlCmd = CONST_SQL_SELECT; _sqlCmd += (!String.IsNullOrEmpty(SortBy)) ? " ORDER BY " + SortBy : " ORDER BY EquipTypeName"; // add default order OleDbCommand _cmd = new OleDbCommand(_sqlCmd, _conn); // run the qurey we have built _conn.Open(); OleDbDataReader _DataReader = _cmd.ExecuteReader(); while (_DataReader.Read()) { EquipTypeTbl _DataItem = new EquipTypeTbl(); _DataItem.EquipTypeId = (_DataReader["EquipTypeId"] == DBNull.Value) ? 0 : Convert.ToInt32(_DataReader["EquipTypeId"]); _DataItem.EquipTypeName = (_DataReader["EquipTypeName"] == DBNull.Value) ? string.Empty : _DataReader["EquipTypeName"].ToString(); _DataItem.EquipTypeDesc = (_DataReader["EquipTypeDesc"] == DBNull.Value) ? string.Empty : _DataReader["EquipTypeDesc"].ToString(); _DataItems.Add(_DataItem); } } return(_DataItems); }