public IActionResult Index()
{
ValidateSession();
ViewBag.TaxToCall = Enum.GetValues(typeof(Enum_TaxToCall)).Cast <Enum_TaxToCall>();
var configuration = _configurationLogic.GetSingleById(1);
_unitTypeLogic = new Lms_UnitTypeLogic(_cache, new EntityFrameworkGenericRepository <Lms_UnitTypePoco>(_dbContext));
_weightScaleLogic = new Lms_WeightScaleLogic(_cache, new EntityFrameworkGenericRepository <Lms_WeightScalePoco>(_dbContext));
ViewBag.UnitTypes = _unitTypeLogic.GetList();
ViewBag.WeightScales = _weightScaleLogic.GetList();
return(View(configuration));
}
private int CreateNewAccount(Lms_CustomerPoco customerPoco)
{
int newAccountId = 0;
_configurationLogic = new Lms_ConfigurationLogic(_cache, new EntityFrameworkGenericRepository <Lms_ConfigurationPoco>(_dbContext));
_chartOfAccountLogic = new Lms_ChartOfAccountLogic(_cache, new EntityFrameworkGenericRepository <Lms_ChartOfAccountPoco>(_dbContext));
var parentGLForCustomerAccount = _configurationLogic.GetSingleById(1).ParentGLForCustomerAccount;
var accounts = _chartOfAccountLogic.GetList().Where(c => c.ParentGLCode == parentGLForCustomerAccount).ToList();
newAccountId = accounts.Max(c => c.Id) + 1;
Lms_ChartOfAccountPoco accountPoco = new Lms_ChartOfAccountPoco();
accountPoco.Id = newAccountId;
accountPoco.ParentGLCode = parentGLForCustomerAccount;
accountPoco.AccountName = customerPoco.CustomerName;
accountPoco.BranchId = sessionData.BranchId == null ? 1 : (int)sessionData.BranchId;
accountPoco.CurrentBalance = 0;
accountPoco.IsActive = true;
accountPoco.Remarks = "Customer Account Receivable";
accountPoco.CreateDate = DateTime.Now;
accountPoco.CreatedBy = sessionData.UserId;
var newAcc = _chartOfAccountLogic.Add(accountPoco);
if (newAcc != null)
{
return(newAccountId);
}
else
{
return(0);
}
}
public IActionResult Add([FromBody] dynamic employeeData)
{
ValidateSession();
var result = "";
try
{
if (employeeData != null)
{
Lms_EmployeePoco employeePoco = JsonConvert.DeserializeObject <Lms_EmployeePoco>(JsonConvert.SerializeObject(employeeData[0]));
if (employeePoco.Id < 1 && employeePoco.FirstName.Trim() != string.Empty)
{
_configurationLogic = new Lms_ConfigurationLogic(_cache, new EntityFrameworkGenericRepository <Lms_ConfigurationPoco>(_dbContext));
_chartOfAccountLogic = new Lms_ChartOfAccountLogic(_cache, new EntityFrameworkGenericRepository <Lms_ChartOfAccountPoco>(_dbContext));
var parentGLForEmployeeAccount = _configurationLogic.GetSingleById(1).ParentGLForEmployeeAccount;
var accounts = _chartOfAccountLogic.GetList().Where(c => c.ParentGLCode == parentGLForEmployeeAccount).ToList();
var newAccountId = accounts.Max(c => c.Id) + 1;
var newEmployeeId = _employeeLogic.GetMaxId() + 1;
using (var scope = new TransactionScope())
{
Lms_ChartOfAccountPoco accountPoco = new Lms_ChartOfAccountPoco();
accountPoco.Id = newAccountId;
accountPoco.ParentGLCode = parentGLForEmployeeAccount;
accountPoco.AccountName = employeePoco.FirstName + employeePoco.LastName;
accountPoco.BranchId = sessionData.BranchId == null ? 1 : (int)sessionData.BranchId;
accountPoco.CurrentBalance = 0;
accountPoco.IsActive = true;
accountPoco.Remarks = "Employee Account Payable";
accountPoco.CreateDate = DateTime.Now;
accountPoco.CreatedBy = sessionData.UserId;
var addedAcc = _chartOfAccountLogic.Add(accountPoco);
if (addedAcc.Id > 0)
{
employeePoco.Id = newEmployeeId;
employeePoco.AccountId = addedAcc.Id;
employeePoco.CreateDate = DateTime.Now;
employeePoco.CreatedBy = sessionData.UserId;
var employeeId = _employeeLogic.Add(employeePoco).Id;
if (employeeId > 0)
{
scope.Complete();
result = employeeId.ToString();
}
}
}
}
}
}
catch (Exception ex)
{
}
return(Json(result));
}
public IActionResult Add([FromBody] dynamic employeeLoanData)
{
ValidateSession();
var result = "";
try
{
if (employeeLoanData != null)
{
Lms_EmployeeLoanPoco employeeLoanPoco = JsonConvert.DeserializeObject <Lms_EmployeeLoanPoco>(JsonConvert.SerializeObject(employeeLoanData[0]));
if (employeeLoanPoco.LoanAmount > 0)
{
using (var scope = new TransactionScope()) {
var _transactionController = new TransactionController(_cache, _dbContext);
var _configLogic = new Lms_ConfigurationLogic(_cache, new EntityFrameworkGenericRepository <Lms_ConfigurationPoco>(_dbContext));
var configInfo = _configLogic.GetSingleById(1);
var employeeInfo = _employeeLogic.GetSingleById(employeeLoanPoco.EmployeeId);
List <TransactionModel> debitTransactionModelList = new List <TransactionModel>();
TransactionModel debitTransactionModel = new TransactionModel();
debitTransactionModel.AccountId = employeeInfo.AccountId;
debitTransactionModel.TxnAmount = employeeLoanPoco.LoanAmount;
debitTransactionModelList.Add(debitTransactionModel);
List <TransactionModel> creditTransactionModelList = new List <TransactionModel>();
TransactionModel creditTransactionModel = new TransactionModel();
creditTransactionModel.AccountId = (int)configInfo.LoanIncomeAccount;
creditTransactionModel.TxnAmount = employeeLoanPoco.LoanAmount;
creditTransactionModelList.Add(creditTransactionModel);
var txnId = _transactionController.MakeTransaction(debitTransactionModelList, creditTransactionModelList, employeeLoanPoco.LoanAmount, DateTime.Now, DateTime.Now, employeeLoanPoco.Remarks);
employeeLoanPoco.TransactionId = txnId;
employeeLoanPoco.CreatedBy = sessionData.UserId;
var loanId = _employeeLoanLogic.Add(employeeLoanPoco);
if (!string.IsNullOrEmpty(loanId.ToString()))
{
result = loanId.ToString();
scope.Complete();
}
}
}
}
}
catch (Exception ex)
{
}
return(Json(result));
}
public IActionResult Index()
{
ValidateSession();
_configurationLogic = new Lms_ConfigurationLogic(_cache, new EntityFrameworkGenericRepository <Lms_ConfigurationPoco>(_dbContext));
ViewBag.DefaultFuelSurcharge = _configurationLogic.GetSingleById(1).DefaultFuelSurcharge;
_cityLogic = new App_CityLogic(_cache, new EntityFrameworkGenericRepository <App_CityPoco>(_dbContext));
ViewBag.Cities = _cityLogic.GetList();
_provinceLogic = new App_ProvinceLogic(_cache, new EntityFrameworkGenericRepository <App_ProvincePoco>(_dbContext));
ViewBag.Provinces = _provinceLogic.GetList();
_countryLogic = new App_CountryLogic(_cache, new EntityFrameworkGenericRepository <App_CountryPoco>(_dbContext));
ViewBag.Countries = _countryLogic.GetList();
return(View(GetCustomerData(0)));
}
public JsonResult GetCustomerById(string id)
{
if (!string.IsNullOrEmpty(id))
{
var customer = _customerLogic.GetSingleById(Convert.ToInt32(id));
if (customer != null)
{
if (customer.FuelSurChargePercentage == null || customer.FuelSurChargePercentage <= 0)
{
_configurationLogic = new Lms_ConfigurationLogic(_cache, new EntityFrameworkGenericRepository <Lms_ConfigurationPoco>(_dbContext));
var defaultFuelSurcharge = _configurationLogic.GetSingleById(1).DefaultFuelSurcharge;
customer.FuelSurChargePercentage = defaultFuelSurcharge;
}
return(Json(JsonConvert.SerializeObject(customer)));
}
}
return(Json(string.Empty));
}
public IActionResult Add([FromBody] dynamic orderData)
{
ValidateSession();
var result = "";
try
{
if (orderData != null)
{
using (var scope = new TransactionScope())
{
Lms_OrderPoco orderPoco = JsonConvert.DeserializeObject <Lms_OrderPoco>(JsonConvert.SerializeObject(orderData[0]));
_addressLogic = new Lms_AddressLogic(_cache, new EntityFrameworkGenericRepository <Lms_AddressPoco>(_dbContext));
var addressList = _addressLogic.GetList();
Lms_AddressPoco newAddress = new Lms_AddressPoco();
var orderAddressData = (JObject)orderData[0];
var customerId = orderAddressData.SelectToken("customerId").ToString();
var waybillNumber = orderAddressData.SelectToken("wayBillNumber").ToString();
var customerAddressId = orderAddressData.SelectToken("customerAddressId").ToString();
var customerAddressline = orderAddressData.SelectToken("customerAddressline").ToString();
var customerUnitNo = orderAddressData.SelectToken("customerUnitNo").ToString();
var customerCityId = orderAddressData.SelectToken("customerCityId").ToString();
var customerProvinceId = orderAddressData.SelectToken("customerProvinceId").ToString();
var customerPostcode = orderAddressData.SelectToken("customerPostcode").ToString();
var orderDate = orderAddressData.SelectToken("orderDate").ToString();
orderPoco.ShipperAddressId = customerAddressId == "" ? 0 : Convert.ToInt32(customerAddressId);
orderPoco.ShipperCustomerId = customerId == "" ? 0 : Convert.ToInt32(customerId);
orderPoco.IsInvoiced = false;
orderPoco.CreateDate = orderDate == "" ? DateTime.Today : Convert.ToDateTime(orderDate);
orderPoco.CreatedBy = sessionData.UserId;
orderPoco.OrderTypeId = 3; //3 for misc. order
var newWbNumber = _orderLogic.GetList().OrderByDescending(c => c.WayBillNumber).Take(1).FirstOrDefault().WayBillNumber;
if (!(newWbNumber.Length > 0))
{
newWbNumber = _configurationLogic.GetSingleById(1).DeliveryWBNoStartFrom;
}
else
{
newWbNumber = (Convert.ToInt16(newWbNumber) + 1).ToString();
}
orderPoco.WayBillNumber = newWbNumber;
var customerAddressInfo = addressList.Where(c => c.Id == orderPoco.ShipperAddressId).FirstOrDefault();
if (customerAddressInfo != null)
{
customerAddressInfo.UnitNumber = !string.IsNullOrEmpty(customerAddressInfo.UnitNumber) ? Convert.ToString(customerAddressInfo.UnitNumber).Trim().ToUpper() : "";
if (customerAddressline.Trim().ToUpper() == customerAddressInfo.AddressLine.Trim().ToUpper() && customerUnitNo.Trim().ToUpper() == customerAddressInfo.UnitNumber && Convert.ToInt16(customerCityId) == customerAddressInfo.CityId)
{
if (Convert.ToInt16(customerProvinceId) != customerAddressInfo.ProvinceId || customerPostcode != customerAddressInfo.PostCode)
{
customerAddressInfo.ProvinceId = Convert.ToInt16(customerProvinceId);
customerAddressInfo.PostCode = customerPostcode;
_addressLogic.Update(customerAddressInfo);
}
}
else
{
newAddress = new Lms_AddressPoco();
newAddress.AddressLine = customerAddressline;
newAddress.UnitNumber = customerUnitNo;
newAddress.CityId = Convert.ToInt16(customerCityId);
newAddress.ProvinceId = Convert.ToInt16(customerProvinceId);
newAddress.CountryId = 41; // default Canada
newAddress.PostCode = customerPostcode;
newAddress.CreatedBy = sessionData.UserId;
orderPoco.ShipperAddressId = _addressLogic.Add(newAddress).Id;
}
}
List <Lms_OrderAdditionalServicePoco> orderAdditionalServices = JsonConvert.DeserializeObject <List <Lms_OrderAdditionalServicePoco> >(JsonConvert.SerializeObject(orderData[1]));
_orderAdditionalServiceLogic = new Lms_OrderAdditionalServiceLogic(_cache, new EntityFrameworkGenericRepository <Lms_OrderAdditionalServicePoco>(_dbContext));
if (orderPoco.Id < 1 && orderPoco.BillToCustomerId > 0)
{
var addedOrder = _orderLogic.Add(orderPoco);
foreach (var item in orderAdditionalServices)
{
item.OrderId = addedOrder.Id;
var existingRecord = _orderAdditionalServiceLogic.GetList().Where(c => c.OrderId == addedOrder.Id && c.AdditionalServiceId == item.AdditionalServiceId).FirstOrDefault();
if (existingRecord == null)
{
_orderAdditionalServiceLogic.Add(item);
}
else
{
_orderAdditionalServiceLogic.Remove(existingRecord);
_orderAdditionalServiceLogic.Add(item);
}
}
result = addedOrder.WayBillNumber;
}
if (result != "")
{
scope.Complete();
}
}
}
}
catch (Exception ex)
{
}
return(Json(result));
}
public IActionResult Add([FromBody] dynamic customerData)
{
ValidateSession();
var result = "";
try
{
if (customerData != null)
{
Lms_CustomerPoco customerPoco = JsonConvert.DeserializeObject <Lms_CustomerPoco>(JsonConvert.SerializeObject(customerData[0]));
CustomerAddressMapping customerAddress = JsonConvert.DeserializeObject <CustomerAddressMapping>(JsonConvert.SerializeObject(customerData[1]));
_configurationLogic = new Lms_ConfigurationLogic(_cache, new EntityFrameworkGenericRepository <Lms_ConfigurationPoco>(_dbContext));
_chartOfAccountLogic = new Lms_ChartOfAccountLogic(_cache, new EntityFrameworkGenericRepository <Lms_ChartOfAccountPoco>(_dbContext));
var parentGLForCustomerAccount = _configurationLogic.GetSingleById(1).ParentGLForCustomerAccount;
var accounts = _chartOfAccountLogic.GetList().Where(c => c.ParentGLCode == parentGLForCustomerAccount).ToList();
var newAccountId = accounts.Max(c => c.Id) + 1;
var newCustomerId = _customerLogic.GetMaxId() + 1;
using (var scope = new TransactionScope())
{
Lms_ChartOfAccountPoco accountPoco = new Lms_ChartOfAccountPoco();
accountPoco.Id = newAccountId;
accountPoco.ParentGLCode = parentGLForCustomerAccount;
accountPoco.AccountName = customerPoco.CustomerName;
accountPoco.BranchId = sessionData.BranchId == null ? 1 : (int)sessionData.BranchId;
accountPoco.CurrentBalance = 0;
accountPoco.IsActive = true;
accountPoco.Remarks = "Customer Account Receivable";
accountPoco.CreateDate = DateTime.Now;
accountPoco.CreatedBy = sessionData.UserId;
var addedAcc = _chartOfAccountLogic.Add(accountPoco);
if (addedAcc.Id > 0)
{
customerPoco.Id = newCustomerId;
customerPoco.AccountId = addedAcc.Id;
customerPoco.CreateDate = DateTime.Now;
customerPoco.CreatedBy = sessionData.UserId;
var customerId = _customerLogic.Add(customerPoco).Id;
result = customerId.ToString();
}
if (customerAddress != null && !string.IsNullOrEmpty(customerAddress.AddressLine))
{
customerAddress.CustomerId = newCustomerId;
customerAddress.IsDefault = true;
_addressLogic = new Lms_AddressLogic(_cache, new EntityFrameworkGenericRepository <Lms_AddressPoco>(_dbContext));
var addressList = _addressLogic.GetList();
_customerAddressMappingLogic = new Lms_CustomerAddressMappingLogic(_cache, new EntityFrameworkGenericRepository <Lms_CustomerAddressMappingPoco>(_dbContext));
var customerAddressList = _customerAddressMappingLogic.GetList().Where(c => c.CustomerId == customerAddress.CustomerId);
int addressId = 0;
var existingAddress = addressList.Where(c => c.UnitNumber == customerAddress.UnitNumber && c.AddressLine == customerAddress.AddressLine && c.CityId == customerAddress.CityId).FirstOrDefault();
if (existingAddress != null)
{
existingAddress.ProvinceId = customerAddress.ProvinceId;
existingAddress.CountryId = customerAddress.CountryId;
existingAddress.PostCode = customerAddress.PostCode;
existingAddress.PrimaryPhoneNumber = customerAddress.PrimaryPhoneNumber;
existingAddress.Fax = customerAddress.Fax;
existingAddress.EmailAddress1 = customerAddress.EmailAddress1;
existingAddress.EmailAddress2 = customerAddress.EmailAddress1;
existingAddress.ContactPersonName = customerAddress.ContactPersonName;
addressId = _addressLogic.Update(existingAddress).Id;
}
else
{
Lms_AddressPoco addressPoco = new Lms_AddressPoco();
addressPoco.UnitNumber = customerAddress.UnitNumber;
addressPoco.AddressLine = customerAddress.AddressLine;
addressPoco.CityId = customerAddress.CityId;
addressPoco.ProvinceId = customerAddress.ProvinceId;
addressPoco.CountryId = customerAddress.CountryId;
addressPoco.PostCode = customerAddress.PostCode;
addressPoco.PrimaryPhoneNumber = customerAddress.PrimaryPhoneNumber;
addressPoco.Fax = customerAddress.Fax;
addressPoco.EmailAddress1 = customerAddress.EmailAddress1;
addressPoco.EmailAddress2 = customerAddress.EmailAddress1;
addressPoco.ContactPersonName = customerAddress.ContactPersonName;
addressId = _addressLogic.Add(addressPoco).Id;
}
if (customerAddress.AddressTypeId == 0)
{
Lms_CustomerAddressMappingPoco customerAddressMappingPoco = new Lms_CustomerAddressMappingPoco();
customerAddressMappingPoco.CustomerId = customerAddress.CustomerId;
customerAddressMappingPoco.AddressId = addressId;
customerAddressMappingPoco.AddressTypeId = (byte)Enum_AddressType.Billing;
customerAddressMappingPoco.IsDefault = customerAddress.IsDefault;
_customerAddressMappingLogic.Add(customerAddressMappingPoco);
customerAddressMappingPoco = new Lms_CustomerAddressMappingPoco();
customerAddressMappingPoco.CustomerId = customerAddress.CustomerId;
customerAddressMappingPoco.AddressId = addressId;
customerAddressMappingPoco.AddressTypeId = (byte)Enum_AddressType.Shipping;
customerAddressMappingPoco.IsDefault = customerAddress.IsDefault;
_customerAddressMappingLogic.Add(customerAddressMappingPoco);
}
else
{
Lms_CustomerAddressMappingPoco customerAddressMappingPoco = new Lms_CustomerAddressMappingPoco();
customerAddressMappingPoco.CustomerId = customerAddress.CustomerId;
customerAddressMappingPoco.AddressId = addressId;
customerAddressMappingPoco.AddressTypeId = customerAddress.AddressTypeId;
customerAddressMappingPoco.IsDefault = customerAddress.IsDefault;
_customerAddressMappingLogic.Add(customerAddressMappingPoco);
}
}
scope.Complete();
}
}
}
catch (Exception ex)
{
}
return(Json(result));
}