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;