public string Disable(BusinessPartnerDTO businessPartner)
{
if (_unitOfWork.Repository <TransactionHeaderDTO>().Query().Get().Any(i => i.BusinessPartnerId == businessPartner.Id) ||
_unitOfWork.Repository <FinancialAccountDTO>().Query().Get().Any(i => i.BusinessPartnerId == businessPartner.Id))
{
return("Can't delete the item, it is already in use...");
}
if (businessPartner == null)
{
return(GenericMessages.ObjectIsNull);
}
string stat;
try
{
_businessPartnerRepository.Update(businessPartner);
_unitOfWork.Commit();
stat = string.Empty;
}
catch (Exception exception)
{
stat = exception.Message;
}
return(stat);
}
public async Task <string> InsertOrUpdateAync(BusinessPartnerDTO businessPartner)
{
try
{
var validate = Validate(businessPartner);
if (!string.IsNullOrEmpty(validate))
{
return(validate);
}
if (ObjectExists(businessPartner))
{
return(GenericMessages.DatabaseErrorRecordAlreadyExists + Environment.NewLine +
"With the same Name/Tin No. Exists");
}
_businessPartnerRepository.InsertUpdate(businessPartner);
await _unitOfWork.CommitAync();
return(string.Empty);
}
catch (Exception exception)
{
return(exception.Message);
}
}
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(BusinessPartnerDTO businessPartner)
{
//if (_unitOfWork.Repository<DeliveryHeaderDTO>().Query().Get().Any(i => i.BusinessPartnerId == BusinessPartner.Id) ||
// _unitOfWork.Repository<DocumentDTO>().Query().Get().Any(i => i.BusinessPartnerId == BusinessPartner.Id))
//{
// return "Can't delete the item, it is already in use...";
//}
if (businessPartner == null)
{
return(GenericMessages.ObjectIsNull);
}
string stat;
try
{
_businessPartnerRepository.Update(businessPartner);
_unitOfWork.Commit();
stat = string.Empty;
}
catch (Exception exception)
{
stat = exception.Message;
}
return(stat);
}
public string InsertOrUpdate(BusinessPartnerDTO businessPartner)
{
try
{
var validate = Validate(businessPartner);
if (!string.IsNullOrEmpty(validate))
{
return(validate);
}
if (ObjectExists(businessPartner))
{
return(GenericMessages.DatabaseErrorRecordAlreadyExists + Environment.NewLine +
"with the same Name/Tin No. Exists");
}
_businessPartnerRepository.InsertUpdate(businessPartner);
_unitOfWork.Commit();
//Generate Business Partner Code
if (string.IsNullOrEmpty(businessPartner.Code))
{
return(GetBusinessPartnerCode(businessPartner));
}
return(string.Empty);
}
catch (Exception exception)
{
return(exception.Message);
}
}
public string Validate(BusinessPartnerDTO BusinessPartner)
{
if (null == BusinessPartner)
{
return(GenericMessages.ObjectIsNull);
}
if (BusinessPartner.Address == null)
{
return("Address " + GenericMessages.ObjectIsNull);
}
if (String.IsNullOrEmpty(BusinessPartner.DisplayName))
{
return(BusinessPartner.DisplayName + " " + GenericMessages.StringIsNullOrEmpty);
}
if (BusinessPartner.DisplayName.Length > 255)
{
return(BusinessPartner.DisplayName + " can not be more than 255 characters ");
}
if (!string.IsNullOrEmpty(BusinessPartner.Number) && BusinessPartner.Number.Length > 50)
{
return(BusinessPartner.Number + " can not be more than 50 characters ");
}
return(string.Empty);
}
public AddPayment(BusinessPartnerDTO customerDTO, WarehouseDTO warehouseDTO)
{
AddPaymentViewModel.Errors = 0;
InitializeComponent();
Messenger.Default.Send <WarehouseDTO>(warehouseDTO);
Messenger.Default.Send <BusinessPartnerDTO>(customerDTO);
}
public PaymentList(TransactionTypes transaction, BusinessPartnerDTO businessPartner, PaymentListTypes listType)
{
InitializeComponent();
Messenger.Default.Send <BusinessPartnerDTO>(businessPartner);
Messenger.Default.Send <PaymentListTypes>(listType);
Messenger.Default.Send <TransactionTypes>(transaction);
Messenger.Reset();
}
// Busca o nome do parceiro de negócios no SQL Server
private static String ObterNomeCliente(DataConnector connector, String cardCode)
{
BusinessPartnerDAO businessPartnerDAO = new BusinessPartnerDAO(connector.SqlServerConnection);
BusinessPartnerDTO businessPartner = businessPartnerDAO.GetBusinessPartner(cardCode);
String informacaoAdicional = "";
if (businessPartner.CardName != businessPartner.CardFName)
{
informacaoAdicional = " (" + businessPartner.CardFName + ")";
}
String cliente = businessPartner.CardName + informacaoAdicional;
return(cliente);
}
private void AddNewBusinessPartner()
{
GetNewSelectedBusinessPartnerAddress();
GetNewSelectedBusinessPartnerContact();
SelectedBusinessPartner = new BusinessPartnerDTO
{
BusinessPartnerType = BusinessPartnerType,
CreditLimit = 0,
MaxNoCreditTransactions = 0,
PaymentTerm = 0,
AllowCreditsWithoutCheck = true,
//Addresses = new[] { SelectedBusinessPartnerAddress }
};
}
public string GetBusinessPartnerCode(BusinessPartnerDTO businessPartner)
{
var bpCode = "";
try
{
var prefix = businessPartner.BusinessPartnerType.ToString().Substring(0, 1);
var code = 10000 + businessPartner.Id;
businessPartner.Code = prefix + code.ToString(CultureInfo.InvariantCulture).Substring(1);
_businessPartnerRepository.InsertUpdate(businessPartner);
_unitOfWork.Commit();
}
catch (Exception exception)
{
bpCode = "Problem Getting Partner Number, try again..." + Environment.NewLine + exception.InnerException.Message;
}
return(bpCode);
}
private void AddNewBusinessPartner()
{
try
{
SelectedBusinessPartner = new BusinessPartnerDTO
{
BusinessPartnerType = BusinessPartnerTypes.Supplier,
Category = BusinessPartnerCategory.Organization,
Address = new AddressDTO
{
Country = "ኢትዮጲያ",
City = "አዲስ አበባ"
},
};
}
catch (Exception)
{
//MessageBox.Show("Problem on adding new BusinessPartner");
}
}
/// <summary>
/// Obtem um parceiro de negócio a partir de seu código
/// </summary>
public BusinessPartnerDTO GetBusinessPartner(String cardCode)
{
String query = "SELECT CardCode, CardName, CardFName, CntctPrsn FROM OCRD WHERE CardCode = '" + cardCode + "'";
SqlCommand command = new SqlCommand(query, sqlServerConnection);
SqlDataReader dataReader = command.ExecuteReader();
if (!dataReader.Read())
{
return(null);
}
BusinessPartnerDTO businessPartner = new BusinessPartnerDTO();
businessPartner.CardCode = GetStringValue(dataReader, "CardCode");
businessPartner.CardName = GetStringValue(dataReader, "CardName");
businessPartner.CardFName = GetStringValue(dataReader, "CardFName");
businessPartner.CntctPrsn = GetStringValue(dataReader, "CntctPrsn");
dataReader.Close();
return(businessPartner);
}
/// <summary>
/// Obtem o parceiro de negócio responsável pelo transporte de mercadorias
/// </summary>
public BusinessPartnerDTO GetDefaultCarrier()
{
String subQuery = "SELECT GroupCode FROM OCRG WHERE GroupName = 'Transportadora'";
String query = "SELECT CardCode, CardName, CardFName, CntctPrsn FROM OCRD WHERE GroupCode = (" + subQuery + ") ORDER BY UpdateDate ASC";
SqlCommand command = new SqlCommand(query, sqlServerConnection);
SqlDataReader dataReader = command.ExecuteReader();
if (!dataReader.Read())
{
return(null);
}
BusinessPartnerDTO businessPartner = new BusinessPartnerDTO();
businessPartner.CardCode = GetStringValue(dataReader, "CardCode");
businessPartner.CardName = GetStringValue(dataReader, "CardName");
businessPartner.CardFName = GetStringValue(dataReader, "CardFName");
businessPartner.CntctPrsn = GetStringValue(dataReader, "CntctPrsn");
dataReader.Close();
return(businessPartner);
}
public string Validate(BusinessPartnerDTO businessPartner)
{
if (null == businessPartner)
{
return(GenericMessages.ObjectIsNull);
}
if (String.IsNullOrEmpty(businessPartner.DisplayName))
{
return(businessPartner.DisplayName + " " + GenericMessages.StringIsNullOrEmpty);
}
if (businessPartner.DisplayName.Length > 255)
{
return(businessPartner.DisplayName + " can not be more than 255 characters ");
}
if (!string.IsNullOrEmpty(businessPartner.Code) && businessPartner.Code.Length > 50)
{
return(businessPartner.Code + " can not be more than 50 characters ");
}
return(string.Empty);
}
public static IDbContext Seed(IDbContext context)
{
#region Setting Seeds
context.Set <SettingDTO>().Add(new SettingDTO()
{
Id = 1,
CheckCreditLimit = false,
HandleBankTransaction = false,
TaxType = TaxTypes.NoTax,
TaxPercent = 0
});
#endregion
#region Business Partner Seeds
if (Singleton.Edition != AMStockEdition.OnlineEdition)
{
#region Customer
var bp = new BusinessPartnerDTO()
{
Id = 1,
BusinessPartnerType = BusinessPartnerTypes.Customer,
Code = "C0001",
DisplayName = "_Walking Customer",
CreditLimit = 0,
MaxNoCreditTransactions = 0,
PaymentTerm = 0,
AllowCreditsWithoutCheck = false,
};
context.Set <BusinessPartnerAddressDTO>().Add(new BusinessPartnerAddressDTO
{
Address = CommonUtility.GetDefaultAddress(),
BusinessPartner = bp
});
context.Set <BusinessPartnerContactDTO>().Add(new BusinessPartnerContactDTO
{
Contact = new ContactDTO()
{
FullName = "ibra yas",
Address = CommonUtility.GetDefaultAddress(),
},
BusinessPartner = bp
});
#endregion
#region Supplier
var sbp = new BusinessPartnerDTO()
{
BusinessPartnerType = BusinessPartnerTypes.Supplier,
Code = "S0001",
DisplayName = "_Common Supplier",
CreditLimit = 0,
MaxNoCreditTransactions = 0,
PaymentTerm = 0,
AllowCreditsWithoutCheck = true,
};
context.Set <BusinessPartnerAddressDTO>().Add(new BusinessPartnerAddressDTO
{
Address = CommonUtility.GetDefaultAddress(),
BusinessPartner = sbp
});
context.Set <BusinessPartnerContactDTO>().Add(new BusinessPartnerContactDTO
{
Contact = new ContactDTO()
{
FullName = "ibra yas",
Address = CommonUtility.GetDefaultAddress(),
},
BusinessPartner = sbp
});
#endregion
}
#endregion
#region List Seeds
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Category, DisplayName = "No Category"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.UnitMeasure, DisplayName = "Pcs"
});
#endregion
#region Bank Seeds
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Commercial Bank of Ethiopia"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Dashen Bank"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Awash Bank"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "United Bank"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Nib Bank"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Buna International Bank"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Wegagen Bank"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Abyssinia Bank"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Abay Bank"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Birhan Bank"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Enat Bank"
});
context.Set <CategoryDTO>().Add(new CategoryDTO {
NameType = NameTypes.Bank, DisplayName = "Lion Bank"
});
#endregion
return(context);
}
