private static PaymentDTO GeneratePayment(SqlDataReader reader, AccountDTO account, PaymentDTO payment, InvoiceDTO invoice) { account.SetID(Convert.ToInt32(reader["accountID"])); invoice.SetID(Convert.ToInt32(reader["invoiceID"])); payment.SetCustomer(account); payment.SetInvoice(invoice); payment.SetID(Convert.ToInt32(reader["paymentID"])); payment.SetID(Convert.ToInt32(reader["amount"])); payment.SetPaymentDate(Convert.ToDateTime(reader["paymentDate"])); return(payment); }
private static InvoiceDTO GenerateInvoice(SqlDataReader reader, InvoiceDTO invoice, AccountDTO account, ShippmentDTO shipping) { invoice.SetID(Convert.ToInt32(reader["invoiceID"])); account.SetID(Convert.ToInt32(reader["accountID"])); shipping.SetID(Convert.ToInt32(reader["shippingID"])); invoice.SetCustomer(account); invoice.SetShippment(shipping); invoice.SetQuantity(Convert.ToInt32(reader["totalQuantity"])); invoice.SetShippingCost(Convert.ToDecimal(reader["shippingCost"])); invoice.SetTotal(Convert.ToDecimal(reader["totalProductCost"])); invoice.SetTax(Convert.ToDecimal(reader["totalTax"])); invoice.SetTotal(Convert.ToDecimal(reader["totalAmount"])); invoice.SetOrderDate(Convert.ToDateTime(reader["orderDate"])); invoice.SetPaymentDate(Convert.ToDateTime(reader["paymentDate"])); invoice.SetStatus(Convert.ToInt32(reader["paymentStatus"])); invoice.SetEmail(reader["customerMail"].ToString()); invoice.SetArrivalDate(Convert.ToDateTime(reader["arrivalDate"])); invoice.SetPostDate(Convert.ToDateTime(reader["postageDate"])); Debug.Print("InvoiceDAL: Invoice ID " + invoice.GetID()); return(invoice); }
private static AccountDTO GenerateAccount(SqlDataReader reader, AccountDTO account, AddressDTO address) { if (reader["addressID"] != DBNull.Value) { address.SetID(Convert.ToInt32(reader["addressID"])); Debug.Print("AccountDAL / GenerateAccount: " + address.GetID()); account.SetAddress(address); } account.SetID(Convert.ToInt32(reader["accountID"])); account.SetEmail(reader["email"].ToString()); account.SetPw((byte[])reader["md5pw"]); account.SetSalt((byte[])reader["salt"]); account.SetFirstName(reader["firstName"].ToString()); account.SetLastName(reader["lastName"].ToString()); account.SetBirthdate(Convert.ToDateTime(reader["birthDate"])); account.SetPhoneNo(reader["phone"].ToString()); account.SetImgPath(reader["imgPath"].ToString()); account.SetIsAdmin(Convert.ToByte(reader["isAdmin"])); account.SetIsConfirmed(Convert.ToByte(reader["isConfirmed"])); account.SetConfirmationID(Convert.ToInt32(reader["confirmationID"])); account.SetStatus(Convert.ToByte(reader["status"])); return(account); }