public void svcExecuteNonQuery(string spName, clsSqlParameterContract objSParam)
{
if (EntHttpExecuteNonQuery != null)
{
EntHttpExecuteNonQuery(spName, objSParam);
}
}
public static ClsPageCollection GetUPageAllocated(int intUserId)
{
try
{
ClsPageCollection obj = new ClsPageCollection();
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 = "@pUserID";
objInfo.PValue = intUserId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGetUsersPageAllocated", 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 = "@pUserID";
objInfo.PValue = intUserId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGetUsersPageAllocated", CSqlInfo).dsInfo);
}
else
{
obj.MapObjects(new ClsPageDataService().GetPageAllocated(intUserId));
}
}
return(obj);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetUPageAllocated", "ClsPageCollection.cs");
return(null);
}
}
public DataSet Get_TabPage(int intPageId)
{
try
{
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 = intPageId;
objInfo.PDBType = "Int";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
return(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", 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 = intPageId;
objInfo.PDBType = "Int";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
return(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo);
}
else
{
return(new ClsTabDataService().GetTabPage(intPageId));
}
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Get_TabPage()", "ClsTab.cs");
return(null);
}
}
public clsDataBaseInfo svcExecuteDataSet(string spName, clsSqlParameterContract objSParam)
{
if (EntHttpExecuteStoredProcedure != null)
{
return(EntHttpExecuteStoredProcedure(spName, objSParam));
}
else
{
return(null);
}
}
public int Get_PageMaxId()
{
try
{
if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap)
{
List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>();
clsSqlParametersInfo objInfo = new clsSqlParametersInfo();
objInfo.Direction = "Output";
objInfo.PName = "@pReturnMaxID";
objInfo.PValue = -1;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPageAllocation", CSqlInfo).ToString()));
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>();
clsSqlParametersInfo objInfo = new clsSqlParametersInfo();
objInfo.Direction = "Output";
objInfo.PName = "@pReturnMaxID";
objInfo.PValue = -1;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPageAllocation", CSqlInfo).ToString()));
}
else
{
return(new ClsPageDataService().GetMaxPageId());
}
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Get_PageMaxId", "clsPage.cs");
return(-1);
}
}
public int svcExecuteReturnNonQuery(string spName, clsSqlParameterContract objSParam)
{
if (EntHttpExecuteReturnNonQuery != null)
{
return(EntHttpExecuteReturnNonQuery(spName, objSParam));
}
else
{
return(-1);
}
}
public void Remove_Pod(int intPodID)
{
try
{
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 = intPodID;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPODLayout", CSqlInfo);
}
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 = intPodID;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPODLayout", CSqlInfo);
}
else
{
new ClsPodDataService().RemovePod(intPodID);
}
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Remove_PodTab()", "ClsPod.cs");
}
}
public static void Delete(Int64 ID, IDbTransaction txn)
{
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 = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDRoles", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Delete(Int64, IDbTransaction)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDRoles", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Delete(Int64, IDbTransaction)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDRoles", CSqlInfo);
}
}
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 = ID;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDRoles", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Delete(Int64, IDbTransaction)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDRoles", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Delete(Int64, IDbTransaction)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDRoles", CSqlInfo);
}
}
else
{
new VMukti.DataAccess.ClsRoleDataService(txn).Role_Delete(ID);
}
}
}
public static ClsRole GetByRoleID(Int64 ID)
{
ClsRole obj = new ClsRole();
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;
DataSet ds = null;
try
{
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGRole", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "GetByRoleID(Int64 ID)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGRole", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "GetByRoleID(Int64 ID)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGRole", CSqlInfo).dsInfo;
}
if (!obj.MapData(ds.Tables[0]))
{
obj = null;
}
}
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 = ID;
objInfo.PDBType = "Int";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
DataSet ds = null;
try
{
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGRole", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "GetByRoleID(Int64 ID)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGRole", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "GetByRoleID(Int64 ID)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGRole", CSqlInfo).dsInfo;
}
if (!obj.MapData(ds.Tables[0]))
{
obj = null;
}
}
else
{
DataSet ds = new VMukti.DataAccess.ClsRoleDataService().Role_GetByID(ID);
if (!obj.MapData(ds.Tables[0]))
{
obj = null;
}
}
}
return(obj);
}
public void SetRecordingFTPDetails(string strTag)
{
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 = "@pTag";
objInfo.PValue = strTag;
objInfo.PDBType = "NVarChar";
objInfo.PSize = 200;
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
DataSet myDS = null;
try
{
myDS = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spAEGetRecordingFTPDetail", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "SetRecordingFTPDetails(string strTag)", "ClsRecordingModule.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
myDS = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spAEGetRecordingFTPDetail", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "SetRecordingFTPDetails(string strTag)", "ClsRecordingModule.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
myDS = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spAEGetRecordingFTPDetail", CSqlInfo).dsInfo;
}
if (myDS.Tables[0].Rows.Count > 0)
{
VMuktiInfo.FTPServerIP = myDS.Tables[0].Rows[0][1].ToString();
VMuktiInfo.FTPPort = myDS.Tables[0].Rows[0][2].ToString();
VMuktiInfo.FTPUserName = myDS.Tables[0].Rows[0][3].ToString();
VMuktiInfo.FTPDirPath = myDS.Tables[0].Rows[0][4].ToString();
VMuktiInfo.FTPPassword = myDS.Tables[0].Rows[0][5].ToString();
}
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>();
clsSqlParametersInfo objInfo = new clsSqlParametersInfo();
objInfo.Direction = "Input";
objInfo.PName = "@pTag";
objInfo.PValue = strTag;
objInfo.PDBType = "NVarChar";
objInfo.PSize = 200;
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
DataSet myDS = null;
try
{
myDS = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spAEGetRecordingFTPDetail", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "SetRecordingFTPDetails(string strTag)", "ClsRecordingModule.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
myDS = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spAEGetRecordingFTPDetail", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "SetRecordingFTPDetails(string strTag)", "ClsRecordingModule.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
myDS = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spAEGetRecordingFTPDetail", CSqlInfo).dsInfo;
}
if (myDS.Tables[0].Rows.Count > 0)
{
VMuktiInfo.FTPServerIP = myDS.Tables[0].Rows[0][1].ToString();
VMuktiInfo.FTPPort = myDS.Tables[0].Rows[0][2].ToString();
VMuktiInfo.FTPUserName = myDS.Tables[0].Rows[0][3].ToString();
VMuktiInfo.FTPDirPath = myDS.Tables[0].Rows[0][4].ToString();
VMuktiInfo.FTPPassword = myDS.Tables[0].Rows[0][5].ToString();
}
}
else
{
clsUserDataService.SetFTPDetails(strTag);
}
}
}
public void Remove_Tab(int intTabId)
{
if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap)
{
List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>();
clsSqlParametersInfo objInfo = new clsSqlParametersInfo();
objInfo.Direction = "Output";
objInfo.PName = "@pID";
objInfo.PValue = intTabId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDTabs", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_Tab(int intTabId", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDTabs", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_Tab(int intTabId", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDTabs", CSqlInfo);
}
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>();
clsSqlParametersInfo objInfo = new clsSqlParametersInfo();
objInfo.Direction = "Output";
objInfo.PName = "@pID";
objInfo.PValue = intTabId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDTabs", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_Tab(int intTabId", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDTabs", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_Tab(int intTabId", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDTabs", CSqlInfo);
}
}
else
{
new ClsTabDataService().RemoveTab(intTabId);
}
}
}
public static int AddPod(int PodId, int TabId, string strPodTitle, int intColumnID, string IFile, int intModuleId, int intUserid)
{
try
{
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 = PodId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo1 = new clsSqlParametersInfo();
objInfo1.Direction = "Input";
objInfo1.PName = "@pTabID";
objInfo1.PValue = TabId;
objInfo1.PDBType = "BigInt";
objInfo1.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pPodTitle";
objInfo2.PValue = strPodTitle;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pColumnID";
objInfo3.PValue = intColumnID;
objInfo3.PDBType = "BigInt";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pIconFile";
objInfo4.PValue = IFile;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pModuleID";
objInfo5.PValue = intModuleId;
objInfo5.PDBType = "BigInt";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pUserID";
objInfo6.PValue = intUserid;
objInfo6.PDBType = "BigInt";
objInfo6.PSize = 200;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Output";
objInfo7.PName = "@pReturnMaxID";
objInfo7.PValue = -1;
objInfo7.PDBType = "BigInt";
objInfo7.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo1);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
lstSP.Add(objInfo7);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPODLayout", CSqlInfo).ToString()));
}
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 = PodId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo1 = new clsSqlParametersInfo();
objInfo1.Direction = "Input";
objInfo1.PName = "@pTabID";
objInfo1.PValue = TabId;
objInfo1.PDBType = "BigInt";
objInfo1.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pPodTitle";
objInfo2.PValue = strPodTitle;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pColumnID";
objInfo3.PValue = intColumnID;
objInfo3.PDBType = "BigInt";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pIconFile";
objInfo4.PValue = IFile;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pModuleID";
objInfo5.PValue = intModuleId;
objInfo5.PDBType = "BigInt";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pUserID";
objInfo6.PValue = intUserid;
objInfo6.PDBType = "BigInt";
objInfo6.PSize = 200;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Output";
objInfo7.PName = "@pReturnMaxID";
objInfo7.PValue = -1;
objInfo7.PDBType = "BigInt";
objInfo7.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo1);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
lstSP.Add(objInfo7);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPODLayout", CSqlInfo).ToString()));
}
else
{
return(new ClsPodDataService().Add_Pod(PodId, TabId, strPodTitle, intColumnID, IFile, intModuleId, intUserid));
}
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "AddPod()", "ClsPod.cs");
return(-1);
}
}
public bool ModuleExists(string strModName)
{
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 = "@pModuleName";
objInfo.PValue = strModName;
objInfo.PDBType = "NVarChar";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Output";
objInfo2.PName = "@Result";
objInfo2.PValue = -1;
objInfo2.PDBType = "Bit";
objInfo2.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(Convert.ToBoolean(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spModuleExists", CSqlInfo)));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "ModuleExists(string strModName)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(bool.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spModuleExists", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "ModuleExists(string strModName)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(bool.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spModuleExists", CSqlInfo).ToString()));
}
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>();
clsSqlParametersInfo objInfo = new clsSqlParametersInfo();
objInfo.Direction = "Input";
objInfo.PName = "@pModuleName";
objInfo.PValue = strModName;
objInfo.PDBType = "NVarChar";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Output";
objInfo2.PName = "@Result";
objInfo2.PValue = -1;
objInfo2.PDBType = "Bit";
objInfo2.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(Convert.ToBoolean(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spModuleExists", CSqlInfo)));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "ModuleExists(string strModName)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(bool.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spModuleExists", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "ModuleExists(string strModName)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(bool.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spModuleExists", CSqlInfo).ToString()));
}
}
else
{
return(new ClsModuleDataService().Module_Exists(strModName));
}
}
}
public int AddModule(int intModId, string strModName, string strModVersion, string strDesc, string strAssFile, string strClassFile, string strZipFile, int intUserid, bool blnIsCollaborative, bool blnNeedAuth, byte[] ImageFile)
{
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 = intModId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pModuleName";
objInfo2.PValue = strModName;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pModuleVersion";
objInfo3.PValue = strModVersion;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pDescription";
objInfo4.PValue = strDesc;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pAssemblyFile";
objInfo5.PValue = strAssFile;
objInfo5.PDBType = "NVarChar";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pClassName";
objInfo6.PValue = strClassFile;
objInfo6.PDBType = "NVarChar";
objInfo6.PSize = 200;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Input";
objInfo7.PName = "@pZipFile";
objInfo7.PValue = strZipFile;
objInfo7.PDBType = "NVarChar";
objInfo7.PSize = 200;
clsSqlParametersInfo objInfo8 = new clsSqlParametersInfo();
objInfo8.Direction = "Input";
objInfo8.PName = "@pUserID";
objInfo8.PValue = intUserid;
objInfo8.PDBType = "BigInt";
objInfo8.PSize = 200;
clsSqlParametersInfo objInfo9 = new clsSqlParametersInfo();
objInfo9.Direction = "Input";
objInfo9.PName = "@pIsCollaborative";
objInfo9.PValue = blnIsCollaborative;
objInfo9.PDBType = "Bit";
objInfo9.PSize = 200;
clsSqlParametersInfo objInfo10 = new clsSqlParametersInfo();
objInfo10.Direction = "Input";
objInfo10.PName = "@pNeedsAuthentication";
objInfo10.PValue = blnNeedAuth;
objInfo10.PDBType = "Bit";
objInfo10.PSize = 200;
clsSqlParametersInfo objInfo11 = new clsSqlParametersInfo();
objInfo11.Direction = "Input";
objInfo11.PName = "@pImageFile";
objInfo11.PValue = ImageFile;
objInfo11.PDBType = "Image";
clsSqlParametersInfo objInfo12 = new clsSqlParametersInfo();
objInfo12.Direction = "Output";
objInfo12.PName = "@pReturnMaxID";
objInfo12.PValue = -1;
objInfo12.PDBType = "BigInt";
objInfo12.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
lstSP.Add(objInfo7);
lstSP.Add(objInfo8);
lstSP.Add(objInfo9);
lstSP.Add(objInfo10);
lstSP.Add(objInfo11);
lstSP.Add(objInfo12);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEModule", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "AddModule(int intModId, string strModName, str..)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEModule", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "AddModule(int intModId, string strModName, str..)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEModule", CSqlInfo).ToString()));
}
}
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 = intModId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pModuleName";
objInfo2.PValue = strModName;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pModuleVersion";
objInfo3.PValue = strModVersion;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pDescription";
objInfo4.PValue = strDesc;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pAssemblyFile";
objInfo5.PValue = strAssFile;
objInfo5.PDBType = "NVarChar";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pClassName";
objInfo6.PValue = strClassFile;
objInfo6.PDBType = "NVarChar";
objInfo6.PSize = 200;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Input";
objInfo7.PName = "@pZipFile";
objInfo7.PValue = strZipFile;
objInfo7.PDBType = "NVarChar";
objInfo7.PSize = 200;
clsSqlParametersInfo objInfo8 = new clsSqlParametersInfo();
objInfo8.Direction = "Input";
objInfo8.PName = "@pUserID";
objInfo8.PValue = intUserid;
objInfo8.PDBType = "BigInt";
objInfo8.PSize = 200;
clsSqlParametersInfo objInfo9 = new clsSqlParametersInfo();
objInfo9.Direction = "Input";
objInfo9.PName = "@pIsCollaborative";
objInfo9.PValue = blnIsCollaborative;
objInfo9.PDBType = "Bit";
objInfo9.PSize = 200;
clsSqlParametersInfo objInfo10 = new clsSqlParametersInfo();
objInfo10.Direction = "Input";
objInfo10.PName = "@pNeedsAuthentication";
objInfo10.PValue = blnNeedAuth;
objInfo10.PDBType = "Bit";
objInfo10.PSize = 200;
clsSqlParametersInfo objInfo11 = new clsSqlParametersInfo();
objInfo11.Direction = "Input";
objInfo11.PName = "@pImageFile";
objInfo11.PValue = ImageFile;
objInfo11.PDBType = "Image";
clsSqlParametersInfo objInfo12 = new clsSqlParametersInfo();
objInfo12.Direction = "Output";
objInfo12.PName = "@pReturnMaxID";
objInfo12.PValue = -1;
objInfo12.PDBType = "BigInt";
objInfo12.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
lstSP.Add(objInfo7);
lstSP.Add(objInfo8);
lstSP.Add(objInfo9);
lstSP.Add(objInfo10);
lstSP.Add(objInfo11);
lstSP.Add(objInfo12);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEModule", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "AddModule(int intModId, string strModName, str..)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEModule", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "AddModule(int intModId, string strModName, str..)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEModule", CSqlInfo).ToString()));
}
}
else
{
return(new ClsModuleDataService().Add_Module(intModId, strModName, strModVersion, strDesc, strAssFile, strClassFile, strZipFile, intUserid, blnIsCollaborative, blnNeedAuth, ImageFile));
}
}
}
public int Add_Permission(int permissionId, int moduleId, string permissionName, int permissionValue)
{
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 = permissionId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pModuleId";
objInfo2.PValue = moduleId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pPermissionName";
objInfo3.PValue = permissionName;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pPermissionValue";
objInfo4.PValue = permissionValue;
objInfo4.PDBType = "BigInt";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Output";
objInfo5.PName = "@pReturnMaxID";
objInfo5.PValue = -1;
objInfo5.PDBType = "BigInt";
objInfo5.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPermissions", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Permission(int permissionId, int moduleId...)", "ClsPermissionLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPermissions", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Permission(int permissionId, int moduleId...)", "ClsPermissionLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPermissions", CSqlInfo).ToString()));
}
}
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 = permissionId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pModuleId";
objInfo2.PValue = moduleId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pPermissionName";
objInfo3.PValue = permissionName;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pPermissionValue";
objInfo4.PValue = permissionValue;
objInfo4.PDBType = "BigInt";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Output";
objInfo5.PName = "@pReturnMaxID";
objInfo5.PValue = -1;
objInfo5.PDBType = "BigInt";
objInfo5.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPermissions", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Permission(int permissionId, int moduleId...)", "ClsPermissionLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPermissions", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Permission(int permissionId, int moduleId...)", "ClsPermissionLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPermissions", CSqlInfo).ToString()));
}
}
else
{
return(new ClsPermissionDataService().AddPermission(permissionId, moduleId, permissionName, permissionValue));
}
}
}
public void Save(IDbTransaction txn, ref int Result)
{
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 = "@pUserID";
objInfo2.PValue = _UserID;
objInfo2.PDBType = "Int";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pDisplayName";
objInfo3.PValue = _DisplayName;
objInfo3.PDBType = "VarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pReqUserID";
objInfo4.PValue = _ReqUserID;
objInfo4.PDBType = "Int";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "InputOutput";
objInfo5.PName = "@pResult";
objInfo5.PValue = Result;
objInfo5.PDBType = "Int";
objInfo5.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEBuddyRequest", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn, ref int Result)", "clsBuddyReq.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEBuddyRequest", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn, ref int Result)", "clsBuddyReq.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEBuddyRequest", CSqlInfo);
}
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.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 = "@pUserID";
objInfo2.PValue = _UserID;
objInfo2.PDBType = "Int";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pDisplayName";
objInfo3.PValue = _DisplayName;
objInfo3.PDBType = "VarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pReqUserID";
objInfo4.PValue = _ReqUserID;
objInfo4.PDBType = "Int";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "InputOutput";
objInfo5.PName = "@pResult";
objInfo5.PValue = Result;
objInfo5.PDBType = "Int";
objInfo5.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEBuddyRequest", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn, ref int Result)", "clsBuddyReq.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEBuddyRequest", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn, ref int Result)", "clsBuddyReq.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAEBuddyRequest", CSqlInfo);
}
}
else
{
new VMukti.DataAccess.ClsBuddyReqDataService(txn).BuddyReq_Save(ref _ID, _UserID, _DisplayName, _ReqUserID, ref Result);
}
}
}
public void AddNewFTPDetail(ref int ID, string ServerIP, string ServerPort, string UserName, string DirectoryName, string strPassword, string strTag)
{
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 = "@pServerIP";
objInfo2.PValue = ServerIP;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pServerPort";
objInfo3.PValue = ServerPort;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pUserName";
objInfo4.PValue = UserName;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pDirectoryName";
objInfo5.PValue = DirectoryName;
objInfo5.PDBType = "NVarChar";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pPassword";
objInfo6.PValue = strPassword;
objInfo6.PDBType = "NVarChar";
objInfo6.PSize = 200;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Input";
objInfo7.PName = "@pTag";
objInfo7.PValue = strTag;
objInfo7.PDBType = "NVarChar";
objInfo7.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
lstSP.Add(objInfo7);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAERecordingFTPServer", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "AddNewFTPDetail(ref int ID, string ServerIP, string ServerPort, string UserName, string DirectoryName, string strPassword,string strTag)", "ClsRecordingModule.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAERecordingFTPServer", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "AddNewFTPDetail(ref int ID, string ServerIP, string ServerPort, string UserName, string DirectoryName, string strPassword,string strTag)", "ClsRecordingModule.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAERecordingFTPServer", CSqlInfo);
}
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.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 = "@pServerIP";
objInfo2.PValue = ServerIP;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pServerPort";
objInfo3.PValue = ServerPort;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pUserName";
objInfo4.PValue = UserName;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pDirectoryName";
objInfo5.PValue = DirectoryName;
objInfo5.PDBType = "NVarChar";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pPassword";
objInfo6.PValue = strPassword;
objInfo6.PDBType = "NVarChar";
objInfo6.PSize = 200;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Input";
objInfo7.PName = "@pTag";
objInfo7.PValue = strTag;
objInfo7.PDBType = "NVarChar";
objInfo7.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
lstSP.Add(objInfo7);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAERecordingFTPServer", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "AddNewFTPDetail(ref int ID, string ServerIP, string ServerPort, string UserName, string DirectoryName, string strPassword,string strTag)", "ClsRecordingModule.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAERecordingFTPServer", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "AddNewFTPDetail(ref int ID, string ServerIP, string ServerPort, string UserName, string DirectoryName, string strPassword,string strTag)", "ClsRecordingModule.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spAERecordingFTPServer", CSqlInfo);
}
}
else
{
clsUserDataService.User_Save(ref ID, ServerIP, ServerPort, UserName, DirectoryName, strPassword, strTag);
}
}
}
public Int64 Save(IDbTransaction txn)
{
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 = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pRoleName";
objInfo2.PValue = _RoleName;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 50;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pDescription";
objInfo3.PValue = _Description;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 100;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pIsAdmin";
objInfo4.PValue = _IsAdmin;
objInfo4.PDBType = "Bit";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pUserID";
objInfo5.PValue = _CreatedBy;
objInfo5.PDBType = "BigInt";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "InputOutput";
objInfo6.PName = "@pReturnMaxID";
objInfo6.PValue = -1;
objInfo6.PDBType = "BigInt";
objInfo6.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return((Int64)int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAERoles", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return((Int64)int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAERoles", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return((Int64)int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAERoles", CSqlInfo).ToString()));
}
}
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 = _ID;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pRoleName";
objInfo2.PValue = _RoleName;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 50;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pDescription";
objInfo3.PValue = _Description;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 100;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pIsAdmin";
objInfo4.PValue = _IsAdmin;
objInfo4.PDBType = "Bit";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pUserID";
objInfo5.PValue = _CreatedBy;
objInfo5.PDBType = "BigInt";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "InputOutput";
objInfo6.PName = "@pReturnMaxID";
objInfo6.PValue = -1;
objInfo6.PDBType = "BigInt";
objInfo6.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return((Int64)int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAERoles", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return((Int64)int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAERoles", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "ClsRole.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return((Int64)int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAERoles", CSqlInfo).ToString()));
}
}
else
{
return(new VMukti.DataAccess.ClsRoleDataService(txn).Role_Save(ref _ID, _RoleName, _Description, _IsAdmin, _CreatedBy));
}
}
}
public int Get_TabMaxId()
{
if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap)
{
List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>();
clsSqlParametersInfo objInfo = new clsSqlParametersInfo();
objInfo.Direction = "Output";
objInfo.PName = "@pReturnMaxID";
objInfo.PValue = -1;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spGMaxTabId", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabMaxId()", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spGMaxTabId", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabMaxId()", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spGMaxTabId", CSqlInfo).ToString()));
}
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>();
clsSqlParametersInfo objInfo = new clsSqlParametersInfo();
objInfo.Direction = "Output";
objInfo.PName = "@pReturnMaxID";
objInfo.PValue = -1;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spGMaxTabId", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabMaxId()", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spGMaxTabId", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabMaxId()", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spGMaxTabId", CSqlInfo).ToString()));
}
}
else
{
return(new ClsTabDataService().GetMaxTabId());
}
}
}
public int Add_Tab(int intTabId, int intPageId, int intTabPosition, string strTabTitle, string strTabDesc, int intUserId, double C1WidthTab, double C2WidthTab, double C3WidthTab, double C4HeigthTab, double C5HeightTab)
{
try
{
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 = intTabId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pPageID";
objInfo2.PValue = intPageId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pTabPosition";
objInfo3.PValue = intTabPosition;
objInfo3.PDBType = "Int";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pTabTitle";
objInfo4.PValue = strTabTitle;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pDescription";
objInfo5.PValue = strTabDesc;
objInfo5.PDBType = "NVarchar";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pGivenID";
objInfo6.PValue = intUserId;
objInfo6.PDBType = "BigInt";
objInfo6.PSize = 200;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Input";
objInfo7.PName = "@pC1Width";
objInfo7.PValue = C1WidthTab;
objInfo7.PDBType = "Float";
objInfo7.PSize = 200;
clsSqlParametersInfo objInfo8 = new clsSqlParametersInfo();
objInfo8.Direction = "Input";
objInfo8.PName = "@pC2Width";
objInfo8.PValue = C2WidthTab;
objInfo8.PDBType = "Float";
objInfo8.PSize = 200;
clsSqlParametersInfo objInfo9 = new clsSqlParametersInfo();
objInfo9.Direction = "Input";
objInfo9.PName = "@pC3Width";
objInfo9.PValue = C3WidthTab;
objInfo9.PDBType = "Float";
objInfo9.PSize = 200;
clsSqlParametersInfo objInfo10 = new clsSqlParametersInfo();
objInfo10.Direction = "Input";
objInfo10.PName = "@pC4Height";
objInfo10.PValue = C4HeigthTab;
objInfo10.PDBType = "Float";
objInfo10.PSize = 200;
clsSqlParametersInfo objInfo11 = new clsSqlParametersInfo();
objInfo11.Direction = "Input";
objInfo11.PName = "@pC5Height";
objInfo11.PValue = C5HeightTab;
objInfo11.PDBType = "Float";
objInfo11.PSize = 200;
clsSqlParametersInfo objInfo12 = new clsSqlParametersInfo();
objInfo12.Direction = "Output";
objInfo12.PName = "@pReturnMaxID";
objInfo12.PValue = -1;
objInfo12.PDBType = "BigInt";
objInfo12.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
lstSP.Add(objInfo7);
lstSP.Add(objInfo8);
lstSP.Add(objInfo9);
lstSP.Add(objInfo10);
lstSP.Add(objInfo11);
lstSP.Add(objInfo12);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAETabs", CSqlInfo).ToString()));
}
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 = intTabId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pPageID";
objInfo2.PValue = intPageId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pTabPosition";
objInfo3.PValue = intTabPosition;
objInfo3.PDBType = "Int";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pTabTitle";
objInfo4.PValue = strTabTitle;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pDescription";
objInfo5.PValue = strTabDesc;
objInfo5.PDBType = "NVarchar";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pGivenID";
objInfo6.PValue = intUserId;
objInfo6.PDBType = "BigInt";
objInfo6.PSize = 200;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Input";
objInfo7.PName = "@pC1Width";
objInfo7.PValue = C1WidthTab;
objInfo7.PDBType = "Float";
objInfo7.PSize = 200;
clsSqlParametersInfo objInfo8 = new clsSqlParametersInfo();
objInfo8.Direction = "Input";
objInfo8.PName = "@pC2Width";
objInfo8.PValue = C2WidthTab;
objInfo8.PDBType = "Float";
objInfo8.PSize = 200;
clsSqlParametersInfo objInfo9 = new clsSqlParametersInfo();
objInfo9.Direction = "Input";
objInfo9.PName = "@pC3Width";
objInfo9.PValue = C3WidthTab;
objInfo9.PDBType = "Float";
objInfo9.PSize = 200;
clsSqlParametersInfo objInfo10 = new clsSqlParametersInfo();
objInfo10.Direction = "Input";
objInfo10.PName = "@pC4Height";
objInfo10.PValue = C4HeigthTab;
objInfo10.PDBType = "Float";
objInfo10.PSize = 200;
clsSqlParametersInfo objInfo11 = new clsSqlParametersInfo();
objInfo11.Direction = "Input";
objInfo11.PName = "@pC5Height";
objInfo11.PValue = C5HeightTab;
objInfo11.PDBType = "Float";
objInfo11.PSize = 200;
clsSqlParametersInfo objInfo12 = new clsSqlParametersInfo();
objInfo12.Direction = "Output";
objInfo12.PName = "@pReturnMaxID";
objInfo12.PValue = -1;
objInfo12.PDBType = "BigInt";
objInfo12.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
lstSP.Add(objInfo7);
lstSP.Add(objInfo8);
lstSP.Add(objInfo9);
lstSP.Add(objInfo10);
lstSP.Add(objInfo11);
lstSP.Add(objInfo12);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAETabs", CSqlInfo).ToString()));
}
else
{
return(new ClsTabDataService().AddTab(intTabId, intPageId, intTabPosition, strTabTitle, strTabDesc, intUserId, C1WidthTab, C2WidthTab, C3WidthTab, C4HeigthTab, C5HeightTab));
}
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Add_Tab()", "ClsTab.cs");
return(-1);
}
}
public int Add_Tab(int intTabId, int intPageId, int intTabPosition, string strTabTitle, string strTabDesc, int intUserId)
{
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 = intTabId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pPageID";
objInfo2.PValue = intPageId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pTabPosition";
objInfo3.PValue = intTabPosition;
objInfo3.PDBType = "Int";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pTabTitle";
objInfo4.PValue = strTabTitle;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pDescription";
objInfo5.PValue = strTabDesc;
objInfo5.PDBType = "NVarchar";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pGivenID";
objInfo6.PValue = intUserId;
objInfo6.PDBType = "BigInt";
objInfo6.PSize = 200;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Output";
objInfo7.PName = "@pReturnMaxID";
objInfo7.PValue = -1;
objInfo7.PDBType = "BigInt";
objInfo7.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
lstSP.Add(objInfo7);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAETabs", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Tab(int intTabId...)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAETabs", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Tab(int intTabId...)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAETabs", CSqlInfo).ToString()));
}
}
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 = intTabId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pPageID";
objInfo2.PValue = intPageId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pTabPosition";
objInfo3.PValue = intTabPosition;
objInfo3.PDBType = "Int";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pTabTitle";
objInfo4.PValue = strTabTitle;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pDescription";
objInfo5.PValue = strTabDesc;
objInfo5.PDBType = "NVarchar";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pGivenID";
objInfo6.PValue = intUserId;
objInfo6.PDBType = "BigInt";
objInfo6.PSize = 200;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Output";
objInfo7.PName = "@pReturnMaxID";
objInfo7.PValue = -1;
objInfo7.PDBType = "BigInt";
objInfo7.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
lstSP.Add(objInfo7);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAETabs", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Tab(int intTabId...)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAETabs", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Tab(int intTabId...)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAETabs", CSqlInfo).ToString()));
}
}
else
{
return(new ClsTabDataService().AddTab(intTabId, intPageId, intTabPosition, strTabTitle, strTabDesc, intUserId));
}
}
}
public static ClsModuleCollection GetCModCountCheck(int intRoleId, int intMCount)
{
ClsModuleCollection obj = new ClsModuleCollection();
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
List <clsSqlParametersInfo> lstSP = new List <clsSqlParametersInfo>();
clsSqlParametersInfo objInfo = new clsSqlParametersInfo();
objInfo.Direction = "Input";
objInfo.PName = "@pRoleId";
objInfo.PValue = intRoleId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParametersInfo objInfoCount = new clsSqlParametersInfo();
objInfoCount.Direction = "Input";
objInfoCount.PName = "@pCount";
objInfoCount.PValue = intMCount;
objInfoCount.PDBType = "BigInt";
objInfoCount.PSize = 200;
lstSP.Add(objInfoCount);
clsSqlParametersInfo objVersionInfo = new clsSqlParametersInfo();
objVersionInfo.Direction = "Input";
objVersionInfo.PName = "@pVersion";
if (VMuktiAPI.VMuktiInfo.VMuktiVersion == "1.0")
{
objVersionInfo.PValue = "1.0.%";
}
else
{
objVersionInfo.PValue = " ";
}
objVersionInfo.PDBType = "varchar";
objVersionInfo.PSize = 10;
lstSP.Add(objVersionInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGCModulesCount", CSqlInfo).dsInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "GetCModCountCheck(int intRoleId,int intMCount)", "clsModuleCollection.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGCModulesCount", CSqlInfo).dsInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "GetCModCountCheck(int intRoleId,int intMCount)", "clsModuleCollection.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGCModulesCount", CSqlInfo).dsInfo);
}
}
else
{
obj.MapObjects(new ClsModuleDataService().GetCollaborativeCheckingModuleCount(intRoleId, intMCount));
}
return(obj);
}
public int Add_Page(int intPageId, string strPageTitle, string strPageDesc, bool blnIsPublic, int intUserId)
{
try
{
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 = intPageId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pPageTitle";
objInfo2.PValue = strPageTitle;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pDescription";
objInfo3.PValue = strPageDesc;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pIsPublic";
objInfo4.PValue = blnIsPublic;
objInfo4.PDBType = "Bit";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pUserID";
objInfo5.PValue = intUserId;
objInfo5.PDBType = "BigInt";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Output";
objInfo6.PName = "@pReturnMaxID";
objInfo6.PValue = -1;
objInfo6.PDBType = "BigInt";
objInfo6.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPage", CSqlInfo).ToString()));
}
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 = intPageId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pPageTitle";
objInfo2.PValue = strPageTitle;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pDescription";
objInfo3.PValue = strPageDesc;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pIsPublic";
objInfo4.PValue = blnIsPublic;
objInfo4.PDBType = "Bit";
objInfo4.PSize = 200;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pUserID";
objInfo5.PValue = intUserId;
objInfo5.PDBType = "BigInt";
objInfo5.PSize = 200;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Output";
objInfo6.PName = "@pReturnMaxID";
objInfo6.PValue = -1;
objInfo6.PDBType = "BigInt";
objInfo6.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
lstSP.Add(objInfo5);
lstSP.Add(objInfo6);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPage", CSqlInfo).ToString()));
}
else
{
return(new ClsPageDataService().AddPage(intPageId, strPageTitle, strPageDesc, blnIsPublic, intUserId));
}
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Add_Page()", "clsPage.cs");
return(-1);
}
}
public int EditCategory(int id, string name)
{
try
{
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 = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pModuleName";
objInfo2.PValue = name;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spEditCategory", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "AddModule(int intModId, string strModName, str..)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spEditCategory", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "AddModule(int intModId, string strModName, str..)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spEditCategory", CSqlInfo).ToString()));
}
}
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 = id;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pModuleName";
objInfo2.PValue = name;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spEditCategory", CSqlInfo).ToString()));
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "AddModule(int intModId, string strModName, str..)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spEditCategory", CSqlInfo).ToString()));
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "AddModule(int intModId, string strModName, str..)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spEditCategory", CSqlInfo).ToString()));
}
}
else
{
return(new ClsCategoryDataService().UpdateCategory(id, name));
}
}
}
catch
{
return(0);
}
}
public static ClsPermissionCollection Get_PermissionRefModule(int ModuleId, int RoleId)
{
ClsPermissionCollection obj = new ClsPermissionCollection();
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 = "@pModuleId";
objInfo.PValue = ModuleId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pRoleId";
objInfo2.PValue = RoleId;
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("spGPermissionRefModule", CSqlInfo).dsInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_PermissionRefModule(int ModuleId, int RoleId)", "ClsPermissionCollection.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGPermissionRefModule", CSqlInfo).dsInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_PermissionRefModule(int ModuleId, int RoleId)", "ClsPermissionCollection.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGPermissionRefModule", 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 = "@pModuleId";
objInfo.PValue = ModuleId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pRoleId";
objInfo2.PValue = RoleId;
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("spGPermissionRefModule", CSqlInfo).dsInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_PermissionRefModule(int ModuleId, int RoleId)", "ClsPermissionCollection.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGPermissionRefModule", CSqlInfo).dsInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_PermissionRefModule(int ModuleId, int RoleId)", "ClsPermissionCollection.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGPermissionRefModule", CSqlInfo).dsInfo);
}
}
else
{
obj.MapObjects(new ClsPermissionDataService().GetPermissionRefModule(ModuleId, RoleId));
}
}
return(obj);
}
void clsMailDBService_EntsvcExecuteNonQuery(string spName, clsSqlParameterContract objSParam)
{
try
{
SqlConnection conn = new SqlConnection(VMuktiInfo.MainConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = spName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
if (objSParam != null && objSParam.objParam != null)
{
for (int paramCnt = 0; paramCnt < objSParam.objParam.Count; paramCnt++)
{
SqlParameter sp = new SqlParameter();
sp.ParameterName = (string)objSParam.objParam[paramCnt].PName;
if (sp.Size != -1)
{
sp.Size = (int)objSParam.objParam[paramCnt].PSize;
}
sp.Value = (object)objSParam.objParam[paramCnt].PValue;
string direction = (string)objSParam.objParam[paramCnt].Direction;
string dbType = (string)objSParam.objParam[paramCnt].PDBType;
//Enum.GetNames(typeof(SqlDbType))
switch (direction)
{
case "Input":
{
sp.Direction = ParameterDirection.Input;
break;
}
case "InputOutput":
{
sp.Direction = ParameterDirection.InputOutput;
break;
}
case "Output":
{
sp.Direction = ParameterDirection.Output;
break;
}
case "ReturnValue":
{
sp.Direction = ParameterDirection.ReturnValue;
break;
}
default:
{
break;
}
}
switch (dbType)
{
case "VarChar":
{
sp.SqlDbType = SqlDbType.VarChar;
break;
}
case "NVarChar":
{
sp.SqlDbType = SqlDbType.NVarChar;
break;
}
case "Char":
{
sp.SqlDbType = SqlDbType.Char;
break;
}
case "NChar":
{
sp.SqlDbType = SqlDbType.NChar;
break;
}
case "Text":
{
sp.SqlDbType = SqlDbType.Text;
break;
}
case "DateTime":
{
sp.SqlDbType = SqlDbType.DateTime;
break;
}
case "Int":
{
sp.SqlDbType = SqlDbType.Int;
break;
}
case "UniqueIdentifier":
{
sp.SqlDbType = SqlDbType.UniqueIdentifier;
break;
}
case "Bit":
{
sp.SqlDbType = SqlDbType.Bit;
break;
}
case "Float":
{
sp.SqlDbType = SqlDbType.Float;
break;
}
case "Decimal":
{
sp.SqlDbType = SqlDbType.Decimal;
break;
}
case "BigInt":
{
sp.SqlDbType = SqlDbType.BigInt;
break;
}
default:
{
break;
}
}
cmd.Parameters.Add(sp);
}
}
cmd.ExecuteNonQuery();
conn.Close();
conn.Dispose();
cmd.Dispose();
}
catch (Exception exp)
{
VMuktiAPI.VMuktiHelper.ExceptionHandler(exp, "clsMailDBService_EntsvcExecuteNonQuery()", "clsMailDBService.xaml.cs");
}
}
public void DeleteCategory(int id)
{
try
{
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 = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spDeleteCategory", CSqlInfo).ToString();
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "DeleteCategory(int Id)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spDeleteCategory", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "DeleteCategory(int Id)", "ClsModuleLogic.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spDeleteCategory", CSqlInfo).ToString();
}
}
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 = id;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spDeleteCategory", CSqlInfo).ToString();
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "DeleteCategory(int Id)", "ClsModuleLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spDeleteCategory", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "DeleteCategory(int Id)", "ClsModuleLogic.cs"); VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spDeleteCategory", CSqlInfo).ToString();
}
}
else
{
ClsCategoryDataService objClsCategoryDataService = new ClsCategoryDataService();
objClsCategoryDataService.Delete_Category(id);
}
}
}
catch (Exception e)
{
VMuktiHelper.ExceptionHandler(e, "DeleteCategory(int Id)", "ClsModuleLogic.cs");
}
}
public static void UpdateUserProfile(int userID, string fullName, string email, string country, string state, string city, string timezone, string language, string gender, DateTime birthDate, string homepage, string aboutMe, string homePhone, string officePhone, string mobilePhone)
{
try
{
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 = "@pUserID";
objInfo.PValue = userID;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParametersInfo objInfo1 = new clsSqlParametersInfo();
objInfo1.Direction = "Input";
objInfo1.PName = "@pFullName";
objInfo1.PValue = fullName;
objInfo1.PDBType = "NVarChar";
objInfo1.PSize = 200;
lstSP.Add(objInfo1);
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pEmail";
objInfo2.PValue = email;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
lstSP.Add(objInfo2);
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pCountry";
objInfo3.PValue = country;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
lstSP.Add(objInfo3);
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pState";
objInfo4.PValue = state;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
lstSP.Add(objInfo4);
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pCity";
objInfo5.PValue = city;
objInfo5.PDBType = "NVarChar";
objInfo5.PSize = 200;
lstSP.Add(objInfo5);
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pTimezone";
objInfo6.PValue = timezone;
objInfo6.PDBType = "NVarChar";
objInfo6.PSize = 200;
lstSP.Add(objInfo6);
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Input";
objInfo7.PName = "@pLanguage";
objInfo7.PValue = language;
objInfo7.PDBType = "NVarChar";
objInfo7.PSize = 200;
lstSP.Add(objInfo7);
clsSqlParametersInfo objInfo8 = new clsSqlParametersInfo();
objInfo8.Direction = "Input";
objInfo8.PName = "@pGender";
objInfo8.PValue = gender;
objInfo8.PDBType = "NVarChar";
objInfo8.PSize = 200;
lstSP.Add(objInfo8);
clsSqlParametersInfo objInfo9 = new clsSqlParametersInfo();
objInfo9.Direction = "Input";
objInfo9.PName = "@pBirthDate";
objInfo9.PValue = birthDate;
objInfo9.PDBType = "DateTime";
objInfo9.PSize = 200;
lstSP.Add(objInfo9);
clsSqlParametersInfo objInfo10 = new clsSqlParametersInfo();
objInfo10.Direction = "Input";
objInfo10.PName = "@pHomePage";
objInfo10.PValue = homepage;
objInfo10.PDBType = "nText";
objInfo10.PSize = 200;
lstSP.Add(objInfo10);
clsSqlParametersInfo objInfo11 = new clsSqlParametersInfo();
objInfo11.Direction = "Input";
objInfo11.PName = "@pAboutMe";
objInfo11.PValue = aboutMe;
objInfo11.PDBType = "NText";
objInfo11.PSize = 200;
lstSP.Add(objInfo11);
clsSqlParametersInfo objInfo12 = new clsSqlParametersInfo();
objInfo12.Direction = "Input";
objInfo12.PName = "@pHomePhone";
objInfo12.PValue = homePhone;
objInfo12.PDBType = "NVarChar";
objInfo12.PSize = 200;
lstSP.Add(objInfo12);
clsSqlParametersInfo objInfo13 = new clsSqlParametersInfo();
objInfo13.Direction = "Input";
objInfo13.PName = "@pOfficePhone";
objInfo13.PValue = officePhone;
objInfo13.PDBType = "NVarChar";
objInfo13.PSize = 200;
lstSP.Add(objInfo13);
clsSqlParametersInfo objInfo14 = new clsSqlParametersInfo();
objInfo14.Direction = "Input";
objInfo14.PName = "@pMobilePhone";
objInfo14.PValue = mobilePhone;
objInfo14.PDBType = "NVarChar";
objInfo14.PSize = 200;
lstSP.Add(objInfo14);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
DataSet ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spAEUserProfile", 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 = "@pUserID";
objInfo.PValue = userID;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParametersInfo objInfo1 = new clsSqlParametersInfo();
objInfo1.Direction = "Input";
objInfo1.PName = "@pFullName";
objInfo1.PValue = fullName;
objInfo1.PDBType = "NVarChar";
objInfo1.PSize = 200;
lstSP.Add(objInfo1);
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pEmail";
objInfo2.PValue = email;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
lstSP.Add(objInfo2);
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pCountry";
objInfo3.PValue = country;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
lstSP.Add(objInfo3);
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pState";
objInfo4.PValue = state;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 200;
lstSP.Add(objInfo4);
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pCity";
objInfo5.PValue = city;
objInfo5.PDBType = "NVarChar";
objInfo5.PSize = 200;
lstSP.Add(objInfo5);
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pTimezone";
objInfo6.PValue = timezone;
objInfo6.PDBType = "NVarChar";
objInfo6.PSize = 200;
lstSP.Add(objInfo6);
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Input";
objInfo7.PName = "@pLanguage";
objInfo7.PValue = language;
objInfo7.PDBType = "NVarChar";
objInfo7.PSize = 200;
lstSP.Add(objInfo7);
clsSqlParametersInfo objInfo8 = new clsSqlParametersInfo();
objInfo8.Direction = "Input";
objInfo8.PName = "@pGender";
objInfo8.PValue = gender;
objInfo8.PDBType = "NVarChar";
objInfo8.PSize = 200;
lstSP.Add(objInfo8);
clsSqlParametersInfo objInfo9 = new clsSqlParametersInfo();
objInfo9.Direction = "Input";
objInfo9.PName = "@pBirthDate";
objInfo9.PValue = birthDate;
objInfo9.PDBType = "DateTime";
objInfo9.PSize = 200;
lstSP.Add(objInfo9);
clsSqlParametersInfo objInfo10 = new clsSqlParametersInfo();
objInfo10.Direction = "Input";
objInfo10.PName = "@pHomePage";
objInfo10.PValue = homepage;
objInfo10.PDBType = "nText";
objInfo10.PSize = 200;
lstSP.Add(objInfo10);
clsSqlParametersInfo objInfo11 = new clsSqlParametersInfo();
objInfo11.Direction = "Input";
objInfo11.PName = "@pAboutMe";
objInfo11.PValue = aboutMe;
objInfo11.PDBType = "NText";
objInfo11.PSize = 200;
lstSP.Add(objInfo11);
clsSqlParametersInfo objInfo12 = new clsSqlParametersInfo();
objInfo12.Direction = "Input";
objInfo12.PName = "@pHomePhone";
objInfo12.PValue = homePhone;
objInfo12.PDBType = "NVarChar";
objInfo12.PSize = 200;
lstSP.Add(objInfo12);
clsSqlParametersInfo objInfo13 = new clsSqlParametersInfo();
objInfo13.Direction = "Input";
objInfo13.PName = "@pOfficePhone";
objInfo13.PValue = officePhone;
objInfo13.PDBType = "NVarChar";
objInfo13.PSize = 200;
lstSP.Add(objInfo13);
clsSqlParametersInfo objInfo14 = new clsSqlParametersInfo();
objInfo14.Direction = "Input";
objInfo14.PName = "@pMobilePhone";
objInfo14.PValue = mobilePhone;
objInfo14.PDBType = "NVarChar";
objInfo14.PSize = 200;
lstSP.Add(objInfo14);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
DataSet ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spAEUserProfile", CSqlInfo).dsInfo;
}
else
{
new VMukti.DataAccess.clsProfile().UpdateUserProfile(userID, fullName, email, country, state, city, timezone, language, gender, birthDate, homepage, aboutMe, homePhone, officePhone, mobilePhone);
}
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "UpdateUserProfile()", "clsProfile.cs");
}
}
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);
}
public void Page_Allocated(int intPageAllocationId, int intPageId, int intUserid)
{
try
{
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 = intPageAllocationId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pPageID";
objInfo2.PValue = intPageId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pUserID";
objInfo3.PValue = intUserid;
objInfo3.PDBType = "BigInt";
objInfo3.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spAEPageAllocation", CSqlInfo);
}
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 = intPageAllocationId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pPageID";
objInfo2.PValue = intPageId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pUserID";
objInfo3.PValue = intUserid;
objInfo3.PDBType = "BigInt";
objInfo3.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spAEPageAllocation", CSqlInfo);
}
else
{
new ClsPageDataService().PageAllocated(intPageAllocationId, intPageId, intUserid);
}
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Page_Allocated", "clsPage.cs");
}
}
