public OrdersDS.OrdersDataTable GetOrders(string condition)
{
if (condition != "")
{
condition = " where " + condition;
}
base.CommandCollection[0].CommandText += condition + " order by OrderId desc";
OrdersDS.OrdersDataTable dt = base.GetData();
//dt.Columns.Add("StatusDescription");
//dt.Columns.Add("TypeDescription");
foreach (OrdersDS.OrdersRow dr in dt.Rows)
{
OrderStatus stat = (OrderStatus)Enum.Parse(typeof(OrderStatus), dr["Status"].ToString());
dr.StatusDescription = EnumHelper.GetDescription(stat);
OrderType type = (OrderType)Enum.Parse(typeof(OrderType), dr["OrderType"].ToString());
dr.TypeDescription = EnumHelper.GetDescription(type);
}
return(dt);
}
public OrdersDS.OrdersRow CreateOrder(
int MemberId,
string FirstName,
string LastName,
string Phone,
string Email,
string Address,
string City,
string State,
string Zip,
string Country,
string Region,
bool ShippingSame,
string ShippingPhone,
string ShippingEmail,
string ShippingAddress,
string ShippingCity,
string ShippingState,
string ShippingZip,
string ShippingCountry,
string ShippingRegion,
decimal SubTotal,
decimal Total,
decimal Discount,
decimal Tax,
decimal Shipping,
decimal Handling,
OrderType oType,
string Description,
string VoucherCode,
decimal VoucherValue,
string PaymentType,
decimal PaymentCost, string XmlData)
{
OrdersDSTableAdapters.OrdersTableAdapter adp = new lw.Orders.OrdersDSTableAdapters.OrdersTableAdapter();
OrdersDS.OrdersDataTable dt = adp.CreateOrder("", MemberId, FirstName, LastName, Phone, Email, Address, City, State,
Zip, Country, Region, ShippingSame, ShippingPhone, ShippingAddress, ShippingCity,
ShippingState, ShippingZip, ShippingCountry, ShippingRegion,
DateTime.Now, (int)OrderStatus.Verifying, SubTotal, Total, Discount, Tax,
Shipping, Handling, short.Parse(((int)oType).ToString()), Description, -1, "", "", VoucherCode, VoucherValue,
PaymentType, PaymentCost, XmlData);
OrdersDS.OrdersRow row = (OrdersDS.OrdersRow)dt.Rows[0];
Random ran = new Random();
string orderNbr = (row.OrderId * Math.Floor((double)ran.Next(1, 15))).ToString();
orderNbr = Math.Pow(10, 10 - orderNbr.Length).ToString().Substring(1) + orderNbr;
string[] temp = System.Guid.NewGuid().ToString().Split('-');
row.OrderVisualId = temp[0] + "-" + temp[1] + "-" + temp[2]; //string.Format("ORD{0}", orderNbr);
adp.Update(row);
return(row);
}
public OrdersDS.OrdersRow GetOrderById(int OrderId)
{
OrdersDSTableAdapters.OrdersTableAdapter adp = new lw.Orders.OrdersDSTableAdapters.OrdersTableAdapter();
OrdersDS.OrdersDataTable dt = adp.GetById(OrderId);
if (dt.Rows.Count == 0)
{
return(null);
}
return((OrdersDS.OrdersRow)dt.Rows[0]);
}
public OrdersDS.OrdersRow GetOrderByVisualId(string VisualId)
{
VisualId = StringUtils.SQLEncode(VisualId);
OrdersDSTableAdapters.OrdersTableAdapter adp = new lw.Orders.OrdersDSTableAdapters.OrdersTableAdapter();
OrdersDS.OrdersDataTable dt = adp.GetOrderByVisualId(VisualId);
if (dt.Rows.Count == 0)
{
return(null);
}
return((OrdersDS.OrdersRow)dt.Rows[0]);
}
public static void CleanUnverifiedOrders()
{
OrdersManager oMgr = new OrdersManager();
string cond = string.Format("DateCreated <'{0}' and Status={1} and PaymentType <>'{2}' ",
DateTime.Now.AddMinutes(-20), (int)OrderStatus.Verifying, Payments.PaymentTypes.PO.ToString());
OrdersDS.OrdersDataTable orders = oMgr.GetOrders(cond);
foreach (OrdersDS.OrdersRow order in orders.Rows)
{
CleanUpOrder(order.OrderVisualId);
}
}
