public static clsProfileCollection GetUserProfile(int userID)
{
try
{
clsProfileCollection obj = new clsProfileCollection();
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);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGUserProfile", 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);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
obj.MapObjects(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGUserProfile", CSqlInfo).dsInfo);
}
else
{
obj.MapObjects(new VMukti.DataAccess.clsProfile().GetUserProfile(userID));
}
}
return(obj);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetUserProfile", "clsProfileCollection.cs");
return(null);
}
}
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 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 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 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 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 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 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 int Save(IDbTransaction txn)
{
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 = "Int";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pDisplayName";
objInfo2.PValue = _DisplayName;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 100;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pRoleID";
objInfo3.PValue = _RoleID;
objInfo3.PDBType = "BigInt";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pFirstName";
objInfo4.PValue = _FName;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 50;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pLastName";
objInfo5.PValue = _LName;
objInfo5.PDBType = "NVarChar";
objInfo5.PSize = 50;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pEMail";
objInfo6.PValue = _EMail;
objInfo6.PDBType = "NVarChar";
objInfo6.PSize = 256;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Input";
objInfo7.PName = "@pPassword";
objInfo7.PValue = _PassWord;
objInfo7.PDBType = "NVarChar";
objInfo7.PSize = 50;
clsSqlParametersInfo objInfo8 = new clsSqlParametersInfo();
objInfo8.Direction = "Input";
objInfo8.PName = "@pIsActive";
objInfo8.PValue = _IsActive;
objInfo8.PDBType = "Bit";
objInfo8.PSize = 200;
clsSqlParametersInfo objInfo9 = new clsSqlParametersInfo();
objInfo9.Direction = "Input";
objInfo9.PName = "@pByUserID";
objInfo9.PValue = _ModifiedBy;
objInfo9.PDBType = "BigInt";
objInfo9.PSize = 200;
clsSqlParametersInfo objInfo10 = new clsSqlParametersInfo();
objInfo10.Direction = "Input";
objInfo10.PName = "@pRatePerHour";
objInfo10.PValue = _RatePerHour;
objInfo10.PDBType = "Float";
objInfo10.PSize = 200;
clsSqlParametersInfo objInfo11 = new clsSqlParametersInfo();
objInfo11.Direction = "Input";
objInfo11.PName = "@pOverTimeRate";
objInfo11.PValue = _OverTimeRate;
objInfo11.PDBType = "Float";
objInfo11.PSize = 200;
clsSqlParametersInfo objInfo12 = new clsSqlParametersInfo();
objInfo12.Direction = "Input";
objInfo12.PName = "@pDoubleRatePerHour";
objInfo12.PValue = _DoubleRatePerHour;
objInfo12.PDBType = "Float";
objInfo12.PSize = 200;
clsSqlParametersInfo objInfo13 = new clsSqlParametersInfo();
objInfo13.Direction = "Input";
objInfo13.PName = "@pDoubleOverTimeRate";
objInfo13.PValue = _DoubleOverTimeRate;
objInfo13.PDBType = "Float";
objInfo13.PSize = 200;
clsSqlParametersInfo objInfo14 = new clsSqlParametersInfo();
objInfo14.Direction = "Output";
objInfo14.PName = "@pReturnId";
objInfo14.PValue = -1;
objInfo14.PDBType = "BigInt";
objInfo14.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);
lstSP.Add(objInfo13);
lstSP.Add(objInfo14);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEUserInfoPayroll", CSqlInfo).ToString());
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEUserInfoPayroll", CSqlInfo).ToString());
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEUserInfoPayroll", 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 = "Int";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pDisplayName";
objInfo2.PValue = _DisplayName;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 100;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pRoleID";
objInfo3.PValue = _RoleID;
objInfo3.PDBType = "BigInt";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "Input";
objInfo4.PName = "@pFirstName";
objInfo4.PValue = _FName;
objInfo4.PDBType = "NVarChar";
objInfo4.PSize = 50;
clsSqlParametersInfo objInfo5 = new clsSqlParametersInfo();
objInfo5.Direction = "Input";
objInfo5.PName = "@pLastName";
objInfo5.PValue = _LName;
objInfo5.PDBType = "NVarChar";
objInfo5.PSize = 50;
clsSqlParametersInfo objInfo6 = new clsSqlParametersInfo();
objInfo6.Direction = "Input";
objInfo6.PName = "@pEMail";
objInfo6.PValue = _EMail;
objInfo6.PDBType = "NVarChar";
objInfo6.PSize = 256;
clsSqlParametersInfo objInfo7 = new clsSqlParametersInfo();
objInfo7.Direction = "Input";
objInfo7.PName = "@pPassword";
objInfo7.PValue = _PassWord;
objInfo7.PDBType = "NVarChar";
objInfo7.PSize = 50;
clsSqlParametersInfo objInfo8 = new clsSqlParametersInfo();
objInfo8.Direction = "Input";
objInfo8.PName = "@pIsActive";
objInfo8.PValue = _IsActive;
objInfo8.PDBType = "Bit";
objInfo8.PSize = 200;
clsSqlParametersInfo objInfo9 = new clsSqlParametersInfo();
objInfo9.Direction = "Input";
objInfo9.PName = "@pByUserID";
objInfo9.PValue = _ModifiedBy;
objInfo9.PDBType = "BigInt";
objInfo9.PSize = 200;
clsSqlParametersInfo objInfo10 = new clsSqlParametersInfo();
objInfo10.Direction = "Input";
objInfo10.PName = "@pRatePerHour";
objInfo10.PValue = _RatePerHour;
objInfo10.PDBType = "Float";
objInfo10.PSize = 200;
clsSqlParametersInfo objInfo11 = new clsSqlParametersInfo();
objInfo11.Direction = "Input";
objInfo11.PName = "@pOverTimeRate";
objInfo11.PValue = _OverTimeRate;
objInfo11.PDBType = "Float";
objInfo11.PSize = 200;
clsSqlParametersInfo objInfo12 = new clsSqlParametersInfo();
objInfo12.Direction = "Input";
objInfo12.PName = "@pDoubleRatePerHour";
objInfo12.PValue = _DoubleRatePerHour;
objInfo12.PDBType = "Float";
objInfo12.PSize = 200;
clsSqlParametersInfo objInfo13 = new clsSqlParametersInfo();
objInfo13.Direction = "Input";
objInfo13.PName = "@pDoubleOverTimeRate";
objInfo13.PValue = _DoubleOverTimeRate;
objInfo13.PDBType = "Float";
objInfo13.PSize = 200;
clsSqlParametersInfo objInfo14 = new clsSqlParametersInfo();
objInfo14.Direction = "Output";
objInfo14.PName = "@pReturnId";
objInfo14.PValue = -1;
objInfo14.PDBType = "BigInt";
objInfo14.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);
lstSP.Add(objInfo13);
lstSP.Add(objInfo14);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEUserInfoPayroll", CSqlInfo).ToString());
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEUserInfoPayroll", CSqlInfo).ToString());
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEUserInfoPayroll", CSqlInfo).ToString());
}
}
else
{
return (new VMukti.DataAccess.ClsUserDataService(txn).User_Save(ref _ID, _DisplayName, _RoleID, _FName, _LName, _EMail, _PassWord, _IsActive, _ModifiedBy, _RatePerHour, _OverTimeRate, _DoubleRatePerHour, _DoubleOverTimeRate));
}
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Save(IDbTransaction)", "clsUser.cs");
return 0;
}
}
public static void Logout(Int64 UserID)
{
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 = -1;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pUserID";
objInfo2.PValue = UserID;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
lstSP.Add(objInfo2);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDOnlineUsers", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Logout(Int64 UserID)", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDOnlineUsers", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Logout(Int64 UserID)", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDOnlineUsers", 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 = -1;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
lstSP.Add(objInfo);
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pUserID";
objInfo2.PValue = UserID;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
lstSP.Add(objInfo2);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDOnlineUsers", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Logout(Int64 UserID)", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDOnlineUsers", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Logout(Int64 UserID)", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteNonQuery("spDOnlineUsers", CSqlInfo);
}
}
else
{
new VMukti.DataAccess.ClsUserDataService().User_LogOff(UserID);
}
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "LogOut()", "clsUser.cs");
}
}
public static ClsUser GetByUNamePass(string UName, string Password, ref bool Result)
{
try
{
ClsUser obj = new ClsUser();
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 = "Int";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pUName";
objInfo2.PValue = UName;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pPass";
objInfo3.PValue = Password;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "InputOutput";
objInfo4.PName = "@pResult";
objInfo4.PValue = false;
objInfo4.PDBType = "Bit";
objInfo4.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
DataSet ds;
try
{
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGUserInfoPayroll", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "GetByUNamePass(string UName, string Password, ref bool Result)", "clsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGUserInfoPayroll", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "GetByUNamePass(string UName, string Password, ref bool Result)", "clsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGUserInfoPayroll", CSqlInfo).dsInfo;
}
if (!obj.MapData(ds.Tables[0])) obj = null;
if (obj != null && ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
obj.MapData4Campaign(ds.Tables[1].Rows[0]);
}
}
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 = "Int";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@pUName";
objInfo2.PValue = UName;
objInfo2.PDBType = "NVarChar";
objInfo2.PSize = 200;
clsSqlParametersInfo objInfo3 = new clsSqlParametersInfo();
objInfo3.Direction = "Input";
objInfo3.PName = "@pPass";
objInfo3.PValue = Password;
objInfo3.PDBType = "NVarChar";
objInfo3.PSize = 200;
clsSqlParametersInfo objInfo4 = new clsSqlParametersInfo();
objInfo4.Direction = "InputOutput";
objInfo4.PName = "@pResult";
objInfo4.PValue = false;
objInfo4.PDBType = "Bit";
objInfo4.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
lstSP.Add(objInfo3);
lstSP.Add(objInfo4);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
DataSet ds;
try
{
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGUserInfoPayroll", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "GetByUNamePass(string UName, string Password, ref bool Result)", "clsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGUserInfoPayroll", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "GetByUNamePass(string UName, string Password, ref bool Result)", "clsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGUserInfoPayroll", CSqlInfo).dsInfo;
}
if (!obj.MapData(ds.Tables[0])) obj = null;
if (obj != null && ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
obj.MapData4Campaign(ds.Tables[1].Rows[0]);
}
}
else
{
DataSet ds = new VMukti.DataAccess.ClsUserDataService().User_GetByUNamePass(UName, Password, ref Result);
if (!obj.MapData(ds.Tables[0])) obj = null;
if (obj != null && ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
obj.MapData4Campaign(ds.Tables[1].Rows[0]);
}
}
}
return obj;
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetByUNamePass()", "clsUser.cs");
return null;
}
}
public static void AddNewRecord(int uid)
{
if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap)
{
List<clsSqlParametersInfo> lstSP1 = new List<clsSqlParametersInfo>();
ClsUser objUser = new ClsUser();
clsSqlParametersInfo objUserInfo1 = new clsSqlParametersInfo();
objUserInfo1.Direction = "Input";
objUserInfo1.PName = "@uid";
objUserInfo1.PValue = uid;
objUserInfo1.PDBType = "Int";
objUserInfo1.PSize = 200;
lstSP1.Add(objUserInfo1);
//clsSqlParametersInfo objUserInfo2 = new clsSqlParametersInfo();
//objUserInfo2.Direction = "Input";
//objUserInfo2.PName = "@dt";
//objUserInfo2.PValue = dt;
//objUserInfo2.PDBType = "DateTime";
//objUserInfo2.PSize = 200;
//lstSP1.Add(objUserInfo2);
clsSqlParameterContract CSqlUserInfo = new clsSqlParameterContract();
CSqlUserInfo.objParam = lstSP1;
try
{
// VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEUserInfoPayroll", CSqlInfo).ToString();
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spLogout", CSqlUserInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
}
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
List<clsSqlParametersInfo> lstSP1 = new List<clsSqlParametersInfo>();
ClsUser objUser = new ClsUser();
clsSqlParametersInfo objUserInfo1 = new clsSqlParametersInfo();
objUserInfo1.Direction = "Input";
objUserInfo1.PName = "@uid";
objUserInfo1.PValue = uid;
objUserInfo1.PDBType = "Int";
objUserInfo1.PSize = 200;
lstSP1.Add(objUserInfo1);
//clsSqlParametersInfo objUserInfo2 = new clsSqlParametersInfo();
//objUserInfo2.Direction = "Input";
//objUserInfo2.PName = "@dt";
//objUserInfo2.PValue = dt;
//objUserInfo2.PDBType = "DateTime";
//objUserInfo2.PSize = 200;
//lstSP1.Add(objUserInfo2);
clsSqlParameterContract CSqlUserInfo = new clsSqlParameterContract();
CSqlUserInfo.objParam = lstSP1;
try
{
// VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEUserInfoPayroll", CSqlInfo).ToString();
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spLogout", CSqlUserInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Save(IDbTransaction txn)", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
}
}
else
{
new VMukti.DataAccess.ClsUserDataService().User_AddNewRecord(uid);
}
}
}
public static DataSet FindBuddy(string username, string email)
//public static DataSet FindBuddy()
{
try
{
if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap)
{
List<clsSqlParametersInfo> lstSP1 = new List<clsSqlParametersInfo>();
ClsUser objUser = new ClsUser();
clsSqlParametersInfo objUserInfo1 = new clsSqlParametersInfo();
objUserInfo1.Direction = "Input";
objUserInfo1.PName = "@uname";
objUserInfo1.PValue = username;
objUserInfo1.PDBType = "nvarchar";
objUserInfo1.PSize = 100;
lstSP1.Add(objUserInfo1);
clsSqlParametersInfo objUserInfo2 = new clsSqlParametersInfo();
objUserInfo2.Direction = "Input";
objUserInfo2.PName = "@email";
objUserInfo2.PValue = email;
objUserInfo2.PDBType = "nvarchar";
objUserInfo2.PSize = 256;
lstSP1.Add(objUserInfo2);
clsSqlParameterContract CSqlUserInfo = new clsSqlParameterContract();
CSqlUserInfo.objParam = lstSP1;
DataSet ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spFindBuddy", CSqlUserInfo).dsInfo;
return ds;
//VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEUserInfoPayroll", CSqlInfo).ToString();
//VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spFindBuddy", CSqlUserInfo);
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
List<clsSqlParametersInfo> lstSP1 = new List<clsSqlParametersInfo>();
ClsUser objUser = new ClsUser();
clsSqlParametersInfo objUserInfo1 = new clsSqlParametersInfo();
objUserInfo1.Direction = "Input";
objUserInfo1.PName = "@uname";
objUserInfo1.PValue = username;
objUserInfo1.PDBType = "nvarchar";
objUserInfo1.PSize = 100;
lstSP1.Add(objUserInfo1);
clsSqlParametersInfo objUserInfo2 = new clsSqlParametersInfo();
objUserInfo2.Direction = "Input";
objUserInfo2.PName = "@email";
objUserInfo2.PValue = email;
objUserInfo2.PDBType = "nvarchar";
objUserInfo2.PSize = 256;
lstSP1.Add(objUserInfo2);
clsSqlParameterContract CSqlUserInfo = new clsSqlParameterContract();
CSqlUserInfo.objParam = lstSP1;
DataSet ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spFindBuddy", CSqlUserInfo).dsInfo;
return ds;
//VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEUserInfoPayroll", CSqlInfo).ToString();
//VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spFindBuddy", CSqlUserInfo);
}
else
{
//return new VMukti.DataAccess.ClsUserDataService().User_FindBuddy();
return new VMukti.DataAccess.ClsUserDataService().User_FindBuddy(username, email);
}
}
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "FindBuddy", "ClsUser.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return null;
//VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spLogin", CSqlUserInfo);
}
}
public DataSet Get_TabPage(int intPageId)
{
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;
try
{
return(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabPage(int intPageId)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabPage(int intPageId)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
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;
try
{
return(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabPage(int intPageId)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabPage(int intPageId)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo);
}
}
else
{
return(new ClsTabDataService().GetTabPage(intPageId));
}
}
}
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);
}
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 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 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 DataSet Get_TabPage(int intPageId)
{
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;
try
{
return VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabPage(int intPageId)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabPage(int intPageId)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
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;
try
{
return VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabPage(int intPageId)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_TabPage(int intPageId)", "ClsTabLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGTabPage", CSqlInfo).dsInfo;
}
}
else
{
return (new ClsTabDataService().GetTabPage(intPageId));
}
}
}
public int Get_PageMaxId()
{
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;
try
{
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPageAllocation", CSqlInfo).ToString());
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_PageMaxId", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPageAllocation", CSqlInfo).ToString());
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_PageMaxId", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
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;
try
{
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPageAllocation", CSqlInfo).ToString());
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_PageMaxId", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPageAllocation", CSqlInfo).ToString());
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Get_PageMaxId", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPageAllocation", CSqlInfo).ToString());
}
}
else
{
return (new ClsPageDataService().GetMaxPageId());
}
}
}
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 Remove_PageAllocated(int intPageId, 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 = intPageId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@uID";
objInfo2.PValue = intUserId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_PageAllocated(int intPageId, int intUserId)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_PageAllocated(int intPageId, int intUserId)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", 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 = intPageId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@uID";
objInfo2.PValue = intUserId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_PageAllocated(int intPageId, int intUserId)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_PageAllocated(int intPageId, int intUserId)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", CSqlInfo);
}
}
else
{
new ClsPageDataService().RemovePageAllocation(intPageId, intUserId);
}
}
}
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 int Add_Page(int intPageId, string strPageTitle, string strPageDesc, bool blnIsPublic, 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 = 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;
try
{
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPage", CSqlInfo).ToString());
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Page(int intPag...)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPage", CSqlInfo).ToString());
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Page(int intPag...)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
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;
try
{
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPage", CSqlInfo).ToString());
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Page(int intPag...)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPage", CSqlInfo).ToString());
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Add_Page(int intPag...)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
return int.Parse(VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteReturnNonQuery("spAEPage", CSqlInfo).ToString());
}
}
else
{
return (new ClsPageDataService().AddPage(intPageId, strPageTitle, strPageDesc, blnIsPublic, intUserId));
}
}
}
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 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 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 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 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_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 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 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 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 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 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 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 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 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 Remove_PageAllocated(int intPageId, 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 = intPageId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@uID";
objInfo2.PValue = intUserId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_PageAllocated(int intPageId, int intUserId)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_PageAllocated(int intPageId, int intUserId)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", 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 = intPageId;
objInfo.PDBType = "BigInt";
objInfo.PSize = 200;
clsSqlParametersInfo objInfo2 = new clsSqlParametersInfo();
objInfo2.Direction = "Input";
objInfo2.PName = "@uID";
objInfo2.PValue = intUserId;
objInfo2.PDBType = "BigInt";
objInfo2.PSize = 200;
lstSP.Add(objInfo);
lstSP.Add(objInfo2);
clsSqlParameterContract CSqlInfo = new clsSqlParameterContract();
CSqlInfo.objParam = lstSP;
try
{
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", CSqlInfo);
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_PageAllocated(int intPageId, int intUserId)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", CSqlInfo);
}
catch (System.ServiceModel.CommunicationException e)
{
VMuktiHelper.ExceptionHandler(e, "Remove_PageAllocated(int intPageId, int intUserId)", "ClsPageLogic.cs");
VMuktiAPI.VMuktiHelper.CallEvent("GetSuperNodeIP", null, null);
VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spDPageAllocation", CSqlInfo);
}
}
else
{
new ClsPageDataService().RemovePageAllocation(intPageId, intUserId);
}
}
}