public static ClsBuddyReqCollection GetAll() { ClsBuddyReqCollection obj = new ClsBuddyReqCollection(); if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap) { try { obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("Select * vMyBuddy").dsInfo); } catch (System.ServiceModel.EndpointNotFoundException e) { VMuktiHelper.ExceptionHandler(e, "GetAll", "ClsBuddyReqCollection.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("Select * vMyBuddy").dsInfo); } catch (System.ServiceModel.CommunicationException e) { VMuktiHelper.ExceptionHandler(e, "GetAll", "ClsBuddyReqCollection.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("Select * vMyBuddy").dsInfo); } } else { if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp) { try { obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("Select * vMyBuddy").dsInfo); } catch (System.ServiceModel.EndpointNotFoundException e) { VMuktiHelper.ExceptionHandler(e, "GetAll", "ClsBuddyReqCollection.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("Select * vMyBuddy").dsInfo); } catch (System.ServiceModel.CommunicationException e) { VMuktiHelper.ExceptionHandler(e, "GetAll", "ClsBuddyReqCollection.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("Select * vMyBuddy").dsInfo); } } else { obj.MapObjects(new ClsBuddyReqDataService().BuddyReq_GetAll()); } } return(obj); }
public static ClsBuddyReqCollection GetByUserID(int UserID) { ClsBuddyReqCollection obj = new ClsBuddyReqCollection(); if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap) { List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>(); clsSqlParametersInfo objInfo = new clsSqlParametersInfo(); objInfo.Direction = "Input"; objInfo.PName = "@pID"; objInfo.PValue = -1; objInfo.PDBType = "BigInt"; objInfo.PSize = 200; clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo(); objInfo2.Direction = "Input"; objInfo2.PName = "@pUserID"; objInfo2.PValue = UserID; objInfo2.PDBType = "BigInt"; objInfo2.PSize = 200; lstSP.Add(objInfo); lstSP.Add(objInfo2); clsSqlParameterContract CSqlInfo = new clsSqlParameterContract(); CSqlInfo.objParam = lstSP; try { obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGBuddyRequest", CSqlInfo).dsInfo); } catch (System.ServiceModel.EndpointNotFoundException e) { VMuktiHelper.ExceptionHandler(e, "GetByUserID(int UserID)", "ClsBuddyReqCollection.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGBuddyRequest", CSqlInfo).dsInfo); } catch (System.ServiceModel.CommunicationException e) { VMuktiHelper.ExceptionHandler(e, "GetByUserID(int UserID)", "ClsBuddyReqCollection.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGBuddyRequest", CSqlInfo).dsInfo); } } else { if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp) { List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>(); clsSqlParametersInfo objInfo = new clsSqlParametersInfo(); objInfo.Direction = "Input"; objInfo.PName = "@pID"; objInfo.PValue = -1; objInfo.PDBType = "BigInt"; objInfo.PSize = 200; clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo(); objInfo2.Direction = "Input"; objInfo2.PName = "@pUserID"; objInfo2.PValue = UserID; objInfo2.PDBType = "BigInt"; objInfo2.PSize = 200; lstSP.Add(objInfo); lstSP.Add(objInfo2); clsSqlParameterContract CSqlInfo = new clsSqlParameterContract(); CSqlInfo.objParam = lstSP; try { obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGBuddyRequest", CSqlInfo).dsInfo); } catch (System.ServiceModel.EndpointNotFoundException e) { VMuktiHelper.ExceptionHandler(e, "GetByUserID(int UserID)", "ClsBuddyReqCollection.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGBuddyRequest", CSqlInfo).dsInfo); } catch (System.ServiceModel.CommunicationException e) { VMuktiHelper.ExceptionHandler(e, "GetByUserID(int UserID)", "ClsBuddyReqCollection.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGBuddyRequest", CSqlInfo).dsInfo); } } else { obj.MapObjects(new VMukti.DataAccess.ClsBuddyReqDataService().BuddyReq_GetByUserID(UserID)); } } return(obj); }