public static void MarkInvoiceAsPaid(Invoice invoice)
{
invoice.IsPaid = true;
invoice.DatePayment = DateTime.Now;
invoice.InvoiceStatus = DictionaryManager.GetDictionaryByEnumAndType((int)InvoiceStatusEnum.Zaplacona, DictionaryTypeNames.Invoice);
InvoiceDB.UpdateInvoice(invoice);
}
public static void UpdateInvoice(Invoice invoice)
{
if (invoice.Invoiceid == Guid.Empty)
return;
string sqlQuery = "UPDATE Invoice SET DatePayment=@DatePayment, IsPaid=@IsPaid, InvoiceStatus=@InvoiceStatus WHERE InvoiceID='" + invoice.Invoiceid + "'";
DbCommand dbCommand = DBHelper.GetDBCommand(sqlQuery);
if(invoice.DatePayment.HasValue)
DBHelper.AddInParameter(dbCommand, "DatePayment", DbType.DateTime, invoice.DatePayment.Value);
else
DBHelper.AddInParameter(dbCommand, "DatePayment", DbType.DateTime,DBNull.Value);
DBHelper.AddInParameter(dbCommand, "IsPaid", DbType.Boolean, invoice.IsPaid);
DBHelper.AddInParameter(dbCommand, "InvoiceStatus", DbType.Guid, invoice.InvoiceStatusID);
DBHelper.ExecuteNonQuery(dbCommand);
}
private static Invoice GetInvoiceFromReader(IDataReader dataReader)
{
Invoice invoice = new Invoice();
invoice.Invoiceid = DBHelper.GetGuid(dataReader, "InvoiceID");
invoice.OrderID = DBHelper.GetGuid(dataReader, "OrderID");
invoice.InvoiceStatusID = DBHelper.GetGuid(dataReader, "InvoiceStatus");
invoice.Number = DBHelper.GetString(dataReader, "Number");
invoice.Date = DBHelper.GetDateTime(dataReader, "Date");
invoice.DatePayment = DBHelper.GetNullableDateTime(dataReader, "DatePayment");
invoice.IsPaid = DBHelper.GetBoolean(dataReader, "IsPaid");
return invoice;
}