public static void RemovedAndUpdateEBLForPoliceList(string bookingItemID) { try { // Get the carReservation from EBL table CarReservationData CarReservationData carReservationData = CarBSDB.getCarReservationData(int.Parse(bookingItemID)); CarReservation expectedCarReservation = (CarReservation)FastInfoSetSerializer.DeserializeFIInDB((byte[])carReservationData.CarReservationNodeData, typeof(CarReservation)); // removed police list if (expectedCarReservation.CarPolicyList.CarPolicy.Count == 0) { Console.WriteLine("No car policy list exist in CarReservation , don't need remove it."); } else { expectedCarReservation.CarPolicyList = null; } Console.WriteLine("Begin update the DB for CarReservationData ..."); SqlConnection conn = new SqlConnection(connectionString); DataSet dsSet = new DataSet(); SqlDataAdapter sdaAdapter = null; SqlCommandBuilder scbBuilder = null; //SqlCommand cmdUpdate = null; SqlCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = string.Format("select * from CarReservationData where BookingItemID = {0}", bookingItemID); sdaAdapter = new SqlDataAdapter(cmd); scbBuilder = new SqlCommandBuilder(sdaAdapter); sdaAdapter.Fill(dsSet, "CarReservationData"); //update the table value with the byte //byte [] reservationDode = FastInfoSetSerializer.ObjectToByteArray(expectedCarReservation); MemoryStream xmlMemory = XMLSerializer.Serialize(expectedCarReservation, typeof(CarReservation)); MemoryStream FI_steam = FastInfoSetSerializer.Serialize(xmlMemory); dsSet.Tables["CarReservationData"].Rows[0]["CarReservationNodeData"] = FI_steam.ToArray(); //Post the data modification to the database. sdaAdapter.Update(dsSet, "CarReservationData"); Console.WriteLine("CarReservationData updated successfully"); conn.Close(); } catch (Exception e) { Console.WriteLine("***********************************************************************"); Console.WriteLine("occured an exception when update CarReservationData table :" + e.Message); Console.WriteLine("***********************************************************************"); throw; } // Get the carReservation from EBL table CarReservationData CarReservationData carReservationData2 = CarBSDB.getCarReservationData(int.Parse(bookingItemID)); CarReservation expectedCarReservation2 = (CarReservation)FastInfoSetSerializer.DeserializeFIInDB((byte[])carReservationData2.CarReservationNodeData, typeof(CarReservation)); }
public static CarReservationData getCarReservationData(int bookingItemID) { CarReservationData carReservationData = null; using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = string.Format("select * from CarReservationData where BookingItemID = {0}", bookingItemID); cmd.CommandTimeout = 0; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { carReservationData = new CarReservationData(reader["JurisdictionCode"], reader["CompanyCode"], reader["ManagementUnitCode"], reader["BookingItemID"], reader["CarReservationNodeData"], reader["CarReservationNodeMajorVersion"], reader["CarReservationNodeMinorVersion"], reader["CarReservationDataExtendedElementCnt"], reader["CarReservationDataExtendedPriceListCnt"], reader["UseDateEnd"], reader["CreateDate"]); } conn.Close(); } return(carReservationData); }