public async Task <IActionResult> ExportAdvancePaymentShipment(AdvancePaymentCriteria advancePaymentCriteria)
{
var accessToken = Request.Headers["Authorization"].ToString();
var advancePaymentsAPI = await HttpServiceExtension.PostAPI(advancePaymentCriteria, aPis.AccountingAPI + Urls.Accounting.AdvancePaymentUrl, accessToken);
var advancePayments = advancePaymentsAPI.Content.ReadAsAsync <List <AdvancePaymentModel> >();
List <string> codes = new List <string>();
foreach (var item in advancePayments.Result)
{
codes.Add(item.AdvanceNo);
}
var responseFromApi = await HttpServiceExtension.PostAPI(codes, aPis.AccountingAPI + Urls.Accounting.GetGroupRequestsByAdvanceNoList, accessToken);
var dataObjects = responseFromApi.Content.ReadAsAsync <List <AdvancePaymentRequestModel> >();
var stream = new AccountingHelper().GenerateAdvancePaymentShipmentExcel(dataObjects.Result);
if (stream == null)
{
return(null);
}
FileContentResult fileContent = new FileHelper().ExportExcel(stream, "Advance Payment List Shipment.xlsx");
return(fileContent);
}
public ActionResult AddEditBalance(OpenBalanceVm openBalanceVm)
{
#region Check Rights
bool hasRights;
string accountId = "";
string tbName, pkName; int libId;
libId = openBalanceVm.LibItemId;
tbName = openBalanceVm.TbName;
pkName = openBalanceVm.PkName;
//Get AccountId
accountId = AccountingChartHelper.GetAccountIdByPkAndTbName(libId, tbName, pkName);
if (string.IsNullOrEmpty(accountId))
{
hasRights = AdminHelper.CheckUserAction(ScreenEnum.OpenBalance, ActionEnum.Add);
}
else
{
hasRights = AdminHelper.CheckUserAction(ScreenEnum.OpenBalance, ActionEnum.Edit);
}
if (!hasRights)
{
return(RedirectToAction("UnAuthorized", "Home", new { area = "" }));
}
#endregion
string isSaved = AccountingHelper.AddEditOpenBalance(openBalanceVm);
return(Json(new { IsSaved = isSaved }));
}
public async Task <IActionResult> ExportAdvancePayment(AdvancePaymentCriteria advancePaymentCriteria)
{
var responseFromApi = await HttpServiceExtension.GetDataFromApi(advancePaymentCriteria, aPis.AccountingAPI + Urls.Accounting.AdvancePaymentUrl);
var dataObjects = responseFromApi.Content.ReadAsAsync <List <AdvancePaymentModel> >();
var stream = new AccountingHelper().GenerateAdvancePaymentExcel(dataObjects.Result);
if (stream == null)
{
return(null);
}
FileContentResult fileContent = new FileHelper().ExportExcel(stream, "Advance Payment List.xlsx");
return(fileContent);
}
public async Task <IActionResult> ExportDetailSettlementPayment(Guid settlementId, string language)
{
var responseFromApi = await HttpServiceExtension.GetApi(aPis.AccountingAPI + Urls.Accounting.DetailSettlementPaymentExportUrl + "?settlementId=" + settlementId);
var dataObjects = responseFromApi.Content.ReadAsAsync <SettlementExport>();
var stream = new AccountingHelper().GenerateDetailSettlementPaymentExcel(dataObjects.Result, language);
if (stream == null)
{
return(null);
}
FileContentResult fileContent = new FileHelper().ExportExcel(stream, "Settlement Form - eFMS.xlsx");
return(fileContent);
}
public async Task <IActionResult> ExportBravoSOA(string soaNo)
{
var responseFromApi = await HttpServiceExtension.GetApi(aPis.AccountingAPI + Urls.Accounting.GetDataBravoSOAUrl + soaNo);
var dataObjects = responseFromApi.Content.ReadAsAsync <List <ExportBravoSOAModel> >();
var stream = new AccountingHelper().GenerateBravoSOAExcel(dataObjects.Result);
if (stream == null)
{
return(null);
}
FileContentResult fileContent = new FileHelper().ExportExcel(stream, "SOA Bravo List.xlsx");
return(fileContent);
}
public async Task <IActionResult> ExportDetailSOA(string soaNo, string currency)
{
var responseFromApi = await HttpServiceExtension.GetApi(aPis.AccountingAPI + Urls.Accounting.DetailSOAExportUrl + soaNo + "&¤cyLocal=" + currency);
var dataObjects = responseFromApi.Content.ReadAsAsync <DetailSOAModel>();
var stream = new AccountingHelper().GenerateDetailSOAExcel(dataObjects.Result);
if (stream == null)
{
return(null);
}
string fileName = "Export SOA " + soaNo + ".xlsx";
FileContentResult fileContent = new FileHelper().ExportExcel(stream, fileName);
return(fileContent);
}
public ActionResult CashOpenBalance(string accid, int cid)
{
ViewBag.PaymentTerm = ListCommonHelper.GetPaymentTerm("en", true)
.Where(x => x.Key != 2 && x.Key < 6)
.ToDictionary(x => x.Key, x => x.Value);
ViewBag.CurrencyList = ListCommonHelper.GetCurrencyList();
ViewBag.BankList = ListCommonHelper.GetBankList();
var cashReceiptObj = CashHelper.GetCashReceiptOpenBalance(accid, cid);
var openBalanceObject = AccountingHelper.Get_OpenBalanceObject(accid, cid);
ViewBag.OpenBalanceObject = openBalanceObject;
ViewBag.CashRecTitle = openBalanceObject.Amount < 0 ? "Cash Out Receipt" : "Cash In Receipt";
return(View(cashReceiptObj));
}
public async Task <IActionResult> ExportSOAOPS(string soaNo)
{
var responseFromApi = await HttpServiceExtension.GetApi(aPis.AccountingAPI + Urls.Accounting.GetDataSOAOPSUrl + soaNo);
var dataObjects = responseFromApi.Content.ReadAsAsync <SOAOPSModel>();
var stream = new AccountingHelper().GenerateSOAOPSExcel(dataObjects.Result);
if (dataObjects.Result.exportSOAOPs.Count == 0)
{
return(Ok());
}
if (stream == null)
{
return(null);
}
FileContentResult fileContent = new FileHelper().ExportExcel(stream, "SOA OPS.xlsx");
return(fileContent);
}
public async Task <IActionResult> ExportSOAAirfreight(string soaNo, string officeId)
{
var responseFromApi = await HttpServiceExtension.GetApi(aPis.AccountingAPI + Urls.Accounting.GetDataSOAAirfreightExportUrl + soaNo + "&&officeId=" + officeId);
var dataObjects = responseFromApi.Content.ReadAsAsync <ExportSOAAirfreightModel>();
if (dataObjects.Result.HawbAirFrieghts == null)
{
return(Ok());
}
var stream = new AccountingHelper().GenerateSOAAirfreightExcel(dataObjects.Result);
if (stream == null)
{
return(null);
}
string fileName = "Export SOA Air Freight " + soaNo + ".xlsx";
FileContentResult fileContent = new FileHelper().ExportExcel(stream, fileName);
return(fileContent);
}
public ActionResult PrintOperationFullCostV(int operationId, int hbId)
{
var operCostMain = AccountingHelper.GetOperationCost(operationId, hbId);
return(View(operCostMain));
}
public ActionResult GetOperationFullCost(int operationId, int hbId)
{
var operCostMain = AccountingHelper.GetOperationCost(operationId, hbId);
return(PartialView("~/Views/Accounting/_OperationCostMain.cshtml", operCostMain));
}
public JObject GetOpenBalanceTableJson( )
{
JObject quotationOrders = AccountingHelper.GetOpenBalanceListJson();
return(quotationOrders);
}
public ActionResult GetBalancePartial(int itemId, string tbName, string pkName)
{
var balanceVm = AccountingHelper.GetOpenBalanceInfo(tbName, itemId, pkName);
return(PartialView("~/Areas/MasterData/Views/OpenBalance/_AddForm.cshtml", balanceVm));
}
