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