public static string GetUserDisplayName(int userID)
{
try
{
string displayName = null;
DataSet ds = null;
if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap)
{
ds = clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("select * from vUserInfo where ID='" + userID + "'").dsInfo;
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
ds = clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("select * from vUserInfo where ID='" + userID + "'").dsInfo;
}
else
{
ds = new VMukti.DataAccess.clsProfile().GetUserDisplayName(userID);
}
}
if (ds.Tables[0] != null)
{
DataRow dr;
if (ds.Tables[0].Rows.Count != 0)
{
dr = ds.Tables[0].Rows[0];
displayName = dr["DisplayName"].ToString();
}
else
{
return(null);
}
}
return(displayName);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetUserDisplayName()", "clsProfile.cs");
return(null);
}
}
public static List<object> GetAllCountries()
{
try
{
List<object> objList = new List<object>();
DataSet ds = null;
if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap)
{
ds = clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("Select ID,CountryName from vCountryUserProfile order by CountryName").dsInfo;
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
ds = clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("Select ID,CountryName from vCountryUserProfile order by CountryName").dsInfo;
}
else
{
ds = new VMukti.DataAccess.clsProfile().GetCountryUserProfile();
}
}
if (ds.Tables[0] != null)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
string CountryName;
CountryName = (string)dr["CountryName"];
objList.Add(CountryName);
}
}
return objList;
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetAllCountries()", "clsProfile.cs");
return null;
}
}
public static List <object> GetAllCountries()
{
try
{
List <object> objList = new List <object>();
DataSet ds = null;
if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap)
{
ds = clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("Select ID,CountryName from vCountryUserProfile order by CountryName").dsInfo;
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
ds = clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("Select ID,CountryName from vCountryUserProfile order by CountryName").dsInfo;
}
else
{
ds = new VMukti.DataAccess.clsProfile().GetCountryUserProfile();
}
}
if (ds.Tables[0] != null)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
string CountryName;
CountryName = (string)dr["CountryName"];
objList.Add(CountryName);
}
}
return(objList);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetAllCountries()", "clsProfile.cs");
return(null);
}
}
public static string GetUserEmail(int userID)
{
try
{
string email = null;
DataSet ds = null;
if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap)
{
ds = clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("select * from vUserInfo where ID='" + userID + "'").dsInfo;
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
ds = clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("select * from vUserInfo where ID='" + userID + "'").dsInfo;
}
else
{
ds = new VMukti.DataAccess.clsProfile().GetUserDisplayName(userID);
}
}
if (ds.Tables[0] != null)
{
DataRow dr;
if (ds.Tables[0].Rows.Count != 0)
{
dr = ds.Tables[0].Rows[0];
email = dr["EMail"].ToString();
}
else
return null;
}
return email;
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetUserDisplayName()", "clsProfile.cs");
return null;
}
}
public static int GetUserID(string displayName)
{
try
{
int userID =-1;
DataSet ds = null;
if (bool.Parse(VMuktiAPI.VMuktiInfo.Port80) && VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType != PeerType.BootStrap)
{
ds = clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("select * from vUserInfo where DisplayName='" + displayName + "'").dsInfo;
}
else
{
if (VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType == VMuktiAPI.PeerType.NodeWithHttp)
{
ds = clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("select * from vUserInfo where DisplayName='"+displayName+"'").dsInfo;
}
else
{
ds = new VMukti.DataAccess.clsProfile().GetUserID(displayName);
}
}
if (ds.Tables[0] != null)
{
DataRow dr;
if (ds.Tables[0].Rows.Count != 0)
{
dr = ds.Tables[0].Rows[0];
userID = int.Parse(dr["ID"].ToString());
}
else
return -1;
}
return userID;
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetUserID()", "clsProfile.cs");
return -1;
}
}