コード例 #1
0
        public IHttpActionResult GetAllLs()
        {
            IList <StudentViewModel> lss = null;

            //allStudents[] allStudents;

            using (var ctx = new EMSEntities())
            {
                lss = ctx.spAllCurrentStudents().Select(s => new StudentViewModel()
                {
                    TRNNO    = s.TRNNO,
                    EMP_ID   = s.EMP_ID,
                    EMP_NAME = s.EMP_NAME,
                    // CST_TRNNO = s.CST_TRNNO,
                    EMP_F_NAME = s.EMP_F_NAME,
                    // DOB = s.DOB,
                    //BP_TRNNO = s.BP_TRNNO,
                    //ETYPE = s.ETYPE,
                    //CL_TRNNO = s.CST_TRNNO,
                    //CL_TRNNO1 = s.CL_TRNNO1,
                    //CERTIFICATE = s.CERTIFICATE,
                    //PSCHDT = s.PSCHDT,
                    //EMAIL = s.EMAIL,
                    //ADT = s.ADT,
                    //FTYPE = s.FTYPE,
                    //FEE = s.FEE,
                    //EMAILST = s.EMAILST,
                    //GRPMST_TRNNO = s.GRPMST_TRNNO,
                    //CNIC = s.CNIC,
                    //SECMST_TRNNO = s.SECMST_TRNNO,
                    //SECDTL_SR = s.SECDTL_SR,
                    //SEX = s.SEX,
                    //BSAL = s.BSAL,
                    //FCNIC = s.FCNIC,
                    //ADIMNO = s.ADIMNO,
                    //STYPE = s.STYPE
                }).ToList();
            }

            if (lss.Count == 0)
            {
                return(NotFound());
            }

            return(Ok(lss));
        }