public List <wsPassportExtended> ws_selectPassportsList(int?TypeID, int?PlaceID, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = "Done"; return(DDM.selectDevicesPassports(TypeID, PlaceID)); } catch (Exception err) { OpStatus = err.Message.ToString(); return(null); } }
//---- for passport report private DataTable LoadDS_PassportData() { int PID = Convert.ToInt32(Request.QueryString["PID"]); DeviceDataManager DDM = new DeviceDataManager(); var result = from Passport in DDM.selectDevicesPassports(null, null).AsQueryable() where Passport.DevID == PID select Passport; Utility objUtility = new Utility(); DataTable dt = new DataTable(); dt = objUtility.LINQToDataTable(result); return(dt.DefaultView.Table); }
public List<wsPassportExtended> ws_selectPassportsList(int? TypeID, int? PlaceID, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = "Done"; return DDM.selectDevicesPassports(TypeID,PlaceID); } catch (Exception err) { OpStatus = err.Message.ToString(); return null; } }
//---- for passport report private DataTable LoadDS_PassportData() { int PID = Convert.ToInt32(Request.QueryString["PID"]); DeviceDataManager DDM = new DeviceDataManager(); var result = from Passport in DDM.selectDevicesPassports(null, null).AsQueryable() where Passport.DevID == PID select Passport; Utility objUtility = new Utility(); DataTable dt = new DataTable(); dt = objUtility.LINQToDataTable(result); return dt.DefaultView.Table; }