/// <summary>
/// Adds Shipment details from a Multiple Shipment Order
/// </summary>
private void InsertDB()
{
var MultiShipOrder_ShipmentGUID = CommonLogic.GetNewGUID();
var sql = string.Format("insert into MultiShipOrder_Shipment(MultiShipOrder_ShipmentGUID,OrderNumber,DestinationAddress,ShippingAmount,ShippingMethodId,ShippingAddressId,BillingAddressId) values({0},{1},{2},{3},{4},{5},{6})", DB.SQuote(MultiShipOrder_ShipmentGUID), _OrderNumber, DB.SQuote(_DestinationAddress), _ShippingAmount, _ShippingMethodId, _ShippingAddressId, _BillingAddressId);
DB.ExecuteSQL(sql);
using (var dbconn = DB.dbConn())
{
dbconn.Open();
using (var rs = DB.GetRS(String.Format("select MultiShipOrder_ShipmentId from MultiShipOrder_Shipment with (NOLOCK) where MultiShipOrder_ShipmentGUID={0}", DB.SQuote(MultiShipOrder_ShipmentGUID)), dbconn))
{
if (rs.Read())
{
_MultiShipOrder_ShipmentId = DB.RSFieldInt(rs, "MultiShipOrder_ShipmentId");
}
}
}
}
public void SerializeGiftCard()
{
//physical gift cards cannot be serialized
if (this.m_GiftCardTypeID != (int)GiftCardTypes.PhysicalGiftCard)
{
Customer c = new Customer(m_PurchasedByCustomerID);
string SerialNumber = String.Empty;
string GiftCardXml = String.Empty;
XmlDocument xdoc = new XmlDocument();
try
{
GiftCardXml = AppLogic.RunXmlPackage("giftcardassignment.xml.config", null, c, 1, String.Empty, String.Empty, false, true);
xdoc.LoadXml(GiftCardXml);
SerialNumber = xdoc.SelectSingleNode("//CardNumber").InnerText;
}
catch
{
SerialNumber = CommonLogic.GetNewGUID();
}
UpdateCard(SerialNumber, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
}
}