public ActionResult AddAPInvoiceItem(string documentNo, Int16 itemNo)
{
APInvoiceDetail apInvoicedetail = null;
if (documentNo == string.Empty || documentNo == null)
{
apInvoicedetail = new APInvoiceDetail();
}
else
{
apInvoicedetail = new NetStock.BusinessFactory.APInvoiceBO().GetAPInvoice(new Contract.APInvoice {
DocumentNo = documentNo
})
.APInvoiceDetails.Where(dt => dt.ItemNo == itemNo).FirstOrDefault();
if (apInvoicedetail == null)
{
apInvoicedetail = new APInvoiceDetail();
}
}
apInvoicedetail.CurrencyCodeList = Utility.GetCurrencyItemList();
apInvoicedetail.AccountCodeList = Utility.GetAccountCodeItemList();
//arInvoicedetailsItem.ServiceTypeList = Utility.GetLookupItemList("ServiceType");
return(View("AddAPInvoiceItem", apInvoicedetail));
//return PartialView("AddQuotationItem");
}
public bool Delete(string documentNo, DbTransaction parentTransaction)
{
var apInvoicedetailItem = new APInvoiceDetail {
DocumentNo = documentNo
};
return(Delete(apInvoicedetailItem, parentTransaction));
}
public APInvoiceDetail GetAPInvoiceDetail(APInvoiceDetail item)
{
return((APInvoiceDetail)apinvoicedetailDAL.GetItem <APInvoiceDetail>(item));
}
public bool DeleteAPInvoiceDetail(APInvoiceDetail item)
{
return(apinvoicedetailDAL.Delete(item));
}
public bool SaveAPInvoiceDetail(APInvoiceDetail newItem)
{
return(apinvoicedetailDAL.Save(newItem));
}
public ActionResult AddDAPInvoiceItem(string customerCode, string accountCode, decimal amount, string bankCode = "")
{
APInvoiceDetail item = new APInvoiceDetail();
item.AccountCode = accountCode;
item.AccountCodeDescription = new NetStock.BusinessFactory.ChartOfAccountBO().GetChartOfAccount(new ChartOfAccount {
AccountCode = accountCode, BranchID = Utility.SsnBranch
}).Description;
item.BaseAmount = amount;
item.LocalAmount = amount;
item.CurrencyCode = "THB";
item.TotalAmount = amount;
item.Discount = 0;
item.DiscountType = "NONE";
var debtorAccount = new NetStock.BusinessFactory.DebtorBO().GetDebtor(new Debtor {
DebtorCode = customerCode
}).DebtorAccount;
string bankAccount = "";
if (!string.IsNullOrWhiteSpace(bankCode))
{
bankAccount = new NetStock.BusinessFactory.BankBO().GetBank(new Bank {
BankCode = bankCode
}).BankAccount;
}
var whAccount = Utility.GetDefaultAccountCodes(DefaultAccountCodes.ARWHACCOUNTCODE);
var vatAccount = Utility.GetDefaultAccountCodes(DefaultAccountCodes.ARVATACCOUNTCODE);
//arInvoicedetail.CurrencyCodeList = Utility.GetCurrencyItemList();
//arInvoicedetail.AccountCodeList = Utility.GetAccountCodeItemList();
/* Debit Credit Account start */
var debitCreditObj = Utility.GetAccountType(debtorAccount);
var customerDC = debitCreditObj != null ? (!string.IsNullOrWhiteSpace(debitCreditObj.DebitCredit) ? debitCreditObj.DebitCredit : "DEBIT") : "DEBIT";
string bankDC = "";
if (!string.IsNullOrWhiteSpace(bankCode))
{
debitCreditObj = Utility.GetAccountType(bankAccount);
bankDC = debitCreditObj != null ? (!string.IsNullOrWhiteSpace(debitCreditObj.DebitCredit) ? debitCreditObj.DebitCredit : "DEBIT") : "DEBIT";
}
debitCreditObj = Utility.GetAccountType(whAccount);
string whDC = debitCreditObj != null ? (!string.IsNullOrWhiteSpace(debitCreditObj.DebitCredit) ? debitCreditObj.DebitCredit : "DEBIT") : "DEBIT";
debitCreditObj = Utility.GetAccountType(vatAccount);
string vatDC = debitCreditObj != null ? (!string.IsNullOrWhiteSpace(debitCreditObj.DebitCredit) ? debitCreditObj.DebitCredit : "DEBIT") : "DEBIT";
debitCreditObj = Utility.GetAccountType(accountCode);
string accountDC = debitCreditObj != null ? (!string.IsNullOrWhiteSpace(debitCreditObj.DebitCredit) ? debitCreditObj.DebitCredit : "DEBIT") : "DEBIT";
/* Debit Credit Account end */
return(Json(new
{
Message = "Success",
APInvoiceDetail = item,
debtorAccount = debtorAccount,
bankAccount = bankAccount,
whAccount = whAccount,
vatAccount = vatAccount,
customerDebitCredit = customerDC,
bankDebitCredit = bankDC,
whDebitCredit = whDC,
vatDebitCredit = vatDC,
accountDebitCredit = accountDC
}, JsonRequestBehavior.AllowGet));
//var creditorAccount = new NetStock.BusinessFactory.DebtorBO().GetDebtor(new Debtor { DebtorCode = customerCode }).DebtorAccount;
//var bankAccount = new NetStock.BusinessFactory.BankBO().GetBank(new Bank { BankCode = bankCode }).BankAccount;
//var whAccount = Utility.GetDefaultAccountCodes(DefaultAccountCodes.ARWHACCOUNTCODE);
//var vatAccount = Utility.GetDefaultAccountCodes(DefaultAccountCodes.ARVATACCOUNTCODE);
//arInvoicedetail.CurrencyCodeList = Utility.GetCurrencyItemList();
//arInvoicedetail.AccountCodeList = Utility.GetAccountCodeItemList();
//return Json(new { Message = "Success", APInvoiceDetail = item, CreditorAccount = creditorAccount, bankAccount = bankAccount, whAccount = whAccount, vatAccount = vatAccount }, JsonRequestBehavior.AllowGet);
}
