private static NpgsqlCommand GetViewCommand(TranBook tranBook, SubTranBook subTranBook, Collection <int> ids)
{
if (tranBook == TranBook.Sales)
{
switch (subTranBook)
{
case SubTranBook.Delivery:
break;
case SubTranBook.Direct:
break;
case SubTranBook.Invoice:
break;
case SubTranBook.Order:
return(SalesOrder.GetSalesOrderViewCommand(ids));
case SubTranBook.Payment:
throw new InvalidOperationException(Common.Helpers.LocalizationHelper.GetResourceString("Errors", "InvalidSubTranBookSalesPayment"));
case SubTranBook.Quotation:
return(SalesQuotation.GetSalesQuotationViewCommand(ids));
case SubTranBook.Receipt:
break;
case SubTranBook.Return:
break;
}
}
switch (subTranBook)
{
case SubTranBook.Delivery:
throw new InvalidOperationException(Common.Helpers.LocalizationHelper.GetResourceString("Errors", "InvalidSubTranBookPurchaseDelivery"));
case SubTranBook.Direct:
break;
case SubTranBook.Invoice:
break;
case SubTranBook.Order:
break;
case SubTranBook.Payment:
break;
case SubTranBook.Quotation:
throw new InvalidOperationException(Common.Helpers.LocalizationHelper.GetResourceString("Errors", "InvalidSubTranBookPurchaseQuotation"));
case SubTranBook.Receipt:
throw new InvalidOperationException(Common.Helpers.LocalizationHelper.GetResourceString("Errors", "InvalidSubTranBookPurchaseReceipt"));
}
return(null);
}
public static MergeModel GetMergeModel(Collection <int> ids, TranBook book, SubTranBook subBook)
{
int rowIndex = 0;
if (ids == null)
{
return(new MergeModel());
}
if (ids.Count.Equals(0))
{
return(new MergeModel());
}
MergeModel model = new MergeModel();
foreach (int tranId in ids)
{
model.AddTransactionIdToCollection(tranId);
}
model.Book = book;
model.SubBook = subBook;
using (NpgsqlConnection connection = new NpgsqlConnection(DbConnection.ConnectionString()))
{
using (NpgsqlCommand command = SalesQuotation.GetSalesQuotationViewCommand(ids))
{
command.Connection = connection;
command.Connection.Open();
NpgsqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
if (!reader.HasRows)
{
return(new MergeModel());
}
while (reader.Read())
{
if (rowIndex.Equals(0))
{
model.ValueDate = Conversion.TryCastDate(reader["value_date"]);
model.PartyCode = Conversion.TryCastString(reader["party_code"]);
model.PriceTypeId = Conversion.TryCastInteger(reader["price_type_id"]);
model.ReferenceNumber = Conversion.TryCastString(reader["reference_number"]);
model.StatementReference = Conversion.TryCastString(reader["statement_reference"]);
}
ProductDetailsModel product = new ProductDetailsModel();
product.ItemCode = Conversion.TryCastString(reader["item_code"]);
product.ItemName = Conversion.TryCastString(reader["item_name"]);
product.Unit = Conversion.TryCastString(reader["unit_name"]);
product.Quantity = Conversion.TryCastInteger(reader["quantity"]);
product.Price = Conversion.TryCastDecimal(reader["price"]);
product.Amount = product.Quantity * product.Price;
product.Discount = Conversion.TryCastDecimal(reader["discount"]);
product.Subtotal = product.Amount - product.Discount;
product.Rate = Conversion.TryCastDecimal(reader["tax_rate"]);
product.Tax = Conversion.TryCastDecimal(reader["tax"]);
product.Total = product.Subtotal + product.Tax;
model.AddViewToCollection(product);
rowIndex++;
}
}
}
if (ids.Count > 0)
{
if (!string.IsNullOrWhiteSpace(model.StatementReference))
{
model.StatementReference += Environment.NewLine;
}
model.StatementReference += "(" + Conversion.GetBookAcronym(book, subBook) + "# " + string.Join(",", ids) + ")";
}
return(model);
}
