Exemplo n.º 1
0
        public bool CreateUser(User user)
        {
            try
            {
                OpenConnection();
                transaction = connection.BeginTransaction();

                string sql = @"INSERT INTO User(userName,password,firstName,lastName,gender,email,dob,mobileNo,address,landNo,typeID)
                               VALUES(@userName,@password,@firstName,@lastName,@gender,@email,@dob,@mobileNo,@address,@landNo,@userType)";

                DbCommand dbCommand = db.GetSqlStringCommand(sql);

                db.AddInParameter(dbCommand, "@userName", DbType.String, user.Username);
                db.AddInParameter(dbCommand, "@password", DbType.String, user.Password);
                db.AddInParameter(dbCommand, "@firstName", DbType.String, user.FirstName);
                db.AddInParameter(dbCommand, "@lastName", DbType.String, user.LastName);
                db.AddInParameter(dbCommand, "@gender", DbType.String, user.Gender);
                db.AddInParameter(dbCommand, "@email", DbType.String, user.Email);
                db.AddInParameter(dbCommand, "@mobileNo", DbType.String, user.MobileNumber);
                db.AddInParameter(dbCommand, "@landNo", DbType.String, user.LandNumber);
                db.AddInParameter(dbCommand, "@address", DbType.String, user.Address);
                db.AddInParameter(dbCommand, "@dob", DbType.DateTime, user.DateOfBirth);
                db.AddInParameter(dbCommand, "@userType", DbType.Int32, user.UserType);

                db.ExecuteNonQuery(dbCommand, transaction);
                transaction.Commit();

                return true;
            }
            catch (Exception ex)
            {
                if (transaction != null)
                {
                    transaction.Rollback();
                    return false;
                }

                if (ex.InnerException == null)
                    throw new Exception("Stack Trace:" + ex.StackTrace + "Message:" + ex.Message, ex);
                else
                    throw ex;
            }
            finally
            {
                if (connection != null && connection.State == ConnectionState.Open)
                {
                    connection.Close();
                    connection.Dispose();
                }
            }
        }
Exemplo n.º 2
0
 public bool CreateUser(User user)
 {
     return userDataProvider.CreateUser(user);
 }
Exemplo n.º 3
0
        public User GetUser(string username, string password)
        {
            User user = null;

            try
            {
                OpenConnection();

                string sql = "SELECT * FROM user WHERE userName=@userName AND password=@password";

                DbCommand dbCommand = db.GetSqlStringCommand(sql);

                db.AddInParameter(dbCommand, "@userName", DbType.String, username);
                db.AddInParameter(dbCommand, "@password", DbType.String, password);

                int intVal;
                DateTime dateVal;

                using (var reader = db.ExecuteReader(dbCommand))
                {
                    if (reader.Read())
                    {
                        user = new User();

                        if (int.TryParse(reader["userID"].ToString(), out intVal))
                            user.UserId = intVal;

                        user.Username = reader["userName"].ToString();
                        user.Password = reader["password"].ToString();
                        user.FirstName = reader["firstName"].ToString();
                        user.LastName = reader["lastName"].ToString();
                        user.Gender = reader["gender"].ToString();
                        user.Email = reader["email"].ToString();
                        user.MobileNumber = reader["mobileNo"].ToString();
                        user.LandNumber = reader["landNo"].ToString();
                        user.Address = reader["address"].ToString();

                        if (DateTime.TryParse(reader["dob"].ToString(), out dateVal))
                            user.DateOfBirth = dateVal;

                        if (int.TryParse(reader["typeID"].ToString(), out intVal))
                            user.UserType = (UserType)intVal;
                    }
                }
            }
            catch (Exception ex)
            {
                if (ex.InnerException == null)
                    throw new Exception("Stack Trace:" + ex.StackTrace + "Message:" + ex.Message, ex);
                else
                    throw ex;
            }
            finally
            {
                if (connection != null && connection.State == ConnectionState.Open)
                {
                    connection.Close();
                    connection.Dispose();
                }
            }

            return user;
        }