Пример #1
0
        /// <summary>
        /// Get company name by company id
        /// </summary>
        /// <param name="id">company id</param>
        /// <returns>company name</returns>
        public string GetCompanyNameByID(int id)
        {
            string companyName = string.Empty;

            OACompany company = mdbDataContext.OACompanies.Where(c => c.ID == id).SingleOrDefault();

            if (company != null)
            {
                companyName = company.CompanyName;
            }

            return(companyName);
        }
Пример #2
0
        /// <summary>
        /// Check whether division is associated with company
        /// </summary>
        /// <param name="divisionVO">division Value Object</param>
        /// <returns></returns>
        public DivisionVO IsDivisionActivatedInCompany(DivisionVO divisionVO)
        {
            Division division = mdbDataContext.Divisions.Where(div => div.DivisionName.Equals(divisionVO.DivisionName) && (div.IsActive == true) && div.CompanyID != divisionVO.CompanyId).SingleOrDefault();

            DivisionVO selectedDivision = null;

            if (division != null)
            {
                selectedDivision = new DivisionVO(division);

                //set the company name
                OACompany company = mdbDataContext.OACompanies.SingleOrDefault(oac => oac.ID == selectedDivision.CompanyId);
                selectedDivision.CompanyName = company.CompanyName;
            }
            return(selectedDivision);
        }
Пример #3
0
        /// <summary>
        /// Gets Divisiondetails by DivisionId
        /// </summary>
        /// <param name="DivisionId">Division Id</param>
        /// <returns>Division details</returns>
        public DivisionVO GetDivisionById(int DivisionId = 0)
        {
            Division   division   = mdbDataContext.Divisions.SingleOrDefault(c => c.ID == DivisionId);
            DivisionVO divisionVO = null;

            if (division != null)
            {
                divisionVO = new DivisionVO(division);

                //set the company name
                OACompany company = mdbDataContext.OACompanies
                                    .SingleOrDefault(oac => oac.ID == division.CompanyID);
                divisionVO.CompanyName = company.CompanyName;
            }
            return(divisionVO);
        }
Пример #4
0
        /// <summary>
        /// Gets the Profitloss details by profitloss id.
        /// </summary>
        /// <param name="profitlossId">profitlossid</param>
        /// <returns>Profitloss details</returns>
        public ProfitLossVO GetPandLbyId(int profitlossId = 0)
        {
            P_LMapping   profitloss   = mdbDataContext.P_LMappings.SingleOrDefault(c => c.ID == profitlossId);
            ProfitLossVO profitlossVO = null;

            if (profitloss != null)
            {
                profitlossVO = new ProfitLossVO(profitloss);

                //Set the Costcenter Name
                OACostCentre costcenter = mdbDataContext.OACostCentres.FirstOrDefault(oac => oac.ID == profitloss.CostCentreID);
                profitlossVO.CostCenterName = costcenter.CostCentreName;

                //set the company name
                OACompany company = mdbDataContext.OACompanies.SingleOrDefault(oac => oac.ID == profitloss.CompanyID);
                profitlossVO.CompanyName = company.CompanyName;
            }
            return(profitlossVO);
        }
Пример #5
0
        /// <summary>
        /// Gets the CostCenter by CostCenterId
        /// </summary>
        /// <param name="costCentreId">CostCenter Id</param>
        /// <param name="companyId">Company Id</param>
        /// <returns>Return value object of P&L</returns>
        public ProfitLossVO GetCostCenterById(int costCentreId, int companyId)
        {
            P_LMapping profitLoss = mdbDataContext.P_LMappings.Where(c => c.CostCentreID == costCentreId && c.CompanyID == companyId && c.IsDeleted == false).SingleOrDefault();

            ProfitLossVO selectedProfitLoss = null;

            if (profitLoss != null)
            {
                selectedProfitLoss = new ProfitLossVO(profitLoss);

                //Set the Costcenter Name
                OACostCentre costcenter = mdbDataContext.OACostCentres.FirstOrDefault(oac => oac.ID == costCentreId);
                selectedProfitLoss.CostCenterName = costcenter.CostCentreName;

                //set the company name
                OACompany company = mdbDataContext.OACompanies.SingleOrDefault(oac => oac.ID == companyId);
                selectedProfitLoss.CompanyName = company.CompanyName;
            }
            return(selectedProfitLoss);
        }
Пример #6
0
 /// <summary>
 /// Constructor
 /// </summary>
 public CompanyVO(OACompany company)
 {
     Name      = company.CompanyName;
     CompanyID = company.ID;
 }