/// <summary> /// Procedure to update the expiry date of a product /// </summary> /// <param name="reference">the product's reference</param> /// <param name="expiryData">the expiry date</param> public void UpdateExipryDate(string reference, DateTime expiryData) { SqlCeConnection conn = null; try { string sqlconnection = ("Data Source =" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\InventoryDB.sdf;")); using (conn = new SqlCeConnection(sqlconnection)) { conn.Open(); SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from Products where Reference ='" + reference + "'"; SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Updatable | ResultSetOptions.Scrollable); SqlCeUpdatableRecord rec = rs.CreateRecord(); if (true == rs.ReadAbsolute(0)) { rs.SetDateTime(3, expiryData); rs.Update(); } } } finally { conn.Close(); } }
/// <summary> /// Reads records from absolute position /// </summary> public override void ReadAbsolute(int position, int count, Action <IDataRecord> process) { for (int i = 0; i < count; ++i) { if (_resultSet.ReadAbsolute(position + i)) { process(_resultSet); } } }