public void Save(IDbTransaction txn) { ClsPeer _Peer = VMuktiAPI.VMuktiInfo.CurrentPeer; if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap) { List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>(); clsSqlParametersInfo objInfo = new clsSqlParametersInfo(); objInfo.Direction = "InputOutput"; objInfo.PName = "@pID"; objInfo.PValue = _ID; objInfo.PDBType = "Int"; objInfo.PSize = 200; clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo(); objInfo2.Direction = "Input"; objInfo2.PName = "@pMyUserID"; objInfo2.PValue = _MyUserID; objInfo2.PDBType = "Int"; objInfo2.PSize = 200; clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo(); objInfo3.Direction = "Input"; objInfo3.PName = "@pUserID"; objInfo3.PValue = _UserID; objInfo3.PDBType = "Int"; objInfo3.PSize = 200; lstSP.Add(objInfo); lstSP.Add(objInfo2); lstSP.Add(objInfo3); clsSqlParameterContract CSqlInfo = new clsSqlParameterContract(); CSqlInfo.objParam = lstSP; try { VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEMyBuddy", CSqlInfo); } catch (System.ServiceModel.EndpointNotFoundException e) { VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "clsBuddy.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEMyBuddy", CSqlInfo); } catch (System.ServiceModel.CommunicationException e) { VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "clsBuddy.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEMyBuddy", CSqlInfo); } } else { if (_Peer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp) { List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>(); clsSqlParametersInfo objInfo = new clsSqlParametersInfo(); objInfo.Direction = "InputOutput"; objInfo.PName = "@pID"; objInfo.PValue = _ID; objInfo.PDBType = "Int"; objInfo.PSize = 200; clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo(); objInfo2.Direction = "Input"; objInfo2.PName = "@pMyUserID"; objInfo2.PValue = _MyUserID; objInfo2.PDBType = "Int"; objInfo2.PSize = 200; clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo(); objInfo3.Direction = "Input"; objInfo3.PName = "@pUserID"; objInfo3.PValue = _UserID; objInfo3.PDBType = "Int"; objInfo3.PSize = 200; lstSP.Add(objInfo); lstSP.Add(objInfo2); lstSP.Add(objInfo3); clsSqlParameterContract CSqlInfo = new clsSqlParameterContract(); CSqlInfo.objParam = lstSP; try { VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEMyBuddy", CSqlInfo); } catch (System.ServiceModel.EndpointNotFoundException e) { VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "clsBuddy.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEMyBuddy", CSqlInfo); } catch (System.ServiceModel.CommunicationException e) { VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "clsBuddy.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEMyBuddy", CSqlInfo); } } else { new VMukti.DataAccess.ClsBuddyDataService(txn).Buddy_Save(ref _ID, _MyUserID, _UserID); } } }
public static ClsBuddy GetByBuddyID(int ID) { ClsBuddy obj = new ClsBuddy(); ClsPeer _Peer = VMuktiAPI.VMuktiInfo.CurrentPeer; 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 = ID; objInfo.PDBType = "Int"; objInfo.PSize = 200; lstSP.Add(objInfo); clsSqlParameterContract CSqlInfo = new clsSqlParameterContract(); CSqlInfo.objParam = lstSP; //super node checking DataSet ds; try { ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGMyBuddy", CSqlInfo).dsInfo; } catch (System.ServiceModel.EndpointNotFoundException e) { VMuktiHelper.ExceptionHandler(e, "GetByBuddyId(int ID)", "clsBuddy.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGMyBuddy", CSqlInfo).dsInfo; } catch (System.ServiceModel.CommunicationException e) { VMuktiHelper.ExceptionHandler(e, "GetByBuddyId(int ID)", "clsBuddy.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGMyBuddy", CSqlInfo).dsInfo; } if (!obj.MapData(ds.Tables[0])) { obj = null; } } else { if (_Peer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp) { List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>(); clsSqlParametersInfo objInfo = new clsSqlParametersInfo(); objInfo.Direction = "Input"; objInfo.PName = "@pID"; objInfo.PValue = ID; objInfo.PDBType = "Int"; objInfo.PSize = 200; lstSP.Add(objInfo); clsSqlParameterContract CSqlInfo = new clsSqlParameterContract(); CSqlInfo.objParam = lstSP; //super node checking DataSet ds; try { ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGMyBuddy", CSqlInfo).dsInfo; } catch (System.ServiceModel.EndpointNotFoundException e) { VMuktiHelper.ExceptionHandler(e, "GetByBuddyId(int ID)", "clsBuddy.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGMyBuddy", CSqlInfo).dsInfo; } catch (System.ServiceModel.CommunicationException e) { VMuktiHelper.ExceptionHandler(e, "GetByBuddyId(int ID)", "clsBuddy.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null); ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGMyBuddy", CSqlInfo).dsInfo; } if (!obj.MapData(ds.Tables[0])) { obj = null; } } else { DataSet ds = new VMukti.DataAccess.ClsBuddyDataService().Buddy_GetByID(ID); if (!obj.MapData(ds.Tables[0])) { obj = null; } } } return(obj); }