public IActionResult GetExpeditionPDF(int id)
{
try
{
var indexAcceptPdf = Request.Headers["Accept"].ToList().IndexOf("application/pdf");
TransferOutDoc model = facade.ReadById(id);
TransferOutDocViewModel viewModel = mapper.Map <TransferOutDocViewModel>(model);
if (viewModel == null)
{
throw new Exception("Invalid Id");
}
if (indexAcceptPdf < 0)
{
return(Ok(new
{
apiVersion = ApiVersion,
statusCode = General.OK_STATUS_CODE,
message = General.OK_MESSAGE,
data = viewModel,
}));
}
else
{
int clientTimeZoneOffset = int.Parse(Request.Headers["x-timezone-offset"].First());
var Spk = pkpbjFacade.ReadByReference(viewModel.code);
PkbjByUserViewModel viewModelSpk = mapper.Map <PkbjByUserViewModel>(Spk);
ReturnToUnitPdfTemplate PdfTemplateLocal = new ReturnToUnitPdfTemplate();
MemoryStream stream = PdfTemplateLocal.GeneratePdfTemplate(viewModel, viewModelSpk, serviceProvider, clientTimeZoneOffset);
return(new FileStreamResult(stream, "application/pdf")
{
FileDownloadName = $"{viewModel.code}.pdf"
});
}
}
catch (Exception e)
{
Dictionary <string, object> Result =
new ResultFormatter(ApiVersion, General.INTERNAL_ERROR_STATUS_CODE, e.Message)
.Fail();
return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, Result));
}
}
public async Task <IActionResult> Post([FromBody] TransferOutDocViewModel ViewModel)
{
try
{
identityService.Username = User.Claims.Single(p => p.Type.Equals("username")).Value;
IValidateService validateService = (IValidateService)serviceProvider.GetService(typeof(IValidateService));
validateService.Validate(ViewModel);
var model = mapper.Map <TransferOutDoc>(ViewModel);
await facade.Create(ViewModel, model, identityService.Username);
// await facade.Crea
Dictionary <string, object> Result =
new ResultFormatter(ApiVersion, General.CREATED_STATUS_CODE, General.OK_MESSAGE)
.Ok();
return(Created(String.Concat(Request.Path, "/", 0), Result));
}
catch (ServiceValidationExeption e)
{
Dictionary <string, object> Result =
new ResultFormatter(ApiVersion, General.BAD_REQUEST_STATUS_CODE, General.BAD_REQUEST_MESSAGE)
.Fail(e);
return(BadRequest(Result));
}
catch (Exception e)
{
Dictionary <string, object> Result =
new ResultFormatter(ApiVersion, General.INTERNAL_ERROR_STATUS_CODE, e.Message)
.Fail();
return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, Result));
}
}
public async Task <int> Create(TransferOutDocViewModel model, TransferOutDoc model2, string username, int clientTimeZoneOffset = 7)
{
int Created = 0;
using (var transaction = this.dbContext.Database.BeginTransaction())
{
try
{
string codeOut = GenerateCode("EFR-KB/RTP");
model2.Code = codeOut;
model2.Date = DateTimeOffset.Now;
List <ExpeditionItem> expeditionItems = new List <ExpeditionItem>();
List <ExpeditionDetail> expeditionDetails = new List <ExpeditionDetail>();
List <SPKDocsItem> sPKDocsItem = new List <SPKDocsItem>();
EntityExtension.FlagForCreate(model2, username, USER_AGENT);
foreach (var i in model2.Items)
{
sPKDocsItem.Add(new SPKDocsItem
{
ItemArticleRealizationOrder = i.ArticleRealizationOrder,
ItemCode = i.ItemCode,
ItemDomesticCOGS = i.DomesticCOGS,
ItemDomesticRetail = i.DomesticRetail,
ItemDomesticSale = i.DomesticSale,
ItemDomesticWholesale = i.DomesticWholeSale,
ItemId = i.ItemId,
ItemName = i.ItemName,
ItemSize = i.Size,
ItemUom = i.Uom,
Quantity = i.Quantity,
Remark = i.Remark,
SendQuantity = i.Quantity
});
EntityExtension.FlagForCreate(i, username, USER_AGENT);
}
dbSet.Add(model2);
//Created = await dbContext.SaveChangesAsync();
SPKDocs sPKDocs = new SPKDocs
{
Code = GenerateCode("EFR-PK/PBJ"),
Date = DateTimeOffset.Now,
IsDistributed = true,
IsDraft = false,
IsReceived = false,
DestinationCode = model2.DestinationCode,
DestinationId = model2.DestinationId,
DestinationName = model2.DestinationName,
PackingList = GenerateCode("EFR-KB/PLR"),
Password = String.Join("", GenerateCode(DateTime.Now.ToString("dd")).Split("/")),
Reference = codeOut,
SourceCode = model2.SourceCode,
SourceName = model2.SourceName,
SourceId = model2.SourceId,
Weight = 0,
Items = sPKDocsItem
};
EntityExtension.FlagForCreate(sPKDocs, username, USER_AGENT);
foreach (var i in sPKDocs.Items)
{
var inventorymovement = new InventoryMovement();
var inven = dbContext.Inventories.Where(x => x.ItemId == i.ItemId && x.StorageId == model2.SourceId).FirstOrDefault();
if (inven != null)
{
inventorymovement.Before = inven.Quantity;
inven.Quantity = inven.Quantity - i.Quantity;
}
inventorymovement.After = inventorymovement.Before + i.Quantity;
inventorymovement.Date = DateTimeOffset.UtcNow;
inventorymovement.ItemCode = i.ItemCode;
inventorymovement.ItemDomesticCOGS = i.ItemDomesticCOGS;
inventorymovement.ItemDomesticRetail = i.ItemDomesticRetail;
inventorymovement.ItemDomesticWholeSale = i.ItemDomesticRetail;
inventorymovement.ItemDomesticSale = i.ItemDomesticSale;
inventorymovement.ItemId = i.ItemId;
inventorymovement.ItemInternationalCOGS = 0;
inventorymovement.ItemInternationalRetail = 0;
inventorymovement.ItemInternationalSale = 0;
inventorymovement.ItemInternationalWholeSale = 0;
inventorymovement.ItemName = i.ItemName;
inventorymovement.ItemSize = i.ItemSize;
inventorymovement.ItemUom = i.ItemUom;
inventorymovement.Quantity = i.Quantity;
inventorymovement.StorageCode = model2.SourceCode;
inventorymovement.StorageId = model2.SourceId;
inventorymovement.StorageName = model2.SourceName;
inventorymovement.Type = "OUT";
inventorymovement.Reference = codeOut;
inventorymovement.Remark = model2.Remark;
inventorymovement.StorageIsCentral = model2.SourceName.Contains("GUDANG") ? true : false;
EntityExtension.FlagForCreate(inventorymovement, username, USER_AGENT);
dbSetInventoryMovement.Add(inventorymovement);
EntityExtension.FlagForCreate(i, username, USER_AGENT);
}
dbSetSPKDocs.Add(sPKDocs);
Created = await dbContext.SaveChangesAsync();
foreach (var i in sPKDocs.Items)
{
expeditionDetails.Add(new ExpeditionDetail
{
ArticleRealizationOrder = i.ItemArticleRealizationOrder,
DomesticCOGS = i.ItemDomesticCOGS,
DomesticRetail = i.ItemDomesticRetail,
DomesticSale = i.ItemDomesticSale,
DomesticWholesale = i.ItemDomesticWholesale,
ItemCode = i.ItemCode,
ItemId = i.ItemId,
ItemName = i.ItemName,
Quantity = i.Quantity,
Remark = i.Remark,
SendQuantity = i.SendQuantity,
Uom = i.ItemUom,
Size = i.ItemSize,
//SPKDocsId = (int)dbContext.SPKDocs.OrderByDescending(x => x.Id).FirstOrDefault().Id + 1
SPKDocsId = (int)sPKDocs.Id
});
}
expeditionItems.Add(new ExpeditionItem
{
Code = sPKDocs.Code,
Date = sPKDocs.Date,
DestinationCode = sPKDocs.DestinationCode,
DestinationId = (int)sPKDocs.DestinationId,
DestinationName = sPKDocs.DestinationName,
IsDistributed = sPKDocs.IsDistributed,
IsDraft = sPKDocs.IsDraft,
IsReceived = sPKDocs.IsReceived,
PackingList = sPKDocs.PackingList,
Password = sPKDocs.Password,
Reference = sPKDocs.Reference,
SourceCode = sPKDocs.SourceCode,
SourceId = (int)sPKDocs.SourceId,
SourceName = sPKDocs.SourceName,
//SPKDocsId = (int)dbContext.SPKDocs.OrderByDescending(x => x.Id).FirstOrDefault().Id + 1,
SPKDocsId = (int)sPKDocs.Id,
Weight = sPKDocs.Weight,
Details = expeditionDetails
});
Expedition expedition = new Expedition
{
Code = GenerateCode("EFR-KB/EXP"),
Date = DateTimeOffset.Now,
ExpeditionServiceCode = model.expeditionService.code,
ExpeditionServiceId = (int)model.expeditionService._id,
ExpeditionServiceName = model.expeditionService.name,
Remark = "",
Weight = 0,
Items = expeditionItems,
};
EntityExtension.FlagForCreate(expedition, username, USER_AGENT);
foreach (var i in expeditionItems)
{
EntityExtension.FlagForCreate(i, username, USER_AGENT);
foreach (var d in expeditionDetails)
{
EntityExtension.FlagForCreate(d, username, USER_AGENT);
}
}
dbSetExpedition.Add(expedition);
Created = await dbContext.SaveChangesAsync();
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.Message);
}
}
return(Created);
}
public async Task <SalesDoc> Create(SalesDoc model)
{
int Created = 0;
using (var transaction = this.DbContext.Database.BeginTransaction())
{
try
{
string code = GenerateCode("sales");
model.Code = code;
model.FlagForCreate(IdentityService.Username, UserAgent);
model.FlagForUpdate(IdentityService.Username, UserAgent);
if (model.isReturn != true)
{
model.isReturn = false;
}
model.isVoid = false;
TransferOutDocViewModel transferOutDocViewModel = new TransferOutDocViewModel();
List <TransferOutDocItemViewModel> transferOutDocItemViewModels = new List <TransferOutDocItemViewModel>();
TransferInDocViewModel transferInDocView = new TransferInDocViewModel();
List <TransferInDocItemViewModel> transferInDocItemViews = new List <TransferInDocItemViewModel>();
transferOutDocViewModel.code = code;
transferOutDocViewModel.reference = code;
transferOutDocViewModel.source = new SourceViewModel
{
_id = model.StoreStorageId,
code = model.StoreStorageCode,
name = model.StoreStorageName
};
transferOutDocViewModel.destination = new DestinationViewModel
{
_id = model.StoreStorageId,
code = model.StoreStorageCode,
name = model.StoreStorageName
};
transferOutDocViewModel.remark = model.Remark;
bool isAnyTransferIn = false;
transferInDocView.code = code;
transferInDocView.reference = code;
transferInDocView.source = new SourceViewModel
{
_id = model.StoreStorageId,
code = model.StoreStorageCode,
name = model.StoreStorageName
};
transferInDocView.destination = new DestinationViewModel
{
_id = model.StoreStorageId,
code = model.StoreStorageCode,
name = model.StoreStorageName
};
transferInDocView.remark = model.Remark;
foreach (var item in model.Details)
{
if (!item.isReturn)
{
transferOutDocItemViewModels.Add(new TransferOutDocItemViewModel
{
articleRealizationOrder = item.ItemArticleRealizationOrder,
remark = model.Remark,
quantity = item.Quantity,
item = new ItemViewModels
{
articleRealizationOrder = item.ItemArticleRealizationOrder,
code = item.ItemCode,
domesticCOGS = item.ItemDomesticCOGS,
domesticRetail = item.ItemDomesticRetail,
domesticSale = item.ItemDomesticSale,
domesticWholesale = item.ItemDomesticWholeSale,
name = item.ItemName,
size = item.ItemSize,
uom = item.ItemUom,
_id = item.ItemId,
}
});
}
else if (item.isReturn)
{
transferInDocItemViews.Add(new TransferInDocItemViewModel
{
remark = model.Remark,
sendquantity = item.Quantity,
item = new ItemViewModels
{
articleRealizationOrder = item.ItemArticleRealizationOrder,
code = item.ItemCode,
domesticCOGS = item.ItemDomesticCOGS,
domesticRetail = item.ItemDomesticRetail,
domesticSale = item.ItemDomesticSale,
domesticWholesale = item.ItemDomesticWholeSale,
name = item.ItemName,
size = item.ItemSize,
uom = item.ItemUom,
_id = item.ItemId,
}
});
isAnyTransferIn = true;
}
item.FlagForCreate(IdentityService.Username, UserAgent);
item.FlagForUpdate(IdentityService.Username, UserAgent);
}
transferOutDocViewModel.items = transferOutDocItemViewModels;
transferInDocView.items = transferInDocItemViews;
if (isAnyTransferIn)
{
string warehouseUritransferin = "transfer-in/for-pos";
var httpClienttarnsfer = (IHttpClientService)ServiceProvider.GetService(typeof(IHttpClientService));
var responsetransfer = await httpClienttarnsfer.PostAsync($"{APIEndpoint.Warehouse}{warehouseUritransferin}", new StringContent(JsonConvert.SerializeObject(transferInDocView).ToString(), Encoding.UTF8, General.JsonMediaType));
responsetransfer.EnsureSuccessStatusCode();
}
string warehouseUri = "transfer-out/pos";
var httpClient = (IHttpClientService)ServiceProvider.GetService(typeof(IHttpClientService));
var response = await httpClient.PostAsync($"{APIEndpoint.Warehouse}{warehouseUri}", new StringContent(JsonConvert.SerializeObject(transferOutDocViewModel).ToString(), Encoding.UTF8, General.JsonMediaType));
response.EnsureSuccessStatusCode();
model.FlagForCreate(IdentityService.Username, UserAgent);
model.FlagForUpdate(IdentityService.Username, UserAgent);
DbSet.Add(model);
Created = await DbContext.SaveChangesAsync();
Created = model.Id;
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.Message);
}
}
return(model);
}
public MemoryStream GeneratePdfTemplate(TransferOutDocViewModel viewModel, PkbjByUserViewModel pkbjByUserViewModel, IServiceProvider serviceProvider, int clientTimeZoneOffset /*, IGarmentDeliveryOrderFacade DOfacad*/)
{
Font header_font = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 18);
Font normal_font = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 9);
Font normal_font1 = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);
Font bold_font = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 20);
Font bold_font1 = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);
Document document = new Document(PageSize.A4, 40, 40, 40, 40);
document.AddHeader("Header", viewModel.code);
MemoryStream stream = new MemoryStream();
PdfWriter writer = PdfWriter.GetInstance(document, stream);
writer.PageEvent = new PDFPages();
document.Open();
PdfPCell cellLeftNoBorder = new PdfPCell()
{
Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
};
PdfPCell cellRightNoBorder = new PdfPCell()
{
Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT
};
Chunk chkHeader = new Chunk(" ");
Phrase pheader = new Phrase(chkHeader);
HeaderFooter header = new HeaderFooter(pheader, false);
header.Border = Rectangle.NO_BORDER;
header.Alignment = Element.ALIGN_RIGHT;
document.Header = header;
#region Header
string titleString = "BON RETUR BARANG\n\n";
Paragraph title = new Paragraph(titleString, bold_font)
{
Alignment = Element.ALIGN_CENTER
};
document.Add(title);
bold_font.SetStyle(Font.NORMAL);
//string addressString = "PT DAN LIRIS" + "\n" + "JL. Merapi No.23" + "\n" + "Banaran, Grogol, Kab. Sukoharjo" + "\n" + "Jawa Tengah 57552 - INDONESIA" + "\n" + "PO.BOX 166 Solo 57100" + "\n" + "Telp. (0271) 740888, 714400" + "\n" + "Fax. (0271) 735222, 740777";
//Paragraph address = new Paragraph(addressString, bold_font) { Alignment = Element.ALIGN_LEFT };
//document.Add(address);
//bold_font.SetStyle(Font.NORMAL);
PdfPTable tableInternNoteHeader = new PdfPTable(2);
tableInternNoteHeader.SetWidths(new float[] { 7.5f, 4.5f });
PdfPCell cellInternNoteHeaderLeft = new PdfPCell()
{
Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
};
PdfPCell cellInternNoteHeaderRight = new PdfPCell()
{
Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
};
cellInternNoteHeaderLeft.Phrase = new Phrase("PT. MAJOR MINOR KREASI NUSANTARA", bold_font1);
tableInternNoteHeader.AddCell(cellInternNoteHeaderLeft);
cellInternNoteHeaderLeft.Phrase = new Phrase("No. Packing List" + " : " + pkbjByUserViewModel.packingList, normal_font);
tableInternNoteHeader.AddCell(cellInternNoteHeaderLeft);
cellInternNoteHeaderRight.Phrase = new Phrase("Equity Tower 15th Floor Suite C, SCBD Lot 9, Jl. Jenderal Sudirman Kav 52-53 Jakarta 12190, Indonesia", normal_font);
tableInternNoteHeader.AddCell(cellInternNoteHeaderRight);
cellInternNoteHeaderLeft.Phrase = new Phrase("Password" + " : " + pkbjByUserViewModel.password, normal_font);
tableInternNoteHeader.AddCell(cellInternNoteHeaderLeft);
cellInternNoteHeaderRight.Phrase = new Phrase("", normal_font);
tableInternNoteHeader.AddCell(cellInternNoteHeaderRight);
cellInternNoteHeaderLeft.Phrase = new Phrase("Tanggal" + " : " + viewModel.CreatedUtc.ToString("dd MMMM yyyy", new CultureInfo("id-ID")) + "\n\n\n", normal_font);
tableInternNoteHeader.AddCell(cellInternNoteHeaderLeft);
cellInternNoteHeaderRight.Phrase = new Phrase("Dari" + " : " + viewModel.source.name, normal_font);
tableInternNoteHeader.AddCell(cellInternNoteHeaderRight);
cellInternNoteHeaderLeft.Phrase = new Phrase("", normal_font);
tableInternNoteHeader.AddCell(cellInternNoteHeaderLeft);
cellInternNoteHeaderRight.Phrase = new Phrase("Tujuan" + " : " + viewModel.destination.name, normal_font);
tableInternNoteHeader.AddCell(cellInternNoteHeaderRight);
cellInternNoteHeaderLeft.Phrase = new Phrase("", normal_font);
tableInternNoteHeader.AddCell(cellInternNoteHeaderLeft);
//cellInternNoteHeaderRight.Phrase = new Phrase("Tanggal Kirim" + " : " + viewModel.date.Value.ToOffset(new TimeSpan(clientTimeZoneOffset, 0, 0)).ToString("dd MMMM yyyy", new CultureInfo("id-ID")), normal_font);
//tableInternNoteHeader.AddCell(cellInternNoteHeaderRight);
//cellInternNoteHeaderLeft.Phrase = new Phrase("", normal_font);
//tableInternNoteHeader.AddCell(cellInternNoteHeaderLeft);
//cellInternNoteHeaderRight.Phrase = new Phrase("Nomor Referensi" + " : " + viewModel.reference, normal_font);
//tableInternNoteHeader.AddCell(cellInternNoteHeaderRight);
//cellInternNoteHeaderLeft.Phrase = new Phrase("", normal_font);
//tableInternNoteHeader.AddCell(cellInternNoteHeaderLeft);
//cellInternNoteHeaderRight.Phrase = new Phrase("Keterangan" + " : " + "" + "\n\n", normal_font);
//tableInternNoteHeader.AddCell(cellInternNoteHeaderRight);
PdfPCell cellInternNoteHeader = new PdfPCell(tableInternNoteHeader); // dont remove
tableInternNoteHeader.ExtendLastRow = false;
tableInternNoteHeader.SpacingAfter = 10f;
document.Add(tableInternNoteHeader);
#endregion
#region Table_Of_Content
PdfPCell cellCenter = new PdfPCell()
{
Border = Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, VerticalAlignment = Element.ALIGN_MIDDLE, Padding = 5
};
PdfPCell cellRight = new PdfPCell()
{
Border = Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT, VerticalAlignment = Element.ALIGN_MIDDLE, Padding = 5
};
PdfPCell cellLeft = new PdfPCell()
{
Border = Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE, Padding = 5
};
PdfPTable tableContent = new PdfPTable(5);
tableContent.SetWidths(new float[] { 2f, 4f, 5f, 6.5f, 5.5f });
cellCenter.Phrase = new Phrase("No", bold_font1);
tableContent.AddCell(cellCenter);
cellCenter.Phrase = new Phrase("Produk", bold_font1);
tableContent.AddCell(cellCenter);
cellCenter.Phrase = new Phrase("Nama Produk", bold_font1);
tableContent.AddCell(cellCenter);
cellCenter.Phrase = new Phrase("Kuantitas", bold_font1);
tableContent.AddCell(cellCenter);
cellCenter.Phrase = new Phrase("Harga", bold_font1);
tableContent.AddCell(cellCenter);
double totalPriceTotal = 0;
double total = 0;
List <TableContent> TableContents = new List <TableContent>();
int index = 1;
foreach (TransferOutDocItemViewModel item in viewModel.items)
{
TableContents.Add(new TableContent
{
No = index++,
Product = item.item.code,
ProductName = item.item.name,
Quantity = item.quantity,
Price = String.Format("{0:n}", item.quantity * item.item.domesticSale)
});
totalPriceTotal += item.quantity * item.item.domesticSale;
total += item.quantity;
}
foreach (TableContent c in TableContents.OrderBy(o => o.No))
{
cellCenter.Phrase = new Phrase(c.No.ToString(), normal_font1);
tableContent.AddCell(cellCenter);
cellCenter.Phrase = new Phrase(c.Product, normal_font1);
tableContent.AddCell(cellCenter);
cellCenter.Phrase = new Phrase(c.ProductName, normal_font1);
tableContent.AddCell(cellCenter);
cellCenter.Phrase = new Phrase(c.Quantity.ToString(), normal_font1);
tableContent.AddCell(cellCenter);
cellCenter.Phrase = new Phrase(c.Price, normal_font1);
tableContent.AddCell(cellCenter);
}
PdfPCell cellContent = new PdfPCell(tableContent); // dont remove
tableContent.ExtendLastRow = false;
tableContent.SpacingAfter = 20f;
document.Add(tableContent);
#endregion
#region Total
PdfPTable tabletotal = new PdfPTable(3);
tabletotal.SetWidths(new float[] { 11f, 6.5f, 5.5f });
PdfPCell cellTotalContent = new PdfPCell()
{
Border = Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_CENTER
};
cellTotalContent.Phrase = new Phrase("Total", normal_font1);
tabletotal.AddCell(cellTotalContent);
cellTotalContent.Phrase = new Phrase("" + total, normal_font1);
tabletotal.AddCell(cellTotalContent);
cellTotalContent.Phrase = new Phrase("" + String.Format("{0:n}", totalPriceTotal), normal_font1);
tabletotal.AddCell(cellTotalContent);
PdfPCell cellTotal = new PdfPCell(tabletotal); // dont remove
tabletotal.ExtendLastRow = false;
tabletotal.SpacingBefore = 20f;
tabletotal.SpacingAfter = 20f;
document.Add(tabletotal);
#endregion
//PdfPTable tableContent2 = new PdfPTable(3);
//tableContent2.SetWidths(new float[] { 13f, 4.5f, 5.5f });
//List<TableContent2> tableContents2 = new List<TableContent2>();
//tableContents2.Add(new TableContent2
//{
// Total = "Total",
// QtyTotal = total.ToString(),
// PriceTotal = String.Format("{0:n}", totalPriceTotal.ToString())
//});
//foreach (TableContent2 c in tableContents2)
//{
// cellLeft.Phrase = new Phrase(c.Total, normal_font1);
// tableContent.AddCell(cellLeft);
// cellLeft.Phrase = new Phrase(c.QtyTotal, normal_font1);
// tableContent.AddCell(cellLeft);
// cellLeft.Phrase = new Phrase(c.PriceTotal, normal_font1);
// tableContent.AddCell(cellLeft);
//}
//PdfPCell cellContent2 = new PdfPCell(tableContent2); // dont remove
//tableContent.ExtendLastRow = false;
//tableContent.SpacingAfter = 20f;
//document.Add(tableContent);
//#region Footer
//PdfPTable tableFooter = new PdfPTable(2);
//tableFooter.SetWidths(new float[] { 1f, 1f });
//PdfPTable tableFooterLeft = new PdfPTable(2);
//tableFooterLeft.SetWidths(new float[] { 3f, 5f });
//PdfPCell cellInternNoteFooterLeft = new PdfPCell() { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT };
//PdfPCell cellInternNoteFooterRight = new PdfPCell() { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT };
////foreach (var unit in units)
////{
//// if (unit.Value == 0)
//// {
//// cellLeftNoBorder.Phrase = new Phrase($"Total {unit.Key}", normal_font);
//// tableFooterLeft.AddCell(cellLeftNoBorder);
//// cellLeftNoBorder.Phrase = new Phrase($": -", normal_font);
//// tableFooterLeft.AddCell(cellLeftNoBorder);
//// }
//// else
//// {
//// cellLeftNoBorder.Phrase = new Phrase($"Total {unit.Key}", normal_font);
//// tableFooterLeft.AddCell(cellLeftNoBorder);
//// cellLeftNoBorder.Phrase = new Phrase($": {unit.Value.ToString("n", new CultureInfo("id-ID"))}", normal_font);
//// tableFooterLeft.AddCell(cellLeftNoBorder);
//// }
////}
//PdfPTable tableFooterRight = new PdfPTable(2);
//tableFooterRight.SetWidths(new float[] { 5f, 5f });
////cellLeftNoBorder.Phrase = new Phrase($"Total Harga Pokok (DPP)", normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase($": " + totalPriceTotal.ToString("N", new CultureInfo("id-ID")), normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase("Mata Uang", normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase($": " + viewModel.currency.Code, normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase("Total Harga Pokok (Rp)", normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase($": " + total.ToString("N", new CultureInfo("id-ID")), normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase("Total Nota Koreksi", normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////if (correctionNote != null)
////{
//// cellLeftNoBorder.Phrase = new Phrase($": " + totalcorrection.ToString("N", new CultureInfo("id-ID")), normal_font);
//// tableFooterRight.AddCell(cellLeftNoBorder);
////}
////else
////{
//// cellLeftNoBorder.Phrase = new Phrase($": " + 0, normal_font);
//// tableFooterRight.AddCell(cellLeftNoBorder);
////}
////cellLeftNoBorder.Phrase = new Phrase("Total Nota PPn", normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase($": " + ppn.ToString("N", new CultureInfo("id-ID")), normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase("Total Nota PPh", normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase($": " + pph.ToString("N", new CultureInfo("id-ID")), normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase("Total yang Harus Dibayar", normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
////cellLeftNoBorder.Phrase = new Phrase($": " + maxtotal.ToString("N", new CultureInfo("id-ID")), normal_font);
////tableFooterRight.AddCell(cellLeftNoBorder);
//PdfPCell cellFooterLeft = new PdfPCell(tableFooterLeft) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER };
//tableFooter.AddCell(cellFooterLeft);
//PdfPCell cellFooterRight = new PdfPCell(tableFooterRight) { Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER };
//tableFooter.AddCell(cellFooterRight);
//PdfPCell cellFooter = new PdfPCell(tableFooter); // dont remove
//tableFooter.ExtendLastRow = false;
//tableFooter.SpacingAfter = 20f;
//document.Add(tableFooter);
//#endregion
//#region TableSignature
//PdfPTable tableSignature = new PdfPTable(3);
//PdfPCell cellSignatureContent = new PdfPCell() { Border = Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.BOTTOM_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_CENTER };
//cellSignatureContent.Phrase = new Phrase("", bold_font1);
//tableSignature.AddCell(cellSignatureContent);
//cellSignatureContent.Phrase = new Phrase("", bold_font1);
//tableSignature.AddCell(cellSignatureContent);
//cellSignatureContent.Phrase = new Phrase("Yang Membuat\n\n\n\n\n\n\n(________________________________)", bold_font1);
//tableSignature.AddCell(cellSignatureContent);
//PdfPCell cellSignature = new PdfPCell(tableSignature); // dont remove
//tableSignature.ExtendLastRow = false;
//tableSignature.SpacingBefore = 20f;
//tableSignature.SpacingAfter = 20f;
//document.Add(tableSignature);
//#endregion
document.Close();
byte[] byteInfo = stream.ToArray();
stream.Write(byteInfo, 0, byteInfo.Length);
stream.Position = 0;
return(stream);
}
public async Task Should_Success_Validate_Data()
{
TransferOutDocViewModel ViewModel = new TransferOutDocViewModel
{
};
Assert.True(ViewModel.Validate(null).Count() > 0);
TransferOutDocViewModel ViewModeldest = new TransferOutDocViewModel
{
destination = new Lib.ViewModels.NewIntegrationViewModel.DestinationViewModel
{
code = "code",
name = "name",
_id = 1
}
};
Assert.True(ViewModel.Validate(null).Count() > 0);
TransferOutDocViewModel ViewModelitem = new TransferOutDocViewModel
{
destination = new Lib.ViewModels.NewIntegrationViewModel.DestinationViewModel
{
code = "code",
name = "name",
_id = 1
},
source = new Lib.ViewModels.NewIntegrationViewModel.SourceViewModel
{
code = "code",
name = "name",
_id = 1
}
};
Assert.True(ViewModel.Validate(null).Count() > 0);
DbSet <Inventory> dbSetInventory = _dbContext(GetCurrentMethod()).Set <Inventory>();
InventoryFacade facade = new InventoryFacade(GetServiceProvider().Object, _dbContext(GetCurrentMethod()));
var model = await invendataUtil(facade, GetCurrentMethod(), _dbContext(GetCurrentMethod())).GetTestData();
TransferOutDocViewModel ViewModelitemquantity = new TransferOutDocViewModel
{
destination = new Lib.ViewModels.NewIntegrationViewModel.DestinationViewModel
{
code = "code",
name = "name",
_id = 1
},
source = new Lib.ViewModels.NewIntegrationViewModel.SourceViewModel
{
code = model.StorageCode,
name = model.StorageName,
_id = model.StorageId
},
items = new List <TransferOutDocItemViewModel>
{
new TransferOutDocItemViewModel
{
item = new Lib.ViewModels.NewIntegrationViewModel.ItemViewModel
{
_id = model.ItemId,
},
quantity = model.Quantity + 1,
remark = "remark"
}
}
};
Assert.True(ViewModelitemquantity.Validate(null).Count() > 0);
TransferOutDocViewModel ViewModelitemremark = new TransferOutDocViewModel
{
destination = new Lib.ViewModels.NewIntegrationViewModel.DestinationViewModel
{
code = "code",
name = "name",
_id = 1
},
source = new Lib.ViewModels.NewIntegrationViewModel.SourceViewModel
{
code = model.StorageCode,
name = model.StorageName,
_id = model.StorageId
},
items = new List <TransferOutDocItemViewModel>
{
new TransferOutDocItemViewModel
{
item = new Lib.ViewModels.NewIntegrationViewModel.ItemViewModel
{
_id = model.ItemId,
},
quantity = model.Quantity,
remark = "",
}
}
};
Assert.True(ViewModelitemquantity.Validate(null).Count() > 0);
}
public async Task <int> Create(TransferOutDocViewModel model, TransferOutDoc model2, string username, int clientTimeZoneOffset = 7)
{
int Created = 0;
using (var transaction = this.dbContext.Database.BeginTransaction())
{
try
{
string codeOut = GenerateCode("EFR-KB/RTT");
string packingList1 = GenerateCode("EFR-KB/PLR");
string CodeIn = GenerateCode("EFR-TB/BRT");
string packingList2 = GenerateCode("EFR-KB/PLB");
string expCode = GenerateCode("EFR-KB/EXP");
string codetransferin = GenerateCode("EFR-TB/BRT");
model2.Code = codeOut;
model2.Date = DateTimeOffset.Now;
var storages = GetStorage("GDG.05");
var expeditionService = GetExpedition("Dikirim Sendiri");
List <ExpeditionItem> expeditionItems = new List <ExpeditionItem>();
List <ExpeditionDetail> expeditionDetails = new List <ExpeditionDetail>();
List <SPKDocsItem> sPKDocsItem1 = new List <SPKDocsItem>();
List <SPKDocsItem> sPKDocsItem2 = new List <SPKDocsItem>();
List <TransferInDocItem> transferInDocs = new List <TransferInDocItem>();
List <InventoryMovement> inventoryMovements = new List <InventoryMovement>();
List <TransferOutDocItem> transferOutDocItems = new List <TransferOutDocItem>();
EntityExtension.FlagForCreate(model2, username, USER_AGENT);
foreach (var i in model2.Items)
{
var invenInTransfer = dbContext.Inventories.Where(x => x.ItemId == i.ItemId && x.StorageId == storages.Id).FirstOrDefault();
if (invenInTransfer == null)
{
Inventory inventory = new Inventory
{
ItemArticleRealizationOrder = i.ArticleRealizationOrder,
ItemCode = i.ItemCode,
ItemDomesticCOGS = i.DomesticCOGS,
ItemDomesticRetail = i.DomesticRetail,
ItemDomesticSale = i.DomesticSale,
ItemDomesticWholeSale = i.DomesticWholeSale,
ItemId = i.ItemId,
ItemInternationalCOGS = 0,
ItemInternationalRetail = 0,
ItemInternationalSale = 0,
ItemInternationalWholeSale = 0,
ItemName = i.ItemName,
ItemSize = i.Size,
ItemUom = i.Uom,
Quantity = 0,
StorageCode = storages.Code,
StorageId = storages.Id,
StorageName = storages.Name,
StorageIsCentral = storages.Name.Contains("GUDANG") ? true : false,
};
EntityExtension.FlagForCreate(inventory, username, USER_AGENT);
dbSetInventory.Add(inventory);
transferOutDocItems.Add(new TransferOutDocItem
{
ArticleRealizationOrder = i.ArticleRealizationOrder,
DomesticCOGS = i.DomesticCOGS,
DomesticRetail = i.DomesticRetail,
DomesticSale = i.DomesticSale,
DomesticWholeSale = i.DomesticWholeSale,
ItemCode = i.ItemCode,
ItemId = i.ItemId,
ItemName = i.ItemName,
Quantity = i.Quantity,
Remark = i.Remark,
Size = i.Size,
Uom = i.Uom
});
}
else
{
invenInTransfer.Quantity = invenInTransfer.Quantity - i.Quantity;
}
sPKDocsItem1.Add(new SPKDocsItem
{
ItemArticleRealizationOrder = i.ArticleRealizationOrder,
ItemCode = i.ItemCode,
ItemDomesticCOGS = i.DomesticCOGS,
ItemDomesticRetail = i.DomesticRetail,
ItemDomesticSale = i.DomesticSale,
ItemDomesticWholesale = i.DomesticWholeSale,
ItemId = i.ItemId,
ItemName = i.ItemName,
ItemSize = i.Size,
ItemUom = i.Uom,
Quantity = i.Quantity,
Remark = i.Remark,
SendQuantity = i.Quantity
});
sPKDocsItem2.Add(new SPKDocsItem
{
ItemArticleRealizationOrder = i.ArticleRealizationOrder,
ItemCode = i.ItemCode,
ItemDomesticCOGS = i.DomesticCOGS,
ItemDomesticRetail = i.DomesticRetail,
ItemDomesticSale = i.DomesticSale,
ItemDomesticWholesale = i.DomesticWholeSale,
ItemId = i.ItemId,
ItemName = i.ItemName,
ItemSize = i.Size,
ItemUom = i.Uom,
Quantity = i.Quantity,
Remark = i.Remark,
SendQuantity = i.Quantity
});
EntityExtension.FlagForCreate(i, username, USER_AGENT);
}
EntityExtension.FlagForCreate(model2, username, USER_AGENT);
foreach (var i in model2.Items)
{
//var inventorymovement = new InventoryMovement();
transferInDocs.Add(new TransferInDocItem
{
ArticleRealizationOrder = i.ArticleRealizationOrder,
ItemCode = i.ItemCode,
DomesticCOGS = i.DomesticCOGS,
DomesticRetail = i.DomesticRetail,
DomesticSale = i.DomesticSale,
DomesticWholeSale = i.DomesticWholeSale,
ItemId = i.ItemId,
ItemName = i.ItemName,
Size = i.Size,
Uom = i.Uom,
Quantity = i.Quantity,
Remark = i.Remark
});
}
SPKDocs sPKDocs1 = new SPKDocs
{
Code = GenerateCode("EFR-PK/PBJ"),
Date = DateTimeOffset.Now,
SourceId = model2.SourceId,
SourceCode = model2.SourceCode,
SourceName = model2.SourceName,
DestinationId = storages.Id,
DestinationCode = storages.Code,
DestinationName = storages.Name,
IsDistributed = true,
IsReceived = true,
IsDraft = false,
PackingList = packingList1,
Reference = codeOut,
Password = String.Join("", GenerateCode(DateTime.Now.ToString("dd")).Split("/")),
Weight = 0,
Items = sPKDocsItem1
};
EntityExtension.FlagForCreate(sPKDocs1, username, USER_AGENT);
TransferInDoc transferInDoc = new TransferInDoc
{
Code = codetransferin,
Date = DateTimeOffset.Now,
DestinationId = storages.Id,
DestinationCode = storages.Code,
DestinationName = storages.Name,
SourceCode = model2.SourceCode,
SourceId = model2.SourceId,
SourceName = model2.SourceName,
Reference = packingList1,
Remark = "",
Items = transferInDocs
};
EntityExtension.FlagForCreate(transferInDoc, username, USER_AGENT);
SPKDocs sPKDocs2 = new SPKDocs
{
Code = GenerateCode("EFR-PK/PBJ"),
Date = DateTimeOffset.Now,
DestinationId = model2.DestinationId,
DestinationCode = model2.DestinationCode,
DestinationName = model2.DestinationName,
SourceId = storages.Id,
SourceCode = storages.Code,
SourceName = storages.Name,
IsDistributed = true,
IsReceived = false,
IsDraft = false,
PackingList = packingList2,
Reference = codeOut,
Password = String.Join("", GenerateCode(DateTime.Now.ToString("dd")).Split("/")),
Weight = 0,
Items = sPKDocsItem2
};
EntityExtension.FlagForCreate(sPKDocs2, username, USER_AGENT);
foreach (var i in sPKDocs1.Items)
{
var QtySource = 0.0;
var invenOutSource = dbContext.Inventories.Where(x => x.ItemId == i.ItemId && x.StorageId == model2.SourceId).FirstOrDefault();
if (invenOutSource != null)
{
QtySource = invenOutSource.Quantity;
invenOutSource.Quantity = invenOutSource.Quantity - i.Quantity;
}
inventoryMovements.Add(new InventoryMovement
{
Before = QtySource,
After = invenOutSource.Quantity,
Date = DateTimeOffset.Now,
ItemCode = i.ItemCode,
ItemDomesticCOGS = i.ItemDomesticCOGS,
ItemDomesticRetail = i.ItemDomesticRetail,
ItemDomesticWholeSale = i.ItemDomesticRetail,
ItemDomesticSale = i.ItemDomesticSale,
ItemId = i.ItemId,
ItemInternationalCOGS = 0,
ItemInternationalRetail = 0,
ItemInternationalSale = 0,
ItemInternationalWholeSale = 0,
ItemName = i.ItemName,
ItemSize = i.ItemSize,
ItemUom = i.ItemUom,
Quantity = i.Quantity,
StorageCode = model2.SourceCode,
StorageId = model2.SourceId,
StorageName = model2.SourceName,
Type = "OUT",
Reference = codeOut,
Remark = model2.Remark,
StorageIsCentral = model2.SourceName.Contains("GUDANG") ? true : false,
});
inventoryMovements.Add(new InventoryMovement
{
Before = 0,
After = 1,
Date = DateTimeOffset.Now,
ItemCode = i.ItemCode,
ItemDomesticCOGS = i.ItemDomesticCOGS,
ItemDomesticRetail = i.ItemDomesticRetail,
ItemDomesticWholeSale = i.ItemDomesticRetail,
ItemDomesticSale = i.ItemDomesticSale,
ItemId = i.ItemId,
ItemInternationalCOGS = 0,
ItemInternationalRetail = 0,
ItemInternationalSale = 0,
ItemInternationalWholeSale = 0,
ItemName = i.ItemName,
ItemSize = i.ItemSize,
ItemUom = i.ItemUom,
Quantity = i.Quantity,
StorageCode = storages.Code,
StorageId = storages.Id,
StorageName = storages.Name,
Type = "IN",
Reference = codetransferin,
Remark = model2.Remark,
StorageIsCentral = storages.Name.Contains("GUDANG") ? true : false,
});
inventoryMovements.Add(new InventoryMovement
{
Before = 1,
After = 0,
Date = DateTimeOffset.Now,
ItemCode = i.ItemCode,
ItemDomesticCOGS = i.ItemDomesticCOGS,
ItemDomesticRetail = i.ItemDomesticRetail,
ItemDomesticWholeSale = i.ItemDomesticRetail,
ItemDomesticSale = i.ItemDomesticSale,
ItemId = i.ItemId,
ItemInternationalCOGS = 0,
ItemInternationalRetail = 0,
ItemInternationalSale = 0,
ItemInternationalWholeSale = 0,
ItemName = i.ItemName,
ItemSize = i.ItemSize,
ItemUom = i.ItemUom,
Quantity = i.Quantity,
StorageCode = model2.DestinationCode,
StorageId = model2.DestinationId,
StorageName = model2.DestinationName,
Type = "OUT",
Reference = expCode,
Remark = model2.Remark,
StorageIsCentral = model2.DestinationName.Contains("GUDANG") ? true : false,
});
expeditionDetails.Add(new ExpeditionDetail
{
ArticleRealizationOrder = i.ItemArticleRealizationOrder,
DomesticCOGS = i.ItemDomesticCOGS,
DomesticRetail = i.ItemDomesticRetail,
DomesticSale = i.ItemDomesticSale,
DomesticWholesale = i.ItemDomesticWholesale,
ItemCode = i.ItemCode,
ItemId = i.ItemId,
ItemName = i.ItemName,
Quantity = i.Quantity,
Remark = i.Remark,
SendQuantity = i.SendQuantity,
Uom = i.ItemUom,
Size = i.ItemSize,
//SPKDocsId = (int)dbContext.SPKDocs.OrderByDescending(x=>x.Id).FirstOrDefault().Id + 1
SPKDocsId = (int)sPKDocs1.Id
});
EntityExtension.FlagForCreate(i, username, USER_AGENT);
}
expeditionItems.Add(new ExpeditionItem
{
Code = sPKDocs2.Code,
Date = sPKDocs2.Date,
DestinationCode = sPKDocs2.DestinationCode,
DestinationId = (int)sPKDocs2.DestinationId,
DestinationName = sPKDocs2.DestinationName,
IsDistributed = sPKDocs2.IsDistributed,
IsDraft = sPKDocs2.IsDraft,
IsReceived = sPKDocs2.IsReceived,
PackingList = sPKDocs2.PackingList,
Password = sPKDocs2.Password,
Reference = codeOut,
SourceCode = sPKDocs2.SourceCode,
SourceId = (int)sPKDocs2.SourceId,
SourceName = sPKDocs2.SourceName,
//SPKDocsId = (int)dbContext.SPKDocs.OrderByDescending(x => x.Id).FirstOrDefault().Id + 1,
SPKDocsId = (int)sPKDocs2.Id,
Weight = sPKDocs2.Weight,
Details = expeditionDetails
});
Expedition expedition = new Expedition
{
Code = expCode,
Date = DateTimeOffset.Now,
ExpeditionServiceCode = expeditionService.code,
ExpeditionServiceId = (int)expeditionService._id,
ExpeditionServiceName = expeditionService.name,
Remark = "",
Weight = 0,
Items = expeditionItems,
};
EntityExtension.FlagForCreate(expedition, username, USER_AGENT);
TransferOutDoc transferOutDoc2 = new TransferOutDoc
{
Code = expCode,
Date = DateTimeOffset.Now,
DestinationCode = model2.DestinationCode,
DestinationId = model2.DestinationId,
DestinationName = model2.DestinationName,
Reference = packingList2,
Remark = "",
SourceId = storages.Id,
SourceCode = storages.Code,
SourceName = storages.Name,
Items = transferOutDocItems
};
EntityExtension.FlagForCreate(transferOutDoc2, username, USER_AGENT);
#region Saving
foreach (var i in transferOutDoc2.Items)
{
EntityExtension.FlagForCreate(i, username, USER_AGENT);
}
foreach (var i in sPKDocs2.Items)
{
EntityExtension.FlagForCreate(i, username, USER_AGENT);
}
foreach (var i in expedition.Items)
{
EntityExtension.FlagForCreate(i, username, USER_AGENT);
foreach (var d in i.Details)
{
EntityExtension.FlagForCreate(d, username, USER_AGENT);
}
}
foreach (var i in transferInDoc.Items)
{
EntityExtension.FlagForCreate(i, username, USER_AGENT);
}
foreach (var i in inventoryMovements)
{
EntityExtension.FlagForCreate(i, username, USER_AGENT);
dbSetInventoryMovement.Add(i);
}
dbSetExpedition.Add(expedition);
dbSetSpk.Add(sPKDocs1);
dbSetSpk.Add(sPKDocs2);
dbSet.Add(model2);
dbSet.Add(transferOutDoc2);
dbSetTransferIn.Add(transferInDoc);
Created = await dbContext.SaveChangesAsync();
transaction.Commit();
#endregion
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.Message);
}
return(Created);
}
}
