public List <EmployeeObject> GetEmployees()
{
try
{
var employeeEntityList = _repository.GetAll("UserProfile").ToList();
if (!employeeEntityList.Any())
{
return(new List <EmployeeObject>());
}
var employeeObjList = new List <EmployeeObject>();
employeeEntityList.ForEach(m =>
{
var employeeObject = ModelCrossMapper.Map <Employee, EmployeeObject>(m);
if (employeeObject != null && employeeObject.EmployeeId > 0)
{
employeeObject.Name = m.UserProfile.LastName + " " + m.UserProfile.OtherNames;
employeeObjList.Add(employeeObject);
}
});
return(employeeObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
public List <PaymentTypeObject> Search(string searchCriteria)
{
try
{
var paymentTypeEntityList = _repository.GetAll(m => m.Name.ToLower().Contains(searchCriteria.ToLower())).ToList();
if (!paymentTypeEntityList.Any())
{
return(new List <PaymentTypeObject>());
}
var paymentTypeObjList = new List <PaymentTypeObject>();
paymentTypeEntityList.ForEach(m =>
{
var paymentTypeObject = ModelCrossMapper.Map <PaymentType, PaymentTypeObject>(m);
if (paymentTypeObject != null && paymentTypeObject.PaymentTypeId > 0)
{
paymentTypeObjList.Add(paymentTypeObject);
}
});
return(paymentTypeObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(new List <PaymentTypeObject>());
}
}
public long AddPaymentType(PaymentTypeObject paymentType)
{
try
{
if (paymentType == null)
{
return(-2);
}
var duplicates = _repository.Count(m => m.Name.Trim().ToLower() == paymentType.Name.Trim().ToLower() && (m.PaymentTypeId != paymentType.PaymentTypeId));
if (duplicates > 0)
{
return(-3);
}
var paymentTypeEntity = ModelCrossMapper.Map <PaymentTypeObject, PaymentType>(paymentType);
if (paymentTypeEntity == null || string.IsNullOrEmpty(paymentTypeEntity.Name))
{
return(-2);
}
var returnStatus = _repository.Add(paymentTypeEntity);
_uoWork.SaveChanges();
return(returnStatus.PaymentTypeId);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public StoreContactObject GetStoreContact(long storeContactId)
{
try
{
var myItem = _repository.Get(m => m.StoreContactId == storeContactId, "Person, ContactTag");
if (myItem == null || myItem.StoreContactId < 1)
{
return(new StoreContactObject());
}
var storeContactObject = ModelCrossMapper.Map <StoreContact, StoreContactObject>(myItem);
if (storeContactObject == null || storeContactObject.StoreContactId < 1)
{
return(new StoreContactObject());
}
var personObj = ModelCrossMapper.Map <Person, PersonObject>(myItem.Person);
var contactObj = ModelCrossMapper.Map <ContactTag, ContactTagObject>(myItem.ContactTag);
if (personObj != null && personObj.PersonId > 0 && contactObj != null && contactObj.ContactTagId > 0)
{
storeContactObject.PersonObject = personObj;
storeContactObject.ContactTagObject = contactObj;
return(storeContactObject);
}
return(new StoreContactObject());
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(new StoreContactObject());
}
}
public List <BankAccountObject> GetBankAccounts()
{
try
{
var bankAccountEntityList = _repository.GetAll().ToList();
if (!bankAccountEntityList.Any())
{
return(new List <BankAccountObject>());
}
var bankAccountObjList = new List <BankAccountObject>();
bankAccountEntityList.ForEach(m =>
{
var bankAccountObject = ModelCrossMapper.Map <BankAccount, BankAccountObject>(m);
if (bankAccountObject != null && bankAccountObject.BankAccountId > 0)
{
bankAccountObjList.Add(bankAccountObject);
}
});
return(bankAccountObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
public List<RegisterObject> GetRegisters()
{
try
{
var registerEntityList = _repository.GetAll().ToList();
if (!registerEntityList.Any())
{
return new List<RegisterObject>();
}
var registerObjList = new List<RegisterObject>();
registerEntityList.ForEach(m =>
{
var registerObject = ModelCrossMapper.Map<Register, RegisterObject>(m);
if (registerObject != null && registerObject.RegisterId > 0)
{
registerObjList.Add(registerObject);
}
});
return registerObjList;
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return null;
}
}
public int UpdateRegister(RegisterObject register)
{
try
{
if (register == null)
{
return -2;
}
var duplicates = _repository.Count(m => m.Name.Trim().ToLower().Equals(register.Name.Trim().ToLower()) && register.CurrentOutletId.Equals(m.CurrentOutletId) && (m.RegisterId != register.RegisterId));
if (duplicates > 0)
{
return -3;
}
var registerEntity = ModelCrossMapper.Map<RegisterObject, Register>(register);
if (registerEntity == null || registerEntity.RegisterId < 1)
{
return -2;
}
_repository.Update(registerEntity);
_uoWork.SaveChanges();
return 5;
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return -2;
}
}
public long AddMessagePerm(MessageObject message)
{
try
{
if (message == null)
{
return(-2);
}
var messageEntity = ModelCrossMapper.Map <MessageObject, Message>(message);
if (messageEntity == null)
{
return(-2);
}
using (var db = _db)
{
var returnStatus = db.Messages.Add(messageEntity);
db.SaveChanges();
return(returnStatus.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public List <UnitsOfMeasurementObject> Search(string searchCriteria)
{
try
{
var unitsOfMeasurementEntityList = _repository.GetAll(m => m.UoMCode.ToLower().Contains(searchCriteria.ToLower())).ToList();
if (!unitsOfMeasurementEntityList.Any())
{
return(new List <UnitsOfMeasurementObject>());
}
var unitsOfMeasurementObjList = new List <UnitsOfMeasurementObject>();
unitsOfMeasurementEntityList.ForEach(m =>
{
var unitsOfMeasurementObject = ModelCrossMapper.Map <UnitsOfMeasurement, UnitsOfMeasurementObject>(m);
if (unitsOfMeasurementObject != null && unitsOfMeasurementObject.UnitOfMeasurementId > 0)
{
unitsOfMeasurementObjList.Add(unitsOfMeasurementObject);
}
});
return(unitsOfMeasurementObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(new List <UnitsOfMeasurementObject>());
}
}
public int UpdateCountry(StoreCountryObject country)
{
try
{
if (country == null)
{
return(-2);
}
var duplicates = _repository.Count(m => m.Name.Trim().ToLower() == country.Name.Trim().ToLower() && (m.StoreCountryId != country.StoreCountryId));
if (duplicates > 0)
{
return(-3);
}
var countryEntity = ModelCrossMapper.Map <StoreCountryObject, StoreCountry>(country);
if (countryEntity == null || countryEntity.StoreCountryId < 1)
{
return(-2);
}
_repository.Update(countryEntity);
_uoWork.SaveChanges();
return(5);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(-2);
}
}
public List <MessageObject> GetMessages()
{
try
{
using (var db = _db)
{
var countries = db.Messages.ToList();
if (!countries.Any())
{
return(new List <MessageObject>());
}
var objList = new List <MessageObject>();
countries.ForEach(app =>
{
var messageObject = ModelCrossMapper.Map <Message, MessageObject>(app);
if (messageObject != null && messageObject.Id > 0)
{
objList.Add(messageObject);
}
});
return(!objList.Any() ? new List <MessageObject>() : objList);
}
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
public long AddCountry(StoreCountryObject country)
{
try
{
if (country == null)
{
return(-2);
}
var duplicates = _repository.Count(m => m.Name.Trim().ToLower() == country.Name.Trim().ToLower() && (m.StoreCountryId != country.StoreCountryId));
if (duplicates > 0)
{
return(-3);
}
var countryEntity = ModelCrossMapper.Map <StoreCountryObject, StoreCountry>(country);
if (countryEntity == null || string.IsNullOrEmpty(countryEntity.Name))
{
return(-2);
}
var returnStatus = _repository.Add(countryEntity);
_uoWork.SaveChanges();
return(returnStatus.StoreCountryId);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public List <StoreCountryObject> GetCountries()
{
try
{
var countryEntityList = _repository.GetAll().ToList();
if (!countryEntityList.Any())
{
return(new List <StoreCountryObject>());
}
var countryObjList = new List <StoreCountryObject>();
countryEntityList.ForEach(m =>
{
var countryObject = ModelCrossMapper.Map <StoreCountry, StoreCountryObject>(m);
if (countryObject != null && countryObject.StoreCountryId > 0)
{
countryObjList.Add(countryObject);
}
});
return(countryObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
public List <StoreCountryObject> Search(string searchCriteria)
{
try
{
var countryEntityList = _repository.GetAll(m => m.Name.ToLower().Contains(searchCriteria.ToLower())).ToList();
if (!countryEntityList.Any())
{
return(new List <StoreCountryObject>());
}
var countryObjList = new List <StoreCountryObject>();
countryEntityList.ForEach(m =>
{
var countryObject = ModelCrossMapper.Map <StoreCountry, StoreCountryObject>(m);
if (countryObject != null && countryObject.StoreCountryId > 0)
{
countryObjList.Add(countryObject);
}
});
return(countryObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(new List <StoreCountryObject>());
}
}
public int UpdateJobRole(JobRoleObject jobRole)
{
try
{
if (jobRole == null)
{
return(-2);
}
var duplicates = _repository.Count(m => m.JobTitle.Trim().ToLower() == jobRole.JobTitle.Trim().ToLower() && (m.JobRoleId != jobRole.JobRoleId));
if (duplicates > 0)
{
return(-3);
}
var jobRoleEntity = ModelCrossMapper.Map <JobRoleObject, JobRole>(jobRole);
if (jobRoleEntity == null || jobRoleEntity.JobRoleId < 1)
{
return(-2);
}
_repository.Update(jobRoleEntity);
_uoWork.SaveChanges();
return(5);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(-2);
}
}
public List <UnitsOfMeasurementObject> GetUnitsofMeasurement()
{
try
{
var unitsOfMeasurementEntityList = _repository.GetAll().ToList();
if (!unitsOfMeasurementEntityList.Any())
{
return(new List <UnitsOfMeasurementObject>());
}
var unitsOfMeasurementObjList = new List <UnitsOfMeasurementObject>();
unitsOfMeasurementEntityList.ForEach(m =>
{
var unitsOfMeasurementObject = ModelCrossMapper.Map <UnitsOfMeasurement, UnitsOfMeasurementObject>(m);
if (unitsOfMeasurementObject != null && unitsOfMeasurementObject.UnitOfMeasurementId > 0)
{
unitsOfMeasurementObjList.Add(unitsOfMeasurementObject);
}
});
return(unitsOfMeasurementObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
public List<RegisterObject> Search(string searchCriteria)
{
try
{
var registerEntityList = _repository.GetAll(m => m.Name.ToLower().Contains(searchCriteria.ToLower()), "StoreOutlet").ToList();
if (!registerEntityList.Any())
{
return new List<RegisterObject>();
}
var registerObjList = new List<RegisterObject>();
registerEntityList.ForEach(m =>
{
var registerObject = ModelCrossMapper.Map<Register, RegisterObject>(m);
if (registerObject != null && registerObject.RegisterId > 0)
{
registerObject.OutletName = m.StoreOutlet.OutletName;
registerObjList.Add(registerObject);
}
});
return registerObjList;
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return new List<RegisterObject>();
}
}
public long AddUnitsOfMeasurement(UnitsOfMeasurementObject unitsOfMeasurement)
{
try
{
if (unitsOfMeasurement == null)
{
return(-2);
}
var duplicates = _repository.Count(m => m.UoMCode.Trim().ToLower() == unitsOfMeasurement.UoMCode.Trim().ToLower());
if (duplicates > 0)
{
return(-3);
}
var unitsOfMeasurementEntity = ModelCrossMapper.Map <UnitsOfMeasurementObject, UnitsOfMeasurement>(unitsOfMeasurement);
if (unitsOfMeasurementEntity == null || string.IsNullOrEmpty(unitsOfMeasurementEntity.UoMCode))
{
return(-2);
}
var returnStatus = _repository.Add(unitsOfMeasurementEntity);
_uoWork.SaveChanges();
return(returnStatus.UnitOfMeasurementId);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public long AddRegister(RegisterObject register)
{
try
{
if (register == null)
{
return -2;
}
var duplicates = _repository.Count(m => m.Name.Trim().ToLower().Equals(register.Name.Trim().ToLower()) && register.CurrentOutletId.Equals(m.CurrentOutletId));
if (duplicates > 0)
{
return -3;
}
var registerEntity = ModelCrossMapper.Map<RegisterObject, Register>(register);
if (registerEntity == null || string.IsNullOrEmpty(registerEntity.Name))
{
return -2;
}
var returnStatus = _repository.Add(registerEntity);
_uoWork.SaveChanges();
return returnStatus.RegisterId;
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return 0;
}
}
public int UpdateUnitsOfMeasurement(UnitsOfMeasurementObject unitsOfMeasurement)
{
try
{
if (unitsOfMeasurement == null)
{
return(-2);
}
var duplicates = _repository.Count(m => m.UoMCode.Trim().ToLower() == unitsOfMeasurement.UoMCode.Trim().ToLower() && (m.UnitOfMeasurementId != unitsOfMeasurement.UnitOfMeasurementId));
if (duplicates > 0)
{
return(-3);
}
var unitsOfMeasurementEntity = ModelCrossMapper.Map <UnitsOfMeasurementObject, UnitsOfMeasurement>(unitsOfMeasurement);
if (unitsOfMeasurementEntity == null || unitsOfMeasurementEntity.UnitOfMeasurementId < 1)
{
return(-2);
}
_repository.Update(unitsOfMeasurementEntity);
_uoWork.SaveChanges();
return(5);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(-2);
}
}
public List <StoreContactObject> GetStoreContacts()
{
try
{
var storeContactEntityList = _repository.GetAll().ToList();
if (!storeContactEntityList.Any())
{
return(new List <StoreContactObject>());
}
var storeContactObjList = new List <StoreContactObject>();
storeContactEntityList.ForEach(m =>
{
var storeContactObject = ModelCrossMapper.Map <StoreContact, StoreContactObject>(m);
if (storeContactObject != null && storeContactObject.StoreContactId > 0)
{
storeContactObjList.Add(storeContactObject);
}
});
return(storeContactObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
public List <StoreItemSoldObject> GetStoreItemSolds()
{
try
{
var itemSoldEntityList = _repository.GetAll().ToList();
if (!itemSoldEntityList.Any())
{
return(new List <StoreItemSoldObject>());
}
var itemSoldObjList = new List <StoreItemSoldObject>();
itemSoldEntityList.ForEach(m =>
{
var itemSoldObject = ModelCrossMapper.Map <StoreItemSold, StoreItemSoldObject>(m);
if (itemSoldObject != null && itemSoldObject.StoreItemSoldId > 0)
{
itemSoldObjList.Add(itemSoldObject);
}
});
return(itemSoldObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
public List <BankAccountObject> Search(string searchCriteria)
{
try
{
long accountNo;
var res = long.TryParse(searchCriteria, out accountNo);
var bankAccountEntityList = res && accountNo > 0 ? _repository.GetAll(m => m.AccountName.ToLower().Contains(searchCriteria.ToLower()) || m.AccountNo.Equals(accountNo), "StoreBank").ToList() : _repository.GetAll(m => m.AccountName.ToLower().Contains(searchCriteria.ToLower()), "StoreBank").ToList();
if (!bankAccountEntityList.Any())
{
return(new List <BankAccountObject>());
}
var bankAccountObjList = new List <BankAccountObject>();
bankAccountEntityList.ForEach(m =>
{
var bankAccountObject = ModelCrossMapper.Map <BankAccount, BankAccountObject>(m);
if (bankAccountObject != null && bankAccountObject.BankAccountId > 0)
{
bankAccountObject.BankName = m.StoreBank.FullName;
bankAccountObjList.Add(bankAccountObject);
}
});
return(bankAccountObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(new List <BankAccountObject>());
}
}
public List <JobRoleObject> Search(string searchCriteria)
{
try
{
var jobRoleEntityList = _repository.GetAll(m => m.JobTitle.ToLower().Contains(searchCriteria.ToLower())).ToList();
if (!jobRoleEntityList.Any())
{
return(new List <JobRoleObject>());
}
var jobRoleObjList = new List <JobRoleObject>();
jobRoleEntityList.ForEach(m =>
{
var jobRoleObject = ModelCrossMapper.Map <JobRole, JobRoleObject>(m);
if (jobRoleObject != null && jobRoleObject.JobRoleId > 0)
{
jobRoleObjList.Add(jobRoleObject);
}
});
return(jobRoleObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(new List <JobRoleObject>());
}
}
public Int32 UpdateBankAccount(BankAccountObject bankAccount)
{
try
{
if (bankAccount == null)
{
return(-2);
}
if (_repository.Count(m => m.CustomerId == bankAccount.CustomerId && m.BankId == bankAccount.BankId && m.AccountName == bankAccount.AccountName && m.AccountNo == bankAccount.AccountNo && (m.BankAccountId != bankAccount.BankAccountId)) > 0)
{
return(-3);
}
var bankAccountEntity = ModelCrossMapper.Map <BankAccountObject, BankAccount>(bankAccount);
if (bankAccountEntity == null || bankAccountEntity.BankAccountId < 1)
{
return(-2);
}
_repository.Update(bankAccountEntity);
_uoWork.SaveChanges();
return(5);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(-2);
}
}
public List <JobRoleObject> GetJobRoles()
{
try
{
var jobRoleEntityList = _repository.GetAll().ToList();
if (!jobRoleEntityList.Any())
{
return(new List <JobRoleObject>());
}
var jobRoleObjList = new List <JobRoleObject>();
jobRoleEntityList.ForEach(m =>
{
var jobRoleObject = ModelCrossMapper.Map <JobRole, JobRoleObject>(m);
if (jobRoleObject != null && jobRoleObject.JobRoleId > 0)
{
jobRoleObjList.Add(jobRoleObject);
}
});
return(jobRoleObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
public List <PaymentTypeObject> GetPaymentTypes()
{
try
{
var paymentTypeEntityList = _repository.GetAll().ToList();
if (!paymentTypeEntityList.Any())
{
return(new List <PaymentTypeObject>());
}
var paymentTypeObjList = new List <PaymentTypeObject>();
paymentTypeEntityList.ForEach(m =>
{
var paymentTypeObject = ModelCrossMapper.Map <PaymentType, PaymentTypeObject>(m);
if (paymentTypeObject != null && paymentTypeObject.PaymentTypeId > 0)
{
paymentTypeObjList.Add(paymentTypeObject);
}
});
return(paymentTypeObjList);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(null);
}
}
public long AddJobRole(JobRoleObject jobRole)
{
try
{
if (jobRole == null)
{
return(-2);
}
var duplicates = _repository.Count(m => m.JobTitle.Trim().ToLower() == jobRole.JobTitle.Trim().ToLower() && (m.JobRoleId != jobRole.JobRoleId));
if (duplicates > 0)
{
return(-3);
}
var jobRoleEntity = ModelCrossMapper.Map <JobRoleObject, JobRole>(jobRole);
if (jobRoleEntity == null || string.IsNullOrEmpty(jobRoleEntity.JobTitle))
{
return(-2);
}
var returnStatus = _repository.Add(jobRoleEntity);
_uoWork.SaveChanges();
return(returnStatus.JobRoleId);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public int UpdatePaymentType(PaymentTypeObject paymentType)
{
try
{
if (paymentType == null)
{
return(-2);
}
var duplicates = _repository.Count(m => m.Name.Trim().ToLower() == paymentType.Name.Trim().ToLower() && (m.PaymentTypeId != paymentType.PaymentTypeId));
if (duplicates > 0)
{
return(-3);
}
var paymentTypeEntity = ModelCrossMapper.Map <PaymentTypeObject, PaymentType>(paymentType);
if (paymentTypeEntity == null || paymentTypeEntity.PaymentTypeId < 1)
{
return(-2);
}
_repository.Update(paymentTypeEntity);
_uoWork.SaveChanges();
return(5);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(-2);
}
}
public int UpdateImageView(ImageViewObject imageView)
{
try
{
if (imageView == null)
{
return(-2);
}
var duplicates = _repository.Count(m => m.Name.Trim().ToLower() == imageView.Name.Trim().ToLower() && (m.ImageViewId != imageView.ImageViewId));
if (duplicates > 0)
{
return(-3);
}
var imageViewEntity = ModelCrossMapper.Map <ImageViewObject, ImageView>(imageView);
if (imageViewEntity == null || imageViewEntity.ImageViewId < 1)
{
return(-2);
}
_repository.Update(imageViewEntity);
_uoWork.SaveChanges();
return(5);
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(-2);
}
}
