public async Task <IActionResult> InCreate([Bind("ItemId,Name,ShortDescription,LongDescription,Price,ImageUrl,ImageThumbnailUrl,FeaturedItem,Amount,InStock,Category")] Inventory inventory)
{
if (ModelState.IsValid)
{
_context.Add(inventory);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(inventory));
}
public async Task <IActionResult> Create([Bind("FName,LName,CustomerNumber,Phone,BAddress,SAddress,Email,Balance")] Customer customer)
{
if (ModelState.IsValid)
{
_context.Add(customer);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(customer));
}
public async Task <int> Create(SPKDocsFromFinihsingOutsViewModel viewModel, string username, string token)
{
int Created = 0;
using (var transaction = this.dbContext.Database.BeginTransaction())
{
try
{
List <SPKDocsItem> sPKDocsItems = new List <SPKDocsItem>();
foreach (var item in viewModel.Items)
{
var isDifferentSize = item.IsDifferentSize;
if (isDifferentSize == true)
{
foreach (var detail in item.Details)
{
var sizeId = detail.Size.Id.ToString("00");
var counterId = viewModel.counters._id.ToString("00");
var subCounterId = viewModel.subCounters._id.ToString("00");
var asal = viewModel.SourceId.ToString("0");
var roCreatedUtc = viewModel.RoCreatedUtc;
var materialId = viewModel.materials._id.ToString("00");
var barcode = asal + counterId + subCounterId + materialId + sizeId + roCreatedUtc;
Console.WriteLine("barcodefad " + barcode);
var itemx = GetItem(barcode);
if (itemx == null || itemx.Count() == 0) //barcode belum terdaftar, insert ke tabel items (BMS) terlebih dahulu
{
ItemCoreViewModelUsername itemCore = new ItemCoreViewModelUsername
{
dataDestination = new List <ItemViewModelRead>
{
new ItemViewModelRead
{
ArticleRealizationOrder = viewModel.RONo,
code = barcode,
name = viewModel.Comodity.name,
Size = item.Size.Size,
Uom = item.Uom.Unit,
ImagePath = viewModel.ImagePath,
ImgFile = "",
Tags = "",
Remark = "",
Description = "",
_id = 0
}
},
color = viewModel.color,
process = viewModel.process,
materials = viewModel.materials,
materialCompositions = viewModel.materialCompositions,
collections = viewModel.collections,
seasons = viewModel.seasons,
counters = viewModel.counters,
subCounters = viewModel.subCounters,
categories = viewModel.categories,
DomesticCOGS = item.BasicPrice,
DomesticRetail = 0,
DomesticSale = item.BasicPrice + item.ComodityPrice,
DomesticWholesale = 0,
InternationalCOGS = 0,
InternationalWholesale = 0,
InternationalRetail = 0,
InternationalSale = 0,
ImageFile = "",
_id = 0,
Username = username,
Token = token,
TotalQty = detail.Quantity
};
string itemsUri = "items/finished-goods/item";
var httpClient = (IHttpClientService)serviceProvider.GetService(typeof(IHttpClientService));
var response = await httpClient.PostAsync($"{APIEndpoint.Core}{itemsUri}", new StringContent(JsonConvert.SerializeObject(itemCore).ToString(), Encoding.UTF8, General.JsonMediaType));
response.EnsureSuccessStatusCode();
var item2 = GetItem2(barcode);
sPKDocsItems.Add(new SPKDocsItem
{
ItemArticleRealizationOrder = viewModel.RONo,
ItemCode = barcode,
ItemDomesticCOGS = item.BasicPrice,
ItemDomesticSale = item.BasicPrice + item.ComodityPrice,
ItemId = item2.FirstOrDefault()._id,
ItemName = viewModel.Comodity.name,
ItemSize = detail.Size.Size,
ItemUom = item.Uom.Unit,
Quantity = detail.Quantity,
Remark = "",
SendQuantity = detail.Quantity,
});
}
else // barcode sudah terdaftar
{
var existItemId = itemx.FirstOrDefault()._id;
ItemCoreViewModelUsername itemCore = new ItemCoreViewModelUsername
{
_id = existItemId,
Username = username,
Token = token,
TotalQty = detail.Quantity
};
sPKDocsItems.Add(new SPKDocsItem
{
ItemArticleRealizationOrder = viewModel.RONo,
ItemCode = barcode,
ItemDomesticCOGS = item.BasicPrice,
ItemDomesticSale = item.BasicPrice + item.ComodityPrice,
ItemId = existItemId,
ItemName = viewModel.Comodity.name,
ItemSize = detail.Size.Size,
ItemUom = item.Uom.Unit,
Quantity = detail.Quantity,
Remark = "",
SendQuantity = detail.Quantity,
});
//update TotalQty di tabel Items
string itemPutUri = $"items/finished-goods/update-qty-by-id/{existItemId}";
IHttpClientService httpClient = (IHttpClientService)serviceProvider.GetService(typeof(IHttpClientService));
var response = await httpClient.PutAsync($"{APIEndpoint.Core}{itemPutUri}", new StringContent(JsonConvert.SerializeObject(itemCore).ToString(), Encoding.UTF8, General.JsonMediaType));
if (response != null)
{
response.EnsureSuccessStatusCode();
}
}
}
}
else
{
var sizeId = item.Size.Id.ToString("00");
var counterId = viewModel.counters._id.ToString("00");
var subCounterId = viewModel.subCounters._id.ToString("00");
var asal = viewModel.SourceId.ToString("0");
var roCreatedUtc = viewModel.RoCreatedUtc;
var materialId = viewModel.materials._id.ToString("00");
var barcode = asal + counterId + subCounterId + materialId + sizeId + roCreatedUtc;
Console.WriteLine("barcodefad " + barcode);
var itemx = GetItem(barcode);
if (itemx == null || itemx.Count() == 0) //barcode belum terdaftar, insert ke tabel items (BMS) terlebih dahulu
{
ItemCoreViewModelUsername itemCore = new ItemCoreViewModelUsername
{
dataDestination = new List <ItemViewModelRead>
{
new ItemViewModelRead
{
ArticleRealizationOrder = viewModel.RONo,
code = barcode,
name = viewModel.Comodity.name,
Size = item.Size.Size,
Uom = item.Uom.Unit,
ImagePath = viewModel.ImagePath,
ImgFile = "",
Tags = "",
Remark = "",
Description = "",
_id = 0
}
},
color = viewModel.color,
process = viewModel.process,
materials = viewModel.materials,
materialCompositions = viewModel.materialCompositions,
collections = viewModel.collections,
seasons = viewModel.seasons,
counters = viewModel.counters,
subCounters = viewModel.subCounters,
categories = viewModel.categories,
DomesticCOGS = item.BasicPrice,
DomesticRetail = 0,
DomesticSale = item.BasicPrice + item.ComodityPrice,
DomesticWholesale = 0,
InternationalCOGS = 0,
InternationalWholesale = 0,
InternationalRetail = 0,
InternationalSale = 0,
ImageFile = "",
_id = 0,
Username = username,
Token = token,
TotalQty = item.Quantity
};
string itemsUri = "items/finished-goods/item";
var httpClient = (IHttpClientService)serviceProvider.GetService(typeof(IHttpClientService));
var response = await httpClient.PostAsync($"{APIEndpoint.Core}{itemsUri}", new StringContent(JsonConvert.SerializeObject(itemCore).ToString(), Encoding.UTF8, General.JsonMediaType));
response.EnsureSuccessStatusCode();
var item2 = GetItem2(barcode);
sPKDocsItems.Add(new SPKDocsItem
{
ItemArticleRealizationOrder = viewModel.RONo,
ItemCode = barcode,
ItemDomesticCOGS = item.BasicPrice,
ItemDomesticSale = item.BasicPrice + item.ComodityPrice,
ItemId = item2.FirstOrDefault()._id,
ItemName = viewModel.Comodity.name,
ItemSize = item.Size.Size,
ItemUom = item.Uom.Unit,
Quantity = item.Quantity,
Remark = "",
SendQuantity = item.Quantity,
});
}
else // barcode sudah terdaftar
{
var existItemId = itemx.FirstOrDefault()._id;
ItemCoreViewModelUsername itemCore = new ItemCoreViewModelUsername
{
_id = existItemId,
Username = username,
Token = token,
TotalQty = item.Quantity
};
sPKDocsItems.Add(new SPKDocsItem
{
ItemArticleRealizationOrder = viewModel.RONo,
ItemCode = barcode,
ItemDomesticCOGS = item.BasicPrice,
ItemDomesticSale = item.BasicPrice + item.ComodityPrice,
ItemId = existItemId,
ItemName = viewModel.Comodity.name,
ItemSize = item.Size.Size,
ItemUom = item.Uom.Unit,
Quantity = item.Quantity,
Remark = "",
SendQuantity = item.Quantity,
});
//update TotalQty di tabel Items
string itemPutUri = $"items/finished-goods/update-qty-by-id/{existItemId}";
IHttpClientService httpClient = (IHttpClientService)serviceProvider.GetService(typeof(IHttpClientService));
var response = await httpClient.PutAsync($"{APIEndpoint.Core}{itemPutUri}", new StringContent(JsonConvert.SerializeObject(itemCore).ToString(), Encoding.UTF8, General.JsonMediaType));
if (response != null)
{
response.EnsureSuccessStatusCode();
}
}
}
}
var packingListCode = GeneratePackingList();
SPKDocs data = new SPKDocs()
{
Code = GenerateCode("EFR-PK/PBJ"),
Date = viewModel.FinishingOutDate,
DestinationId = (long)viewModel.DestinationStorageId,
DestinationCode = viewModel.DestinationStorageCode,
DestinationName = viewModel.DestinationStorageName,
IsDistributed = false,
IsReceived = false,
PackingList = packingListCode,
Password = "******",
Reference = packingListCode,
SourceId = (long)viewModel.SourceStorageId,
SourceCode = viewModel.SourceStorageCode,
SourceName = viewModel.SourceStorageName,
Weight = 0,
FinishingOutIdentity = viewModel.FinishingOutIdentity,
Items = sPKDocsItems
};
foreach (var i in data.Items)
{
EntityExtension.FlagForCreate(i, username, USER_AGENT);
}
EntityExtension.FlagForCreate(data, username, USER_AGENT);
dbContext.Add(data);
Created = await dbContext.SaveChangesAsync();
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.Message);
}
}
return(Created);
}