Exemplos de dbFirmsEntities.usp_GetWitnessesofOrgType em C# (CSharp)

Exemplo n.º 1

        public List <MdlWitness> GetAllWitnessListForSociety()
        {
            var query = _dbFirms.usp_GetWitnessesofOrgType(2);
            var list  = new  List <MdlWitness>();

            foreach (var obj in query)
            {
                list.Add(new MdlWitness()
                {
                    WitnessID         = obj.WitnessID,
                    WitnessName       = obj.WitnessName,
                    WitnessCNIC       = obj.WitnessCNIC,
                    WitnessONIC       = obj.WitnessONIC,
                    WitnessAddress    = obj.WitnessAddress,
                    WitnessContactNo  = obj.WitnessContactNo,
                    WitnessMobileNo   = obj.WitnessMobileNo,
                    WitnessCitizenNo  = obj.WitnessCitizenNo,
                    WitnessPassportNo = obj.WitnessPassportNo,
                    OrgDoc_ID         = obj.OrgDoc_ID,
                    EnterByUser_ID    = obj.EnterByUser_ID,
                    EntryDate         = obj.EntryDate.Date
                });
            }
            return(list);
        }