public List<GuardPaymentViewModel> GetGuardPaymentReport(int GuardId)
        {
            using (SecurityAgencyEntities objSecurityAgencyEntities = new SecurityAgencyEntities())
            {
                List<getGuardPayment_Result> objectGuard = objSecurityAgencyEntities.getGuardPayment().ToList();

                if (objectGuard == null)
                    return null;

                if (GuardId!=0)
                {
                    objectGuard = objectGuard.Where(i => i.Guardid == GuardId).ToList();
                }
                

                Mapper.CreateMap<getGuardPayment_Result, GuardPaymentViewModel>();
                return Mapper.Map<List<getGuardPayment_Result>, List<GuardPaymentViewModel>>(objectGuard);
            }
        }