// 2015.02.02 MadhuVenkat K Modified SQL statement for CR#66165-App Order Processing fails when an order is processed by previous App version.
/// <summary>
/// GetUpdatedDeliveryDetails
/// Function to return list of delivery details records
/// </summary>
/// <param name="customerID">customer id</param>
/// <param name="loadID">load id</param>
/// <param name="sysTrxNo">system trx no</param>
/// <param name="session">Session object</param>
/// <returns>List of delivery details</returns>
public static List <DAL.DeliveryDetailsRow> GetUpdatedDeliveryDetails(String customerID, Guid loadID, decimal sysTrxNo, ISession session, String VersionNo = "")
{
DeliveryDetailsTableAdapter ta = new DeliveryDetailsTableAdapter();
ta.CurrentConnection = session;
return(ta.GetUpdatedData(customerID, loadID, sysTrxNo).ToList());
}
/// <summary>
/// UpdateDeliveryDetails
/// Function to update the delivery details records
/// </summary>
/// <param name="orderItemID">Order item ID</param>
/// <param name="session">Session object</param>
public static void UpdateDeliveryDetails(Guid orderItemID, ISession session, String VersionNo = "")
{
DeliveryDetailsTableAdapter ta = new DeliveryDetailsTableAdapter();
ta.CurrentConnection = session;
ta.UpdateQuery(orderItemID);
}
/// <summary>
/// UpdateDeliveryDetails
/// Function to update the delivery details records
/// </summary>
/// <param name="orderItemID">Order item ID</param>
/// <param name="session">Session object</param>
//public static void UpdateDeliveryDetails(Guid orderItemID, ISession session, String VersionNo = "")
//{
// DeliveryDetailsTableAdapter ta = new DeliveryDetailsTableAdapter();
// ta.CurrentConnection = session;
// ta.UpdateQuery(orderItemID);
//}
public static void UpdateDeliveryDetails(Guid orderItemID, ISession session, String VersionNo = "")
{
DeliveryDetailsTableAdapter ta = new DeliveryDetailsTableAdapter();
ta.CurrentConnection = session;
ta.UpdateQuery(orderItemID);
//SqlCommand cmd = (SqlCommand)session.CreateCommand();
//cmd.CommandText = "Cloud_UpdateNeedUpdateDeliveryDetails";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@orderItemID", orderItemID);
//cmd.ExecuteNonQuery();
}
