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 ClsUser GetByGroupID(int ID)
{
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 = ID;
objInfo.PDBType = "Int";
objInfo.PSize = 200;
lstSP.Add(objInfo);
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, "GetByGroupID(int ID)", "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, "GetByGroupID(int ID)", "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;
}
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;
try
{
ds = VMukti.Business.clsDataBaseChannel.chHttpDataBaseService.svcExecuteDataSet("spGUserInfoPayroll", CSqlInfo).dsInfo;
}
catch (System.ServiceModel.EndpointNotFoundException e)
{
VMuktiHelper.ExceptionHandler(e, "GetByGroupID(int ID)", "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, "GetByGroupID(int ID)", "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;
}
else
{
DataSet ds = new VMukti.DataAccess.ClsUserDataService().User_GetByID(ID);
if (!obj.MapData(ds.Tables[0])) obj = null;
}
}
return obj;
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetByGroupId()", "clsUser.cs");
return null;
}
}
