public string Disable(AgentDTO agent)
{
if (agent == null)
{
return(GenericMessages.ObjectIsNull);
}
string stat;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
_foreignAgentRepository.Update(agent);
_unitOfWork.Commit();
stat = string.Empty;
}
catch (Exception exception)
{
stat = exception.Message;
}
finally
{
iDbContext.Dispose();
}
return(stat);
}
public void InitializeDbContext()
{
var iDbContext = DbContextUtil.GetDbContextInstance();
_clientRepository = new Repository <CompanyDTO>(iDbContext);
_unitOfWork = new UnitOfWork(iDbContext);
}
public bool ObjectExists(BusinessPartnerDTO businessPartner)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var catRepository = new Repository <BusinessPartnerDTO>(iDbContext);
var catExists = catRepository.Query()
.Filter(bp => (bp.DisplayName == businessPartner.DisplayName ||
(!string.IsNullOrEmpty(bp.TinNumber) && bp.TinNumber == businessPartner.TinNumber)) &&
bp.Id != businessPartner.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public string Disable(CategoryDTO category)
{
if (category == null)
{
return(GenericMessages.ObjectIsNull);
}
//var catId = category.Id;
string stat;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
//var items = new Repository<ItemDTO>(iDbContext).Query().Get();
//if (items.Any(i => i.CategoryId == catId || i.UnitOfMeasureId == catId))
//{
// stat = GenericMessages.DatabaseErrorRecordAlreadyInUse;
//}
//else
//{
_categoryRepository.Update(category);
_unitOfWork.Commit();
stat = string.Empty;
//}
}
catch (Exception exception)
{
stat = exception.Message;
}
finally
{
iDbContext.Dispose();
}
return(stat);
}
public void InitializeDbContext()
{
IDbContext iDbContext = DbContextUtil.GetDbContextInstance();
_employeeRepository = new Repository <EmployeeDTO>(iDbContext);
_unitOfWork = new UnitOfWork(iDbContext);
}
public void InitializeDbContext()
{
_iDbContext = DbContextUtil.GetDbContextInstance();
_businessPartnerRepository = new Repository <BusinessPartnerDTO>(_iDbContext);
//_businessPartnerSubscriptionRepository = new Repository<BusinessPartnerSubscriptionDTO>(_iDbContext);
_unitOfWork = new UnitOfWork(_iDbContext);
}
public bool ObjectExists(ItemDTO item)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var catRepository = new Repository <ItemDTO>(iDbContext);
var catExists = catRepository.Query().Filter(bp =>
(bp.DisplayName == item.DisplayName && bp.Number == item.Number) && bp.Id != item.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public TransactionItemsListViewModel()
{
CleanUp();
_unitOfWork = new UnitOfWork(DbContextUtil.GetDbContextInstance());
FilterStartDate = DateTime.Now.AddYears(-1);
FilterEndDate = DateTime.Now.AddDays(1);
Messenger.Default.Register <ItemDTO>(this, (message) => { SelectedItem = message; });
Messenger.Default.Register <TransactionTypes>(this, (message) => { Transaction = message; });
LoadCategories();
GetLiveItems();
GetWarehouses();
if (Warehouses != null && Warehouses.Any())
{
if (SelectedWarehouse == null)
{
SelectedWarehouse = Warehouses.FirstOrDefault(w => w.IsDefault) ?? Warehouses.FirstOrDefault();
}
else
{
SelectedWarehouse = SelectedWarehouse;
}
}
}
public bool ObjectExists(MemberDTO member)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var memRepository = new Repository <MemberDTO>(iDbContext);
var catExists = memRepository
.Query()
.Include(a => a.Address)
.Filter(bp => (bp.Number == member.Number || bp.Address.Mobile == member.Address.Mobile) && bp.Id != member.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public bool ObjectExists(FinancialAccountDTO financialAccount)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var catRepository = new Repository <FinancialAccountDTO>(iDbContext);
var catExists = catRepository
.Query()
.Filter(bp => bp.BankName == financialAccount.BankName && bp.AccountNumber == financialAccount.AccountNumber && bp.Id != financialAccount.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public void InitializeDbContext()
{
var iDbContext = DbContextUtil.GetDbContextInstance();
_financialAccountRepository = new Repository <FinancialAccountDTO>(iDbContext);
_unitOfWork = new UnitOfWork(iDbContext);
}
public void InitializeDbContext()
{
var iDbContext = DbContextUtil.GetDbContextInstance();
_roomResourceRepository = new Repository <RoomResourceDTO>(iDbContext);
_unitOfWork = new UnitOfWork(iDbContext);
}
public bool ObjectExists(EquipmentDTO equipment)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var catRepository = new Repository <EquipmentDTO>(iDbContext);
var catExists = catRepository.Query()
.Filter(bp => (bp.Number == equipment.Number) && bp.Id != equipment.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public void InitializeDbContext()
{
var iDbContext = DbContextUtil.GetDbContextInstance();
_foreignAgentRepository = new Repository <AgentDTO>(iDbContext);
_unitOfWork = new UnitOfWork(iDbContext);
}
public bool ObjectExists(VisaDTO visa)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var visaRepository = new Repository <VisaDTO>(iDbContext);
var visaExists = visaRepository.Query()
.Filter(visaDTO => visaDTO.VisaNumber == visa.VisaNumber && visaDTO.Id != visa.Id)
.Get()
.FirstOrDefault();
if (visaExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public void InitializeDbContext()
{
_iDbContext = DbContextUtil.GetDbContextInstance();
_memberRepository = new Repository <MemberDTO>(_iDbContext);
_memberSubscriptionRepository = new Repository <MemberSubscriptionDTO>(_iDbContext);
_unitOfWork = new UnitOfWork(_iDbContext);
}
public string DisableSponsor(VisaSponsorDTO visaSponsor)
{
if (visaSponsor == null)
{
return(GenericMessages.ObjectIsNull);
}
string stat;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
_visaSponsorRepository.Update(visaSponsor);
_unitOfWork.Commit();
stat = string.Empty;
}
catch (Exception exception)
{
stat = exception.Message;
}
finally
{
iDbContext.Dispose();
}
return(stat);
}
public bool ObjectExists(RentalPaymentDTO rentalPayment)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var catRepository = new Repository <RentalPaymentDTO>(iDbContext);
var catExists =
catRepository.Query()
.Filter(bp => bp.ReceiptNumber == rentalPayment.ReceiptNumber && bp.Id != rentalPayment.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public void InitializeContext()
{
_iDbContext = DbContextUtil.GetDbContextInstance();
_imHeaderRepository = new Repository <ItemsMovementHeaderDTO>(_iDbContext);
_imLineRepository = new Repository <ItemsMovementLineDTO>(_iDbContext);
_unitOfWork = new UnitOfWork(_iDbContext);
}
public void InitializeContext()
{
_iDbContext = DbContextUtil.GetDbContextInstance();
_piHeaderRepository = new Repository <PhysicalInventoryHeaderDTO>(_iDbContext);
_piLineRepository = new Repository <PhysicalInventoryLineDTO>(_iDbContext);
_unitOfWork = new UnitOfWork(_iDbContext);
}
public void InitializeDbContext()
{
var iDbContext = DbContextUtil.GetDbContextInstance();
_itemRepository = new Repository <ItemDTO>(iDbContext);
_unitOfWork = new UnitOfWork(iDbContext);
}
public string Disable(FlightProcessDTO flightProcess)
{
if (flightProcess == null)
{
return(GenericMessages.ObjectIsNull);
}
string stat;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
_flightProcessRepository.Update(flightProcess);
_unitOfWork.Commit();
stat = string.Empty;
}
catch (Exception exception)
{
stat = exception.Message;
}
finally
{
iDbContext.Dispose();
}
return(stat);
}
public string Disable(EmployeeDTO employee)
{
if (employee == null)
{
return(GenericMessages.ObjectIsNull);
}
string stat;
IDbContext iDbContext = DbContextUtil.GetDbContextInstance();
try
{
_employeeRepository.Update(employee);
_unitOfWork.Commit();
stat = string.Empty;
}
catch (Exception exception)
{
stat = exception.Message;
}
finally
{
iDbContext.Dispose();
}
return(stat);
}
public void InitializeDbContext()
{
var iDbContext = DbContextUtil.GetDbContextInstance();
_flightProcessRepository = new Repository <FlightProcessDTO>(iDbContext);
_unitOfWork = new UnitOfWork(iDbContext);
}
//public string Disable(CompanyDTO client)
//{
// if (client == null)
// return GenericMessages.ObjectIsNull;
// try
// {
// _clientRepository.Update(client);
// _unitOfWork.Commit();
// return string.Empty;
// }
// catch (Exception exception)
// {
// return exception.Message;
// }
//}
//public int Delete(string clientId)
//{
// try
// {
// _clientRepository.Delete(clientId);
// _unitOfWork.Commit();
// return 0;
// }
// catch (Exception exception)
// {
// return -1;
// }
//}
public bool ObjectExists(CompanyDTO client)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var catRepository = new Repository <CompanyDTO>(iDbContext);
var catExists = catRepository
.Query()
.Filter(bp => bp.DisplayName == client.DisplayName && bp.Id != client.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public bool ObjectExists(TransactionHeaderDTO transaction)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var catRepository = new Repository <TransactionHeaderDTO>(iDbContext);
var catExists = catRepository
.Query()
.Filter(bp => bp.TransactionNumber == transaction.TransactionNumber && bp.Id != transaction.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public void InitializeDbContext()
{
var iDbContext = DbContextUtil.GetDbContextInstance();
_warehouseRepository = new Repository <WarehouseDTO>(iDbContext);
_unitOfWork = new UnitOfWork(iDbContext);
}
public bool ObjectExists(StorageBinDTO storageBin)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var catRepository = new Repository <StorageBinDTO>(iDbContext);
var catExists = catRepository.Query()
.Filter(bp => (bp.Shelve == storageBin.Shelve || bp.BoxNumber == storageBin.BoxNumber) &&
bp.Id != storageBin.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public string DisableRemark(ComplainRemarkDTO complainRemark)
{
if (complainRemark == null)
{
return(GenericMessages.ObjectIsNull);
}
string stat;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
_complainRemarkRepository.Update(complainRemark);
_unitOfWork.Commit();
stat = string.Empty;
}
catch (Exception exception)
{
stat = exception.Message;
}
finally
{
iDbContext.Dispose();
}
return(stat);
}
public void InitializeDbContext()
{
_iDbContext = DbContextUtil.GetDbContextInstance();
_representeeRepository = new Repository <RepresenteeDTO>(_iDbContext);
//_representeeSubscriptionRepository = new Repository<RepresenteeSubscriptionDTO>(_iDbContext);
_unitOfWork = new UnitOfWork(_iDbContext);
}
