Exemple #1
0
        public static int CreateMember(string userName, string firstName,
                                       string lastName, int phone_num)
        {
            int id = UserProcessor.get_id(userName);

            MemberModel data = new MemberModel
            {
                FirstName = firstName,
                LastName  = lastName,
                Phone_Num = phone_num,
                User_ID   = id
            };

            string sql = @"insert into dbo.Member(FirstName, LastName, Phone, User_ID)
                        values (@FirstName, @LastName, @Phone_num, @User_ID);";

            return(SqlDataAccess.SaveData <MemberModel>(sql, data));
        }