public void NeutralizeInvoice(ref Invoice Invoice, Transaction oldTransaction)
{
Invoice.TotalHasPaid -= oldTransaction.TotalPayment.AsDecimal();
if (Invoice.TotalHasPaid != Invoice.TotalPrice)
{
Invoice.PaymentStatus = (int)DbConstant.PaymentStatus.NotSettled;
}
}
public void NeutralizePurchasing(ref Purchasing purchasing, Transaction oldTransaction)
{
purchasing.TotalHasPaid -= oldTransaction.TotalPayment.AsDecimal();
if (purchasing.TotalHasPaid != purchasing.TotalPrice)
{
purchasing.PaymentStatus = (int)DbConstant.PaymentStatus.NotSettled;
}
}
public void InsertTransaction(TransactionViewModel parentTransaction,
List<TransactionDetailViewModel> detailTransactionList, int userId)
{
Reference refTable = _referenceRepository.GetMany(r => r.Code == DbConstant.REF_TRANSTBL_MANUAL).FirstOrDefault();
DateTime currentTime = DateTime.Now;
Transaction parentEntity = new Transaction();
Map(parentTransaction, parentEntity);
parentEntity.CreateUserId = userId;
parentEntity.CreateDate = currentTime;
parentEntity.ModifyUserId = userId;
parentEntity.ModifyDate = currentTime;
parentEntity.ReferenceTableId = refTable.Id;
parentEntity.PrimaryKeyValue = -1;
parentEntity.Status = (int)DbConstant.DefaultDataStatus.Active;
_transactionRepository.AttachNavigation<User>(parentEntity.CreateUser);
_transactionRepository.AttachNavigation<User>(parentEntity.ModifyUser);
_transactionRepository.AttachNavigation<Reference>(parentEntity.PaymentMethod);
_transactionRepository.AttachNavigation<Reference>(parentEntity.ReferenceTable);
parentEntity = _transactionRepository.Add(parentEntity);
_unitOfWork.SaveChanges();
// update primary key value into previous inserted transaction id
parentEntity = _transactionRepository.GetById(parentEntity.Id);
parentEntity.PrimaryKeyValue = parentEntity.Id;
_transactionRepository.Update(parentEntity);
_unitOfWork.SaveChanges();
foreach (var detailTransaction in detailTransactionList)
{
TransactionDetail detailEntity = new TransactionDetail();
Map(detailTransaction, detailEntity);
detailEntity.ParentId = parentEntity.Id;
_transactionDetailRepository.AttachNavigation<Transaction>(detailEntity.Parent);
_transactionDetailRepository.AttachNavigation<JournalMaster>(detailEntity.Journal);
_transactionDetailRepository.Add(detailEntity);
}
_unitOfWork.SaveChanges();
}
public void InsertDebt(TransactionViewModel transaction, decimal purchasingPrice, int userID)
{
DateTime serverTime = DateTime.Now;
Reference transactionReferenceTable = _referenceRepository.GetMany(c => c.Code == DbConstant.REF_TRANSTBL_PURCHASING).FirstOrDefault();
transaction.CreateDate = serverTime;
transaction.ModifyDate = serverTime;
transaction.CreateUserId = userID;
transaction.ModifyUserId = userID;
transaction.TransactionDate = serverTime;
transaction.TotalTransaction = purchasingPrice.AsDouble();
transaction.ReferenceTableId = transactionReferenceTable.Id;
transaction.Status = (int)DbConstant.DefaultDataStatus.Active;
transaction.Description = "Pembayaran hutang";
Transaction entity = new Transaction();
Map(transaction, entity);
Transaction transactionInserted = _transactionRepository.Add(entity);
Purchasing purchasingEntity = _purchasingRepository.GetById(transaction.PrimaryKeyValue);
purchasingEntity.TotalHasPaid += transaction.TotalPayment.AsDecimal();
if (purchasingEntity.TotalHasPaid == purchasingEntity.TotalPrice)
{
purchasingEntity.PaymentStatus = (int)DbConstant.PaymentStatus.Settled;
}
_purchasingRepository.Update(purchasingEntity);
Reference paymentMethod = _referenceRepository.GetById(transaction.PaymentMethodId);
switch (paymentMethod.Code)
{
case DbConstant.REF_DEBT_PAYMENTMETHOD_BANK_EKONOMI:
case DbConstant.REF_DEBT_PAYMENTMETHOD_BANK_BCA1:
case DbConstant.REF_DEBT_PAYMENTMETHOD_BANK_BCA2:
{
// Bank Kredit --> Karena berkurang
TransactionDetail detailBank = new TransactionDetail();
detailBank.Credit = transaction.TotalPayment.AsDecimal();
if (paymentMethod.Code == DbConstant.REF_DEBT_PAYMENTMETHOD_BANK_EKONOMI)
{
detailBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.01").FirstOrDefault().Id;
}
else if (paymentMethod.Code == DbConstant.REF_DEBT_PAYMENTMETHOD_BANK_BCA1)
{
detailBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.02").FirstOrDefault().Id;
}
else if (paymentMethod.Code == DbConstant.REF_DEBT_PAYMENTMETHOD_BANK_BCA2)
{
detailBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.03").FirstOrDefault().Id;
}
detailBank.Parent = transactionInserted;
_transactionDetailRepository.Add(detailBank);
break;
}
case DbConstant.REF_DEBT_PAYMENTMETHOD_KAS:
// Kas Kredit --> Karena berkurang
TransactionDetail detailKas = new TransactionDetail();
detailKas.Credit = transaction.TotalPayment.AsDecimal();
detailKas.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.01.01").FirstOrDefault().Id;
detailKas.Parent = transactionInserted;
_transactionDetailRepository.Add(detailKas);
break;
}
TransactionDetail detailDebt = new TransactionDetail();
detailDebt.Debit = transaction.TotalPayment.AsDecimal();
detailDebt.JournalId = _journalMasterRepository.GetMany(j => j.Code == "2.01.01.01").FirstOrDefault().Id;
detailDebt.Parent = transactionInserted;
_transactionDetailRepository.Add(detailDebt);
_unitOfWork.SaveChanges();
}
public void InsertSalesReturnFunc(int invoiceID, List<ReturnViewModel> listReturn, int userID)
{
DateTime serverTime = DateTime.Now;
Reference transactionReferenceTable = _referenceRepository.GetMany(c => c.Code == DbConstant.REF_TRANSTBL_SALESRETURN).FirstOrDefault();
SalesReturn salesReturn = new SalesReturn();
salesReturn.CreateDate = serverTime;
salesReturn.CreateUserId = userID;
salesReturn.ModifyDate = serverTime;
salesReturn.ModifyUserId = userID;
salesReturn.InvoiceId = invoiceID;
salesReturn.Date = serverTime;
salesReturn.Status = (int)DbConstant.DefaultDataStatus.Active;
string code = "SLR" + "-" + serverTime.Month.ToString() + serverTime.Day.ToString() + "-";
//get total sales return created today
List<SalesReturn> todaySLR = _salesReturnRepository.GetMany(s => s.Code.ToString().Contains(code) && s.CreateDate.Year == serverTime.Year).ToList();
code = code + (todaySLR.Count + 1);
salesReturn.Code = code;
_salesReturnRepository.AttachNavigation(salesReturn.CreateUser);
_salesReturnRepository.AttachNavigation(salesReturn.ModifyUser);
_salesReturnRepository.AttachNavigation(salesReturn.Invoice);
salesReturn = _salesReturnRepository.Add(salesReturn);
_unitOfWork.SaveChanges();
List<SalesReturnDetail> listReturnDetail = new List<SalesReturnDetail>();
decimal totalTransaction = 0;
foreach (var itemReturn in listReturn)
{
List<InvoiceDetail> invoiceDetails = _invoiceDetailRepository.GetMany(x => x.SPKDetailSparepartDetail.SparepartDetail.SparepartId == itemReturn.SparepartId
&& x.InvoiceId == invoiceID
&& (x.SPKDetailSparepartDetail.SparepartDetail.Status == (int)DbConstant.SparepartDetailDataStatus.OutPurchase
|| x.SPKDetailSparepartDetail.SparepartDetail.Status == (int)DbConstant.SparepartDetailDataStatus.OutService
|| x.SPKDetailSparepartDetail.SparepartDetail.Status == (int)DbConstant.SparepartDetailDataStatus.OutInstalled)
).OrderByDescending(x => x.CreateDate)
.Take(itemReturn.ReturQty).ToList();
foreach (var invoiceDetail in invoiceDetails)
{
listReturnDetail.Add(new SalesReturnDetail
{
CreateDate = serverTime,
CreateUserId = userID,
ModifyDate = serverTime,
ModifyUserId = userID,
SalesReturnId = salesReturn.Id,
InvoiceDetailId = invoiceDetail.Id,
Status = (int)DbConstant.DefaultDataStatus.Active
});
totalTransaction += invoiceDetail.SubTotalPrice.AsDecimal();
SparepartDetail spDetail = _sparepartDetailRepository.GetById(invoiceDetail.SPKDetailSparepartDetail.SparepartDetailId);
spDetail.ModifyDate = serverTime;
spDetail.ModifyUserId = userID;
spDetail.Status = (int)DbConstant.SparepartDetailDataStatus.Active;
_sparepartDetailRepository.AttachNavigation(spDetail.CreateUser);
_sparepartDetailRepository.AttachNavigation(spDetail.ModifyUser);
_sparepartDetailRepository.AttachNavigation(spDetail.PurchasingDetail);
_sparepartDetailRepository.AttachNavigation(spDetail.Sparepart);
_sparepartDetailRepository.AttachNavigation(spDetail.SparepartManualTransaction);
_sparepartDetailRepository.Update(spDetail);
}
Sparepart sparepart = _sparepartRepository.GetById(itemReturn.SparepartId);
sparepart.ModifyDate = serverTime;
sparepart.ModifyUserId = userID;
sparepart.StockQty += itemReturn.ReturQty;
_sparepartRepository.AttachNavigation(sparepart.CreateUser);
_sparepartRepository.AttachNavigation(sparepart.ModifyUser);
_sparepartRepository.AttachNavigation(sparepart.CategoryReference);
_sparepartRepository.AttachNavigation(sparepart.UnitReference);
_sparepartRepository.Update(sparepart);
SparepartStockCard stockCard = new SparepartStockCard();
stockCard.CreateUserId = userID;
stockCard.CreateDate = serverTime;
stockCard.PrimaryKeyValue = salesReturn.Id;
stockCard.ReferenceTableId = transactionReferenceTable.Id;
stockCard.SparepartId = sparepart.Id;
stockCard.Description = "Retur Penjualan";
stockCard.QtyIn = itemReturn.ReturQty;
SparepartStockCard lastStockCard = _sparepartStokCardRepository.RetrieveLastCard(sparepart.Id);
double lastStock = 0;
if (lastStockCard != null)
{
lastStock = lastStockCard.QtyLast;
}
stockCard.QtyFirst = lastStock;
stockCard.QtyLast = lastStock + stockCard.QtyIn;
_sparepartStokCardRepository.AttachNavigation(stockCard.CreateUser);
_sparepartStokCardRepository.AttachNavigation(stockCard.Sparepart);
_sparepartStokCardRepository.AttachNavigation(stockCard.ReferenceTable);
_sparepartStokCardRepository.Add(stockCard);
}
_unitOfWork.SaveChanges();
foreach (var itemReturnDetail in listReturnDetail)
{
_salesReturnDetailRepository.AttachNavigation(itemReturnDetail.CreateUser);
_salesReturnDetailRepository.AttachNavigation(itemReturnDetail.ModifyUser);
_salesReturnDetailRepository.AttachNavigation(itemReturnDetail.SalesReturn);
_salesReturnDetailRepository.AttachNavigation(itemReturnDetail.InvoiceDetail);
_salesReturnDetailRepository.Add(itemReturnDetail);
}
Invoice invoice = _invoiceRepository.GetById(salesReturn.InvoiceId);
invoice.Status = (int)DbConstant.InvoiceStatus.HasReturn;
invoice.ModifyDate = serverTime;
invoice.ModifyUserId = userID;
if (invoice.TotalPrice != invoice.TotalHasPaid && (invoice.TotalPrice - invoice.TotalHasPaid) >= totalTransaction)
{
invoice.TotalHasPaid += totalTransaction;
}
if (invoice.TotalPrice == invoice.TotalHasPaid)
{
invoice.PaymentStatus = (int)DbConstant.PaymentStatus.Settled;
}
else
{
invoice.PaymentStatus = (int)DbConstant.PaymentStatus.NotSettled;
}
_invoiceRepository.AttachNavigation(invoice.CreateUser);
_invoiceRepository.AttachNavigation(invoice.ModifyUser);
_invoiceRepository.AttachNavigation(invoice.PaymentMethod);
_invoiceRepository.AttachNavigation(invoice.SPK);
_unitOfWork.SaveChanges();
Transaction transaction = new Transaction();
transaction.CreateDate = serverTime;
transaction.CreateUserId = userID;
transaction.ModifyDate = serverTime;
transaction.ModifyUserId = userID;
transaction.PrimaryKeyValue = salesReturn.Id;
transaction.ReferenceTableId = transactionReferenceTable.Id;
transaction.TotalPayment = totalTransaction.AsDouble();
transaction.TotalTransaction = totalTransaction.AsDouble();
transaction.Status = (int)DbConstant.DefaultDataStatus.Active;
transaction.Description = "Retur Penjualan";
transaction.TransactionDate = serverTime;
_transactionRepository.AttachNavigation(transaction.CreateUser);
_transactionRepository.AttachNavigation(transaction.ModifyUser);
_transactionRepository.AttachNavigation(transaction.PaymentMethod);
_transactionRepository.AttachNavigation(transaction.ReferenceTable);
transaction = _transactionRepository.Add(transaction);
_unitOfWork.SaveChanges();
TransactionDetail transCredit = new TransactionDetail();
transCredit.Credit = totalTransaction;
transCredit.ParentId = transaction.Id;
transCredit.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.03.01.01").FirstOrDefault().Id;
_transactionDetailRepository.AttachNavigation(transCredit.Journal);
_transactionDetailRepository.AttachNavigation(transCredit.Parent);
_transactionDetailRepository.Add(transCredit);
TransactionDetail transDebit = new TransactionDetail();
transDebit.Debit = totalTransaction;
transDebit.ParentId = transaction.Id;
transDebit.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.04.01").FirstOrDefault().Id;
_transactionDetailRepository.AttachNavigation(transCredit.Journal);
_transactionDetailRepository.AttachNavigation(transCredit.Parent);
_transactionDetailRepository.Add(transDebit);
_unitOfWork.SaveChanges();
}
public void Approve(PurchasingViewModel purchasing, int userID)
{
using (var trans = _unitOfWork.BeginTransaction())
{
try
{
DateTime serverTime = DateTime.Now;
Reference transactionReferenceTable = _referenceRepository.GetMany(c => c.Code == DbConstant.REF_TRANSTBL_PURCHASING).FirstOrDefault();
List<PurchasingDetail> listPurchasingDetail = _purchasingDetailRepository
.GetMany(c => c.PurchasingId == purchasing.Id).ToList();
foreach (var purchasingDetail in listPurchasingDetail)
{
Sparepart sparepartDB = _sparepartRepository.GetById(purchasingDetail.SparepartId);
SparepartDetail lastSPDetail = _sparepartDetailRepository.
GetMany(c => c.SparepartId == purchasingDetail.SparepartId).OrderByDescending(c => c.Id)
.FirstOrDefault();
string lastSPID = string.Empty;
if (lastSPDetail != null) lastSPID = lastSPDetail.Code;
SpecialSparepart specialSparepart = _specialSparepartRepository.GetMany(w => w.SparepartId == sparepartDB.Id && w.Status == (int)DbConstant.DefaultDataStatus.Active).FirstOrDefault();
for (int i = 1; i <= purchasingDetail.Qty; i++)
{
SparepartDetail spDetail = new SparepartDetail();
if (string.IsNullOrEmpty(lastSPID))
{
lastSPID = sparepartDB.Code + "0000000001";
}
else
{
lastSPID = sparepartDB.Code + (Convert.ToInt32(lastSPID.Substring(lastSPID.Length - 10)) + 1)
.ToString("D10");
}
spDetail.PurchasingDetailId = purchasingDetail.Id;
spDetail.SparepartId = sparepartDB.Id;
spDetail.Code = lastSPID;
spDetail.CreateDate = serverTime;
spDetail.CreateUserId = userID;
spDetail.ModifyUserId = userID;
spDetail.ModifyDate = serverTime;
spDetail.Status = (int)DbConstant.SparepartDetailDataStatus.Active;
_sparepartDetailRepository.AttachNavigation(spDetail.CreateUser);
_sparepartDetailRepository.AttachNavigation(spDetail.ModifyUser);
_sparepartDetailRepository.AttachNavigation(spDetail.PurchasingDetail);
_sparepartDetailRepository.AttachNavigation(spDetail.Sparepart);
_sparepartDetailRepository.AttachNavigation(spDetail.SparepartManualTransaction);
SparepartDetail insertedSpDetail = _sparepartDetailRepository.Add(spDetail);
if (!string.IsNullOrEmpty(purchasingDetail.SerialNumber) && specialSparepart != null)
{
SpecialSparepartDetail wd = new SpecialSparepartDetail();
wd.SerialNumber = purchasingDetail.SerialNumber;
wd.CreateUserId = userID;
wd.CreateDate = serverTime;
wd.ModifyUserId = userID;
wd.ModifyDate = serverTime;
wd.SpecialSparepartId = specialSparepart.Id;
wd.SparepartDetail = insertedSpDetail;
wd.Status = (int)DbConstant.WheelDetailStatus.Ready;
_specialSparepartDetailRepository.AttachNavigation(spDetail.CreateUser);
_specialSparepartDetailRepository.AttachNavigation(spDetail.ModifyUser);
_specialSparepartDetailRepository.AttachNavigation(spDetail.PurchasingDetail);
_specialSparepartDetailRepository.AttachNavigation(spDetail.Sparepart);
_specialSparepartDetailRepository.AttachNavigation(spDetail.SparepartManualTransaction);
_specialSparepartDetailRepository.Add(wd);
}
}
purchasingDetail.Status = (int)DbConstant.PurchasingStatus.Active;
_purchasingDetailRepository.AttachNavigation(purchasingDetail.CreateUser);
_purchasingDetailRepository.AttachNavigation(purchasingDetail.ModifyUser);
_purchasingDetailRepository.AttachNavigation(purchasingDetail.Purchasing);
_purchasingDetailRepository.AttachNavigation(purchasingDetail.Sparepart);
_purchasingDetailRepository.Update(purchasingDetail);
Sparepart sparepart = _sparepartRepository.GetById(purchasingDetail.SparepartId);
sparepart.StockQty += purchasingDetail.Qty;
_sparepartRepository.AttachNavigation(sparepart.CreateUser);
_sparepartRepository.AttachNavigation(sparepart.ModifyUser);
_sparepartRepository.AttachNavigation(sparepart.CategoryReference);
_sparepartRepository.AttachNavigation(sparepart.UnitReference);
_sparepartRepository.Update(sparepart);
SparepartStockCard stockCard = new SparepartStockCard();
stockCard.CreateUserId = userID;
stockCard.CreateDate = serverTime;
stockCard.PrimaryKeyValue = purchasing.Id;
stockCard.ReferenceTableId = transactionReferenceTable.Id;
stockCard.SparepartId = sparepart.Id;
stockCard.Description = "Purchasing";
stockCard.QtyIn = purchasingDetail.Qty;
SparepartStockCard lastStockCard = _sparepartStokCardRepository.RetrieveLastCard(sparepart.Id);
double lastStock = 0;
if (lastStockCard != null)
{
lastStock = lastStockCard.QtyLast;
}
stockCard.QtyFirst = lastStock;
stockCard.QtyLast = lastStock + stockCard.QtyIn;
_sparepartStokCardRepository.AttachNavigation(stockCard.CreateUser);
_sparepartStokCardRepository.AttachNavigation(stockCard.Sparepart);
_sparepartStokCardRepository.AttachNavigation(stockCard.ReferenceTable);
_sparepartStokCardRepository.Add(stockCard);
_unitOfWork.SaveChanges();
}
Reference refSelected = _referenceRepository.GetById(purchasing.PaymentMethodId);
purchasing.Status = (int)DbConstant.PurchasingStatus.Active;
if (refSelected != null &&
(refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_BANK_EKONOMI
|| refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_BANK_BCA1
|| refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_BANK_BCA2
|| refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_KAS)
)
{
purchasing.TotalHasPaid = purchasing.TotalPrice;
}
if (purchasing.TotalHasPaid != purchasing.TotalPrice)
{
purchasing.PaymentStatus = (int)DbConstant.PaymentStatus.NotSettled;
}
else
{
purchasing.PaymentStatus = (int)DbConstant.PaymentStatus.Settled;
}
Purchasing entity = _purchasingRepository.GetById(purchasing.Id);
//Map(purchasing, entity);
entity.PaymentStatus = purchasing.PaymentStatus;
entity.Status = purchasing.Status;
entity.TotalHasPaid = purchasing.TotalHasPaid;
entity.TotalPrice = purchasing.TotalPrice;
entity.PaymentMethodId = purchasing.PaymentMethodId;
_purchasingRepository.AttachNavigation(entity.CreateUser);
_purchasingRepository.AttachNavigation(entity.ModifyUser);
_purchasingRepository.AttachNavigation(entity.PaymentMethod);
_purchasingRepository.AttachNavigation(entity.Supplier);
_purchasingRepository.Update(entity);
_unitOfWork.SaveChanges();
Transaction transaction = new Transaction();
transaction.TransactionDate = purchasing.Date;
transaction.TotalPayment = Convert.ToDouble(purchasing.TotalHasPaid);
transaction.TotalTransaction = Convert.ToDouble(purchasing.TotalPrice);
transaction.ReferenceTableId = transactionReferenceTable.Id;
transaction.PrimaryKeyValue = purchasing.Id;
transaction.CreateDate = serverTime;
transaction.CreateUserId = userID;
transaction.ModifyUserId = userID;
transaction.ModifyDate = serverTime;
transaction.Status = (int)DbConstant.DefaultDataStatus.Active;
transaction.Description = "Pembelian sparepart";
transaction.PaymentMethodId = purchasing.PaymentMethodId;
_transactionRepository.AttachNavigation(transaction.CreateUser);
_transactionRepository.AttachNavigation(transaction.ModifyUser);
_transactionRepository.AttachNavigation(transaction.PaymentMethod);
_transactionRepository.AttachNavigation(transaction.ReferenceTable);
Transaction transactionInserted = _transactionRepository.Add(transaction);
_unitOfWork.SaveChanges();
switch (refSelected.Code)
{
case DbConstant.REF_PURCHASE_PAYMENTMETHOD_BANK_EKONOMI:
case DbConstant.REF_PURCHASE_PAYMENTMETHOD_BANK_BCA1:
case DbConstant.REF_PURCHASE_PAYMENTMETHOD_BANK_BCA2:
{
// Bank Kredit --> Karena berkurang
TransactionDetail detailBank = new TransactionDetail();
detailBank.Credit = purchasing.TotalHasPaid;
if (refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_BANK_EKONOMI)
{
detailBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.01").FirstOrDefault().Id;
}
else if (refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_BANK_BCA1)
{
detailBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.02").FirstOrDefault().Id;
}
else if (refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_BANK_BCA2)
{
detailBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.03").FirstOrDefault().Id;
}
detailBank.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(detailBank.Journal);
_transactionDetailRepository.AttachNavigation(detailBank.Parent);
_transactionDetailRepository.Add(detailBank);
break;
}
case DbConstant.REF_PURCHASE_PAYMENTMETHOD_KAS:
// Kas Kredit --> Karena berkurang
TransactionDetail detailKas = new TransactionDetail();
detailKas.Credit = purchasing.TotalHasPaid;
detailKas.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.01.01").FirstOrDefault().Id;
detailKas.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(detailKas.Journal);
_transactionDetailRepository.AttachNavigation(detailKas.Parent);
_transactionDetailRepository.Add(detailKas);
break;
case DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_KAS:
// Kas Kredit --> Karena berkurang
TransactionDetail detailKasKarenaUangMuka = new TransactionDetail();
detailKasKarenaUangMuka.Credit = purchasing.TotalHasPaid;
detailKasKarenaUangMuka.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.01.01").FirstOrDefault().Id;
detailKasKarenaUangMuka.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(detailKasKarenaUangMuka.Journal);
_transactionDetailRepository.AttachNavigation(detailKasKarenaUangMuka.Parent);
_transactionDetailRepository.Add(detailKasKarenaUangMuka);
// Uang Muka Debit --> Karena bertambah
TransactionDetail detailUangMukaBertambahKarenaKas = new TransactionDetail();
detailUangMukaBertambahKarenaKas.Debit = purchasing.TotalHasPaid;
detailUangMukaBertambahKarenaKas.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.05.01.01").FirstOrDefault().Id;
detailUangMukaBertambahKarenaKas.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(detailUangMukaBertambahKarenaKas.Journal);
_transactionDetailRepository.AttachNavigation(detailUangMukaBertambahKarenaKas.Parent);
_transactionDetailRepository.Add(detailUangMukaBertambahKarenaKas);
// Uang Muka Kredit --> Karena berkurang
TransactionDetail detailUangMukaBerkurangKarenaKas = new TransactionDetail();
detailUangMukaBerkurangKarenaKas.Credit = purchasing.TotalHasPaid;
detailUangMukaBerkurangKarenaKas.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.05.01.01").FirstOrDefault().Id;
detailUangMukaBerkurangKarenaKas.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(detailUangMukaBerkurangKarenaKas.Journal);
_transactionDetailRepository.AttachNavigation(detailUangMukaBerkurangKarenaKas.Parent);
_transactionDetailRepository.Add(detailUangMukaBerkurangKarenaKas);
break;
case DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_BANK_EKONOMI:
case DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_BANK_BCA1:
case DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_BANK_BCA2:
{
// Bank Kredit --> Karena berkurang
TransactionDetail detailBankKarenaUangMuka = new TransactionDetail();
detailBankKarenaUangMuka.Credit = purchasing.TotalHasPaid;
if (refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_BANK_EKONOMI)
{
detailBankKarenaUangMuka.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.01").FirstOrDefault().Id;
}
else if (refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_BANK_BCA1)
{
detailBankKarenaUangMuka.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.02").FirstOrDefault().Id;
}
else if (refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_BANK_BCA2)
{
detailBankKarenaUangMuka.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.03").FirstOrDefault().Id;
}
detailBankKarenaUangMuka.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(detailBankKarenaUangMuka.Journal);
_transactionDetailRepository.AttachNavigation(detailBankKarenaUangMuka.Parent);
_transactionDetailRepository.Add(detailBankKarenaUangMuka);
// Uang Muka Debit --> Karena bertambah
TransactionDetail detailUangMukaBertambahKarenaBank = new TransactionDetail();
detailUangMukaBertambahKarenaBank.Debit = purchasing.TotalHasPaid;
detailUangMukaBertambahKarenaBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.05.01.01").FirstOrDefault().Id;
detailUangMukaBertambahKarenaBank.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(detailUangMukaBertambahKarenaBank.Journal);
_transactionDetailRepository.AttachNavigation(detailUangMukaBertambahKarenaBank.Parent);
_transactionDetailRepository.Add(detailUangMukaBertambahKarenaBank);
// Uang Muka Kredit --> Karena berkurang
TransactionDetail detailUangMukaBerkurangKarenaBank = new TransactionDetail();
detailUangMukaBerkurangKarenaBank.Credit = purchasing.TotalHasPaid;
detailUangMukaBerkurangKarenaBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.05.01.01").FirstOrDefault().Id;
detailUangMukaBerkurangKarenaBank.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(detailUangMukaBerkurangKarenaBank.Journal);
_transactionDetailRepository.AttachNavigation(detailUangMukaBerkurangKarenaBank.Parent);
_transactionDetailRepository.Add(detailUangMukaBerkurangKarenaBank);
break;
}
case DbConstant.REF_PURCHASE_PAYMENTMETHOD_UTANG:
TransactionDetail utang = new TransactionDetail();
utang.Credit = purchasing.TotalPrice - purchasing.TotalHasPaid;
utang.JournalId = _journalMasterRepository.GetMany(j => j.Code == "2.01.01.01").FirstOrDefault().Id;
utang.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(utang.Journal);
_transactionDetailRepository.AttachNavigation(utang.Parent);
_transactionDetailRepository.Add(utang);
break;
}
if (refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_BANK_EKONOMI ||
refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_BANK_BCA1 ||
refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_BANK_BCA2 ||
refSelected.Code == DbConstant.REF_PURCHASE_PAYMENTMETHOD_UANGMUKA_KAS)
{
if (purchasing.TotalPrice > purchasing.TotalHasPaid)
{
// Utang Kredit --> Karena bertambah
TransactionDetail utang = new TransactionDetail();
utang.Credit = purchasing.TotalPrice - purchasing.TotalHasPaid;
utang.JournalId = _journalMasterRepository.GetMany(j => j.Code == "2.01.01.01").FirstOrDefault().Id;
utang.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(utang.Journal);
_transactionDetailRepository.AttachNavigation(utang.Parent);
_transactionDetailRepository.Add(utang);
}
}
// Sparepart Debit --> Karena bertambah
TransactionDetail detailSparepart = new TransactionDetail();
detailSparepart.Debit = purchasing.TotalPrice;
detailSparepart.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.04.01").FirstOrDefault().Id;
detailSparepart.ParentId = transactionInserted.Id;
_transactionDetailRepository.AttachNavigation(detailSparepart.Journal);
_transactionDetailRepository.AttachNavigation(detailSparepart.Parent);
_transactionDetailRepository.Add(detailSparepart);
_unitOfWork.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw;
}
}
}
public void InsertPurchaseReturnFunc(int purchasingID, List<ReturnViewModel> listReturn, int userID)
{
DateTime serverTime = DateTime.Now;
Reference transactionReferenceTable = _referenceRepository.GetMany(c => c.Code == DbConstant.REF_TRANSTBL_PURCHASERETURN).FirstOrDefault();
PurchaseReturn purchaseReturn = new PurchaseReturn();
purchaseReturn.CreateDate = serverTime;
purchaseReturn.CreateUserId = userID;
purchaseReturn.ModifyDate = serverTime;
purchaseReturn.ModifyUserId = userID;
purchaseReturn.PurchasingId = purchasingID;
purchaseReturn.Date = serverTime;
purchaseReturn.Status = (int)DbConstant.DefaultDataStatus.Active;
string code = "PRR" + "-" + serverTime.Month.ToString() + serverTime.Day.ToString() + "-";
//get total purchasing return created today
List<PurchaseReturn> todayPRR = _purchaseReturnRepository.GetMany(s => s.Code.ToString().Contains(code) && s.CreateDate.Year == serverTime.Year).ToList();
code = code + (todayPRR.Count + 1);
purchaseReturn.Code = code;
_purchaseReturnRepository.AttachNavigation(purchaseReturn.CreateUser);
_purchaseReturnRepository.AttachNavigation(purchaseReturn.ModifyUser);
_purchaseReturnRepository.AttachNavigation(purchaseReturn.Purchasing);
purchaseReturn = _purchaseReturnRepository.Add(purchaseReturn);
_unitOfWork.SaveChanges();
List<PurchaseReturnDetail> listReturnDetail = new List<PurchaseReturnDetail>();
decimal totalTransaction = 0;
foreach (var itemReturn in listReturn)
{
PurchasingDetail purchasingDetail = _purchasingDetailRepository.GetMany(x => x.SparepartId == itemReturn.SparepartId && x.PurchasingId == purchasingID).FirstOrDefault();
List<SparepartDetail> listSpDetail = _sparepartDetailRepository.GetMany(x => x.PurchasingDetailId == purchasingDetail.Id && x.Status == (int)DbConstant.SparepartDetailDataStatus.Active).OrderByDescending(x => x.CreateDate).Take(itemReturn.ReturQty).ToList();
foreach (var spDetail in listSpDetail)
{
listReturnDetail.Add(new PurchaseReturnDetail
{
CreateDate = serverTime,
CreateUserId = userID,
ModifyDate = serverTime,
ModifyUserId = userID,
PurchaseReturnId = purchaseReturn.Id,
PurchasingDetailId = purchasingDetail.Id,
SparepartDetailId = spDetail.Id,
Status = (int)DbConstant.DefaultDataStatus.Active
});
totalTransaction += spDetail.PurchasingDetail.Price;
spDetail.ModifyDate = serverTime;
spDetail.ModifyUserId = userID;
spDetail.Status = (int)DbConstant.SparepartDetailDataStatus.Deleted;
_sparepartDetailRepository.AttachNavigation(spDetail.CreateUser);
_sparepartDetailRepository.AttachNavigation(spDetail.ModifyUser);
_sparepartDetailRepository.AttachNavigation(spDetail.PurchasingDetail);
_sparepartDetailRepository.AttachNavigation(spDetail.Sparepart);
_sparepartDetailRepository.AttachNavigation(spDetail.SparepartManualTransaction);
_sparepartDetailRepository.Update(spDetail);
}
Sparepart sparepart = _sparepartRepository.GetById(itemReturn.SparepartId);
sparepart.ModifyDate = serverTime;
sparepart.ModifyUserId = userID;
sparepart.StockQty -= itemReturn.ReturQty;
_sparepartRepository.AttachNavigation(sparepart.CreateUser);
_sparepartRepository.AttachNavigation(sparepart.ModifyUser);
_sparepartRepository.AttachNavigation(sparepart.CategoryReference);
_sparepartRepository.AttachNavigation(sparepart.UnitReference);
_sparepartRepository.Update(sparepart);
SparepartStockCard stockCard = new SparepartStockCard();
stockCard.CreateUserId = userID;
stockCard.CreateDate = serverTime;
stockCard.PrimaryKeyValue = purchaseReturn.Id;
stockCard.ReferenceTableId = transactionReferenceTable.Id;
stockCard.SparepartId = sparepart.Id;
stockCard.Description = "Retur Pembelian";
stockCard.QtyOut = itemReturn.ReturQty;
SparepartStockCard lastStockCard = _sparepartStokCardRepository.RetrieveLastCard(sparepart.Id);
double lastStock = 0;
if (lastStockCard != null)
{
lastStock = lastStockCard.QtyLast;
}
stockCard.QtyFirst = lastStock;
stockCard.QtyLast = lastStock - stockCard.QtyOut;
_sparepartStokCardRepository.AttachNavigation(stockCard.CreateUser);
_sparepartStokCardRepository.AttachNavigation(stockCard.Sparepart);
_sparepartStokCardRepository.AttachNavigation(stockCard.ReferenceTable);
_sparepartStokCardRepository.Add(stockCard);
}
Purchasing purchasing = _purchasingRepository.GetById(purchaseReturn.PurchasingId);
if(purchasing.TotalPrice != purchasing.TotalHasPaid && (purchasing.TotalPrice - purchasing.TotalHasPaid) >= totalTransaction)
{
purchasing.TotalHasPaid += totalTransaction;
}
if (purchasing.TotalPrice == purchasing.TotalHasPaid)
{
purchasing.PaymentStatus = (int)DbConstant.PaymentStatus.Settled;
}
else
{
purchasing.PaymentStatus = (int)DbConstant.PaymentStatus.NotSettled;
}
_purchasingRepository.AttachNavigation(purchasing.CreateUser);
_purchasingRepository.AttachNavigation(purchasing.ModifyUser);
_purchasingRepository.AttachNavigation(purchasing.PaymentMethod);
_purchasingRepository.AttachNavigation(purchasing.Supplier);
_unitOfWork.SaveChanges();
foreach (var itemReturnDetail in listReturnDetail)
{
_purchaseReturnDetailRepository.AttachNavigation(itemReturnDetail.CreateUser);
_purchaseReturnRepository.AttachNavigation(itemReturnDetail.ModifyUser);
_purchaseReturnRepository.AttachNavigation(itemReturnDetail.PurchaseReturn);
_purchaseReturnRepository.AttachNavigation(itemReturnDetail.PurchasingDetail);
_purchaseReturnRepository.AttachNavigation(itemReturnDetail.SparepartDetail);
_purchaseReturnDetailRepository.Add(itemReturnDetail);
}
_unitOfWork.SaveChanges();
Transaction transaction = new Transaction();
transaction.CreateDate = serverTime;
transaction.CreateUserId = userID;
transaction.ModifyDate = serverTime;
transaction.ModifyUserId = userID;
transaction.PrimaryKeyValue = purchaseReturn.Id;
transaction.ReferenceTableId = transactionReferenceTable.Id;
transaction.TotalPayment = totalTransaction.AsDouble();
transaction.TotalTransaction = totalTransaction.AsDouble();
transaction.Status = (int)DbConstant.DefaultDataStatus.Active;
transaction.Description = "Retur Pembelian";
transaction.TransactionDate = serverTime;
_transactionRepository.AttachNavigation(transaction.CreateUser);
_transactionRepository.AttachNavigation(transaction.ModifyUser);
_transactionRepository.AttachNavigation(transaction.PaymentMethod);
_transactionRepository.AttachNavigation(transaction.ReferenceTable);
transaction = _transactionRepository.Add(transaction);
_unitOfWork.SaveChanges();
TransactionDetail transDebit = new TransactionDetail();
transDebit.Debit = totalTransaction;
transDebit.ParentId = transaction.Id;
transDebit.JournalId = _journalMasterRepository.GetMany(j => j.Code == "2.01.01.01").FirstOrDefault().Id;
_transactionDetailRepository.AttachNavigation(transDebit.Journal);
_transactionDetailRepository.AttachNavigation(transDebit.Parent);
_transactionDetailRepository.Add(transDebit);
TransactionDetail transCredit = new TransactionDetail();
transCredit.Credit = totalTransaction;
transCredit.ParentId = transaction.Id;
transCredit.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.04.01").FirstOrDefault().Id;
_transactionDetailRepository.AttachNavigation(transCredit.Journal);
_transactionDetailRepository.AttachNavigation(transCredit.Parent);
_transactionDetailRepository.Add(transCredit);
_unitOfWork.SaveChanges();
}
public static void DataImporter()
{
BrawijayaWorkshopDbContext contextTemp = new BrawijayaWorkshopDbContext(
new MySqlConnection(ConfigurationManager.ConnectionStrings["TempConn"].ConnectionString), true);
BrawijayaWorkshopDbContext contextDest = new BrawijayaWorkshopDbContext(
new MySqlConnection(ConfigurationManager.ConnectionStrings["DestConn"].ConnectionString), true);
contextDest.Database.CreateIfNotExists();
//get all data from temp db
List<ApplicationModul> ApplicationModulList = contextTemp.ApplicationModuls.ToList();
List<Role> RoleList = contextTemp.Roles.ToList();
List<Setting> SettingList = contextTemp.Settings.ToList();
List<Reference> ReferenceList = contextTemp.References.ToList();
List<User> UserList = contextTemp.Users.ToList();
List<JournalMaster> JournalMasterList = contextTemp.JournalMasters.ToList();
List<Brand> BrandList = contextTemp.Brands.ToList();
List<BrawijayaWorkshop.Database.Entities.Type> TypeList = contextTemp.Types.ToList();
List<City> CityList = contextTemp.Cities.ToList();
List<RoleAccess> RoleAccessList = contextTemp.RoleAccesses.ToList();
List<UserRole> UserRoleList = contextTemp.UserRoles.ToList();
List<Customer> CustomerList = contextTemp.Customers.ToList();
List<VehicleGroup> VehicleGroupList = contextTemp.VehicleGroups.ToList();
List<Vehicle> VehicleList = contextTemp.Vehicles.ToList();
List<VehicleDetail> VehicleDetailList = contextTemp.VehicleDetails.ToList();
List<Mechanic> MechanicList = contextTemp.Mechanics.ToList();
List<Supplier> SupplierList = contextTemp.Suppliers.ToList();
List<Sparepart> SparepartList = contextTemp.Spareparts.ToList();
List<SpecialSparepart> SpecialSparepartList = contextTemp.Wheels.ToList();
List<SparepartManualTransaction> SparepartManualTransactionList = contextTemp.SparepartManualTransactions.ToList();
List<Purchasing> PurchasingList = contextTemp.Purchasings.ToList();
List<PurchasingDetail> PurchasingDetailList = contextTemp.PurchasingDetails.ToList();
List<PurchaseReturn> PurchaseReturnList = contextTemp.PurchaseReturns.ToList();
List<PurchaseReturnDetail> PurchaseReturnDetailList = contextTemp.PurchaseReturnDetails.ToList();
List<SparepartDetail> SparepartDetailList = contextTemp.SparepartDetails.ToList();
List<SpecialSparepartDetail> SpecialSparepartDetailList = contextTemp.WheelDetails.ToList();
List<VehicleWheel> VehicleWheelList = contextTemp.VehicleWheels.ToList();
List<UsedGood> UsedGoodList = contextTemp.UsedGoods.ToList();
List<UsedGoodTransaction> UsedGoodTransactionList = contextTemp.UsedGoodsTransactions.ToList();
List<GuestBook> GuestBookList = contextTemp.GuestBooks.ToList();
List<SPK> SPKList = contextTemp.SPKs.ToList();
List<SPKDetailSparepart> SPKDetailSparepartList = contextTemp.SPKDetailSpareparts.ToList();
List<SPKDetailSparepartDetail> SPKDetailSparepartDetailList = contextTemp.SPKDetailSparepartDetails.ToList();
List<SPKSchedule> SPKScheduleList = contextTemp.SPKSchedules.ToList();
List<WheelExchangeHistory> WheelExchangeHistoryList = contextTemp.WheelExchangeHistories.ToList();
List<Invoice> InvoiceList = contextTemp.Invoices.ToList();
List<InvoiceDetail> InvoiceDetailList = contextTemp.InvoiceDetails.ToList();
List<SalesReturn> SalesReturnList = contextTemp.SalesReturns.ToList();
List<SalesReturnDetail> SalesReturnDetailList = contextTemp.SalesReturnDetails.ToList();
List<Transaction> TransactionList = contextTemp.Transactions.ToList();
List<TransactionDetail> TransactionDetailList = contextTemp.TransactionDetails.ToList();
List<BalanceJournal> BalanceJournalList = contextTemp.BalanceJournals.ToList();
List<BalanceJournalDetail> BalanceJournalDetailList = contextTemp.BalanceJournalDetails.ToList();
Dictionary<int, int> dictAppModul = new Dictionary<int, int>();
Dictionary<int, int> dictRole = new Dictionary<int, int>();
Dictionary<int, int> dictUser = new Dictionary<int, int>();
Dictionary<int, int> dictCity = new Dictionary<int, int>();
Dictionary<int, int> dictReference = new Dictionary<int, int>();
Dictionary<int, int> dictJournalMaster = new Dictionary<int, int>();
Dictionary<int, int> dictBrand = new Dictionary<int, int>();
Dictionary<int, int> dictType = new Dictionary<int, int>();
Dictionary<int, int> dictCustomer = new Dictionary<int, int>();
Dictionary<int, int> dictVehicleGroup = new Dictionary<int, int>();
Dictionary<int, int> dictVehicle = new Dictionary<int, int>();
Dictionary<int, int> dictMechanic = new Dictionary<int, int>();
Dictionary<int, int> dictSupplier = new Dictionary<int, int>();
Dictionary<int, int> dictSparepart = new Dictionary<int, int>();
Dictionary<int, int> dictSpecialSparepart = new Dictionary<int, int>();
Dictionary<int, int> dictSpManualTrans = new Dictionary<int, int>();
Dictionary<int, int> dictPurchasing = new Dictionary<int, int>();
Dictionary<int, int> dictPurchasingDetail = new Dictionary<int, int>();
Dictionary<int, int> dictPurchaseReturn = new Dictionary<int, int>();
Dictionary<int, int> dictSparepartDetail = new Dictionary<int, int>();
Dictionary<int, int> dictSpecialSparepartDetail = new Dictionary<int, int>();
Dictionary<int, int> dictUsedGood = new Dictionary<int, int>();
Dictionary<int, int> dictSPK = new Dictionary<int, int>();
Dictionary<int, int> dictSPKDetailSparepart = new Dictionary<int, int>();
Dictionary<int, int> dictSPKDetailSparepartDetail = new Dictionary<int, int>();
Dictionary<int, int> dictInvoice = new Dictionary<int, int>();
Dictionary<int, int> dictInvoiceDetail = new Dictionary<int, int>();
Dictionary<int, int> dictSalesReturn = new Dictionary<int, int>();
Dictionary<int, int> dictTransaction = new Dictionary<int, int>();
Dictionary<int, int> dictBalanceJournal = new Dictionary<int, int>();
//applicationmodul
Console.Write("\nImporting table ApplicationModul");
foreach (var item in ApplicationModulList)
{
int itemOldId = item.Id;
item.Id = -1;
ApplicationModul newItem = contextDest.ApplicationModuls.Add(item);
contextDest.SaveChanges();
dictAppModul.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table ApplicationModul done, " + ApplicationModulList.Count + " records imported");
//role
Console.Write("\nImporting table Role");
foreach (var item in RoleList)
{
int itemOldId = item.Id;
item.Id = -1;
Role newItem = contextDest.Roles.Add(item);
contextDest.SaveChanges();
dictRole.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table Role done, " + RoleList.Count + " records imported");
//setting
Console.Write("\nImporting table setting");
foreach (var item in SettingList)
{
contextDest.Settings.Add(item);
}
contextDest.SaveChanges();
Console.Write("\nImporting table setting done, " + SettingList.Count + " records imported");
//reference
Console.Write("\nImporting table Reference");
foreach (var item in ReferenceList)
{
int itemOldId = item.Id;
Reference newItem = new Reference
{
Id = -1,
Code = item.Code,
Description = item.Description,
Name = item.Name,
ParentId = item.ParentId,
Value = item.Value
};
if (item.ParentId > 0)
{
int newParentId = dictReference[item.ParentId.Value];
newItem.ParentId = newParentId;
}
Reference insertedReference = contextDest.References.Add(newItem);
contextDest.SaveChanges();
dictReference.Add(itemOldId, insertedReference.Id);
}
Console.Write("\nImporting table Reference done, " + ReferenceList.Count + " records imported");
//user
Console.Write("\nImporting table User");
foreach (var item in UserList)
{
int itemOldId = item.Id;
item.Id = -1;
User newItem = contextDest.Users.Add(item);
contextDest.SaveChanges();
dictUser.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table User done, " + UserList.Count + " records imported");
//journalMaster
Console.Write("\nImporting table JournalMaster");
foreach (var item in JournalMasterList)
{
int itemOldId = item.Id;
JournalMaster newItem = new JournalMaster
{
Id = -1,
Code = item.Code,
Name = item.Name,
ParentId = item.ParentId,
};
if (item.ParentId > 0)
{
int newParentId = dictJournalMaster[item.ParentId.Value];
newItem.ParentId = newParentId;
}
JournalMaster insertedJournalMaster = contextDest.JournalMasters.Add(newItem);
contextDest.SaveChanges();
dictJournalMaster.Add(itemOldId, insertedJournalMaster.Id);
}
Console.Write("\nImporting table JournalMaster done, " + JournalMasterList.Count + " records imported");
//brand
Console.Write("\nImporting table Brand");
foreach (var item in BrandList)
{
int itemOldId = item.Id;
item.Id = -1;
Brand newItem = contextDest.Brands.Add(item);
contextDest.SaveChanges();
dictBrand.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table Brand done, " + BrandList.Count + " records imported");
//type
Console.Write("\nImporting table Type");
foreach (var item in TypeList)
{
int itemOldId = item.Id;
item.Id = -1;
BrawijayaWorkshop.Database.Entities.Type newItem = contextDest.Types.Add(item);
contextDest.SaveChanges();
dictType.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table Type done, " + TypeList.Count + " records imported");
//city
Console.Write("\nImporting table City");
foreach (var item in CityList)
{
int itemOldId = item.Id;
item.Id = -1;
City newItem = contextDest.Cities.Add(item);
contextDest.SaveChanges();
dictCity.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table City done, " + CityList.Count + " records imported");
//role access
Console.Write("\nImporting table RoleAccess");
foreach (var item in RoleAccessList)
{
RoleAccess newItem = new RoleAccess();
int role = dictRole[item.RoleId];
int appModul = dictAppModul[item.ApplicationModulId];
newItem.Id = -1;
newItem.RoleId = role;
newItem.ApplicationModulId = appModul;
newItem.AccessCode = item.AccessCode;
contextDest.RoleAccesses.Add(newItem);
}
contextDest.SaveChanges();
Console.Write("\nImporting table RoleAccess done, " + RoleAccessList.Count + " records imported");
//user role
Console.Write("\nImporting table UserRole");
foreach (var item in UserRoleList)
{
UserRole newItem = new UserRole();
int role = dictRole[item.RoleId];
int user = dictUser[item.UserId];
newItem.Id = -1;
newItem.RoleId = role;
newItem.UserId = user;
contextDest.UserRoles.Add(newItem);
}
Console.Write("\nImporting table UserRole done, " + UserRoleList.Count + " records imported");
//customer
Console.Write("\nImporting table Customer");
foreach (var item in CustomerList)
{
int itemOldId = item.Id;
Customer newItem = new Customer();
int city = dictCity[item.CityId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.CityId = city;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.Address = item.Address;
newItem.Code = item.Code;
newItem.CompanyName = item.CompanyName;
newItem.ContactPerson = item.ContactPerson;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.PhoneNumber = item.PhoneNumber;
newItem.Status = item.Status;
newItem = contextDest.Customers.Add(newItem);
contextDest.SaveChanges();
dictCustomer.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table Customer done, " + CustomerList.Count + " records imported");
//vehicle group
Console.Write("\nImporting table VehicleGroup");
foreach (var item in VehicleGroupList)
{
int itemOldId = item.Id;
VehicleGroup newItem = new VehicleGroup();
int customer = dictCustomer[item.CustomerId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.CustomerId = customer;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Name = item.Name;
newItem.Status = item.Status;
newItem = contextDest.VehicleGroups.Add(newItem);
contextDest.SaveChanges();
dictVehicleGroup.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table VehicleGroup done, " + VehicleGroupList.Count + " records imported");
//vehicle
Console.Write("\nImporting table Vehicle");
foreach (var item in VehicleList)
{
int itemOldId = item.Id;
Vehicle newItem = new Vehicle();
int customer = dictCustomer[item.CustomerId];
int vehicleGroup = dictVehicleGroup[item.VehicleGroupId];
int brand = dictBrand[item.BrandId];
int type = dictType[item.TypeId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.CustomerId = customer;
newItem.VehicleGroupId = vehicleGroup;
newItem.BrandId = brand;
newItem.TypeId = type;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.ActiveLicenseNumber = item.ActiveLicenseNumber;
newItem.Code = item.Code;
newItem.CreateDate = item.CreateDate;
newItem.Kilometers = item.Kilometers;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem.YearOfPurchase = item.YearOfPurchase;
newItem = contextDest.Vehicles.Add(newItem);
contextDest.SaveChanges();
dictVehicle.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table Vehicle done, " + VehicleList.Count + " records imported");
//vehicle detail
Console.Write("\nImporting table VehicleDetail");
foreach (var item in VehicleDetailList)
{
VehicleDetail newItem = new VehicleDetail();
int vehicle = dictVehicle[item.VehicleId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.VehicleId = vehicle;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.CreateDate = item.CreateDate;
newItem.ExpirationDate = item.ExpirationDate;
newItem.LicenseNumber = item.LicenseNumber;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
contextDest.VehicleDetails.Add(newItem);
}
contextDest.SaveChanges();
Console.Write("\nImporting table VehicleDetail done, " + VehicleDetailList.Count + " records imported");
//mechanic
Console.Write("\nImporting table Mechanic");
foreach (var item in MechanicList)
{
int itemOldId = item.Id;
Mechanic newItem = new Mechanic();
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.Address = item.Address;
newItem.BaseFee = item.BaseFee;
newItem.Code = item.Code;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Name = item.Name;
newItem.PhoneNumber = item.PhoneNumber;
newItem.Status = item.Status;
newItem = contextDest.Mechanics.Add(newItem);
contextDest.SaveChanges();
dictMechanic.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table Mechanic done, " + MechanicList.Count + " records imported");
//supplier
Console.Write("\nImporting table Supplier");
foreach (var item in SupplierList)
{
int itemOldId = item.Id;
Supplier newItem = new Supplier();
int city = dictCity[item.CityId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.CityId = city;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.Address = item.Address;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Name = item.Name;
newItem.PhoneNumber = item.PhoneNumber;
newItem.Status = item.Status;
newItem = contextDest.Suppliers.Add(newItem);
contextDest.SaveChanges();
dictSupplier.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table Supplier done, " + SupplierList.Count + " records imported");
//sparepart
Console.Write("\nImporting table Sparepart");
foreach (var item in SparepartList)
{
int itemOldId = item.Id;
Sparepart newItem = new Sparepart();
int category = dictReference[item.CategoryReferenceId];
int unit = dictReference[item.UnitReferenceId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.CategoryReferenceId = category;
newItem.UnitReferenceId = unit;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.Code = item.Code;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Name = item.Name;
newItem.Status = item.Status;
newItem.StockQty = item.StockQty;
newItem = contextDest.Spareparts.Add(newItem);
contextDest.SaveChanges();
dictSparepart.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table Sparepart done, " + SparepartList.Count + " records imported");
//special sparepart
Console.Write("\nImporting table SpecialSparepart");
foreach (var item in SpecialSparepartList)
{
int itemOldId = item.Id;
SpecialSparepart newItem = new SpecialSparepart();
int category = dictReference[item.ReferenceCategoryId];
int sparepart = dictSparepart[item.SparepartId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.ReferenceCategoryId = category;
newItem.SparepartId = sparepart;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.Wheels.Add(newItem);
contextDest.SaveChanges();
dictSpecialSparepart.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table SpecialSparepart done, " + SpecialSparepartList.Count + " records imported");
//sparepart manual trans
Console.Write("\nImporting table SparepartManualTransaction");
foreach (var item in SparepartManualTransactionList)
{
int itemOldId = item.Id;
SparepartManualTransaction newItem = new SparepartManualTransaction();
int sparepart = dictSparepart[item.SparepartId];
int type = dictReference[item.UpdateTypeId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.SparepartId = sparepart;
newItem.UpdateTypeId = type;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Price = item.Price;
newItem.Qty = item.Qty;
newItem.Remark = item.Remark;
newItem.TransactionDate = item.TransactionDate;
newItem = contextDest.SparepartManualTransactions.Add(newItem);
contextDest.SaveChanges();
dictSpManualTrans.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table SparepartManualTransaction done, " + SparepartManualTransactionList.Count + " records imported");
//purchasing
Console.Write("\nImporting table Purchasing");
foreach (var item in PurchasingList)
{
int itemOldId = item.Id;
Purchasing newItem = new Purchasing();
int paymentMethod = dictReference[item.PaymentMethodId];
int supplier = dictSupplier[item.SupplierId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.PaymentMethodId = paymentMethod;
newItem.SupplierId = supplier;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.Code = item.Code;
newItem.CreateDate = item.CreateDate;
newItem.Date = item.Date;
newItem.ModifyDate = item.ModifyDate;
newItem.PaymentStatus = item.PaymentStatus;
newItem.Status = item.Status;
newItem.TotalHasPaid = item.TotalHasPaid;
newItem.TotalPrice = item.TotalPrice;
newItem = contextDest.Purchasings.Add(newItem);
contextDest.SaveChanges();
dictPurchasing.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table InvPurchasingoice done, " + PurchasingList.Count + " records imported");
//purchasing detail
Console.Write("\nImporting table PurchasingDetail");
foreach (var item in PurchasingDetailList)
{
int itemOldId = item.Id;
PurchasingDetail newItem = new PurchasingDetail();
int purchasing = dictPurchasing[item.PurchasingId];
int sparepart = dictSparepart[item.SparepartId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.PurchasingId = purchasing;
newItem.SparepartId = sparepart;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Price = item.Price;
newItem.Qty = item.Qty;
newItem.SerialNumber = item.SerialNumber;
newItem.Status = item.Status;
newItem = contextDest.PurchasingDetails.Add(newItem);
contextDest.SaveChanges();
dictPurchasingDetail.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table PurchasingDetail done, " + PurchasingDetailList.Count + " records imported");
//purchasing return
Console.Write("\nImporting table PurchaseReturn");
foreach (var item in PurchaseReturnList)
{
int itemOldId = item.Id;
PurchaseReturn newItem = new PurchaseReturn();
int purchasing = dictPurchasing[item.PurchasingId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.PurchasingId = purchasing;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.Code = item.Code;
newItem.CreateDate = item.CreateDate;
newItem.Date = item.Date;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.PurchaseReturns.Add(newItem);
contextDest.SaveChanges();
dictPurchaseReturn.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table PurchaseReturn done, " + PurchaseReturnList.Count + " records imported");
//purchasing return detail
Console.Write("\nImporting table PurchaseReturnDetail");
foreach (var item in PurchaseReturnDetailList)
{
int itemOldId = item.Id;
PurchaseReturnDetail newItem = new PurchaseReturnDetail();
int purchaseReturn = dictPurchaseReturn[item.PurchaseReturnId];
int pDetail = dictPurchasingDetail[item.PurchasingDetailId];
int spDetail = dictSparepartDetail[item.SparepartDetailId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.PurchaseReturnId = purchaseReturn;
newItem.PurchasingDetailId = pDetail;
newItem.SparepartDetailId = spDetail;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
contextDest.PurchaseReturnDetails.Add(newItem);
}
contextDest.SaveChanges();
Console.Write("\nImporting table PurchaseReturnDetail done, " + PurchaseReturnDetailList.Count + " records imported");
//sparepart detail
Console.Write("\nImporting table SparepartDetail");
foreach (var item in SparepartDetailList)
{
int itemOldId = item.Id;
SparepartDetail newItem = new SparepartDetail();
int sparepart = dictSparepart[item.SparepartId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.SparepartId = sparepart;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
if (item.PurchasingDetailId.HasValue && item.PurchasingDetailId != null && item.PurchasingDetailId > 0)
{
int pDetail = dictPurchasingDetail[item.PurchasingDetailId.Value];
newItem.PurchasingDetailId = pDetail;
}
if (item.SparepartManualTransactionId.HasValue && item.SparepartManualTransactionId != null && item.SparepartManualTransactionId > 0)
{
int spManualTrans = dictSpManualTrans[item.SparepartManualTransactionId.Value];
newItem.SparepartManualTransactionId = spManualTrans;
}
newItem.Code = item.Code;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.SparepartDetails.Add(newItem);
contextDest.SaveChanges();
dictSparepartDetail.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table SparepartDetail done, " + SparepartDetailList.Count + " records imported");
//special sparepart detail
Console.Write("\nImporting table SpecialSparepartDetail");
foreach (var item in SpecialSparepartDetailList)
{
int itemOldId = item.Id;
SpecialSparepartDetail newItem = new SpecialSparepartDetail();
int spDetail = dictSparepartDetail[item.SparepartDetailId];
int ssp = dictSpecialSparepart[item.SpecialSparepartId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.SparepartDetailId = spDetail;
newItem.SpecialSparepartId = ssp;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.CreateDate = item.CreateDate;
newItem.Kilometers = item.Kilometers;
newItem.ModifyDate = item.ModifyDate;
newItem.SerialNumber = item.SerialNumber;
newItem.Status = item.Status;
newItem = contextDest.WheelDetails.Add(newItem);
contextDest.SaveChanges();
dictSpecialSparepartDetail.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table SpecialSparepartDetail done, " + SpecialSparepartDetailList.Count + " records imported");
//vehicle wheel
Console.Write("\nImporting table VehicleWheel");
foreach (var item in VehicleWheelList)
{
VehicleWheel newItem = new VehicleWheel();
int vehicle = dictVehicle[item.VehicleId];
int sspDetail = dictSpecialSparepartDetail[item.WheelDetailId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.VehicleId = vehicle;
newItem.WheelDetailId = sspDetail;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Notes = item.Notes;
newItem.Status = item.Status;
contextDest.VehicleWheels.Add(newItem);
}
contextDest.SaveChanges();
Console.Write("\nImporting table VehicleWheel done, " + VehicleWheelList.Count + " records imported");
//used good
Console.Write("\nImporting table UsedGood");
foreach (var item in UsedGoodList)
{
int itemOldId = item.Id;
UsedGood newItem = new UsedGood();
int sparepart = dictSparepart[item.SparepartId];
newItem.Id = -1;
newItem.SparepartId = sparepart;
newItem.Stock = item.Stock;
newItem.Status = item.Status;
newItem = contextDest.UsedGoods.Add(newItem);
contextDest.SaveChanges();
dictUsedGood.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table UsedGood done, " + UsedGoodList.Count + " records imported");
//used good trans
Console.Write("\nImporting table UsedGoodTransaction");
foreach (var item in UsedGoodTransactionList)
{
UsedGoodTransaction newItem = new UsedGoodTransaction();
int type = dictReference[item.TypeReferenceId];
int usedGood = dictUsedGood[item.UsedGoodId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.TypeReferenceId = type;
newItem.UsedGoodId = usedGood;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.CreateDate = item.CreateDate;
newItem.ItemPrice = item.ItemPrice;
newItem.ModifyDate = item.ModifyDate;
newItem.Qty = item.Qty;
newItem.Remark = item.Remark;
newItem.TotalPrice = item.TotalPrice;
newItem.TransactionDate = item.TransactionDate;
contextDest.UsedGoodsTransactions.Add(newItem);
}
contextDest.SaveChanges();
Console.Write("\nImporting table UsedGoodTransaction done, " + UsedGoodTransactionList.Count + " records imported");
//guest book
Console.Write("\nImporting table GuestBook");
foreach (var item in GuestBookList)
{
GuestBook newItem = new GuestBook();
int vehicle = dictVehicle[item.VehicleId];
int userCreate = dictUser[item.CreateUserId];
int userModified = dictUser[item.ModifyUserId];
newItem.Id = -1;
newItem.VehicleId = vehicle;
newItem.CreateUserId = userCreate;
newItem.ModifyUserId = userModified;
newItem.CreateDate = item.CreateDate;
newItem.Description = item.Description;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
contextDest.GuestBooks.Add(newItem);
}
contextDest.SaveChanges();
Console.Write("\nImporting table GuestBook done, " + GuestBookList.Count + " records imported");
//SPK
Console.Write("\nImporting table SPK");
foreach (var item in SPKList)
{
int itemOldId = item.Id;
SPK newItem = new SPK();
newItem.Id = -1;
newItem.VehicleId = dictVehicle[item.VehicleId];
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.VehicleGroupId = dictVehicleGroup[item.VehicleGroupId];
newItem.CategoryReferenceId = dictReference[item.CategoryReferenceId];
if (item.SPKParentId > 0)
{
newItem.SPKParentId = dictSPK[item.SPKParentId.Value];
}
newItem.Description = item.Description;
newItem.Code = item.Code;
newItem.isContractWork = item.isContractWork;
newItem.Contractor = item.Contractor;
newItem.ContractWorkFee = item.ContractWorkFee;
newItem.DueDate = item.DueDate;
newItem.Kilometers = item.Kilometers;
newItem.StatusApprovalId = item.StatusApprovalId;
newItem.StatusCompletedId = item.StatusCompletedId;
newItem.StatusPrintId = item.StatusPrintId;
newItem.StatusOverLimit = item.StatusOverLimit;
newItem.Subtotal = item.Subtotal;
newItem.TotalMechanicFee = item.TotalMechanicFee;
newItem.TotalSparepartPrice = item.TotalSparepartPrice;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
SPK insertedSPK = contextDest.SPKs.Add(newItem);
contextDest.SaveChanges();
dictSPK.Add(itemOldId, insertedSPK.Id);
}
Console.Write("\nImporting table SPK done, " + SPKList.Count + " records imported");
//spk detail sparepart
Console.Write("\nImporting table SPKDetailSparepart");
foreach (var item in SPKDetailSparepartList)
{
int itemOldId = item.Id;
SPKDetailSparepart newItem = new SPKDetailSparepart();
newItem.Id = -1;
newItem.SparepartId = dictSparepart[item.SparepartId];
newItem.SPKId = dictSPK[item.SPKId];
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.TotalPrice = item.TotalPrice;
newItem.TotalQuantity = item.TotalQuantity;
newItem.TotalPriceAfterCommission = item.TotalPriceAfterCommission;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.SPKDetailSpareparts.Add(newItem);
contextDest.SaveChanges();
dictSPKDetailSparepart.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table SPKDetailSparepart done, " + SPKDetailSparepartList.Count + " records imported");
//spk detail sparepart detail
Console.Write("\nImporting table SPKDetailSparepartDetail");
foreach (var item in SPKDetailSparepartDetailList)
{
int itemOldId = item.Id;
SPKDetailSparepartDetail newItem = new SPKDetailSparepartDetail();
newItem.Id = -1;
newItem.SparepartDetailId = dictSparepartDetail[item.SparepartDetailId];
newItem.SPKDetailSparepartId = dictSPKDetailSparepart[item.SPKDetailSparepartId];
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.SPKDetailSparepartDetails.Add(newItem);
contextDest.SaveChanges();
dictSPKDetailSparepartDetail.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table SPKDetailSparepartDetail done, " + SPKDetailSparepartDetailList.Count + " records imported");
//spk schedule
Console.Write("\nImporting table SPKSchedule");
foreach (var item in SPKScheduleList)
{
int itemOldId = item.Id;
SPKSchedule newItem = new SPKSchedule();
newItem.Id = -1;
newItem.SPKId = dictSPK[item.SPKId];
newItem.MechanicId = dictSPKDetailSparepart[item.MechanicId];
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.Description = item.Description;
newItem.Date = item.Date;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.SPKSchedules.Add(newItem);
contextDest.SaveChanges();
}
Console.Write("\nImporting table SPKSchedule done, " + SPKScheduleList.Count + " records imported");
//wheel exchange history
Console.Write("\nImporting table WheelExchangeHistory");
foreach (var item in WheelExchangeHistoryList)
{
int itemOldId = item.Id;
WheelExchangeHistory newItem = new WheelExchangeHistory();
newItem.Id = -1;
newItem.SPKId = dictSPK[item.SPKId];
newItem.OriginalWheelId = dictSpecialSparepartDetail[item.OriginalWheelId];
newItem.ReplaceWheelId = dictSpecialSparepartDetail[item.ReplaceWheelId];
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.WheelExchangeHistories.Add(newItem);
contextDest.SaveChanges();
}
Console.Write("\nImporting table WheelExchangeHistory done, " + WheelExchangeHistoryList.Count + " records imported");
//invoice
Console.Write("\nImporting table Invoice");
foreach (var item in InvoiceList)
{
int itemOldId = item.Id;
Invoice newItem = new Invoice();
newItem.Id = -1;
newItem.SPKId = dictSPK[item.SPKId];
newItem.PaymentMethodId = dictReference[item.PaymentMethodId];
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.Code = item.Code;
newItem.TotalPrice = item.TotalPrice;
newItem.TotalHasPaid = item.TotalHasPaid;
newItem.TotalService = item.TotalService;
newItem.TotalFeeService = item.TotalFeeService;
newItem.TotalServicePlusFee = item.TotalServicePlusFee;
newItem.TotalSparepart = item.TotalSparepart;
newItem.TotalFeeSparepart = item.TotalFeeSparepart;
newItem.TotalSparepartPlusFee = item.TotalSparepartPlusFee;
newItem.TotalValueAdded = item.TotalValueAdded;
newItem.TotalSparepartAndService = item.TotalSparepartAndService;
newItem.PaymentStatus = item.PaymentStatus;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
Invoice insertedInvoice = contextDest.Invoices.Add(newItem);
contextDest.SaveChanges();
dictInvoice.Add(itemOldId, insertedInvoice.Id);
}
Console.Write("\nImporting table Invoice done, " + InvoiceList.Count + " records imported");
//invoice detail
Console.Write("\nImporting table InvoiceDetail");
foreach (var item in InvoiceDetailList)
{
int itemOldId = item.Id;
InvoiceDetail newItem = new InvoiceDetail();
newItem.Id = -1;
newItem.InvoiceId = dictInvoice[item.InvoiceId];
newItem.SPKDetailSparepartDetailId = dictReference[item.SPKDetailSparepartDetailId];
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.FeePctg = item.FeePctg;
newItem.SubTotalPrice = item.SubTotalPrice;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.InvoiceDetails.Add(newItem);
contextDest.SaveChanges();
dictInvoiceDetail.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table InvoiceDetail done, " + InvoiceDetailList.Count + " records imported");
//sales return
Console.Write("\nImporting table SalesReturn");
foreach (var item in SalesReturnList)
{
int itemOldId = item.Id;
SalesReturn newItem = new SalesReturn();
newItem.Id = -1;
newItem.InvoiceId = dictInvoice[item.InvoiceId];
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.Code = item.Code;
newItem.Date = item.Date;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.SalesReturns.Add(newItem);
contextDest.SaveChanges();
dictSalesReturn.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table SalesReturn done, " + SalesReturnList.Count + " records imported");
//sales return detail
Console.Write("\nImporting table SalesReturnDetail");
foreach (var item in SalesReturnDetailList)
{
int itemOldId = item.Id;
SalesReturnDetail newItem = new SalesReturnDetail();
newItem.Id = -1;
newItem.SalesReturnId = dictSalesReturn[item.SalesReturnId];
newItem.InvoiceDetailId = dictInvoiceDetail[item.InvoiceDetailId];
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.SalesReturnDetails.Add(newItem);
contextDest.SaveChanges();
}
Console.Write("\nImporting table SalesReturnDetail done, " + SalesReturnDetailList.Count + " records imported");
//transaction
Console.Write("\nImporting table Transaction");
foreach (var item in TransactionList)
{
int itemOldId = item.Id;
Transaction newItem = new Transaction();
newItem.Id = -1;
newItem.ReferenceTableId = dictReference[item.ReferenceTableId];
newItem.PaymentMethodId = dictReference[item.PaymentMethodId.Value];
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.PrimaryKeyValue = item.PrimaryKeyValue;
newItem.TotalTransaction = item.TotalTransaction;
newItem.TotalPayment = item.TotalPayment;
newItem.Description = item.Description;
newItem.IsReconciliation = item.IsReconciliation;
newItem.TransactionDate = item.TransactionDate;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.Transactions.Add(newItem);
contextDest.SaveChanges();
dictTransaction.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table Transaction done, " + TransactionList.Count + " records imported");
//transaction detail
Console.Write("\nImporting table TransactionDetail");
foreach (var item in TransactionDetailList)
{
int itemOldId = item.Id;
TransactionDetail newItem = new TransactionDetail();
newItem.Id = -1;
newItem.JournalId = dictJournalMaster[item.JournalId];
newItem.ParentId = dictTransaction[item.ParentId];
//newItem.CreateUserId = dictUser[item.CreateUserId];
//newItem.ModifyUserId = dictUser[item.ModifyUserId];
//newItem.CreateDate = item.CreateDate;
//newItem.ModifyDate = item.ModifyDate;
//newItem.Status = item.Status;
newItem = contextDest.TransactionDetails.Add(newItem);
contextDest.SaveChanges();
}
Console.Write("\nImporting table TransactionDetail done, " + TransactionDetailList.Count + " records imported");
//balance journal
Console.Write("\nImporting table BalanceJournal");
foreach (var item in BalanceJournalList)
{
int itemOldId = item.Id;
BalanceJournal newItem = new BalanceJournal();
newItem.Id = -1;
newItem.CreateUserId = dictUser[item.CreateUserId];
newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.Month = item.Month;
newItem.Year = item.Year;
newItem.IsFirst = item.IsFirst;
newItem.CreateDate = item.CreateDate;
newItem.ModifyDate = item.ModifyDate;
newItem.Status = item.Status;
newItem = contextDest.BalanceJournals.Add(newItem);
contextDest.SaveChanges();
dictBalanceJournal.Add(itemOldId, newItem.Id);
}
Console.Write("\nImporting table BalanceJournal done, " + BalanceJournalList.Count + " records imported");
//balance journal detail
Console.Write("\nImporting table BalanceJournalDetail");
foreach (var item in BalanceJournalDetailList)
{
int itemOldId = item.Id;
BalanceJournalDetail newItem = new BalanceJournalDetail();
newItem.Id = -1;
newItem.JournalId = dictJournalMaster[item.JournalId];
newItem.ParentId = dictBalanceJournal[item.ParentId];
//newItem.CreateUserId = dictUser[item.CreateUserId];
//newItem.ModifyUserId = dictUser[item.ModifyUserId];
newItem.FirstDebit = item.FirstDebit;
newItem.FirstCredit = item.FirstCredit;
newItem.MutationDebit = item.MutationDebit;
newItem.MutationCredit = item.MutationCredit;
newItem.BalanceAfterMutationDebit = item.BalanceAfterMutationDebit;
newItem.BalanceAfterMutationCredit = item.BalanceAfterMutationCredit;
newItem.ReconciliationDebit = item.ReconciliationDebit;
newItem.ReconciliationCredit = item.ReconciliationCredit;
newItem.BalanceAfterReconciliationDebit = item.BalanceAfterReconciliationDebit;
newItem.BalanceAfterReconciliationCredit = item.BalanceAfterReconciliationCredit;
newItem.ProfitLossDebit = item.ProfitLossDebit;
newItem.ProfitLossCredit = item.ProfitLossCredit;
newItem.LastDebit = item.LastDebit;
newItem.LastCredit = item.LastCredit;
//newItem.CreateDate = item.CreateDate;
//newItem.ModifyDate = item.ModifyDate;
//newItem.Status = item.Status;
newItem = contextDest.BalanceJournalDetails.Add(newItem);
contextDest.SaveChanges();
}
Console.Write("\nImporting table BalanceJournalDetail done, " + BalanceJournalDetailList.Count + " records imported");
Console.Write("MOTHA F****N DONE!");
Console.Read();
}
public void UpdateInvoice(InvoiceViewModel invoice, List<InvoiceDetailViewModel> invoiceDetails, int userId)
{
using(var trans = _unitOfWork.BeginTransaction())
{
try
{
DateTime serverTime = DateTime.Now;
Invoice entity = _invoiceRepository.GetById<int>(invoice.Id);
entity.PaymentMethodId = invoice.PaymentMethodId;
entity.TotalHasPaid = invoice.TotalHasPaid;
entity.TotalPrice = invoice.TotalPrice;
entity.TotalService = invoice.TotalService;
entity.TotalFeeService = invoice.TotalFeeService;
entity.TotalServicePlusFee = invoice.TotalServicePlusFee;
entity.TotalSparepart = invoice.TotalSparepart;
entity.TotalFeeSparepart = invoice.TotalFeeSparepart;
entity.TotalSparepartPlusFee = invoice.TotalSparepartPlusFee;
entity.TotalSparepartAndService = invoice.TotalSparepartAndService;
entity.TotalValueAdded = invoice.TotalValueAdded;
//Map(invoice, entity);
entity.ModifyDate = serverTime;
entity.ModifyUserId = userId;
entity.Status = (int)DbConstant.InvoiceStatus.NotPrinted;
if (entity.TotalHasPaid == entity.TotalPrice)
{
entity.PaymentStatus = (int)DbConstant.PaymentStatus.Settled;
}
else
{
entity.PaymentStatus = (int)DbConstant.PaymentStatus.NotSettled;
}
_invoiceRepository.AttachNavigation(entity.CreateUser); // yang inherit ke base modifier harus ada ini, klo gak user e dobel2
_invoiceRepository.AttachNavigation(entity.ModifyUser); // yang inherit ke base modifier harus ada ini, klo gak user e dobel2
_invoiceRepository.AttachNavigation(entity.SPK);
_invoiceRepository.AttachNavigation(entity.PaymentMethod);
_invoiceRepository.Update(entity);
_unitOfWork.SaveChanges();
foreach (var invoiceDetail in invoiceDetails)
{
InvoiceDetail entityDetail = _invoiceDetailRepository.GetById<int>(invoiceDetail.Id);
entityDetail.FeePctg = invoiceDetail.FeePctg;
entityDetail.SubTotalPrice = invoiceDetail.SubTotalPrice;
//Map(invoiceDetail, entityDetail);
entityDetail.ModifyDate = serverTime;
entityDetail.ModifyUserId = userId;
_invoiceDetailRepository.AttachNavigation(entityDetail.CreateUser);
_invoiceDetailRepository.AttachNavigation(entityDetail.ModifyUser);
_invoiceDetailRepository.AttachNavigation(entityDetail.Invoice);
_invoiceDetailRepository.AttachNavigation(entityDetail.SPKDetailSparepartDetail);
_invoiceDetailRepository.Update(entityDetail);
}
_unitOfWork.SaveChanges();
Reference transactionReferenceTable = _referenceRepository.GetMany(c => c.Code == DbConstant.REF_TRANSTBL_INVOICE).FirstOrDefault();
Transaction transaction = _transactionRepository.GetMany(x =>x.ReferenceTableId == transactionReferenceTable.Id &&
x.PrimaryKeyValue == invoice.Id).OrderBy(x => x.CreateDate).FirstOrDefault();
Reference paymentMethod = _referenceRepository.GetById(invoice.PaymentMethodId);
if (transaction != null)
{
transaction.ModifyDate = serverTime;
transaction.ModifyUserId = userId;
transaction.TotalTransaction = invoice.TotalPrice.AsDouble();
transaction.TotalPayment = invoice.TotalHasPaid.AsDouble();
transaction.PaymentMethodId = invoice.PaymentMethodId;
_transactionRepository.AttachNavigation(transaction.CreateUser);
_transactionRepository.AttachNavigation(transaction.ModifyUser);
_transactionRepository.AttachNavigation(transaction.ReferenceTable);
_transactionRepository.AttachNavigation(transaction.PaymentMethod);
_transactionRepository.Update(transaction);
_unitOfWork.SaveChanges();
List<TransactionDetail> transactionDetails = _transactionDetailRepository.GetMany(x => x.ParentId == transaction.Id).ToList();
foreach (TransactionDetail transactionDetail in transactionDetails)
{
_transactionDetailRepository.Delete(transactionDetail);
}
_unitOfWork.SaveChanges();
}
else
{
transaction = new Transaction();
transaction.CreateDate = serverTime;
transaction.CreateUserId = userId;
transaction.ModifyDate = serverTime;
transaction.ModifyUserId = userId;
transaction.Description = "pembayaran invoice";
transaction.TotalTransaction = invoice.TotalPrice.AsDouble();
transaction.TotalPayment = invoice.TotalHasPaid.AsDouble();
transaction.ReferenceTableId = transactionReferenceTable.Id;
transaction.PrimaryKeyValue = invoice.Id;
transaction.TransactionDate = serverTime;
transaction.PaymentMethodId = invoice.PaymentMethodId;
transaction.Status = (int)DbConstant.DefaultDataStatus.Active;
_transactionRepository.AttachNavigation(transaction.CreateUser);
_transactionRepository.AttachNavigation(transaction.ModifyUser);
_transactionRepository.AttachNavigation(transaction.ReferenceTable);
_transactionRepository.AttachNavigation(transaction.PaymentMethod);
transaction = _transactionRepository.Add(transaction);
_unitOfWork.SaveChanges();
}
switch (paymentMethod.Code)
{
case DbConstant.REF_INVOICE_PAYMENTMETHOD_BANK_EKONOMI:
case DbConstant.REF_INVOICE_PAYMENTMETHOD_BANK_BCA1:
case DbConstant.REF_INVOICE_PAYMENTMETHOD_BANK_BCA2:
{
// Bank Debet --> Karena bertmbah
TransactionDetail detailBank = new TransactionDetail();
detailBank.Debit = invoice.TotalHasPaid;
if (paymentMethod.Code == DbConstant.REF_INVOICE_PAYMENTMETHOD_BANK_EKONOMI)
{
detailBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.01").FirstOrDefault().Id;
}
else if (paymentMethod.Code == DbConstant.REF_INVOICE_PAYMENTMETHOD_BANK_BCA1)
{
detailBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.02").FirstOrDefault().Id;
}
else if (paymentMethod.Code == DbConstant.REF_INVOICE_PAYMENTMETHOD_BANK_BCA2)
{
detailBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.03").FirstOrDefault().Id;
}
detailBank.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(detailBank.Journal);
_transactionDetailRepository.AttachNavigation(detailBank.Parent);
_transactionDetailRepository.Add(detailBank);
break;
}
case DbConstant.REF_INVOICE_PAYMENTMETHOD_KAS:
// Kas Debit --> Karena bertambah
TransactionDetail detailKas = new TransactionDetail();
detailKas.Debit = invoice.TotalHasPaid;
detailKas.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.01.01").FirstOrDefault().Id;
detailKas.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(detailKas.Journal);
_transactionDetailRepository.AttachNavigation(detailKas.Parent);
_transactionDetailRepository.Add(detailKas);
break;
case DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_KAS:
// Kas Debit --> Karena bertambah
TransactionDetail detailKasKarenaUangMuka = new TransactionDetail();
detailKasKarenaUangMuka.Debit = invoice.TotalHasPaid;
detailKasKarenaUangMuka.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.01.01").FirstOrDefault().Id;
detailKasKarenaUangMuka.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(detailKasKarenaUangMuka.Journal);
_transactionDetailRepository.AttachNavigation(detailKasKarenaUangMuka.Parent);
_transactionDetailRepository.Add(detailKasKarenaUangMuka);
// Uang Muka Debit --> Karena bertambah
TransactionDetail detailUangMukaBertambahKarenaKas = new TransactionDetail();
detailUangMukaBertambahKarenaKas.Debit = invoice.TotalHasPaid;
detailUangMukaBertambahKarenaKas.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.05.01.01").FirstOrDefault().Id;
detailUangMukaBertambahKarenaKas.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(detailUangMukaBertambahKarenaKas.Journal);
_transactionDetailRepository.AttachNavigation(detailUangMukaBertambahKarenaKas.Parent);
_transactionDetailRepository.Add(detailUangMukaBertambahKarenaKas);
// Uang Muka Kredit --> Karena berkurang
TransactionDetail detailUangMukaBerkurangKarenaKas = new TransactionDetail();
detailUangMukaBerkurangKarenaKas.Credit = invoice.TotalHasPaid;
detailUangMukaBerkurangKarenaKas.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.05.01.01").FirstOrDefault().Id;
detailUangMukaBerkurangKarenaKas.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(detailUangMukaBerkurangKarenaKas.Journal);
_transactionDetailRepository.AttachNavigation(detailUangMukaBerkurangKarenaKas.Parent);
_transactionDetailRepository.Add(detailUangMukaBerkurangKarenaKas);
break;
case DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_BANK_EKONOMI:
case DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_BANK_BCA1:
case DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_BANK_BCA2:
{
// Bank Debit --> Karena bertambah
TransactionDetail detailBankKarenaUangMuka = new TransactionDetail();
detailBankKarenaUangMuka.Debit = invoice.TotalHasPaid;
if (paymentMethod.Code == DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_BANK_EKONOMI)
{
detailBankKarenaUangMuka.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.01").FirstOrDefault().Id;
}
else if (paymentMethod.Code == DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_BANK_BCA1)
{
detailBankKarenaUangMuka.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.02").FirstOrDefault().Id;
}
else if (paymentMethod.Code == DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_BANK_BCA2)
{
detailBankKarenaUangMuka.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.02.03").FirstOrDefault().Id;
}
detailBankKarenaUangMuka.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(detailBankKarenaUangMuka.Journal);
_transactionDetailRepository.AttachNavigation(detailBankKarenaUangMuka.Parent);
_transactionDetailRepository.Add(detailBankKarenaUangMuka);
// Uang Muka Debit --> Karena bertambah
TransactionDetail detailUangMukaBertambahKarenaBank = new TransactionDetail();
detailUangMukaBertambahKarenaBank.Debit = invoice.TotalHasPaid;
detailUangMukaBertambahKarenaBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.05.01.01").FirstOrDefault().Id;
detailUangMukaBertambahKarenaBank.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(detailUangMukaBertambahKarenaBank.Journal);
_transactionDetailRepository.AttachNavigation(detailUangMukaBertambahKarenaBank.Parent);
_transactionDetailRepository.Add(detailUangMukaBertambahKarenaBank);
// Uang Muka Kredit --> Karena berkurang
TransactionDetail detailUangMukaBerkurangKarenaBank = new TransactionDetail();
detailUangMukaBerkurangKarenaBank.Credit = invoice.TotalHasPaid;
detailUangMukaBerkurangKarenaBank.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.05.01.01").FirstOrDefault().Id;
detailUangMukaBerkurangKarenaBank.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(detailUangMukaBerkurangKarenaBank.Journal);
_transactionDetailRepository.AttachNavigation(detailUangMukaBerkurangKarenaBank.Parent);
_transactionDetailRepository.Add(detailUangMukaBerkurangKarenaBank);
break;
}
case DbConstant.REF_INVOICE_PAYMENTMETHOD_PIUTANG:
TransactionDetail piutang = new TransactionDetail();
piutang.Debit = invoice.TotalPrice - invoice.TotalHasPaid;
piutang.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.03.01.01").FirstOrDefault().Id;
piutang.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(piutang.Journal);
_transactionDetailRepository.AttachNavigation(piutang.Parent);
_transactionDetailRepository.Add(piutang);
break;
}
if (paymentMethod.Code == DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_BANK_EKONOMI ||
paymentMethod.Code == DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_BANK_BCA1 ||
paymentMethod.Code == DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_BANK_BCA2 ||
paymentMethod.Code == DbConstant.REF_INVOICE_PAYMENTMETHOD_UANGMUKA_KAS)
{
if (invoice.TotalPrice > invoice.TotalHasPaid)
{
// Piutang Debit --> Karena bertambah
TransactionDetail piutang = new TransactionDetail();
piutang.Debit = invoice.TotalPrice - invoice.TotalHasPaid;
piutang.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.03.01.01").FirstOrDefault().Id;
piutang.Parent = transaction;
_transactionDetailRepository.AttachNavigation(piutang.Journal);
_transactionDetailRepository.AttachNavigation(piutang.Parent);
_transactionDetailRepository.Add(piutang);
}
}
// Sales Kredit --> Karena berkurang
TransactionDetail sales = new TransactionDetail();
sales.Credit = invoice.TotalSparepartAndService;
sales.JournalId = _journalMasterRepository.GetMany(j => j.Code == "3.01.01").FirstOrDefault().Id;
sales.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(sales.Journal);
_transactionDetailRepository.AttachNavigation(sales.Parent);
_transactionDetailRepository.Add(sales);
// Service Income Kredit --> Karena berkurang
TransactionDetail serviceIncome = new TransactionDetail();
serviceIncome.Credit = invoice.TotalValueAdded + invoice.TotalFeeSparepart;
serviceIncome.JournalId = _journalMasterRepository.GetMany(j => j.Code == "3.01.04").FirstOrDefault().Id;
serviceIncome.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(serviceIncome.Journal);
_transactionDetailRepository.AttachNavigation(serviceIncome.Parent);
_transactionDetailRepository.Add(serviceIncome);
// HPP Sparepart Debit --> Karena bertambah
TransactionDetail hppSparepart = new TransactionDetail();
hppSparepart.Debit = invoice.TotalSparepartPlusFee;
hppSparepart.JournalId = _journalMasterRepository.GetMany(j => j.Code == "3.04.01").FirstOrDefault().Id;
hppSparepart.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(hppSparepart.Journal);
_transactionDetailRepository.AttachNavigation(hppSparepart.Parent);
_transactionDetailRepository.Add(hppSparepart);
if(invoice.TotalServicePlusFee > 0)
{
if (entity.SPK.isContractWork)
{
// HPP Tukang Harian Debit --> Karena bertambah
TransactionDetail hppTukang = new TransactionDetail();
hppTukang.Debit = invoice.TotalServicePlusFee;
hppTukang.JournalId = _journalMasterRepository.GetMany(j => j.Code == "3.04.05").FirstOrDefault().Id;
hppTukang.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(hppTukang.Journal);
_transactionDetailRepository.AttachNavigation(hppTukang.Parent);
_transactionDetailRepository.Add(hppTukang);
}
else
{
// HPP Tukang Borongan Debit --> Karena bertambah
TransactionDetail hppTukang = new TransactionDetail();
hppTukang.Debit = invoice.TotalServicePlusFee;
hppTukang.JournalId = _journalMasterRepository.GetMany(j => j.Code == "3.04.04").FirstOrDefault().Id;
hppTukang.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(hppTukang.Journal);
_transactionDetailRepository.AttachNavigation(hppTukang.Parent);
_transactionDetailRepository.Add(hppTukang);
}
}
// Sparepart Kredit --> Karena berkurang
TransactionDetail detailSparepart = new TransactionDetail();
detailSparepart.Credit = invoice.TotalSparepart;
detailSparepart.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.04.01").FirstOrDefault().Id;
detailSparepart.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(detailSparepart.Journal);
_transactionDetailRepository.AttachNavigation(detailSparepart.Parent);
_transactionDetailRepository.Add(detailSparepart);
if (invoice.TotalServicePlusFee > 0)
{
// SDM Kredit --> Karena berkurang
TransactionDetail detailSDM = new TransactionDetail();
detailSDM.Credit = invoice.TotalServicePlusFee;
detailSDM.JournalId = _journalMasterRepository.GetMany(j => j.Code == "1.01.04.04").FirstOrDefault().Id;
detailSDM.ParentId = transaction.Id;
_transactionDetailRepository.AttachNavigation(detailSDM.Journal);
_transactionDetailRepository.AttachNavigation(detailSDM.Parent);
_transactionDetailRepository.Add(detailSDM);
}
_unitOfWork.SaveChanges();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
}
