public IActionResult Update([FromBody] dynamic cityData)
{
ValidateSession();
var result = "";
try
{
if (cityData != null)
{
App_CityPoco cityPoco = JsonConvert.DeserializeObject <App_CityPoco>(JsonConvert.SerializeObject(cityData[0]));
using (var scope = new TransactionScope())
{
var existingCity = _cityLogic.GetSingleById(cityPoco.Id);
existingCity.CityName = cityPoco.CityName;
existingCity.ProvinceId = cityPoco.ProvinceId;
existingCity.CountryId = cityPoco.CountryId;
var cityId = _cityLogic.Update(existingCity).Id;
if (cityId > 0)
{
scope.Complete();
result = cityId.ToString();
}
}
}
}
catch (Exception ex)
{
}
return(Json(result));
}
public IActionResult PartialViewDataTable()
{
ValidateSession();
List <ViewModel_AddressDetail> filteredAddresses = new List <ViewModel_AddressDetail>();
try
{
var addresses = _addressLogic.GetList();
foreach (var address in addresses)
{
ViewModel_AddressDetail filteredAddress = new ViewModel_AddressDetail();
filteredAddress.AddressId = address.Id;
filteredAddress.UnitNumber = address.UnitNumber;
filteredAddress.HouseNumber = address.HouseNumber;
filteredAddress.StreetNumber = address.StreetNumber;
filteredAddress.AddressLine = address.AddressLine;
filteredAddress.CityName = _cityLogic.GetSingleById(address.CityId).CityName;
filteredAddress.ProvinceShortCode = _provinceLogic.GetSingleById(address.ProvinceId).ShortCode;
filteredAddress.CountryName = _countryLogic.GetSingleById(address.CountryId).CountryName;
filteredAddress.PostCode = address.PostCode;
filteredAddress.ContactPersonName = address.ContactPersonName;
filteredAddress.Fax = address.Fax;
filteredAddress.PrimaryPhoneNumber = address.PrimaryPhoneNumber;
filteredAddress.PhoneNumber2 = address.PhoneNumber2;
filteredAddress.MobileNumber = address.MobileNumber;
filteredAddress.EmailAddress1 = address.EmailAddress1;
filteredAddresses.Add(filteredAddress);
}
}
catch (Exception ex)
{
}
return(PartialView("_PartialViewAddressData", filteredAddresses));
}
public JsonResult PrintCustomerDueReportAsPdf([FromBody] dynamic reportParam)
{
try
{
var viewName = "CustomerWiseDueReportGenerated";
var customerId = ((JObject)reportParam).SelectToken("customers").ToString();
var isPaidIncluded = Convert.ToBoolean(((JObject)reportParam).SelectToken("isPaidIncluded").ToString());
var _fromDateString = ((JObject)reportParam).SelectToken("startDate").ToString();
var _toDateString = ((JObject)reportParam).SelectToken("endDate").ToString();
DateTime _fromDate = DateTime.Now;
DateTime _toDate = DateTime.Now;
if (DateTime.TryParse(_fromDateString, out _fromDate))
{
//code
}
else
{
_fromDate = DateTime.Now.AddMonths(-1);
}
if (!DateTime.TryParse(_toDateString, out _toDate))
{
//code
}
_companyInfoLogic = new Lms_CompanyInfoLogic(_cache, new EntityFrameworkGenericRepository <Lms_CompanyInfoPoco>(_dbContext));
var companyInfo = _companyInfoLogic.GetSingleById(1);
if (companyInfo != null)
{
SessionData.CompanyName = !string.IsNullOrEmpty(companyInfo.CompanyName) ? companyInfo.CompanyName : "";
SessionData.CompanyLogo = companyInfo.CompanyLogo != null?Convert.ToBase64String(companyInfo.CompanyLogo) : null;
SessionData.CompanyAddress = !string.IsNullOrEmpty(companyInfo.MainAddress) ? companyInfo.MainAddress.ToUpper() : "";
SessionData.CompanyTelephone = !string.IsNullOrEmpty(companyInfo.Telephone) ? companyInfo.Telephone : "";
SessionData.CompanyFax = companyInfo.Fax;
SessionData.CompanyEmail = !string.IsNullOrEmpty(companyInfo.EmailAddress) ? companyInfo.EmailAddress : "";
SessionData.CompanyTaxNumber = !string.IsNullOrEmpty(companyInfo.TaxNumber) ? companyInfo.TaxNumber : "";
}
string rptDuration = _fromDate.ToString("dd/MMM/yyyy") + " - " + _toDate.ToString("dd/MMM/yyyy");
_toDate = _toDate.AddDays(1);
ViewModel_Report_CustomerDue viewModel_Report_CustomerDue = new ViewModel_Report_CustomerDue();
if (string.IsNullOrEmpty(customerId))
{
return(Json(""));
}
var customerInfo = _customerLogic.GetSingleById(Convert.ToInt32(customerId));
viewModel_Report_CustomerDue.CustomerId = customerInfo.Id;
viewModel_Report_CustomerDue.CustomerName = customerInfo.CustomerName;
viewModel_Report_CustomerDue.TotalAmountPayable = 0;
viewModel_Report_CustomerDue.InvoiceDueDays = customerInfo.InvoiceDueDays;
var addressMappingInfo = _addressMappingLogic.GetList().Where(c => c.CustomerId == customerInfo.Id && c.AddressTypeId == (byte)Enum_AddressType.Billing).FirstOrDefault();
var addressInfo = _addressLogic.GetSingleById(addressMappingInfo.AddressId);
viewModel_Report_CustomerDue.AddressLine1 = addressInfo.UnitNumber + " " + addressInfo.AddressLine;
viewModel_Report_CustomerDue.City = _cityLogic.GetSingleById(addressInfo.CityId).CityName;
viewModel_Report_CustomerDue.ProvinceCode = _provinceLogic.GetSingleById(addressInfo.ProvinceId).ShortCode;
viewModel_Report_CustomerDue.PostCode = addressInfo.PostCode;
var invoices = _invoiceLogic.GetList().Where(c => c.BillerCustomerId == Convert.ToInt32(customerId) && c.CreateDate >= _fromDate && c.CreateDate <= _toDate).ToList();
if (isPaidIncluded == false)
{
invoices = invoices.Where(c => c.PaidAmount == null || c.PaidAmount < c.TotalInvoiceAmount).ToList();
}
if (invoices.Count < 1)
{
return(Json(""));
}
var paymentCollections = _paymentCollectionLogic.GetList();
var paymentMethods = _paymentMethodLogic.GetList();
var banks = _bankLogic.GetList();
List <ViewModel_InvoiceDueData> invoiceDataList = new List <ViewModel_InvoiceDueData>();
foreach (var invoice in invoices)
{
ViewModel_InvoiceDueData invoiceDueData = new ViewModel_InvoiceDueData();
invoiceDueData.InvoiceNo = invoice.Id;
invoiceDueData.InvoiceDate = invoice.CreateDate.ToString("M/d/yyyy");
invoiceDueData.TotalInvoiceAmount = invoice.TotalInvoiceAmount;
invoiceDueData.PaidAmount = invoice.PaidAmount == null ? 0 : invoice.PaidAmount;
invoiceDueData.BalanceDueAmount = invoice.TotalInvoiceAmount - invoiceDueData.PaidAmount;
var paymentCollectionList = paymentCollections.Where(c => c.InvoiceId == invoice.Id).ToList();
if (paymentCollectionList.Count > 0)
{
var paymentCollection = paymentCollectionList.LastOrDefault();
if (paymentCollection != null)
{
invoiceDueData.PaymentMethod = paymentMethods.Where(c => c.Id == paymentCollection.PaymentMethodId).FirstOrDefault().MethodName;
invoiceDueData.PaymentDate = paymentCollection.PaymentDate.ToString("M/d/yyyy");
decimal chqAmount = 0;
foreach (var coll in paymentCollectionList)
{
chqAmount += coll.ChequeAmount != null ? (decimal)coll.ChequeAmount : 0;
}
invoiceDueData.ChqDate = paymentCollection.ChequeDate != null?Convert.ToDateTime(paymentCollection.ChequeDate).ToString("M/d/yyyy") : "";
invoiceDueData.ChqNo = paymentCollection.ChequeNo;
invoiceDueData.ChqAmount = chqAmount.ToString("0.00");
invoiceDueData.BankShortName = banks.Where(c => c.Id == paymentCollection.BankId).FirstOrDefault().BankShortName;
}
}
invoiceDataList.Add(invoiceDueData);
viewModel_Report_CustomerDue.TotalAmountPayable += invoiceDueData.BalanceDueAmount;
}
viewModel_Report_CustomerDue.InvoiceData = invoiceDataList;
var webrootPath = _hostingEnvironment.WebRootPath;
var uniqueId = DateTime.Now.ToFileTime();
var fileName = "CustomerDueReport_" + uniqueId + ".pdf";
var directoryPath = webrootPath + "/contents/reports/";
var filePath = directoryPath + fileName;
if (!System.IO.Directory.Exists(directoryPath))
{
System.IO.Directory.CreateDirectory(directoryPath);
}
var pdfReport = new ViewAsPdf(viewName, viewModel_Report_CustomerDue)
{
PageSize = Rotativa.AspNetCore.Options.Size.Letter
};
var file = pdfReport.BuildFile(ControllerContext).Result;
System.IO.File.WriteAllBytes(filePath, file);
string returnPath = "/contents/reports/" + fileName;
//_emailService.SendEmail("*****@*****.**", "test subject", "test body content", returnPath);
return(Json(returnPath));
}
catch (Exception ex)
{
return(null);
}
//return View();
}