public static int InsertAdvanceReceipt(ReceiptDTO ReceiptDTO)
{
try
{
int?NewRecieptID = 0;
db.Manali_Receipt_CreateAdvanceReceipt(
ReceiptDTO.ReceiptDate,
ReceiptDTO.MagNo,
ReceiptDTO.Section,
ReceiptDTO.FunctionTime,
ReceiptDTO.IsGoingAwayIncluded,
ReceiptDTO.PayerName,
ReceiptDTO.AccountOf,
ReceiptDTO.Payment,
ReceiptDTO.CashOrCheckNo,
ReceiptDTO.Quotation.QuotationID,
ref NewRecieptID
);
if (NewRecieptID != null && NewRecieptID != 0)
{
return(NewRecieptID.Value);
}
else
{
return(0);
}
}
catch (Exception e)
{
return(0);
}
}
public async Task ExecuteCallbackAsync(string?callback, ReceiptDTO receiptDto)
{
if (!String.IsNullOrEmpty(callback))
{
_logger.LogInformation($"Calling back {callback} with receipt data for order {receiptDto.OrderNumber}");
await _httpClient.PostAsJsonAsync(callback, receiptDto);
}
}
public static ReceiptDTO ReceiptToDTO(Receipt Receipt)
{
if (Receipt == null)
{
return(null);
}
Mapper.CreateMap <Receipt, ReceiptDTO>();
ReceiptDTO ReceiptDTO = Mapper.Map <ReceiptDTO>(Receipt);
return(ReceiptDTO);
}
public static Receipt ReceiptToDomain(ReceiptDTO ReceiptDTO)
{
if (ReceiptDTO == null)
{
return(null);
}
Mapper.CreateMap <ReceiptDTO, Receipt>();
Receipt Receipt = Mapper.Map <Receipt>(ReceiptDTO);
return(Receipt);
}
public JsonResult SaveAdvanceReceipt(ReceiptDTO Receipt)
{
int receiptID = 0;
receiptID = BusinessLayer.BusinessStore.Receipt.SaveAdvanceReceiptDetails(Receipt);
ActionDetailsDTO actionDetails = new ActionDetailsDTO
{
Status = receiptID > 0 ? 1 : 0,
Content = receiptID.ToString()
};
return(Json(actionDetails, JsonRequestBehavior.AllowGet));
}
public static List <ReceiptDTO> GetAllReceipts()
{
List <ReceiptDTO> lstReceiptList = new List <ReceiptDTO>();
try
{
var lstReceiptListFromDB = db.Manali_Receipt_GetAllReceipts();
foreach (var item in lstReceiptListFromDB)
{
QuotationDTO quotation = new QuotationDTO
{
QuotationID = item.QuotationID,
DateOfWedding = item.DateOfWedding.Value,
NameOfBride = item.Bride,
BrideAddress = item.BrideAddress,
BrideEmail = item.BrideEmail,
BrideContactNo = item.BrideContactNo,
DateOfHomecoming = item.DateOfHomecoming.Value,
NameOfGroom = item.Groom,
GroomAddress = item.GroomAddress,
GroomContactNo = item.GroomContactNo,
};
ReceiptDTO receipt = new ReceiptDTO
{
ReceiptID = item.ReceiptID,
ReceiptDate = item.ReceiptDate.Value,
MagNo = item.MagNo,
Section = item.Section,
FunctionTime = item.FunctionTime.Value,
IsGoingAwayIncluded = item.IsGoingAwayIncluded.Value,
PayerName = item.PayerName,
AccountOf = item.AccountOf,
Payment = item.Payment.Value,
CashOrCheckNo = item.CashOrCheckNo,
Quotation = quotation
};
lstReceiptList.Add(receipt);
}
}
catch (Exception)
{
}
return(lstReceiptList);
}
public void Test2()
{
List <Item> items = new List <Item>();
items.Add(new Item {
Name = "box of chocolates", Quantity = 1, UnitPrice = 10, Category = ItemCategory.FOOD, IsImported = true
});
items.Add(new Item {
Name = "bottle of perfume", Quantity = 1, UnitPrice = 47.50, Category = ItemCategory.PERSONALCARE, IsImported = true
});
ReceiptDTO receipt = new ReceiptDTO(items);
Assert.True(receipt.SalesTaxes == 7.65, "Sales Taxes: " + receipt.SalesTaxes);
Assert.True(receipt.GrandTotal == 65.15, "Grand Total: " + receipt.GrandTotal);
}
public static ReceiptDTO GetReceiptByID(int ReceiptID)
{
try
{
var ReceiptObject = db.Manali_Receipt_GetReceiptByID(ReceiptID).FirstOrDefault();
if (ReceiptObject != null)
{
QuotationDTO quotation = new QuotationDTO
{
QuotationID = ReceiptObject.QuotationID,
DateOfWedding = ReceiptObject.DateOfWedding.Value,
NameOfBride = ReceiptObject.Bride,
BrideAddress = ReceiptObject.BrideAddress,
BrideEmail = ReceiptObject.BrideEmail,
BrideContactNo = ReceiptObject.BrideContactNo,
DateOfHomecoming = ReceiptObject.DateOfHomecoming.Value,
NameOfGroom = ReceiptObject.Groom,
GroomAddress = ReceiptObject.GroomAddress,
GroomContactNo = ReceiptObject.GroomContactNo,
};
ReceiptDTO receipt = new ReceiptDTO
{
ReceiptID = ReceiptObject.ReceiptID,
ReceiptDate = ReceiptObject.ReceiptDate.Value,
MagNo = ReceiptObject.MagNo,
Section = ReceiptObject.Section,
FunctionTime = ReceiptObject.FunctionTime.Value,
IsGoingAwayIncluded = ReceiptObject.IsGoingAwayIncluded.Value,
PayerName = ReceiptObject.PayerName,
AccountOf = ReceiptObject.AccountOf,
Payment = ReceiptObject.Payment.Value,
CashOrCheckNo = ReceiptObject.CashOrCheckNo,
Quotation = quotation
};
return(receipt);
}
}
catch (Exception e)
{
}
return(null);
}
public void Test1()
{
List <Item> items = new List <Item>();
items.Add(new Item {
Name = "book", Quantity = 2, UnitPrice = 12.49, Category = ItemCategory.BOOK
});
items.Add(new Item {
Name = "music CD", Quantity = 1, UnitPrice = 14.99, Category = ItemCategory.MUSIC
});
items.Add(new Item {
Name = "chocolate bar", Quantity = 1, UnitPrice = 0.85, Category = ItemCategory.FOOD
});
ReceiptDTO receipt = new ReceiptDTO(items);
Assert.True(receipt.SalesTaxes == 1.5, "Sales Taxes: " + receipt.SalesTaxes);
Assert.True(receipt.GrandTotal == 42.32, "Grand Total: " + receipt.GrandTotal);
}
public async Task <ReceiptDTO> GetReceiptAsync(Order order)
{
_logger.LogInformation($"Getting receipt for order {order.OrderNumber}");
if (order.OrderStatus == OrderStatus.Paid || order.OrderStatus == OrderStatus.Overpaid || order.OrderStatus == OrderStatus.PartiallyPaid)
{
var diff = order.Settlements.Sum(x => x.PaidAmount) - order.OrderAmount;
var result = new ReceiptDTO()
{
OrderNumber = order.OrderNumber,
Signature = order.Receipt?.Signature,
PaymentDate = order.Settlements.Max(x => x.PaymentDate),
Amount = order.OrderAmount,
Overpayment = diff > 0 ? diff : 0,
Debt = diff < 0 ? Math.Abs(diff) : 0
};
return(await Task.FromResult(result));
}
throw new OrderNotProcessedException(order.OrderNumber);
}
public void Test3()
{
List <Item> items = new List <Item>();
items.Add(new Item {
Name = "bottle of perfume", Quantity = 1, UnitPrice = 27.99, Category = ItemCategory.PERSONALCARE, IsImported = true
});
items.Add(new Item {
Name = "bottle of perfume", Quantity = 1, UnitPrice = 18.99, Category = ItemCategory.PERSONALCARE
});
items.Add(new Item {
Name = "packet of headache pills", Quantity = 1, UnitPrice = 9.75, Category = ItemCategory.MEDICAL
});
items.Add(new Item {
Name = "box of chocolates", Quantity = 3, UnitPrice = 11.25, Category = ItemCategory.FOOD, IsImported = true
});
ReceiptDTO receipt = new ReceiptDTO(items);
Assert.True(receipt.SalesTaxes == 7.9, "Sales Taxes: " + receipt.SalesTaxes);
Assert.True(receipt.GrandTotal == 98.38, "Grand Total: " + receipt.GrandTotal);
}
public static int SaveAdvanceReceiptDetails(ReceiptDTO Receipt)
{
return(DataAccessLayer.Datastore.ReceiptDataStore.InsertAdvanceReceipt(Receipt));
}
/// <summary>
/// Проводит инвентаризацию. Создает документы по результатам.
/// </summary>
private void MakeInventory()
{
// Создать список картриджей для коррекционного поступления.
ObservableCollection <ReceiptCartridgeDTO> receiptCarts = new ObservableCollection <ReceiptCartridgeDTO>();
// Перебрать баланс для инвентаризации.
foreach (InventBalanceDTO newBalance in EditedBalance)
{
// Значение фактического остатка.
int factCount = (int)newBalance.FactCount;
// Найти редактируемый баланс в бд.
BalanceDTO currentBalance = DataService.Balance.Get(newBalance.Id);
// Если фактический остаток больше текущего.
if (factCount > currentBalance.Count)
{
// Создать картридж поступления.
var receipCart = new ReceiptCartridgeDTO()
{
Cartridge = new CartridgeDTO(currentBalance.Cartridge.Id, currentBalance.Cartridge.Model, new ObservableCollection <PrinterDTO>(), currentBalance.Cartridge.InUse),
Count = factCount - currentBalance.Count
};
// Добавить картридж в коллекцию картриджей поступления.
receiptCarts.Add(receipCart);
}
// Если фактический остаток меньше текущего.
else if (factCount < currentBalance.Count)
{
// Найти последнее списание в БД.
ExpenseDTO lastExpense = DataService.Expenses.Find(x => x.Osp.Id == Osp.Id).LastOrDefault();
// Создать корректирующее списание.
var expense = new ExpenseDTO()
{
Basis = "Коррекция по результатам инвентаризации",
Cartridge = currentBalance.Cartridge,
Date = DateTime.Now.Date,
Count = currentBalance.Count - factCount,
Delete = false,
Edit = false,
Number = lastExpense is null ? 1 : lastExpense.Number + 1,
User = User,
OspId = Osp.Id
};
// Добавить корректирующее списание в БД.
DataService.Expenses.Add(expense);
// Получить добавленное списание с присвоенным Id.
ExpenseDTO addedExpense = DataService.Expenses.Find(x => x.Osp.Id == Osp.Id).LastOrDefault();
// Добавить его в список созданных по результатам инвентаризации списаний.
Expenses.Add(addedExpense);
}
}
// Если были добавлены картриджи для корректирующего поступления.
if (receiptCarts.Any())
{
// Найти последнее поступление в БД.
ReceiptDTO lastReceipt = DataService.Receipts.Find(x => x.Osp.Id == Osp.Id).LastOrDefault();
// Создать корректирующее поступление.
var receipt = new ReceiptDTO()
{
Date = DateTime.Now.Date,
Comment = "Коррекция по результатам инвентаризации",
Delete = false,
Edit = false,
Number = lastReceipt is null ? 1 : lastReceipt.Number + 1,
Cartridges = receiptCarts,
Provider = null,
User = User,
OspId = Osp.Id,
};
// Добавить корректирующее поступление в БД.
DataService.Receipts.Add(receipt);
// Получить добавленное поступление с присвоенным Id и присвоить его свойству.
Receipt = DataService.Receipts.Find(x => x.Osp.Id == Osp.Id).LastOrDefault();
}
}
}
public ActionResult EditReceipt(int ReceiptID)
{
ReceiptDTO Receipt = BusinessLayer.BusinessStore.Receipt.GetReceiptByID(ReceiptID);
return(View(Receipt));
}
