public override string ToString()
{
return(FirstName + " "
+ LastName + " "
+ OrderDate.ToString()//Had to remove this from the parenthesis=> "MM/dd/yyyy HH:mm:ss")
+ " Price: " + Price.ToString("c"));
}
/// <summary>
/// Converts current object to a PSV row
/// </summary>
public string ToPsvRow()
{
string[] data =
{
OrderId.ToString(),
ProgramName,
OrderDate.ToString(Constants.DateTimeIsoFormat),
LastName,
FirstName,
SpouseName,
string.Join(",", Children),
Address,
Suburb,
State,
PostCode.ToString(),
TelNo,
MobileNo,
SpouseMobileNo,
Email1,
Email2,
PaymentDate.ToString(Constants.DateTimeIsoFormat),
OrderStatus
};
return(string.Join("|", data));
}
public override string ToString()
{
return(string.Format("Order[{0}-{1}-{2}]",
Client,
OrderDate.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture),
string.Join(", ", this.Items.ToList())));
}
public override string ToString()
{
return(FirstName + " "
+ LastName + " "
// +OrderDate.ToString()+" "
+ OrderDate?.ToString("MM/dd/yyyy HH:mm:ss") + " " // TODO: EF missing ? after OrderDate
+ " Price: " + Price.ToString("c"));
}
public override string ToString()
{
var phoneNumber = ClientPhoneNumber ?? "空";
var note = Note ?? "空";
return("订单号：" + OrderId + "； 客户姓名：" + ClientName + "； 订单日期：" + OrderDate.ToString("d")
+ "； 客户电话：" + phoneNumber + "； 备注：" + note);
}
public override string ToString()
{
return("Order Key : " + Key
+ "\nHosting unit : " + HostingUnit
+ "\nGuest request : " + GuestRequest
+ "\nOrder date : " + OrderDate.ToString(format: "dd/MM/yyyy")
+ "\n");
}
public void RefreshOrders()
{
var orders = dataService
.Get <OrderHeader>(true)
.Where(s => s.Date.ToString("yyyy/MM/dd") == OrderDate.ToString("yyyy/MM/dd"))
.ToList();
OrderList = new ObservableCollection <OrderHeader>(orders);
}
public virtual string AsString()
{
StringBuilder builder = new StringBuilder(string.Format("Order number {0} contains:\n", OrderID.ToString()));
builder.Append(string.Join("\n\t", OrderedProducts.Select(p => p.Quantity + " times " + p.Product.Description)));
builder.Append(string.Format("\nFor a total value of {0}", OrderedProducts.Sum(p => p.Product.UnitPrice * p.Quantity).ToString()));
builder.Append(string.Format("\nOrder finalised at {0}", OrderDate.ToString()));
return(builder.ToString());
}
public string ToJson()
{
JsonObject obj = new JsonObject();
obj.SetNamedValue("CustomerID", JsonValue.CreateStringValue(CustomerID));
obj.SetNamedValue("EmployeeID", JsonValue.CreateNumberValue(EmployeeID));
obj.SetNamedValue("OrderDateString", JsonValue.CreateStringValue(OrderDate.ToString()));
JsonArray array = OrderDetails.ToJsonArray();
obj.Add("OrderDetails", array);
var jsonString = obj.Stringify();
return(jsonString);
}
public void setOrder(string func)
{
string sqlFormattedDate = OrderDate.ToString("yyyy-MM-dd");
DbService db = new DbService();
string query = "";
if (func == "edit")
{
query = "UPDATE Orders SET OrderName = '" + OrderName + "', CustomerID = " + Customer.CustomerID + ", OrderDate = '" + sqlFormattedDate + "', TotalPrice = " + TotalPrice + ", Comments = '" + Comments + "', ShipFromID = " + ShipFrom.AddressID + " , AddTime = " + AddTime + " , Container = '" + Container + "' , DriverLicenseTypeID = " + OrderLicenseType.DriverLicenseTypeID + ", ServiceID = " + OrderService.ServiceID + " , ShipToID = " + ShipTo.AddressID + ", DriverCertificationTypeID = " + OrderCertificationType.DriverLicenseTypeID + " ,DeliveryDuration = " + DeliveryDuration + " WHERE OrderID = " + OrderID;
}
else if (func == "new")
{
query = "insert into Orders values ('" + OrderName + "'," + Customer.CustomerID + ",'" + sqlFormattedDate + "'," + 1 + ",'" + Comments + "', " + ShipFrom.AddressID + ", " + AddTime + ", '" + Container + "', " + OrderLicenseType.DriverLicenseTypeID + ", '" + "N" + "',null,null,null, " + OrderService.ServiceID + ", " + ShipTo.AddressID + "," + TotalPrice + ", " + OrderCertificationType.DriverLicenseTypeID + ", " + DeliveryDuration + ")";
}
db.ExecuteNonQuery(query);
}
public override string ToString()
{
Console.WriteLine("***********************************");
Console.WriteLine("New Order" + "\t\t\t" + "Order Id:\t" + Id);
Console.WriteLine();
Console.WriteLine("Order Date:\t" + OrderDate.ToString("dd/MM/yyyy hh:mm"));
Console.WriteLine();
Costumer.ToString();
Console.WriteLine("-------------------- Order lines --------------------");
Console.WriteLine("Line" + "\t" + "ID" + "\t" + "Name" + "\t" + "Price");
foreach (OrderLine o in OrderLines)
{
o.ToString();
}
Console.WriteLine("-------------------- ----------- --------------------");
Console.WriteLine("TOTAL PRICE: " + TotalPrice.ToString());
return(base.ToString());
}
public string GetOrderDetails()
{
string info = $"Your order {Number} made on {OrderDate.ToString()} with delivery type {DeliveryType}:\n";
foreach (var orderItem in OrderItems)
{
info += orderItem.GetOrderItemInfo() + "\n";
}
if (DeliveryType == DeliveryType.DeliveryToDoor)
{
info += $"Dostava do doma = {100}\n";
}
info += $"Total: {CalculatePrice()}";
return(info);
}
public bool Validate()
{
Regex alphabetic = new Regex(@"^[\s\p{L}]+$");
Regex numeric = new Regex("^[0-9]*$");
Regex mail = new Regex(@"^\w+@[a-zA-Z_]+?\.[a-zA-Z]{2,3}$");
if (string.IsNullOrEmpty(OrderDate.ToString()) ||
string.IsNullOrEmpty(RentalTime.ToString()) || (!numeric.IsMatch(RentalTime.ToString())) ||
string.IsNullOrEmpty(DeliveryPlace) || (!alphabetic.IsMatch(DeliveryPlace)))
{
return(false);
}
if (OrderDate > DateTime.Now)
{
return(false);
}
return(true);
}
protected override bool Work()
{
try
{
var accountPreferences = new AccountPreferences(ParentActivity);
if (accountPreferences.Valid == false)
{
return(ValidConfiguration = false);
}
var url = string.Format(URL, accountPreferences.Farm, _MemberData.Group,
_OrderDate.ToString());
GetOrderSummaryResp = InvokeWebServiceRequest <GetOrderSummaryResp>(url);
}
catch
{
return(false);
}
return(true);
}
/// <summary>
/// Convert current object to PSV row
/// </summary>
/// <returns>PSV row</returns>
public string ToPsvRow()
{
string[] data =
{
OrderId.ToString(),
ProgramName,
OrderDate.ToString(Constants.DateTimeIsoFormat),
FirstName,
LastName,
TelNo,
MobileNo,
Email1,
Email2,
PaymentDate.ToString(Constants.DateTimeIsoFormat),
Quantity.ToString(),
TotalAmount.ToString("f02"),
TicketType,
PaymentMode,
OrderStatus
};
return(string.Join("|", data));
}
public override string ToString()
{
return(string.Format("Заказ от {0} [{1}]", OrderDate.ToString(), StateName));
}
public override String ToString()
{
return(string.Format("Customer {0} \n (Name: {1}, Surname: {2},Email: {3},Phone: {4},Birth year: {5},Order date: {6},Order time: {7},Desc: {8},Dorctor: {9})", ID, Name, Surname, Email, Phone, BirthYear, OrderDate.ToString(), OrderTime, Description, DoctorID));
}
public XElement ToXml()
{
XElement result = new XElement("SlideOrder");
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "SlideOrderId", SlideOrderId.ToString());
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "AliquotOrderId", AliquotOrderId.ToString());
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "OrderDate", OrderDate.ToString("yyyy-MM-ddTHH:mm:ss.FFF"));
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "Description", Description);
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "AliquotType", AliquotType);
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "Label", Label);
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "OrderedById", OrderedById.ToString());
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "OrderedBy", OrderedBy);
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "OrderedFrom", OrderedFrom);
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "ValidationDate", ValidationDate);
YellowstonePathology.Business.Domain.Persistence.SerializationHelper.Serialize(result, "Status", Status);
return(result);
}
public override string ToString()
{
return("Hosting Unit ID: " + HostingUnitKey.ToString() + " Hosting Request ID: " + GuestRequestKey.ToString() +
" Order ID: " + OrderKey.ToString() + " Order Status: " + Status + " Order Creation Date: " +
CreateDate.ToString("d") + " Offer Date Submission: " + OrderDate.ToString("d"));
}
public override string ToString()
{
return(OrderDate.ToString());
}
public override string ToString()
{
return(string.Format("Order {0} rep: {1,8} ({2,7}) item: {3,7} {4,2} x {6,7} = {6:c2}", OrderDate.ToString("yyyy-MM-dd"), Rep, Region, Item, Units, UnitCost, Total));
}
public void AddToOrderTable()
{
int takeaway = 0;
int user_id = 0;
int order_id = 0;
int item_id = 0;
if (DineOrTakeAway.Equals("Dine-in"))
{
takeaway = 0;
}
else if (DineOrTakeAway.Equals("Take away"))
{
takeaway = 1;
}
db.OpenDBConnection();
//get user id
db.Sqlite_cmd = db.SqlConn.CreateCommand();//ask database what to query
db.Sqlite_cmd.CommandText = "Select id from user where user_name = '" + OrderUserName + "'";
db.Sqlite_datareader = db.Sqlite_cmd.ExecuteReader();
while (db.Sqlite_datareader.Read())
{
user_id = db.Sqlite_datareader.GetInt32(0);
}
//clear previous statements
db.Sqlite_cmd.Dispose();
//insert into db
db.Sqlite_cmd.CommandText = "Insert into purchase_order(order_num,takeaway,created_time,user_id,is_completed) values('" + OrderNum + "'," + takeaway + ",'" + OrderDate.ToString("yyyy-MM-dd HH:mm:ss") + "'," + user_id + ",0)";
db.Sqlite_cmd.ExecuteNonQuery();
//clear previous statements
db.Sqlite_cmd.Dispose();
//get order id
db.Sqlite_cmd = db.SqlConn.CreateCommand();//ask database what to query
db.Sqlite_cmd.CommandText = "Select id from purchase_order where order_num = '" + OrderNum + "'";
db.Sqlite_datareader = db.Sqlite_cmd.ExecuteReader();
while (db.Sqlite_datareader.Read())
{
order_id = db.Sqlite_datareader.GetInt32(0);
}
foreach (Item item in OrderItems)
{
//clear previous statements
db.Sqlite_cmd.Dispose();
//get order id
db.Sqlite_cmd = db.SqlConn.CreateCommand();//ask database what to query
db.Sqlite_cmd.CommandText = "Select id from item where name = '" + item.Name + "'";
db.Sqlite_datareader = db.Sqlite_cmd.ExecuteReader();
while (db.Sqlite_datareader.Read())
{
item_id = db.Sqlite_datareader.GetInt32(0);
}
//clear previous statements
db.Sqlite_cmd.Dispose();
db.Sqlite_cmd.CommandText = "INSERT INTO order_product(order_id,item_id,quantity) VALUES(@order_id,@item_id,@qty)";
db.Sqlite_cmd.Parameters.AddWithValue("@order_id", order_id);
db.Sqlite_cmd.Parameters.AddWithValue("@item_id", item_id);
db.Sqlite_cmd.Parameters.AddWithValue("@qty", item.Quantity);
db.Sqlite_cmd.ExecuteNonQuery();
}
db.CloseDBConnection();
}
public string CreateReceipt()
{
decimal totalPrice = 0.00m;
StringBuilder receipt = new StringBuilder();
if (Gadgets.Count > 0)
{
receipt.Append("\t\t\t\t\t\t\tWag Corporation\n\nOrder date: ");
receipt.Append(OrderDate.ToString());
receipt.Append("\n\nCustomer: ");
receipt.Append(Customer.CustomerName.ToString());
receipt.Append("\n\nCustomer ID Number: ");
receipt.Append(Customer.CustomerID.ToString());
receipt.Append("\n\nItems:");
foreach (Gadget gadget in Gadgets)
{
receipt.Append("\n\n");
receipt.Append(gadget.Name);
receipt.Append(" | ");
receipt.Append(gadget.SerialNumber);
receipt.Append(" | ");
receipt.Append(gadget.Size);
receipt.Append(" | ");
receipt.Append(gadget.Finish);
receipt.Append(" | ");
receipt.Append(gadget.PoweredBy);
receipt.Append("\t\t\t\t\t\t\t\t");
receipt.Append(gadget.Price);
foreach (IComponent component in gadget.FixedComponents)
{
receipt.Append("\n\t|__ ");
receipt.Append(component.Name);
receipt.Append("\t\t\t\t");
receipt.Append(component.Price);
}
foreach (Widget widget in gadget.Components)
{
receipt.Append("\n\t|__ ");
receipt.Append(widget.Name);
receipt.Append(" | ");
receipt.Append(widget.SerialNumber);
receipt.Append(" | ");
receipt.Append(widget.Size);
receipt.Append(" | ");
receipt.Append(widget.Finish);
receipt.Append("\t\t\t\t\t");
receipt.Append(widget.Price);
foreach (IComponent component in widget.Components)
{
receipt.Append("\n\t\t|__ ");
receipt.Append(component.Name);
receipt.Append("\t\t\t");
receipt.Append(component.Price);
}
}
totalPrice += gadget.Price;
}
receipt.Append("\n\nTotal Price: ");
receipt.Append(totalPrice.ToString());
}
else
{
receipt.Append("No order found.");
}
return(receipt.ToString());
}
public override string ToString()
{
return($"Order {OrderID} from {OrderDate?.ToString("yyyy-MM-dd")}");
}
public override string ToString()
{
return($"{"OrderId:"} {OrderId} {"Cost:"} {Cost} {"Order Date:"} {OrderDate.ToString("MM/dd/yyyy h:mm tt")} {"Location:"} {Location}");
}
public override string ToString()
{
return(String.Format("{0,-5}| {1,-20}\t| {2,-20}\t| {3,-30}\t\t| {4,-5}| {5:C}\t| {6,-20}\t", OrderID, CustName, CustPhone, CustMail, SerialNo, OrderPrice, OrderDate.ToString("dd/mm/yyyy")));
}
public override string ToString() => OrderDate.ToString() + OrderId;