public static bool DeleteAllListings()
{
String sql = string.Format("delete * from [ActiveListing]");
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool MarkMessageAsReplied(String ebayMessageId)
{
String sql = string.Format("update [Message] set IsReplied=true where EbayMessageId='{0}'", ebayMessageId);
DataFactory.ExecuteSql(sql);
return(true);
}
} // DeleteOneItem
public static bool ModifyItemCategory(int itemId, int newCatId)
{
String sql = string.Format("update [Item] set CategoryId={0} where ItemId={1}", newCatId, itemId);
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool DecreaseItem(string sku, int count)
{
InventoryItemType item = GetItemBySKU(sku);
if (item == null)
{
return(false);
}
if (count > item.ItemStockNum)
{
return(false);
}
int newStock = item.ItemStockNum - count;
if (newStock < 0)
{
return(false);
}
String sql = string.Format("update [Item] set ItemStockNum={0} where ItemSKU='{1}'", newStock, sku);
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool UpdateTransactionsShippingService(List <string> orderLineItemIds, string shippingServiceCode, string shippingServiceDesc)
{
// if transIds = (1001, 1002, 1003), then
// transIdsStr = 1001, 1002, 1003
String orderLineItemIdsStr = "";
bool first = true;
foreach (string orderLineItemId in orderLineItemIds)
{
if (first == false)
{
orderLineItemIdsStr += ",";
}
orderLineItemIdsStr += "'" + orderLineItemId.ToString() + "'";
if (first == true)
{
first = false;
}
}
String sql = "update [Transaction] set ShippingServiceCode='" + shippingServiceCode + "', ShippingService='"
+ shippingServiceDesc + "' where OrderId in (" + orderLineItemIdsStr + ")";
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool UpdateTransactionItemSKU(int transId, string SKU)
{
String sql = "update [Transaction] set ItemSKU='" + SKU + "' where TransactionId=" + transId;
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool UpdateTransactionShippingTrackingNo(int transId, String trackingNo)
{
String sql = string.Format("update [Transaction] set ShippingTrackingNo={0} where TransactionId={1}",
trackingNo, transId);
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool UpdateTransactionBuyerLeftFeedback(int transId, bool bBuyerLeftFeedback)
{
String sql = string.Format("update [Transaction] set IsBuyerLeftFeedback={0} where TransactionId={1}",
bBuyerLeftFeedback ? 1 : 0, transId);
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool UpdateTransactionShippedStatus(int transId, bool shipped, DateTime shippedDate)
{
String sql = string.Format("update [Transaction] set IsShipped={0}, ShippedDate='{1}' where TransactionId={2}",
shipped ? 1 : 0, StringUtil.GetSafeDateTime(shippedDate), transId);
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool updateTransactionShippingCost(int transId, double shippingCost)
{
String sql = string.Format("update [Transaction] set ShippingCost={0} where TransactionId={1}",
shippingCost, transId);
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool UpdateTransactionMessageStatus(int transId, TransactionMessageStatus messageStatus)
{
String sql = string.Format("update [Transaction] set MessageStatus={0} where TransactionId={1}",
(int)messageStatus, transId);
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool DeleteItemSuppliers(int itemId)
{
bool result = false;
String sql = string.Format("delete from [ItemSupplier] where ItemId={0}", itemId);
DataFactory.ExecuteSql(sql);
result = true;
return(result);
}
public static bool DeleteItemSupplier(ItemSupplierType itemSupplier)
{
bool result = false;
String sql = string.Format("delete from [ItemSupplier] where ItemId={0} and SupplierId={1}",
itemSupplier.ItemId, itemSupplier.SupplierId);
DataFactory.ExecuteSql(sql);
result = true;
return(result);
}
public static bool DeleteOneSupplier(int supplierId)
{
bool result = false;
SupplierType supplier = GetSupplierById(supplierId);
if (supplier == null)
{
return(false);
}
String sql = string.Format("delete from [Supplier] where Supplierid={0}", supplierId);
DataFactory.ExecuteSql(sql);
result = true;
return(result);
}
public static bool DeleteOneItemStockInNote(String noteId)
{
bool result = false;
ItemStockInNoteType note = ItemStockInNoteDAL.GetOneItemStockInNote(noteId);
if (note == null)
{
return(false);
}
String sql = string.Format("delete from [ItemStockInNote] where NoteId={0}", noteId);
DataFactory.ExecuteSql(sql);
result = true;
return(result);
}
public static bool DeleteOneSourcingNote(int noteId)
{
bool result = false;
SourcingNoteType note = GetSourcingNoteById(noteId);
if (note == null)
{
return(false);
}
String sql = string.Format("delete from [SourcingNote] where SourcingId={0}", noteId);
DataFactory.ExecuteSql(sql);
result = true;
return(result);
}
public static bool UpdateTransactionDeliveryStatus(String transId, bool isDelivered, int deliveryNoteId)
{
String sql = "";
if (isDelivered)
{
sql = string.Format("update [Transaction] set IsDelivered={0}, DeliveryNoteId={1} where TransactionId={2}",
1, deliveryNoteId, transId);
}
else
{
sql = string.Format("update [Transaction] set IsDelivered={0}, DeliveryNoteId={1} where TransactionId={2}",
0, -1, transId);
}
DataFactory.ExecuteSql(sql);
return(true);
}
public static bool DeleteOneListing(String itemID)
{
bool result = false;
String sql = string.Format("delete from [ActiveListing] where ItemID='{0}'", itemID);
try
{
DataFactory.ExecuteSql(sql);
result = true;
}
catch (System.Exception ex)
{
Logger.WriteSystemLog(String.Format("Delete listing with ItemID={0} failed, error msg={1}", itemID, ex.Message));
}
return(result);
} // DeleteOneListing
public static bool DeleteOneDeliveryNote(String noteId)
{
bool result = false;
DeliveryNoteType deliveryNote = DeliveryNoteDAL.GetOneDeliveryNote(noteId);
if (deliveryNote == null)
{
return(false);
}
String sql = string.Format("delete from [DeliveryNote] where DeliveryNoteId={0}", noteId);
DataFactory.ExecuteSql(sql);
result = true;
return(result);
}
public static bool DeleteOneItem(int itemId)
{
bool result = false;
InventoryItemType itemInfo = GetItemById(itemId);
if (itemInfo == null || itemInfo.ItemId <= 0)
{
return(false);
}
String sql = string.Format("delete from [Item] where ItemId={0}", itemId);
DataFactory.ExecuteSql(sql);
result = true;
return(result);
} // DeleteOneItem