예제 #1
0
        public void Update(ref DBHelper dbHelper, UserEmail objUserEmail)
        {
            try
            {

            }
            catch (Exception objExp)
            {
                throw objExp;
            }
        }
예제 #2
0
        public async Task<IUserEmail> Select(System.Int64 UserID)
        {
            return await Task.Run(() =>
            {
                IDataReader objDataReader = null;
                UserEmail objUserEmail = null;
                try
                {
                    var dbHelper = DBHelper.Instance;
                    dbHelper.AddInParameter("@UserID", UserID, DbType.Int64);
                    objDataReader = dbHelper.ExecuteDataReader(ProcedureName.SelectUserEmail, CommandType.StoredProcedure);
                    if (objDataReader != null)
                    {
                        if (objDataReader.Read())
                        {
                            objUserEmail = new UserEmail();

                            if (!objDataReader.IsDBNull(0))
                                objUserEmail.EmailID = objDataReader.GetString(0);

                            if (!objDataReader.IsDBNull(1))
                                objUserEmail.UserID = objDataReader.GetInt64(1);

                            if (!objDataReader.IsDBNull(2))
                                objUserEmail.Email = objDataReader.GetString(2);

                            if (!objDataReader.IsDBNull(3))
                                objUserEmail.IsActive = objDataReader.GetInt32(3);

                            if (!objDataReader.IsDBNull(4))
                                objUserEmail.IsVerified = objDataReader.GetInt32(4);

                            if (!objDataReader.IsDBNull(5))
                                objUserEmail.IsVerCodeSent = objDataReader.GetInt32(5);

                            if (!objDataReader.IsDBNull(6))
                                objUserEmail.VerificationCode = objDataReader.GetString(6);

                            if (!objDataReader.IsDBNull(7))
                                objUserEmail.DttmCreated = objDataReader.GetDateTime(7);

                            if (!objDataReader.IsDBNull(8))
                                objUserEmail.DttmModified = objDataReader.GetDateTime(8);

                        }
                    }
                    if (!objDataReader.IsClosed)
                        objDataReader.Close();
                }
                catch (Exception objExp)
                {
                    throw objExp;
                }

                return objUserEmail;
            });
        }