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