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