public static void saveLenseOrder(MetroForm f)
{
//update summary
summary.Insert(NewSpectaclesInvoice.OrderNumber, NewSpectaclesInvoice.receiptNumber, Customer.id, "S", NewSpectaclesInvoice.OrderStatus, NewSpectaclesInvoice.Balance.ToString(), "UNPAID");
//update order
spec_order.Insert(NewSpectaclesInvoice.receiptNumber, NewSpectaclesInvoice.OrderNumber, Customer.id, NewSpectaclesInvoice.TestedBy, NewSpectaclesInvoice.EyeWear, NewSpectaclesInvoice.Lense, NewSpectaclesInvoice.Total, NewSpectaclesInvoice.Advance, NewSpectaclesInvoice.Discount, NewSpectaclesInvoice.Balance, NewSpectaclesInvoice.DistRightSph, NewSpectaclesInvoice.DistRightCyl, NewSpectaclesInvoice.DistRightAxis, NewSpectaclesInvoice.DistLeftSph, NewSpectaclesInvoice.DistLeftCyl, NewSpectaclesInvoice.DistLeftAxis, NewSpectaclesInvoice.AddRightSph, NewSpectaclesInvoice.AddRightCyl, NewSpectaclesInvoice.AddRightAxis, NewSpectaclesInvoice.AddLeftSph, NewSpectaclesInvoice.AddLeftCyl, NewSpectaclesInvoice.AddLeftAxis, NewSpectaclesInvoice.LensType, NewSpectaclesInvoice.Frame, NewSpectaclesInvoice.PD, NewSpectaclesInvoice.SegmentHeight, NewSpectaclesInvoice.SpecialInc, NewSpectaclesInvoice.Remarks, NewSpectaclesInvoice.OrderStatus, DateTime.Parse(NewSpectaclesInvoice.OrderDate), DateTime.Parse(NewSpectaclesInvoice.DueDate), NewSpectaclesInvoice.PayMethod, NewSpectaclesInvoice.PayPlan);
//update receipt
payments.Insert(NewSpectaclesInvoice.OrderNumber, NewSpectaclesInvoice.receiptNumber + "- 01", NewSpectaclesInvoice.Advance, DateTime.Now.Date);
MSG.SUCCESS(f, "Saved!");
}
public static void saveLenseOrder(MetroForm f)
{
//update summary
summary.Insert(NewContactLenseInvoice.OrderNumber, NewContactLenseInvoice.ReceiptNumber, Customer.id, "L", NewContactLenseInvoice.OrderStatus, NewContactLenseInvoice.LenseBalance.ToString(), "UNPAID");
//update order
lense_order.Insert(NewContactLenseInvoice.ReceiptNumber, NewContactLenseInvoice.OrderNumber, int.Parse(Customer.id.ToString()), NewContactLenseInvoice.JobType, NewContactLenseInvoice.TestedBy, Double.Parse(NewContactLenseInvoice.LenseTotal.ToString()), Double.Parse(NewContactLenseInvoice.LenseAdvance.ToString()), Double.Parse(NewContactLenseInvoice.LenseBalance.ToString()), NewContactLenseInvoice.OldRightSph, NewContactLenseInvoice.OldRightCyl, NewContactLenseInvoice.OldRightAxis, NewContactLenseInvoice.OldRightAdd, NewContactLenseInvoice.OldLeftSph, NewContactLenseInvoice.OldLeftCyl, NewContactLenseInvoice.OldLeftAxis, NewContactLenseInvoice.OldLeftAdd, NewContactLenseInvoice.PresentRightSph, NewContactLenseInvoice.PresentRightCyl, NewContactLenseInvoice.PresentRightAxis, NewContactLenseInvoice.PresentRightAdd, NewContactLenseInvoice.PresentLeftSph, NewContactLenseInvoice.PresentLeftCyl, NewContactLenseInvoice.PresentLeftAxis, NewContactLenseInvoice.PresentLeftAdd, NewContactLenseInvoice.RightBc, NewContactLenseInvoice.RightPow, NewContactLenseInvoice.RightDia, NewContactLenseInvoice.RightDesz, NewContactLenseInvoice.LeftBc, NewContactLenseInvoice.LeftPow, NewContactLenseInvoice.LeftDia, NewContactLenseInvoice.LeftDesz, NewContactLenseInvoice.TrailLens, NewContactLenseInvoice.OverRefract, NewContactLenseInvoice.KReading, NewContactLenseInvoice.BlinkTest, NewContactLenseInvoice.SpecialIns, NewContactLenseInvoice.Remarks, NewContactLenseInvoice.OrderStatus, DateTime.Parse(NewContactLenseInvoice.OrderDate), DateTime.Parse(NewContactLenseInvoice.DueDate), NewContactLenseInvoice.PaymentMethod, NewContactLenseInvoice.PaymentPlan);
//update receipt
payments.Insert(NewContactLenseInvoice.OrderNumber, NewContactLenseInvoice.ReceiptNumber + "- 01", NewContactLenseInvoice.LenseAdvance, DateTime.Now.Date);
}
