/// <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); }