public static int UpdateOrderItems(PurchaseItemDTO purchaseItemDto)
{
string query = "UPDATE purchase_has_item SET product_id = " + purchaseItemDto.ProductId + "" + ", brand_id = " + purchaseItemDto.BrandId + ", qty = " +
purchaseItemDto.Quntity + ", unit_price = " + purchaseItemDto.Price + ", updated_by = " + purchaseItemDto.UpdatedBy + ", updated_at = '" +
DateTime.Now + "' WHERE id = " + purchaseItemDto.Id;
try
{
DataTable purchaseItemTable = DatabaseConnection.ConnectWithServer(query);
if (purchaseItemTable == null)
{
return(-1);
}
return(1);
}
catch (Exception)
{
return(-1);
}
}
public static int AddOrderItems(PurchaseItemDTO purchaseItemsDto)
{
string query = "INSERT INTO purchase_has_item (purchase_id, product_id, brand_id, qty, unit_price, created_by) VALUES " +
"( " + "" + purchaseItemsDto.PurchaseId + "," + purchaseItemsDto.ProductId + "," + purchaseItemsDto.BrandId + "," +
purchaseItemsDto.Quntity + "," + purchaseItemsDto.Price + "," + purchaseItemsDto.CreatedBy + ")";
try
{
DataTable purchaseItemTable = DatabaseConnection.ConnectWithServer(query);
if (purchaseItemTable == null)
{
return(-1);
}
return(1);
}
catch (Exception)
{
return(-1);
}
}
