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; } }