public JsonResult AddARDebitNote(string accountcode, string amount, string customerCode)
{
ARDebitNoteDetail item = new ARDebitNoteDetail();
item.AccountCodeDescription = new NetStock.BusinessFactory.ChartOfAccountBO().GetChartOfAccount(new ChartOfAccount {
AccountCode = accountcode, BranchID = Utility.SsnBranch
}).Description;
item.AccountCode = accountcode;
item.BaseAmount = Convert.ToDecimal(amount);
item.LocalAmount = Convert.ToDecimal(amount);
item.CurrencyCode = "THB";
item.TaxAmount = 0;
var debtorAccount = new NetStock.BusinessFactory.DebtorBO().GetDebtor(new Debtor {
DebtorCode = customerCode
}).DebtorAccount;
/* Debit Credit Account start */
var debitCreditObj = Utility.GetAccountType(debtorAccount);
var customerDC = 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",
ARDebitNoteDetail = item,
DebtorAccount = debtorAccount,
CustomerDebitCredit = customerDC,
AccountDebitCredit = accountDC
}, JsonRequestBehavior.AllowGet));
//return Json(new { Message = "Success", ARDebitNoteDetail = item, DebtorAccount = debtorAccount }, JsonRequestBehavior.AllowGet);
}
public ActionResult CustomerList()
{
var lstCustomer = new NetStock.BusinessFactory.DebtorBO().GetList()
.Where(x => x.Status == true).ToList();
return(View("Customers", lstCustomer));
}
public JsonResult SaveDebtor(NetStock.Contract.Debtor debtor)
{
try
{
debtor.CreatedBy = Utility.DEFAULTUSER;
debtor.ModifiedBy = Utility.DEFAULTUSER;
debtor.Status = Utility.DEFAULTSTATUS;
if (debtor.DebtorAddress.AddressId == 0 || debtor.DebtorAddress.AddressId == null)
{
debtor.DebtorAddress.AddressType = "Debtor";
debtor.DebtorAddress.SeqNo = 1;
debtor.DebtorAddress.AddressLinkID = debtor.DebtorCode;
}
var result = new NetStock.BusinessFactory.DebtorBO().SaveDebtor(debtor);
}
catch (Exception ex)
{
ModelState.AddModelError("Error", ex.Message);
}
//return RedirectToAction("DebtorProfile");
return(Json(new { success = true, Message = "Customer saved successfully.", Debtor = debtor }));
}
public ActionResult SearchDebtor(string debtorCode)
{
if (debtorCode != "")
{
Debtor debtor = null;
debtor = new NetStock.BusinessFactory.DebtorBO().GetDebtor(new Debtor {
DebtorCode = debtorCode
});
if (debtor == null)
{
debtor = new Debtor();
}
//}
debtor.CountryList = Utility.GetCountryList();
debtor.DebtorAccountList = Utility.GetDebtorAccountList();
return(RedirectToAction("DebtorProfile", new { debtorCode = debtorCode }));
//return View("CBReceipt", cbReceipt);
}
else
{
return(RedirectToAction("DebtorProfile"));
}
}
public JsonResult SearchDebtorList(string searchText, int limitRecords, string source = null)
{
try
{
var result = new NetStock.BusinessFactory.DebtorBO().GetListAutoSearch(searchText);
return(Json(result));
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public static IEnumerable <SelectListItem> GetDebtorList()
{
var countryList = new NetStock.BusinessFactory.DebtorBO().GetList();
var selectList = countryList.Select(c =>
new SelectListItem
{
Value = c.DebtorCode,
Text = string.Format("{0} ({1})", c.DebtorName, c.DebtorCode)
});
return(new SelectList(selectList, "Value", "Text"));
}
public JsonResult DeleteDebtor(string debtorCode)
{
var result = false;
string message = string.Empty;
try
{
result = new NetStock.BusinessFactory.DebtorBO().DeleteDebtor(new Debtor {
DebtorCode = debtorCode
});
}
catch (Exception ex)
{
ModelState.AddModelError("Error", ex.Message);
}
return(Json(new { result = result, Message = "Debtor deleted successfully.", debtorCode = debtorCode }));
}
public ActionResult DebtorProfile(string debtorCode)
{
var debtorBO = new NetStock.BusinessFactory.DebtorBO();
var debtor = new NetStock.BusinessFactory.DebtorBO().GetDebtor(new Debtor {
DebtorCode = debtorCode
});
if (debtor != null)
{
debtor.DebtorAddress = debtorBO.GetDebtorAddress(debtor);
}
else
{
debtor = new Contract.Debtor();
debtor.Status = true;
debtor.DebtorCode = "";
}
debtor.CountryList = Utility.GetCountryList();
debtor.DebtorAccountList = Utility.GetAccountCodeItemList();
debtor.PaymentTypeList = Utility.GetLookupItemList("PaymentTerm");
//return View("CompanyProfile");
return(View(debtor));
}
public ActionResult AddARInvoiceItem(string debtorCode, string accountCode, decimal amount, string bankCode = "")
{
ARInvoiceDetail item = new ARInvoiceDetail();
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 = debtorCode
}).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(bankDC))
{
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",
ARInvoiceDetail = item,
DebtorAccount = debtorAccount,
bankAccount = bankAccount,
whAccount = whAccount,
vatAccount = vatAccount,
customerDebitCredit = customerDC,
bankDebitCredit = bankDC,
whDebitCredit = whDC,
vatDebitCredit = vatDC,
accountDebitCredit = accountDC
}, JsonRequestBehavior.AllowGet));
//arInvoicedetail.CurrencyCodeList = Utility.GetCurrencyItemList();
//arInvoicedetail.AccountCodeList = Utility.GetAccountCodeItemList();
//return Json(new { Message = "Success", ARInvoiceDetail = item,DebtorAccount = debtorAccount }, JsonRequestBehavior.AllowGet);
}
