/// <summary>
/// Transpose OACustomer LINQ object to value object
/// </summary>
/// <param name="oaCustomer"></param>
public EndUserVO(OACustomer oaCustomer)
{
ID = oaCustomer.ID;
EndUserId = oaCustomer.ID.ToString();
Name = oaCustomer.CustomerName;
CompanyId = oaCustomer.CompanyID;
EndUserNameWithCustomerCode = oaCustomer.CustomerName + " - " + oaCustomer.CustomerID + " - " +
oaCustomer.ShortName;
}
/// <summary>
/// Gets the list of Contracts
/// </summary>
/// <param name="companyId">company id</param>
/// <param name="invoiceCustomerId">invoicecustomer id</param>
/// <returns>List of contracts</returns>
public List <ContractVO> GetContractList(int companyId, int?invoiceCustomerId)
{
List <Contract> contracts = null;
if (invoiceCustomerId != -1)
{
contracts = mdbDataContext.Contracts.Where(c => c.CompanyID == companyId && c.InvoiceCustomerID == invoiceCustomerId && c.IsDeleted == false).ToList();
}
else
{
contracts = mdbDataContext.Contracts.Where(c => c.CompanyID == companyId && c.IsDeleted == false).ToList();
}
List <ContractVO> contractVOList = new List <ContractVO>();
List <EndUser> endUsers =
mdbDataContext.EndUsers.Where(e => e.IsDeleted == false && e.BusinessPartner.CompanyID == companyId)
.ToList();
//Get all invoice customers associated with company
List <OACustomer> invoiceCustomerList = mdbDataContext.OACustomers.Where(x => x.CompanyID == companyId).ToList();
int enduserId = 0;
OACustomer customer = null;
foreach (var item in contracts)
{
ContractVO contractVO = new ContractVO(item);
//If enduser is not invoice customer
if (contractVO.EndUserId.StartsWith("E"))
{
EndUser endUser = endUsers.FirstOrDefault(c => c.EndUserTextID == contractVO.EndUserId);
if (endUser != null)
{
contractVO.EndUserName = endUser.EndUserName;
}
}
else
{
//If enduser is invoice customer
if (contractVO.EndUserId != contractVO.InvoiceCustomerId.ToString())
{
enduserId = Convert.ToInt32(contractVO.EndUserId);
customer = invoiceCustomerList.FirstOrDefault(x => x.ID == enduserId);
contractVO.EndUserName = (customer != null) ? customer.CustomerName : contractVO.EndUserName;
}
}
contractVOList.Add(contractVO);
}
return(contractVOList);
}
/// <summary>
/// Transpose Model object to value object
/// </summary>
/// <param name="endUser"></param>
//public InvoiceCustomerVO(MODEL.InvoiceCustomer invoiceCustomer)
//{
// InvoiceCustomerId = invoiceCustomer.ID;
// OACustomerId = invoiceCustomer.OACustomerId;
// CompanyId = invoiceCustomer.CompanyId;
// CompanyName = invoiceCustomer.CompanyName;
// Name = invoiceCustomer.Name;
// CurrencyId = invoiceCustomer.CurrencyId;
// ShortName = invoiceCustomer.ShortName;
// CustomerandOACustomerId = Name + " - " + OACustomerId;
// CustomerNameCodeAndShortName = Name + " - " + OACustomerId + " - " + ShortName;
//}
/// <summary>
/// Transpose LINQ object to value object
/// </summary>
/// <param name="endUser"></param>
public InvoiceCustomerVO(OACustomer invoiceCustomer)
{
InvoiceCustomerId = invoiceCustomer.ID;
OACustomerId = invoiceCustomer.CustomerID;
CompanyId = invoiceCustomer.CompanyID;
CompanyName = invoiceCustomer.OACompany.CompanyName;
Name = invoiceCustomer.CustomerName;
CurrencyId = invoiceCustomer.CurrencyID;
CustomerandOACustomerId = Name + " - " + OACustomerId;
ShortName = invoiceCustomer.ShortName;
CustomerNameCodeAndShortName = Name + " - " + OACustomerId + " - " + ShortName;
}
/// <summary>
/// Get the invoice customer name from OAcustomer table
/// </summary>
/// <param name="id">invoice customer id</param>
/// <returns>invoice customer name</returns>
public string GetInvoiceCustomerNameByID(string id, int?companyId)
{
//TO DO:- Need to get end invoice customer name by company id
OACustomer invoiceCustomer = mdbDataContext.OACustomers.Where(cust => cust.ID.Equals(id) && cust.CompanyID == companyId && cust.IsDeleted == false).SingleOrDefault();
if (invoiceCustomer == null)
{
return(string.Empty);
}
return(invoiceCustomer.CustomerName);
}
/// <summary>
/// Get currecny based on invoice customer id
/// </summary>
/// <param name="invoiceCustomerId">invoice customer Id</param>
/// <returns>invoice customer VO object</returns>
public InvoiceCustomerVO GetCurrencyByCustomer(int invoiceCustomerId)
{
InvoiceCustomerVO invoiceCustomerVO = null;
OACustomer invoiceCustomer = mdbDataContext.OACustomers.Where(x => x.ID == invoiceCustomerId).SingleOrDefault();
if (invoiceCustomer != null)
{
invoiceCustomerVO = new InvoiceCustomerVO();
invoiceCustomerVO.CurrencyId = invoiceCustomer.CurrencyID;
}
return(invoiceCustomerVO);
}
/// <summary>
/// to get end user name based on Id
/// </summary>
/// <param name="endUserId"></param>
/// <returns></returns>
public string GetEndUserName(string endUserId)
{
//to get end user details from EndUser table
EndUser endUser = mdbDataContext.EndUsers.Where(c => c.EndUserTextID == endUserId && c.IsDeleted == false).SingleOrDefault();
string endUserName = string.Empty;
if (endUser == null)
{
//to get customer name from OACustomer table
OACustomer oaCustomer = mdbDataContext.OACustomers.Where(c => c.ID == Convert.ToInt32(endUserId) && c.IsDeleted == false).SingleOrDefault();
endUserName = oaCustomer.CustomerName;
}
else
{
endUserName = endUser.EndUserName;
}
return(endUserName);
}
