예제 #1
0
        /// <summary>
        /// Created By : Satish Verma
        /// Created Date : 11-Dec-2014
        /// Purpose : To get user details
        /// </summary>
        /// <param name="objUserManagementBO"></param>
        /// <returns></returns>
        public List <UserManagementBO> GetUserDetails(UserManagementBO objUserManagementBO)
        {
            DataTable objDataTable = new UserManagementDA().GetUserDetails(objUserManagementBO);
            List <UserManagementBO> lstUserManagementBO = new List <UserManagementBO>();

            foreach (DataRow Row in objDataTable.Rows)
            {
                UserManagementBO obUserManagementBO = new UserManagementBO();
                obUserManagementBO.UserDetailId = Convert.ToInt32(Row["UserDetailId"]);

                if (string.IsNullOrEmpty(Convert.ToString(Row["FirstName"])))
                {
                    obUserManagementBO.FirstName = string.Empty;
                }
                else
                {
                    obUserManagementBO.FirstName = Convert.ToString(Row["FirstName"]);
                }

                if (string.IsNullOrEmpty(Convert.ToString(Row["LastName"])))
                {
                    obUserManagementBO.LastName = string.Empty;
                }
                else
                {
                    obUserManagementBO.LastName = Convert.ToString(Row["LastName"]);
                }

                if (string.IsNullOrEmpty(Convert.ToString(Row["CountryId"])))
                {
                    obUserManagementBO.CountryId = null;
                }
                else
                {
                    obUserManagementBO.CountryId = Convert.ToInt32(Row["CountryId"]);
                }

                if (string.IsNullOrEmpty(Convert.ToString(Row["Phone"])))
                {
                    obUserManagementBO.Phone = null;
                }
                else
                {
                    obUserManagementBO.Phone = Convert.ToInt64(Row["Phone"]);
                }

                if (string.IsNullOrEmpty(Convert.ToString(Row["Email"])))
                {
                    obUserManagementBO.Email = string.Empty;
                }
                else
                {
                    obUserManagementBO.Email = Convert.ToString(Row["Email"]);
                }

                obUserManagementBO.DOB = Convert.ToDateTime(Row["DOB"]).ToString("dd-MMM-yyyy");

                if (string.IsNullOrEmpty(Convert.ToString(Row["Balance"])))
                {
                    obUserManagementBO.Balance = string.Empty;
                }
                else
                {
                    obUserManagementBO.Balance = Convert.ToString(Row["Balance"]);
                }


                obUserManagementBO.IsActive    = Convert.ToBoolean(Row["IsActive"]);
                obUserManagementBO.UserLoginId = (Guid)Row["UserLoginId"];
                obUserManagementBO.UserName    = Convert.ToString(Row["UserName"]);
                obUserManagementBO.Email       = Convert.ToString(Row["Email"]);
                obUserManagementBO.RoleId      = Convert.ToInt32(Row["RoleId"]);
                obUserManagementBO.Total       = Convert.ToInt32(Row["Total"]);
                lstUserManagementBO.Add(obUserManagementBO);
            }
            return(lstUserManagementBO);
        }
예제 #2
0
        /// <summary>
        /// Created By : Satish Verma
        /// Created Date : 18-Dec-2014
        /// Purpose : To get trading history by user
        /// </summary>
        /// <param name="userId"></param>
        /// <returns></returns>
        public List <TradingHistoryBO> GetTradingHistoryByUserId(TradingHistoryBO obTradingHistoryBO)
        {
            DataTable objDataTable = new UserManagementDA().GetTradingHistoryByUserId(obTradingHistoryBO);
            List <TradingHistoryBO> lstTradingHistoryBO = new List <TradingHistoryBO>();

            foreach (DataRow Row in objDataTable.Rows)
            {
                TradingHistoryBO objTradingHistoryBO = new TradingHistoryBO();
                objTradingHistoryBO.TradingHistoryId = Convert.ToInt64(Row["TradingHistoryId"]);
                objTradingHistoryBO.TradingTypeId    = Convert.ToInt32(Row["TradingTypeId"]);

                if (string.IsNullOrEmpty(Convert.ToString(Row["TradingType"])))
                {
                    objTradingHistoryBO.TradingType = string.Empty;
                }
                else
                {
                    objTradingHistoryBO.TradingType = Convert.ToString(Row["TradingType"]);
                }

                objTradingHistoryBO.BidType = Convert.ToString(Row["BidType"]);
                objTradingHistoryBO.AssetId = (Guid)Row["AssetId"];
                objTradingHistoryBO.Asset   = Convert.ToString(Row["Asset"]);

                if (string.IsNullOrEmpty(Convert.ToString(Row["InvestedAmount"])))
                {
                    objTradingHistoryBO.InvestedAmount = string.Empty;
                }
                else
                {
                    objTradingHistoryBO.InvestedAmount = Convert.ToString(Row["InvestedAmount"]);
                }

                if (string.IsNullOrEmpty(Convert.ToString(Row["Payout"])))
                {
                    //  objTradingHistoryBO.Payout = string.Empty;
                    objTradingHistoryBO.Payout = "0";
                }
                else
                {
                    objTradingHistoryBO.Payout = Convert.ToString(Row["Payout"]);
                }

                if (string.IsNullOrEmpty(Convert.ToString(Row["TargetPrice"])))
                {
                    objTradingHistoryBO.TargetPrice = string.Empty;
                }
                else
                {
                    objTradingHistoryBO.TargetPrice = Convert.ToString(Row["TargetPrice"]);
                }

                objTradingHistoryBO.TradeTime = Convert.ToDateTime(Row["TradeTime"]).ToString("HH:mm:ss");

                if (string.IsNullOrEmpty(Convert.ToString(Row["ExpiryPrice"])))
                {
                    objTradingHistoryBO.ExpiryPrice = string.Empty;
                }
                else
                {
                    objTradingHistoryBO.ExpiryPrice = Convert.ToString(Row["ExpiryPrice"]);
                }

                objTradingHistoryBO.ExpiryTime = Convert.ToDateTime(Row["ExpiryTime"]).ToString("HH:mm:ss");

                if (string.IsNullOrEmpty(Convert.ToString(Row["ExpirtyStatus"])))
                {
                    objTradingHistoryBO.ExpirtyStatus = null;
                }
                else
                {
                    objTradingHistoryBO.ExpirtyStatus = Convert.ToInt32(Row["ExpirtyStatus"]);
                }

                objTradingHistoryBO.ExpirtyStatusName = Convert.ToString(Row["ExpirtyStatusName"]);

                if (string.IsNullOrEmpty(Convert.ToString(Row["TradingStatus"])))
                {
                    objTradingHistoryBO.TradingStatus = null;
                }
                else
                {
                    objTradingHistoryBO.TradingStatus = Convert.ToInt32(Row["TradingStatus"]);
                }

                if (string.IsNullOrEmpty(Convert.ToString(Row["ReturnAmount"])))
                {
                    objTradingHistoryBO.ReturnAmount = string.Empty;
                }
                else
                {
                    objTradingHistoryBO.ReturnAmount = Convert.ToString(Row["ReturnAmount"]);
                }

                objTradingHistoryBO.UserId = (Guid)Row["UserId"];
                objTradingHistoryBO.IsRead = Convert.ToBoolean(Row["IsRead"]);
                objTradingHistoryBO.Total  = Convert.ToInt32(Row["Total"]);
                lstTradingHistoryBO.Add(objTradingHistoryBO);
            }
            return(lstTradingHistoryBO);
        }