public IActionResult Remove(string id) { var result = ""; try { var poco = _customerLogic.GetSingleById(Convert.ToInt32(id)); if (poco != null) { _chartOfAccountLogic = new Lms_ChartOfAccountLogic(_cache, new EntityFrameworkGenericRepository <Lms_ChartOfAccountPoco>(_dbContext)); var accPoco = _chartOfAccountLogic.GetSingleById(poco.AccountId); _chartOfAccountLogic.Remove(accPoco); _customerAddressMappingLogic = new Lms_CustomerAddressMappingLogic(_cache, new EntityFrameworkGenericRepository <Lms_CustomerAddressMappingPoco>(_dbContext)); var mappingAddresses = _customerAddressMappingLogic.GetList().Where(c => c.CustomerId == poco.Id).ToList(); if (mappingAddresses.Count > 0) { foreach (var item in mappingAddresses) { _customerAddressMappingLogic.Remove(item); } } _customerLogic.Remove(poco); } result = "Success"; } catch (Exception ex) { } return(Json(result)); }
private bool DeleteCustomerById(int customerId) { bool isDeleted = false; try { var poco = _customerLogic.GetSingleById(Convert.ToInt32(customerId)); if (poco != null) { _chartOfAccountLogic = new Lms_ChartOfAccountLogic(_cache, new EntityFrameworkGenericRepository <Lms_ChartOfAccountPoco>(_dbContext)); var accPoco = _chartOfAccountLogic.GetSingleById(poco.AccountId); _chartOfAccountLogic.Remove(accPoco); _customerAddressMappingLogic = new Lms_CustomerAddressMappingLogic(_cache, new EntityFrameworkGenericRepository <Lms_CustomerAddressMappingPoco>(_dbContext)); var mappingAddresses = _customerAddressMappingLogic.GetList().Where(c => c.CustomerId == poco.Id).ToList(); if (mappingAddresses.Count > 0) { foreach (var item in mappingAddresses) { _customerAddressMappingLogic.Remove(item); } } _customerLogic.Remove(poco); isDeleted = true; } } catch (Exception ex) { // } return(isDeleted); }
public IActionResult Remove(string id) { var result = ""; try { var poco = _customerLogic.GetSingleById(Convert.ToInt32(id)); if (poco != null) { _chartOfAccountLogic = new Lms_ChartOfAccountLogic(_cache, new EntityFrameworkGenericRepository <Lms_ChartOfAccountPoco>(_dbContext)); var accPoco = _chartOfAccountLogic.GetSingleById(poco.AccountId); _chartOfAccountLogic.Remove(accPoco); } _customerLogic.Remove(poco); result = "Success"; } catch (Exception ex) { } return(Json(result)); }
/// <summary> /// Should be able to make single debit, multiple credit and single credit multiple debit entries. Therefore debit and credit info are passed as objects /// </summary> /// <param name="debitAccountInfo"></param> /// <param name="creditAccountInfo"></param> /// <param name="transactionAmount"></param> /// <param name="transactionDate"></param> /// <param name="valueDate"></param> /// <param name="transactionRemarks"></param> /// <returns></returns> public int MakeTransaction(List <TransactionModel> debitAccountInfo, List <TransactionModel> creditAccountInfo, decimal transactionAmount, DateTime transactionDate, DateTime valueDate, string transactionRemarks) { var transactionId = _transactionDetailLogic.GetMaxId() + 1; Lms_TransactionDetailPoco txnDetail = new Lms_TransactionDetailPoco(); txnDetail.Id = transactionId; txnDetail.TransactionAmount = transactionAmount; txnDetail.TransactionDate = transactionDate; txnDetail.ValueDate = valueDate; txnDetail.Remarks = transactionRemarks; _transactionDetailLogic.Add(txnDetail); Lms_TransactionPoco _transactionPoco = new Lms_TransactionPoco(); if (debitAccountInfo.Count == 1) { //Add Debit side _transactionPoco = new Lms_TransactionPoco(); _transactionPoco.Id = transactionId; _transactionPoco.SerialNo = 1; _transactionPoco.AccountId = debitAccountInfo.FirstOrDefault().AccountId; _transactionPoco.TransactionAmount = debitAccountInfo.FirstOrDefault().TxnAmount; _transactionPoco.Remarks = transactionRemarks; if (_transactionPoco.TransactionAmount > 0) { _transactionLogic.Add(_transactionPoco); var debitAccount = _chartOfAccountLogic.GetSingleById(_transactionPoco.AccountId); debitAccount.CurrentBalance = debitAccount.CurrentBalance + _transactionPoco.TransactionAmount; _chartOfAccountLogic.Update(debitAccount); } //Add Credit side var serialNo = 2; for (int i = 0; i < creditAccountInfo.Count; i++) { _transactionPoco = new Lms_TransactionPoco(); _transactionPoco.Id = transactionId; _transactionPoco.SerialNo = serialNo + i; _transactionPoco.AccountId = creditAccountInfo[i].AccountId; _transactionPoco.TransactionAmount = (-1) * creditAccountInfo[i].TxnAmount; _transactionPoco.Remarks = transactionRemarks; if (_transactionPoco.TransactionAmount < 0) { _transactionLogic.Add(_transactionPoco); var creditAccount = _chartOfAccountLogic.GetSingleById(_transactionPoco.AccountId); creditAccount.CurrentBalance = creditAccount.CurrentBalance + _transactionPoco.TransactionAmount; _chartOfAccountLogic.Update(creditAccount); } } } else if (creditAccountInfo.Count == 1) { //Add Credit side _transactionPoco = new Lms_TransactionPoco(); _transactionPoco.Id = transactionId; _transactionPoco.SerialNo = 1; _transactionPoco.AccountId = creditAccountInfo.FirstOrDefault().AccountId; _transactionPoco.TransactionAmount = (-1) * creditAccountInfo.FirstOrDefault().TxnAmount; _transactionPoco.Remarks = transactionRemarks; if (_transactionPoco.TransactionAmount < 0) { _transactionLogic.Add(_transactionPoco); var creditAccount = _chartOfAccountLogic.GetSingleById(_transactionPoco.AccountId); creditAccount.CurrentBalance = creditAccount.CurrentBalance + _transactionPoco.TransactionAmount; _chartOfAccountLogic.Update(creditAccount); } //Add Debit side var serialNo = 2; for (int i = 0; i < debitAccountInfo.Count; i++) { _transactionPoco = new Lms_TransactionPoco(); _transactionPoco.Id = transactionId; _transactionPoco.SerialNo = serialNo + i; _transactionPoco.AccountId = debitAccountInfo[i].AccountId; _transactionPoco.TransactionAmount = debitAccountInfo[i].TxnAmount; _transactionPoco.Remarks = transactionRemarks; if (_transactionPoco.TransactionAmount > 0) { _transactionLogic.Add(_transactionPoco); var debitAccount = _chartOfAccountLogic.GetSingleById(_transactionPoco.AccountId); debitAccount.CurrentBalance = debitAccount.CurrentBalance + _transactionPoco.TransactionAmount; _chartOfAccountLogic.Update(debitAccount); } } } return(transactionId); }
public IActionResult Update([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 jAddressObject = (JObject)customerData[1]; var shippingAddressMappingId = Convert.ToString(jAddressObject.SelectToken("shippingAddressMappingId")); var billingAddressMappingId = Convert.ToString(jAddressObject.SelectToken("billingAddressMappingId")); //using (var scope = new TransactionScope()) //{ if (customerPoco.Id > 0) { var customer = _customerLogic.GetSingleById(customerPoco.Id); customer.CustomerName = customerPoco.CustomerName; customer.DiscountPercentage = customerPoco.DiscountPercentage; customer.FuelSurChargePercentage = customerPoco.FuelSurChargePercentage > 0 ? customerPoco.FuelSurChargePercentage : null; customer.InvoiceDueDays = customerPoco.InvoiceDueDays; customer.IsGstApplicable = customerPoco.IsGstApplicable; customer.IsActive = customerPoco.IsActive; var accountInfo = _chartOfAccountLogic.GetSingleById(customer.AccountId); accountInfo.AccountName = customerPoco.CustomerName; _chartOfAccountLogic.Update(accountInfo); result = _customerLogic.Update(customer).Id.ToString(); if (customerAddress != null) { customerAddress.CustomerId = customerPoco.Id; 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).ToList().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; } // This will ensure only one address is set as default address for the same type var typeWiseAddresses = new List <Lms_CustomerAddressMappingPoco>(); if (customerAddress.IsDefault) { typeWiseAddresses = customerAddressList.Where(c => c.CustomerId == customerAddress.CustomerId && c.AddressTypeId == customerAddress.AddressTypeId).ToList(); if (typeWiseAddresses.Count > 0) { foreach (var item in typeWiseAddresses) { item.IsDefault = false; _customerAddressMappingLogic.Update(item); } } } var addressMappingList = _customerAddressMappingLogic.GetList(); if (customerAddress.AddressTypeId == 0) { Lms_CustomerAddressMappingPoco customerAddressMappingPoco = new Lms_CustomerAddressMappingPoco(); if (billingAddressMappingId != "") { customerAddressMappingPoco = addressMappingList.Where(c => c.Id == Convert.ToInt32(billingAddressMappingId)).FirstOrDefault(); customerAddressMappingPoco.AddressTypeId = (byte)Enum_AddressType.Billing; customerAddressMappingPoco.AddressId = addressId; customerAddressMappingPoco.IsDefault = true; _customerAddressMappingLogic.Update(customerAddressMappingPoco); } else { customerAddressMappingPoco = new Lms_CustomerAddressMappingPoco(); customerAddressMappingPoco.CustomerId = customerAddress.CustomerId; customerAddressMappingPoco.AddressId = addressId; customerAddressMappingPoco.AddressTypeId = (byte)Enum_AddressType.Billing; customerAddressMappingPoco.IsDefault = true; _customerAddressMappingLogic.Add(customerAddressMappingPoco); } if (shippingAddressMappingId != "") { customerAddressMappingPoco = addressMappingList.Where(c => c.Id == Convert.ToInt32(shippingAddressMappingId)).FirstOrDefault(); customerAddressMappingPoco.AddressTypeId = (byte)Enum_AddressType.Shipping; customerAddressMappingPoco.AddressId = addressId; customerAddressMappingPoco.IsDefault = true; _customerAddressMappingLogic.Update(customerAddressMappingPoco); } else { customerAddressMappingPoco = new Lms_CustomerAddressMappingPoco(); customerAddressMappingPoco.CustomerId = customerAddress.CustomerId; customerAddressMappingPoco.AddressId = addressId; customerAddressMappingPoco.AddressTypeId = (byte)Enum_AddressType.Shipping; customerAddressMappingPoco.IsDefault = true; _customerAddressMappingLogic.Add(customerAddressMappingPoco); } } else { Lms_CustomerAddressMappingPoco customerAddressMappingPoco = new Lms_CustomerAddressMappingPoco(); if (customerAddress.AddressTypeId == 1) { if (billingAddressMappingId != "") { customerAddressMappingPoco = addressMappingList.Where(c => c.Id == Convert.ToInt32(billingAddressMappingId)).FirstOrDefault(); customerAddressMappingPoco.AddressId = addressId; customerAddressMappingPoco.IsDefault = true; _customerAddressMappingLogic.Update(customerAddressMappingPoco); } else { customerAddressMappingPoco = new Lms_CustomerAddressMappingPoco(); customerAddressMappingPoco.CustomerId = customerAddress.CustomerId; customerAddressMappingPoco.AddressId = addressId; customerAddressMappingPoco.AddressTypeId = customerAddress.AddressTypeId; customerAddressMappingPoco.IsDefault = true; _customerAddressMappingLogic.Add(customerAddressMappingPoco); } } if (customerAddress.AddressTypeId == 2) { if (shippingAddressMappingId != "") { customerAddressMappingPoco = addressMappingList.Where(c => c.Id == Convert.ToInt32(shippingAddressMappingId)).FirstOrDefault(); customerAddressMappingPoco.AddressId = addressId; customerAddressMappingPoco.IsDefault = true; _customerAddressMappingLogic.Update(customerAddressMappingPoco); } else { customerAddressMappingPoco = new Lms_CustomerAddressMappingPoco(); customerAddressMappingPoco.CustomerId = customerAddress.CustomerId; customerAddressMappingPoco.AddressId = addressId; customerAddressMappingPoco.AddressTypeId = customerAddress.AddressTypeId; customerAddressMappingPoco.IsDefault = true; _customerAddressMappingLogic.Add(customerAddressMappingPoco); } } } } //scope.Complete(); } //} } } catch (Exception ex) { } return(Json(result)); }
public IActionResult Update([FromBody] dynamic customerData) { ValidateSession(); int customerId = 0; int billingAddressId = 0; int shippingAddressId = 0; try { if (customerData != null) { Lms_CustomerPoco customerPoco = JsonConvert.DeserializeObject <Lms_CustomerPoco>(JsonConvert.SerializeObject(customerData[0])); CustomerAddress customerBillingAddress = JsonConvert.DeserializeObject <CustomerAddress>(JsonConvert.SerializeObject(customerData[1])); CustomerAddress customerShippingAddress = JsonConvert.DeserializeObject <CustomerAddress>(JsonConvert.SerializeObject(customerData[2])); if (customerPoco.Id < 1) { return(Json("")); } var existingCustomer = _customerLogic.GetSingleById(customerPoco.Id); if (existingCustomer != null) { existingCustomer.CustomerName = customerPoco.CustomerName; existingCustomer.DiscountPercentage = customerPoco.DiscountPercentage; existingCustomer.FuelSurChargePercentage = customerPoco.FuelSurChargePercentage > 0 ? customerPoco.FuelSurChargePercentage : null; existingCustomer.InvoiceDueDays = customerPoco.InvoiceDueDays; existingCustomer.IsGstApplicable = customerPoco.IsGstApplicable; existingCustomer.IsActive = customerPoco.IsActive; var existingAccountInfo = _chartOfAccountLogic.GetSingleById(existingCustomer.AccountId); existingAccountInfo.AccountName = customerPoco.CustomerName; _chartOfAccountLogic.Update(existingAccountInfo); customerId = _customerLogic.Update(existingCustomer).Id; } customerBillingAddress.CustomerId = customerId; customerShippingAddress.CustomerId = customerId; billingAddressId = AddOrGetAddress(customerBillingAddress); shippingAddressId = AddOrGetAddress(customerShippingAddress); DeleteExistingMappedBillingAddress(customerId); if (billingAddressId > 0) { SetBillingShippingAddress(customerId, billingAddressId, (byte)Enum_AddressType.Billing, true); } DeleteExistingMappedShippingAddress(customerId, shippingAddressId); MakeAllShippingAddressSecondary(customerId); if (shippingAddressId > 0) { SetBillingShippingAddress(customerId, shippingAddressId, (byte)Enum_AddressType.Shipping, true); } } } catch (Exception ex) { } return(Json(customerId.ToString())); }